PLEASE NOTE:
This course has been superseded by an expanded version of Power BI for the Business Analyst Online.
The new version of the course includes all of the videos and materials from this original version of the course course, but also contains 3 additional hours of content on Power Query. In additional, any new or updated content will only be available in this new course.
We highly recommend enrolling in the new versions of Power BI for the Business Analyst Online instead of this course.
Course Description
Power BI for the Business Analyst Online is a structured, online training course that will help you learn reporting with Power BI, getting and transforming your data with Power Query, and writing DAX formulas (DAX is the data modeling language of Power BI).
It is created and delivered by Matt Allington, a world-renowned Power BI and DAX expert and trainer, Microsoft MVP (Power BI) for 6 consecutive years, and author of the best selling book Supercharge Power BI.
Power BI for the Business Analyst Online training comprises of:
- Self-paced viewing of online videos, practicing following along with the demos and practice exercises.
- Attending live online Q&A calls (1 hour each) held every 2 weeks at your convenience.
- Downloading the video recordings of the Q&A calls for your later reference.
- Extension reading and practicing with Matt’s books (included in this registration).
How it Works
This training a combination of self-paced learning and guided coaching. 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 make you learn the content with examples, demos, and practice exercises.
- Bi-weekly (every 2 weeks) live online Q&A calls (1 hour each) with Matt Allington / Jason Cockington.
- The Q&A calls are recorded, and the recordings are shared with you after each call. You can download these recordings and keep them for your later reference.
This access will be valid initially for one year that you can renew annually at your own discretion.
Who this course is for?
This is an introductory course for all people that want to learn Power BI from the beginning. It is perfect for:
- Anyone who is new to Power BI and wants to learn it end-to-end.
- Those who are self-taught and need to learn the important concepts they have missed.
- Those who prefer guided learning.
Course Coverage
This online course consists of two Modules (Module 1 and Module 3). 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.
Introduction to data modelling.
Overview of the DAX language (Data Analysis Expressions).
Common functions in the DAX language.
How to write formulas that leverage multiple tables.
CALCULATE – the most important function in DAX.
Advanced concepts including table functions such as ALL, FILTER.
Time Intelligence.
What-if Analysis.
Field Parameters in Power BI
Live Online Q&A Calls
The live online Q&A calls will be held once every two weeks throughout the year (about 20 calls per year).
You can choose to complete the course material any time based on your availability and time preferences, and you can attend any of the scheduled Q&A calls.
You will receive a Zoom meeting invite for the Q&A calls in an upcoming month before the start of that month.
There are 2 Q&A calls that run concurrently (Group 1 and Group 2), designed to cater for most time zones around the world.
- Group 1: 8:00 AM Australian Eastern Time (Sydney)
- Group 2: 4:00 PM Australian Eastern Time (Sydney)
You can attend any group (Group 1/ Group 2) that you prefer.
The Q&A calls timings for February 2023 based on certain time zones are given below. If your time zone is not shown below, please convert to your time zone based on the time in Sydney, Australia (AEST).
Note: Please be aware of the multiple time differences due to the beginning and ending of Daylight Savings Time around the world.
Recommended Practice
It is recommended you view the videos, complete the practice exercises, and then prepare any questions you have prior to the Q&A call. You can email your questions along with any workbooks used and those questions will be taken up during the Q&A call.
One of the benefits of this style of learning is you can listen to and learn from all the discussion and questions from other participants.
DAX Books
Your registration includes digital copies of Matt Allington’s books, Supercharge Power BI and Supercharge Excel.
You can choose to use either book for your DAX learning. 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.
Note:
Bonus Gifts with this Course
Downloadable video recordings of the live online Q&A calls.
Access to all the scheduled Q&A calls as long as you are subscribed.
Course Update Log
First release of the course on Skillwave site. Registration opens for Semester 1, 2022 (commencing in the week of 31st January).
Release of Student Guide that can be used as a handy reference of the concepts/features covered in the course.
New lesson Field Parameters in Power BI is added to the topic Building DAX Language. Field Parameters is released as a preview feature in May 2022.
The Semester duration increased from 3 weeks to 5 weeks. The online live Q&A calls are scheduled once a week instead of twice a week based on the participants feedback.
This version of the course superseded by expanded version of Power BI for the Business Analyst Online, which contains 3 modules. We recommend enrolling in the new version of the course instead.