Course Description
Power BI for the Business Analyst Online is a structured, online training course that covers Power BI from end-to-end. It will help you learn reporting with Power BI, getting and transforming your data with Power Query, and writing DAX formulas to extract data insights for reporting. (DAX, or Data Analysis eXpressions, is the data modeling language of Power BI.)
This course is created and delivered by Matt Allington, a world-renowned Power BI and DAX expert and trainer, eight-time Microsoft MVP (Power BI), and author of the best selling DAX books, Supercharge Power BI and Supercharge Excel
This course comprises of:
- Self-paced viewing of the online videos.
- Hands-on practice following the demos in the videos and solving the practice exercises.
- Extension reading and practicing with either of Matt’s books (included in this registration).
Course Coverage
This online course consists of three Modules (expand the sections below for details).
Introduction to Power BI
Building Your First Report
Power BI Visuals
Power BI Formatting Features
Power BI Reporting Capabilities
Creating Different Types of Reports
Publishing Reports to PowerbI.com
Creating Dashboards Online
Creating Group Workspaces for Collaboration
Power BI.com Salient Features
Creating and Sharing Apps with End Users
Intro to Power Query
Power Query UI Walk Through
The Get Data User Experience
Splitting Columns into Other Columns and into Rows
Cleansing Data with Power Query
Combine all Flat Files in a Folder
7 Ways to Join Queries
Audit Query
De Normalize Relational DB
Relative References in Queries
Conditional Logic
Introduction to Data Modelling
Overview of the DAX Language (Data Analysis eXpressions)
Common Functions in the DAX Language
Writing Formulas that Leverage Multiple Tables
CALCULATE – the Most Important Function in DAX.
Advanced Concepts, including Table Functions such as ALL and FILTER
Time Intelligence
What-if Analysis
Field Parameters in Power BI
Sample Lesson
Not sure if this course is right for you?
Visit our Learning Journey page to compare courses by skill level and area of specialization.
How it Works
Upon registration, you will receive access to:
- Online videos and downloadable course materials. The online videos are recorded by Matt Allington, who has the innate ability to explain the complex concepts and help you understand them.
- Matt Allington’s books, Supercharge Power BI and Supercharge Excel (digital editions)
You can choose to complete the course material any time based on your availability and time preferences. Plus, you can view the videos again at any time later when you are solving relevant business problems.
Registration also comes with access to our private Discussion Forum, where you can ask questions on how to apply the techniques to your own work. The forum is monitored by the course author Matt Allington, answering any questions about the course content. This forum is also intended to act as a place for students to practice their own learnings by helping others with those questions.
How long can videos be accessed?
Power BI for the Business Analyst Online is built on an annual subscription basis. Your access is valid initially for one year, and you can choose to renew it annually or cancel it at your own discretion.
You will have access to online videos, course materials, and our exclusive Discussions Forum for help with your questions for as long as your subscription is active.
(Please see the How Subscription Works section below for more information.)
Bonus Gifts with this Course
Digital editions of the top-selling DAX books, 'Supercharge Power BI' and 'Supercharge Excel'
You can choose to use either book for your learning, depending on which tool you work with most. DAX skills are transferable between Power BI Desktop and Excel Power Pivot, with the difference being UI.
Power BI Desktop is more advanced than Excel in that it might include new DAX functions before Excel. But the DAX concepts remain the same.
The books will help you with more illustrations and practice exercises with DAX.
Reviews
Power BI for the Business Analyst Online
Average Rating
4.74 / 5
Course Update Log
First release of this course with 3 Modules. (This course supersedes the original version, which only contained Modules 1 and 3.)