LIVE Online Instructor-Led Power BI Training

Author: Matt Allington

Become a Power BI expert by learning reporting and data modeling with DAX. This LIVE, online, instructor-led training is conducted over 6 half-days. It is developed by Matt Allington, MVP (Power BI) and author of the best-selling book ‘Supercharge Power BI’. It is delivered by Jason Cockington, who is trained by Matt Allington and is certified by Microsoft.

Duration:
24h
Tools:
  • Power BI
Skills:
  • Data Visualization
  • Data Modeling
  • DAX Formulas
  • Data Transformation

What you'll learn?

  • Specific features of Power BI Desktop that you should know
  • Creating different types of Power BI reports using a variety of different Visuals for displaying data
  • Publishing the Power BI report to Power BI.com and sharing it with other users
  • My Workspace and Group Workspaces
  • Specific features of Power BI.com that you should know
  • Creating dashboards
  • Creating Workspace App and sharing it with end users
  • Get and Transform with Power Query
  • Hands on practice to clean and shape the data before loading into Power BI
  • Introduction to Data Modelling and DAX (Data Analysis Expressions), the data modelling language of Power BI
  • Lookup tables, Data tables and Relationshiips
  • Concept of Measures and Calculated Columns
  • DAX functions
  • Writing DAX formulas
  • Evaluation Contexts, CALCULATE() function and Context Transition
  • Understanding how the results of the measures vary as per the visualization and writing correct formulas
Course
Course Icon - LIVE Online Instructor-Led Power BI Training

LIVE Online Instructor-Led Power BI Training

$1,450(All prices in USD)
  • 24h of training content
  • 3 modules
  • Downloadable files and Handouts
  • Support and Discussion
  • Certificate of Completion

Out of stock

LIVE Online Instructor-Led Power BI Training

$1,450

Out of stock

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?

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?

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.

Bonus Gifts with this Course

12 months free access to the video version of this course, Power BI for the Business Analyst, including our exclusive Discussions Forum

If you are in Australia, a print edition of 'Supercharge Power BI'

A digital edition of Matt Allington's book, 'Supercharge Power BI'

Reviews

LIVE Online Power BI Training

Average Rating

5 / 5

(based on 3 reviews)

5/5
Tom
Tom
February 10, 2023
Read More
Jason was terrific, I have just attended the [live] business analyst course and his detailed explanations, preparation and presenting style truly hit the mark in terms of improving my skills and, more importantly, applying the course content to the workplace. Highly recommended to anyone on their Microsoft Power Query / Power BI journey, his explanation of the DAX foundations / formulas is worth the price alone.
Jonny
Jonny
December 15, 2022
Read More
Awesome work Jason! I’m from a data science background and typically perform data analysis in Python. I have a newfound respect for Power BI, its technical ability and I now understand its place in business. I thought the delivery was great. I found the pace easy to follow, Jason was very clear with his instructions, and additionally Jason was very approachable if there was an issue.
Jeff
Jeff
June 7, 2023
Read More
Jason did a great job getting through a ton of useful information. Great intro to Power BI. Clear and easy to follow.
Previous
Next

Course Formats

Coached
This is a LIVE, ONLINE, INSTRUCTOR-LED course. Over 6 half-days, you will receive hands-on training developed by Matt Allington and delivered by Microsoft Certified Trainer, Jason Cockington.

How does the subscription work?

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.

About the author

Matt Allington

Matt Allington

Matt Allington is one of the founding partners of Skillwave.Training, and the founder of Excelerator BI in Australia. He is an expert in Power BI and DAX training, and has 30+ years of experience in using data to deliver business value. Matt is an author, blogger, and eight-time Microsoft MVP that specializes in Power BI, Power Pivot, and Power Query. He brings his business and IT experience to solve general business data problems quickly and efficiently.

FAQs

How is this training delivered?

This training is delivered online, live by an instructor over 4 consecutive half-days. Each session will run from 9:00am to 1:00pm Australia Eastern Time (Sydney time).

What online platform is used to conduct the training?

Each live session will be hosted via Zoom Meetings, with both video and audio.

How will I receive my copy of 'Supercharge Power BI' and 'Supercharge Excel'?

You will receive your digital editions of the books after the training. If you are located in Australia, you will also receive a print edition of 'Supercharge Power BI' after the training.

How do I get access to the online videos of the course?

You will receive instructions on how to access the online video version of this course after the live training is complete. You will have one year of access to the video course. Should you choose to extend your access after the first year, the annual renewal price is $99 USD.

What payment methods do you accept? What currency is used?

We accept credit card payments through our secure online payment portal, Stripe. If you would like to discuss other payment options, please get in touch through our Contact Us page. All transactions are charged in US Dollars. Please note that because Skillwave is registered in Canada, we are required by Canada Revenue Agency to collect the 5% Goods & Services Tax (GST) on registrations made by Canadians.

What is your cancellation and refund policy for this course?

Please see the Things You Need To Know section above.

What discounts do you have for this course?

We offer an early bird discount of 10% if you register and pay one month before the start date. (This discount may also be combined with group discounts.) We also provide bulk discounts for registering 3 or more people, please see the Early Bird and Bulk Discounts section above.

How do I register multiple people?

In order to register multiple people and receive the bulk discount rate, please get in touch through our Contact Us page.

Recommended Courses

Continue your learning journey with our other training offerings. We’ll help you take your skills to the next level.

11h 30m
22 Modules
$495
  • Excel
  • Power BI
27h 26m
24 Modules
$350