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 is the data modeling language of Power BI).
This course is created and delivered by Matt Allington, 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 comprises of:
Thus, this training is a combination of self-paced learning and guided coaching.
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
De Normalize Relational DB
Relative References in Queries
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
Field Parameters in Power BI
Upon registration, you will receive access to:
It is recommended you
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, even if you don’t have questions of your own.
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 (see the Live Online Q&A Calls section below for the details).
The 1-hour live online Q&A calls will be held once every two weeks throughout the year.
There are two Q&A calls that run concurrently (Group 1 and Group 2), designed to cater for most time zones around the world.
You will receive a Zoom meeting invite for the Q&A calls in an upcoming month before the start of that month, which is for both Group 1 and Group 2. (There are typically 2 or 3 calls per month for both Group 1 and Group 2, making it to about 40 calls per year all together.)
You can attend whichever group call (Group 1 or 2) that you prefer.
You can email your questions along with any workbooks used one or two days earlier and those questions will be taken up during the Q&A call.
The Q&A calls will be recorded, and all the recordings will be shared with you after the call irrespective of whether you could make it to the call or not. You can download these recordings and keep them for your later reference.
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 at your own discretion.
You will have access to online videos, course materials and the live online Q&A calls for as long as your subscription is active.
(Please see the How Subscription Works section below for more information.)
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.
First release of this course with 3 Modules. (This course supersedes the original version, which only contained Modules 1 and 3.)
This course is built on an annual subscription format. Your registration comes with 12 months of access to the course materials, so you can refer back to the videos and example files whenever you like. Your subscription also gives you access to our private Discussion Forum, where you can ask questions related to the course materials, as well as how to apply those teachings to your own work. This forum is an invaluable resource that also allows students to practice their own learnings by helping others with those questions.
On your annual renewal date, your subscription will be automatically renewed with the credit card information on file, unless you cancel your subscription beforehand. You will be emailed a renewal reminder about one month before the renewal date. Please see the FAQs below for information about subscription renewals and cancellations.
Want to really take your skills to the next level? Check out these other great products.
Continue your learning journey with our other training offerings. We’ll help you take your skills to the next level.
There are no reviews yet.