Supercharge Power BI Large

Supercharge Power BI Online Training

USD $250.00 Exc.Tax

Power BI is better when you learn to write DAX

Power BI online training course: With the right Power BI online trainingcourse anyone can learn to use Power BI.  But if you want to Supercharge Power BI, you really need to learn the DAX (Data Analysis Expressions) language.  This is a high quality Online Power BI training course that will teach you how to get the most from this tool.  Participants of this hands-on Power BI online training program will soon realise there is so much more you can do with Power BI once you learn to write DAX.   Anyone that uses Excel can learn the DAX language, but it can be mysteriously confusing to first time Power BI users.  I can help you with that.

Please note: If you are purchasing this training on behalf of someone else, or are purchasing for a group of people, please be sure to include the name(s) and email address(es) of the intended student(s) using the Order Notes during Checkout.

This Power BI online training course is a combination of:

  1. Self-paced remote learning using one of my books – Supercharge Power BI or Supercharge Excel. (3 hours per week for 5 weeks – 15 CPD hours)
  2. Weekly video based training with examples and demos to support the complex topics in the book. (1 hour per week for 5 weeks – 5 CPD hours)
  3. Weekly live screen sharing Q&A sessions with me, Matt Allington. (1 hour per week for 5 weeks – 5 CPD hours)

Total CPD hours = 15+5+5 = 25 hours.

This online Power BI training course will teach you how to use the data modelling capabilities in Power BI Desktop and Power Pivot for Excel.

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

Power BI online training – Kick Off for Next Semester

The next semester for Supercharge Power BI Online Training starts on Tuesday 23rd April 2019 (USA and Euro Time Zones) and Wednesday 24th April 2019 (Australian/Oceania Time Zones) and will run for 6 consecutive weeks (5 sessions + 1 study week).  The semester timings for different time zones are given below.

Which Book is Right for You?

  

You have a choice of which book to use for your learning.  If you primarily want to use Power Pivot for Excel, you can learn using my first book Supercharge Excel: When You Learn to Write DAX for Power Pivot. If on the other hand you are planning on using Power BI, I recommend you use my new book Supercharge Power BI: Power BI is better when you learn to write DAX.  They both cover the same content and the skills are transferable between Power BI and Excel.  Participants in this Power BI online training course will be given an eBook copy of both books, and you can choose to read which ever version you prefer to participate in the training.

Buy this course and the Power Query Online Training at the same time and automatically get 10% off the price of both products.

Bulk Registration Discounts

Corporate orders for large groups receive the following discounts if purchased on the same order:

  • 2 – 5 people = 10%
  • 6 – 9 people = 15%
  • 10 – 19 people = 20%

Semester Timings

Schedule for Live Q&A Sessions

The online live Q&A sessions are scheduled for two group sessions, suited for different Time Zones as follows.

Be sure to specify which group you’d prefer using the Order Notes during Checkout.
Note: 
Please be sure to note the multiple time differences due to the beginning and ending of Daylight Savings Time around the world. If your time zone is not shown below, please base all time zone conversions based from the Sydney (AEST) time.

Group 1, USA Time Zones

Date Topic Time US Pacific Time US Central Time US Eastern Duration
Tue 23rd Apr 2019 Kick Off 2pm 4pm 5pm 30 minutes
Tue 30th Apr 2019 Week 1 2pm 4pm 5pm 60 minutes
Tue 7th May 2019 Week 2 2pm 4pm 5pm 60 minutes
Tue 14th May 2019 Extra Study Week N/A N/A N/A 0 minutes
Tue 21st May 2019 Week 3 2pm 4pm 5pm 60 minutes
Tue 28th May 2019 Week 4 2pm 4pm 5pm 60 minutes
Tue 4th Jun 2019 Week 5 2pm 4pm 5pm 60 minutes

Group 1, Euro Time Zones
Date Topic Time London Time Berlin Time Moscow Duration
Tue 23rd Apr 2019 Kick Off 10pm 11pm 12 midnight 30 minutes
Tue 30th Apr 2019 Week 1 10pm 11pm 12 midnight 60 minutes
Tue 7th May 2019 Week 2 10pm 11pm 12 midnight 60 minutes
Tue 14th May 2019 Extra Study Week N/A N/A N/A 0 minutes
Tue 21st May 2019 Week 3 10pm 11pm 12 midnight 60 minutes
Tue 28th May 2019 Week 4 10pm 11pm 12 midnight 60 minutes
Tue 4th Jun 2019 Week 5 10pm 11pm 12 midnight 60 minutes

Group 1, Australasia Time Zones
Date Topic Time Auckland Time Sydney Time Perth Duration
Wed 24th Apr 2019 Kick Off 9am 7am 5am 30 minutes
Wed 1st May 2019 Week 1 9am 7am 5am 60 minutes
Wed 8th May 2019 Week 2 9am 7am 5am 60 minutes
Wed 15th May 2019 Extra Study Week N/A N/A N/A 0 minutes
Wed 22nd May 2019 Week 3 9am 7am 5am 60 minutes
Wed 29th May 2019 Week 4 9am 7am 5am 60 minutes
Wed 5th Jun 2019 Week 5 9am 7am 5am 60 minutes

Group 2, Australasia Time Zones
Date Topic Time Auckland Time Sydney Time Perth Duration
Date Topic Time Auckland Time Sydney Time Perth Duration
Wed 24th Apr 2019 Kick Off 6pm 4pm 2pm 30 minutes
Wed 1st May 2019 Week 1 6pm 4pm 2pm 60 minutes
Wed 8th May 2019 Week 2 5pm 3pm 1pm 60 minutes
Wed 15th May 2019 Extra Study Week N/A N/A N/A 0 minutes
Wed 22nd May 2019 Week 3 6pm 4pm 2pm 60 minutes
Wed 29th May 2019 Week 4 6pm 4pm 2pm 60 minutes
Wed 5th Jun 2019 Week 5 6pm 4pm 2pm 60 minutes

Group 2, Euro Time Zones
Date Topic Time London Time Berlin Time Moscow Duration
Wed 24th Apr 2019 Kick Off 7am 8am 9am 30 minutes
Wed 1st May 2019 Week 1 7am 8am 9am 60 minutes
Wed 8th May 2019 Week 2 6am 7am 8am 60 minutes
Wed 15th May 2019 Extra Study Week N/A N/A N/A 0 minutes
Wed 22nd May 2019 Week 3 7am 8am 9am 60 minutes
Wed 29th May 2019 Week 4 7am 8am 9am 60 minutes
Wed 5th Jun 2019 Week 5 7am 8am 9am 60 minutes

Category:

Product Description

How it Works

You will get a DRM free eBook copy of the books Supercharge Excel and Supercharge Power BI included in the purchase price for this training. If you prefer a paperback, you can refer to my book pages here for Supercharge Excel or here for Supercharge Power BI, to find a suitable place to purchase the physical book (some people just like a real book).

This intuitive Power BI online course is spread across 6 weeks.  Each week, you need to

  • study the chapters prescribed for the week (as given below).
  • complete the exercises in the relevant chapters for the week.
  • watch the video summary for the week to cement your learning.
  • attend the weekly Q&A seminar and bring along any questions you have ready to ask for clarification.

The examples and exercises in the book are based on the Adventure Works Access database that you can download for practice as you proceed with the chapters.

access Adventure Works Database Download

Course Syllabus

The course will follow the chapters in my books (Supercharge Excel and Supercharge Power BI) as outlined below.
If you want to learn using Excel, follow the book Supercharge Excel, and if you want to learn using Power BI Desktop, follow the book Supercharge Power BI. Either way you will learn the same concepts that you can use both in Excel and Power BI Desktop. The only difference is in the User Interface and to help you to switch from one to other, a chapter is devoted for the purpose.

Course Coverage: Kickoff Week

Video Session: Course Overview, Tips for Watching Videos

Chapters to Study during the Week
None! This week is just to get to know each other and look over what we'll be covering during the next 5 weeks.

Course Coverage: Week 1

Video Session: Loading Data, Basic Measures, Power BI Desktop

Topics Covered in Week 1 Supercharge Power BI Chapter Supercharge Excel Chapter
Concept: Introduction to Data Modelling Chapter 1 Chapter 1
Concept: Loading Data Chapter 2 Chapter 2
Concept: Measures Chapter 3 Chapter 3
DAX Topic: SUM(); COUNT(); COUNTROWS(); MIN(); MAX(); COUNTBLANK() and DIVIDE() Chapter 4 Chapter 4

Course Coverage: Week 2

Video Session: Filter Propagation, Evaluation Contexts, Iterating functions, CALCULATE() explained

Topics Covered in Week 2 Supercharge Power BI Chapter Supercharge Excel Chapter
Concept: Filter Propagation Chapter 5 Chapter 5
Concept: Lookup Tables and Data Tables Chapter 6 Chapter 6
DAX Topic: The Basic Iterators SUMX() and AVERAGEX() Chapter 7 Chapter 7
DAX Topic: Calculated Columns Chapter 8 Chapter 8
DAX Topic: CALCULATE() Chapter 9 Chapter 9

Course Coverage: Week 3

Video Session: SWITCH, VALUES, ALL, Evaluation Context and Context Transition

Topics Covered in Week 3 Supercharge Power BI Chapter Supercharge Excel Chapter
Concept: Evaluation Context and Context Transition Chapter 10 Chapter 10
DAX Topic: IF(); SWITCH() and FIND() Chapter 11 Chapter 11
DAX Topic: VALUES(); HASONEVALUE() Chapter 12 Chapter 12
DAX Topic: ALL(); ALLEXCEPT() and ALLSELECTED() Chapter 13 Chapter 13

Course Coverage: Week 4

Video Session: FILTER(), Time Intelligence, Custom Time Intelligence Explained

Topics Covered in Week 4 Supercharge Power BI Chapter Supercharge Excel Chapter
DAX Topic: FILTER() Chapter 14 Chapter 14
DAX Topic: Time Intelligence Chapter 15 Chapter 15
DAX Topic: RELATED() and RELATEDTABLE() Chapter 16 Chapter 16
Concept: Disconnected Tables Chapter 17 Chapter 17

Course Coverage: Week 5

Video Session: Multiple Data Tables, Writing Cube Formulas from scratch, Final questions, Next steps

Topics Covered in Week 5 Supercharge Power BI Chapter Supercharge Excel Chapter
Concept: KPIs Chapter 18
Concept: Multiple Data Tables Chapter 18 Chapter 19
Concept: Using Analyze in Excel and Cube Formulas Chapter 19 Chapter 20
Transferring Your Skills to Excel Chapter 20
Moving from Excel to Power BI Chapter 21
Next Steps on Your DAX Journey Chapter 21 Chapter 22

Reviews

There are no reviews yet.

Be the first to review “Supercharge Power BI Online Training”

Your email address will not be published. Required fields are marked *

You may also like…

  • Power Query Training icon-300x300

    Power Query for Excel and Power BI – Online Training

    USD $250.00 Exc.Tax
    Add to cart