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
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
Upscale reports with essential features of Power BI Desktop and Power BI online service
- Complete overview of the essential features of Power BI Desktop and Power BI online service
- Step-by-step process on how to develop dynamic reports, following the 4 pillars of Power BI development
Details Of What You Will Learn
During This Course
- Describe - the key components of Power BI and the important features across the entire Power BI suite
- Identify - the steps on how to bring in data from different sources into Power BI and transform the data in the Query Editor
- Describe - the process of setting up and managing data relationships for the data model
- Identify - appropriate DAX measures for your analysis
- Detail - the process of customizing reports using color themes, grids and custom visuals
- Explain - how to share report publicly using the Publish to Web feature
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
- 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!
Your Instructor
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.
Frequently Asked Questions
- How long do I have access to the course? You have access to this course as long as you have Enterprise DNA On-Demand Subscription.
- Can I purchase a single course instead of the Enterprise DNA On-Demand? The option to purchase a single course has been discontinued. To access any of our courses, you will need to upgrade to full On-Demand Subscription here.
- Do you offer one-off support or coaching? All support around Power BI and Enterprise DNA's online training content now occurs at the Enterprise DNA Forum. You must have an Enterprise DNA On-Demand Subscription or CoE access to receive support.
- What if I need to train my team? We recommend exploring Enterprise DNA Center of Excellence platform. To learn more, see here.
Get full access to unparalleled training
& skill-building resourcess
For Individuals
Enterprise DNA
On-Demand
Empowering the most valuable Power BI users to expand their analytical thinking and insight generation possibilities
For Teams
Enterprise DNA
Center of Excellence