Supercharge Power BI Large

Supercharge Power BI Online Training

USD $250.00 Exc.Tax

Power BI is better when you learn to write DAX

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.  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.

This online training course is a combination of:

  1. Self-paced remote learning using one of my books (see below)
  2. Weekly video based training with examples and demos to support the complex topics in the book
  3. Weekly live screen sharing Q&A sessions with me, Matt Allington.

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

Which Book is Right for You?

 

I have just completed the second edit of my new book “Supercharge Power BI: Power BI is better when you learn to write DAX“.  Participants in this training will be given an eBook copy of either the original book “Learn to Write DAX” or the new book “Supercharge Power BI”.  Both books follow the same learning curriculum but using the different software products (Excel or Power BI).

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

Semester Timings

The next semester for this course will commence (Kickoff week) on Wed 17th Jan (Tues 16th USA time zone) and will run for a total of 6 consecutive weeks.

Schedule for Q&A Sessions
The online Q&A sessions are scheduled for each Time Zone as follows:
USA

Date Topic Time US Pacific Time US Central Time US Eastern Duration
Tues 16th Jan 2018 Kick Off 12 midday 2pm 3pm 30 minutes
Tues 23rd Jan 2018 Week 1 12 midday 2pm 3pm 60 minutes
Tues 31st Jan 2018 Week 2 12 midday 2pm 3pm 60 minutes
Tues 6th Feb 2018 Week 3 12 midday 2pm 3pm 60 minutes
Tues 13th Feb 2018 Week 4 12 midday 2pm 3pm 60 minutes
Tues 20th Feb 2018 Week 5 12 midday 2pm 3pm 60 minutes

ANZ
Date Topic Time Auckland Time Sydney Time Perth Duration
Wed 17th Jan 2018 Kick Off 5pm 3pm 12 midday 30 minutes
Wed 24th Jan 2018 Week 1 5pm 3pm 12 midday 60 minutes
Wed 31st Jan 2018 Week 2 5pm 3pm 12 midday 60 minutes
Wed 7th Feb 2018 Week 3 5pm 3pm 12 midday 60 minutes
Wed 14th Feb 2018 Week 4 5pm 3pm 12 midday 60 minutes
Wed 21st Feb 2018 Week 5 5pm 3pm 12 midday 60 minutes

Euro
Date Topic Time London Time Berlin Time Moscow Duration
Tues 16th Jan 2018 Kick Off 8pm 9pm 11pm 30 minutes
Tues 23rd Jan 2018 Week 1 8pm 9pm 11pm 60 minutes
Tues 30th Jan 2018 Week 2 8pm 9pm 11pm 60 minutes
Tues 6th Feb 2018 Week 3 8pm 9pm 11pm 60 minutes
Tues 13th Feb 2018 Week 4 8pm 9pm 11pm 60 minutes
Tues 20th Feb 2018 Week 5 8pm 9pm 11pm 60 minutes

Category:
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%,

Product Description

Course Syllabus

The course will follow the chapters in my books (Learn to Write DAX and Supercharge Power BI) as outlined below.
If you want to learn using Excel, follow the book Learn to Write DAX, 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, Power BI Desktop, Basic measures

Chapters to Study during the Week - Learn to Write DAX
Chapter Topics Covered
Chapter 1 Concept: Pivot Tables vs. Power Pivot
Chapter 19 Moving from Excel to Power BI
Chapter 2 Concept: Loading Data
Chapter 3 Concept: Calculated Fields/Measures
Chapter 4 DAX Topic: SUM(); COUNT(); COUNTROWS(); MIN(); MAX(); COUNTBLANK(); and DIVIDE()

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

Course Coverage: Week 2

Video Session: CALCULATE() explained, Filter Propagation, Iterators revisited

Chapters to Study during the Week - Learn to Write DAX
Chapter Topics Covered
Chapter 5 Concept: Filter Propagation
Chapter 6 DAX Topic: The Basic Iterators SUMX() and AVERAGEX()
Chapter 7 DAX Topic: Calculated Columns
Chapter 8 DAX Topic: CALCULATE()
Chapters to Study during the Week - Supercharge Power BI
Chapter Topics Covered
Chapter 5 Concept: Filter Propagation
Chapter6 Concept: Lookup Tables and Data Tables
Chapter 7 DAX Topic: The Basic Iterators SUMX() and AVERAGEX()
Chapter 8 DAX Topic: Calculated Columns
Chapter 9 DAX Topic: CALCULATE()

Course Coverage: Week 3

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

Chapters to Study during the Week - Learn to Write DAX
Chapter Topics Covered
Chapter 9 Concept: Evaluation Context and Context Transition
Chapter 10 DAX Topic: IF(); SWITCH(); and FIND()
Chapter 11 DAX Topic: VALUES(); HASONEVALUE()
Chapter 12 DAX Topic: ALL(); ALLEXCEPT(); and ALLSELECTED()
Chapter 13 DAX Topic: FILTER()
Chapters to Study during the Week - Supercharge Power BI
Chapter Topics Covered
Chapter 10 Concept: Evaluation Context and Context Transition
Chapter 11 DAX Topic: IF(); SWITCH(); and FIND()
Chapter 12 DAX Topic: VALUES(); HASONEVALUE()
Chapter 13 DAX Topic: ALL(); ALLEXCEPT(); and ALLSELECTED()
Chapter 14 DAX Topic: FILTER()

Course Coverage: Week 4

Video Session: Time Intelligence, Custom Time Intelligence Explained

Chapters to Study during the Week - Learn to Write DAX
Chapter Topics Covered
Chapter 14 DAX Topic: Time Intelligence
Chapter 15 DAX Topic: RELATED() and RELATEDTABLE()
Chapter 16 Concept: Disconnected Tables
Chapters to Study during the Week - Supercharge Power BI
Chapter Topics Covered
Chapter 15 DAX Topic: Time Intelligence
Chapter 16 DAX Topic: RELATED() and RELATEDTABLE()
Chapter 17 Concept: Disconnected Tables

Course Coverage: Week 5

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

Chapters to Study during the Week - Learn to Write DAX
Chapter Topics Covered
Chapter 17 Concept: KPIs and Multiple Data Tables
Chapter 18 Concept: Cube Formulas
Chapter 20 Next Steps on Your DAX Journey
Chapters to Study during the Week - Supercharge Power BI
Chapter Topics Covered
Chapter 18 Concept: Multiple Data Tables
Chapter 19 Concept: Using Analyze in Excel and Cube Formulas
Chapter 20 Transferring Your Skills to Excel
Chapter 21 Next Steps on Your DAX Journey

 

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 basket