Power BI Training for the Business Analyst

Best in Class Power BI Training

Jump directly to Power BI Live Training Calendar

This live public Power BI training course is also available as

• private, onsite corporate training
• private, live, instructor-led virtual online inhouse training
• online video training

Why this Course is Different/Better

Not all Power BI training is created equal.  This training course was developed by Matt Allington who is a Microsoft MVP (Power BI) and author of the best selling book Supercharge Power BI. The training is delivered by Matt Allington or one of his accredited trainers.  The curriculum of this course has been designed to make complicated concepts easy to understand. 

The course is for 2 days and can be taken as a standalone 2-day course, or as two separate training programs. It is recommended for most people to attend the comprehensive 2-day course “Power BI for the Business Analyst”.

• 1 Day Foundations of Power BI – Data to Dashboard (6.5 CPD hours)
• 1 Day Extracting Data Insights with Power BI and DAX (6.5 CPD hours)

Total CPD hours = 13 hours.

All participants will receive the certificate of completion at the end of the course.

Matt Allington’s Books

Each participant of the second day of training will receive a paperback copy of the book “Supercharge Power BI” and the eBook bundle “Supercharge Power BI & Supercharge Excel“.   With these books you can continue your learning after the live training using the same familiar learning style covered in the course.

Course Coverage

The course coverage for 2 days (check below for the dates in your location) is as given below.

Foundations of Power BI – Data to Dashboard  (Day 1)

This first day of the two day training covers all you need to know to start using the Power BI suite of tools without expecting you to be a programmer. It can also be taken as a one day course. The topics include

• How to use Power BI Desktop.
• In depth coverage of building visuals and reports using Power BI Desktop.
• Creating dashboards on Power BI.com.
• Sharing your reports with dashboards and work spaces using PowerBI.com.
• Introduction to Power Query, and hands on learning of several reusable patterns that cover common use cases for loading ad hoc data.

Extracting Data Insights with Power BI and DAX (Day 2)

This second day of the two day training focuses on teaching business analysts how to model data using Power BI. Unlike some other learning resources, this course dives deep into the details of Power BI Data Modelling with DAX (Data Analysis eXpressions – the data modelling language of Power BI), teaching you everything you really need to know to be good at using Power BI.

The term “Data Modelling” is not something that is familiar to most Excel Pros, and that is because data modelling has historically been done by IT on your behalf. But if you want to be good with Power BI, you must learn how to become a data modeller using Power BI– this is exactly what you will learn in this class. Although the concepts are difficult to pick up via self learning, the expert approach from this live training course makes it accessible to any Excel Pro. It can also be taken as a one day course. The topics include

• Overview of the DAX language (Data Analysis Expressions).
• Common functions in the DAX language.
• How to write formulas that leverage multiple tables.
• The CALCULATE function – the most important function in DAX.
• Advanced concepts including table functions such as ALL, FILTER.
• Time Intelligence

At the end of the 2 days you will be well on you way to becoming a Power BI ninja.

Full details of the course are covered in this downloadable course brochure.

Click here to download the brochure

Course Locations and Dates

The upcoming training dates can be seen in the table below.

There is an early bird special offer if you book and pay 1 month in advance.

Bulk discounts are available when you register and pay for 3 or more people at the same time.

• Register and pay for 3 – 5 people, get 10% discount on total amount.
• Register and pay for 6 – 15 people, get 15% discount on total amount.
• Register and pay for 16 – 25 people, get 20% discount on total amount.

Training will be located at a suitable central location in your capital city (depending on numbers).