This training is a LIVE, online, instructor-led version of our popular Power BI for the Business Analyst Online course. It is developed by Matt Allington, Microsoft MVP (Power BI) and author of the best-selling book, Supercharge Power BI. It is delivered by Jason Cockington, a Microsoft Certified Trainer.
Who this course is for?
- Those who want to start their Power BI journey and become a Power BI expert.
- Those who are looking for industry-standard training and support.
- Those who want to learn by hands-on practice and coaching.
- Those who want to understand the Power BI concepts and apply the techniques learned to their own work.
- Those who want to prepare their data for analysis, and to create reports and dashboards with valuable data insights.
- Those who want to attend live training from the comfort of their home or office.
In short, this course covers Power BI from opening the program for the first time to publishing and sharing your reports. You will learn about the versatile features of Power BI and how to use them with hands-on practice during the training. The example files and slide handouts will be provided to you. At the end of the training you will become a Power BI expert.
Training Content
The course is comprised of 3 modules, which cover Power BI’s get & transform data, reporting features and data modeling capabilities from end to end with hands-on practice:
This first module covers everything you need to know to start using the Power BI suite of tools without expecting you to be a programmer.
The topics include:
- How to use Power BI Desktop to build reports using data prepared by others
- Various features of Power BI Desktop
- Creating different types of Power BI reports
- Publishing Reports to PowerBI.com
- Creating dashboards on PowerBI.com
- Various features of PowerBI.com
- Creating Group Workspaces for collaboration
- Creating and sharing Power BI Apps with end users
- Power BI.com Features
This second module covers the capabilities of Power Query that is built into Power BI and helps you with automating the daily repetitive data cleansing tasks.
The topics include:
- Intro to Power Query
- Power Query UI Walk Through
- The Get Data User Experience
- Splitting Columns (into columns and into rows)
- Cleansing Data with Power Query
- Combine all Flat Files in a folder
- 7 Ways to Join Queries
- Audit Query
- De Normalise Relational DB
- Relative References in Queries
- Conditional Logic
This third module focuses on teaching you how to model and prepare data with DAX (Data Analysis eXpressions) the data modeling language of Power BI.
The topics include:
- Introduction to data modeling
- 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 and FILTER
- What-if analysis
- Time intelligence
What makes this course so great?
- This course is developed by Matt Allington, who has a strong business background and understands how real people use data. This is reflected in the training content and delivery.
- Matt is the author of the best-selling book 'Supercharge Power BI' which is now in its third edition. These books have sold more than 25,000 copies worldwide. Amazon reviews show that the people that have read this book find it the easiest to read, learn, and most importantly, to understand.
- This book is given to all those who attend the training. If you reside in Australia you will receive both a paperback copy and digital version. If you are outside Australia, you will only receive the digital edition.
- The curriculum of this course is logically structured and has been designed to make complicated concepts easy to understand. It’s continuously being updated with the latest Power BI features and techniques.
- The training is delivered by Jason Cockington, Matt’s certified full-time trainer. Jason Cockington is a Microsoft Certified Trainer and holds an MCSA in BI Reporting.
- You will receive 12 months access to the same content in video format for later revision and practice.
Not sure if this course is right for you?
Visit our Learning Journey page to compare courses by skill level and area of specialization.
Course Schedule
NOTE: There are no sessions currently available. Please contact us through our online contact form to be notified of future sessions.
This LIVE, online, instructor-led training runs for 6 days for 4 hours each day, from 9AM – 1PM (AEST – Sydney, Australia).
We will schedule a 30-minute Tech Check and Intro Session one week prior to the first day of the training. This will enable us to ensure your connectivity and preparedness on the training days.
Below is a table converting the training times for the next session to certain time zones. 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.
We realize that the above timing may not be suitable for people in Europe. If we have enough interest, we will look at running a session that is better for European time zones. Click here to add your name to the interest list.
Things You Need To Know
- This LIVE, online, instructor-led training runs for 6 days for 4 hours each day (1 module is covered over 2 days).
- Please ensure that you have the connectivity set up for the training days. This will be checked by us in a Tech Check and Intro Session (30 min.) a week prior to the course start date.
- Cancellations will be accepted up to 7 business days prior to the course start date. After that time, no refunds will be issued. If you are unable to attend for any reason at short notice (i.e. with less than 7 days’ notice), you can send a proxy to attend the course in your place with prior agreement.
- The training course may be rescheduled or cancelled if insufficient registrations are received up until 7 days prior to the course start date. In this event, a suitable arrangement will be made to either refund the course fee in full or reschedule to another session, at the choice of the student. (Our objective is to provide you with the option that works best for you.)
Early Bird and Bulk Discounts
- If you register and pay for this course one month in advance, you will automatically receive a 10% early bird discount.
- If you register and pay for groups of 3 or more people at the same time, you are entitled to the following bulk discounts:
- 3 – 5 people = 10% discount on total amount
- 6 – 15 people = 15% discount on total amount
- 16 – 25 people = 20% discount on total amount
For group registrations, please get in touch through our Contact Us page in order to receive the bulk discount.
Reviews
LIVE Online Power BI Training
Average Rating
5 / 5
(based on 3 reviews)