Platform Access

Power BI

Super Users Workshop

An in-depth overview of the entire Power BI suite, with a focus on using Power BI to extract compelling insights from your own data

Enroll Now
Power BI Super Users Workshop

Here's What You'll Get With The Course

More than 6 hours of self-paced video training

Resource pack with 1x demo data set and 1x pbix file

Six review quizzes

One final assessment

9.5 CPE Credits Awarded

Power BI Super Users Workshop

A complete overview of the various different parts of Power BI Desktop, Power BI online service, and Power BI mobile applications.

  • Review of the best practice techniques on how to develop reports in Power BI desktop
  • Techniques on how to use Power BI within your organization by harnessing the online service features
  • A step-by-step process on how to develop dynamic reports, following the 4 pillars of Power BI development: data loading and transformation, data modeling, DAX calculations, reports and visualizations
  • Program Level - Basic
  • Field(s) of Study - Computer Software & App
  • Instruction Delivery Method - QAS Self-study
  • Prerequisites - Power BI account and possess reporting and analytical skills. No other advance preparation


Details Of What You Will Learn

During This Course

  • Recognize - the key components of Power BI and the important features across the entire Power BI suite
  • Link - the steps on how to bring in data from different sources into Power BI and transform the data in the Query Editor
  • Distinguish - the process of setting up and managing data relationships for the data model
  • Identify - appropriate DAX measures for your analysis
  • Identify - the process of customizing reports using color themes, grids and custom visuals
  • Determine - how to share report publicly using the Publish to Web feature
Power BI Super Users Workshop

This Course Module is Tailored for:

Data Analysts

Reporting Managers

Excel Users

Participants of this module should have a Power BI account and possess reporting and analytical skills. It is recommended to have completed the Ultimate Beginners Guide to Power BI and DAX modules. No other advance preparation is needed to take this course.

LEARN HOW TO

Utilize the key features

within Power BI

Power BI Super Users Workshop
  • Upscale reporting that delivers comprehensive analysis and insights
  • Develop dynamic reports
  • Data loading and transformation
  • Data modeling
  • DAX calculations
  • Reports and visualizations

Course Curriculum

1. Power BI Super Users Workshop

  • Let's get started
  • Definition of Terms
  • Goals for this training
  • Resources we will be using in this course
  • Power BI Workshop Resource Pack

2. Introduction

  • Power BI explained
  • Why reporting in Power BI is better than in excel
  • Why you are now building analytical solutions
  • 4 Pillars of high quality Power BI solutions
  • Review Question
  • Review Question Feedback

3. Querying and Transforming Data

  • What is the query editor?
  • The essential way to source data for Power BI
  • Fundamentals of using the query editor
  • Querying multiple data sources in the same model
  • Best practices for transforming data in the query editor
  • Row & Column transformations
  • Making sure data types are correct
  • Create groups for your queries
  • What is 'M' and why do you need to have an understanding
  • Query dependencies
  • Importance of date tables
  • Review Question
  • Review Question Feedback

2. Data Modeling

  • Introduction to the importance of the data model
  • Where to manage relationships for your data model
  • Understanding what types of tables you have & setup techniques
  • Setting up relationships in your models
  • Difference between active and inactive relationships
  • Building out additional dimensions in your data
  • Review Questions
  • Review Question Feedback

4. DAX Calculations

  • DAX explained & key techniques to learning it
  • Getting started & naming conventions tips
  • Calculated columns versus measures
  • Creating a measure table & organizing your measures
  • Context! - What is this?
  • Evaluation (initial) context
  • Aggregating formulas or filter context
  • Iterating formula or row context
  • Main table functions
  • Building measures on measures (measure branching)
  • CALCULATE function - the most important function in DAX
  • Simple Time Intelligence functions
  • More advanced DAX formula examples
  • What you can achieve if you learn DAX well
  • Review Question
  • Review Question Feedback

5. Reports and Data Visualizations

  • Design best practice tips
  • Developing visualizations in Power BI
  • How to create colour themes for your reports
  • Visualization and report formatting
  • Managing interactions between visuals
  • Additional filtering across your reports
  • Analytics automation features
  • Importing custom visuals
  • Review Question
  • Review Question Feedback

6. Power BI Online Service

  • How to publish your data to the web
  • Power BI service explained
  • Apps & Workspaces explained
  • Reports vs Dashboards
  • Email subscriptions, comments and other compelling features
  • Q+A feature in-depth
  • Admin settings within the online service
  • Review Question
  • Review Question Feedback

7. Tips for using Power BI within an organisation

  • Enterprise architecture recommendations for Power BI
  • Develop Power BI desktop templates to scale reporting requirements
  • Row level security
  • The Microsoft Power Platform
  • Why Power BI is going to be huge!

What our Students Say

Your Instructor

Sam McKay - Power Bi Super Users Workshop

Sam McKay

Sam is the founder and CEO at Enterprise DNA, a business intelligence training & consultancy business primarily focused on driving better decision making within organizations by empowering individuals and teams to transform raw data into unmatched insights using Microsoft's Power BI suite of tools.


Sam has a strong history in Finance, previously working at ANZ, PIMCO, and Fonterra. He is also a CFA charter holder, achieving the designation in 2011.

He has a passion for building highly scalable analytical solutions within organizations and wants to see others learn how to do the same.

Enterprise DNA is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org

Enterprise DNA is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org

Frequently Asked Questions

  • How do I cancel my subscription? Cancellation of On-Demand subscription is possible by sending an email to [email protected].
  • Who do I reach out to if I have questions or concerns on this course? If you have any question/s about the training content, please initiate a thread in the Enterprise DNA Forum. But if your concern is about your access or subscription, please reach out to our team at [email protected].
  • How can I access the course? You can access this course by purchasing an Enterprise DNA On-Demand Subscription.

  • Are refunds available if I want to cancel my subscription? If for valid reason you wish to cancel your yearly subscription and would like to process a refund, you may do so within 30 days after purchase. All you need to do is email [email protected].

Get full access to unparalleled training

& skill-building resourcess

For Individuals

Enterprise DNA

On-Demand

Empowering the most valuable data analysts to expand their analytical thinking and insight generation possibilities

For Teams

Enterprise DNA

For Business

Training, tools, and guidance to unify and upskill the data analysts in your workplace