Learn to write DAX_300px_Native

Super Charge Power BI Online Training

USD $250.00 Exc.Tax

Power BI is better when you learn to write DAX.  This online training course is a combination of self-paced remote learning using the book “Learn to Write DAX“, weekly video based training with examples and demos to support the complex topics in the book, and weekly live screen sharing Q&A sessions with Matt Allington.  This course will teach you how to use Power Pivot for Excel and/or Power BI Desktop.

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

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 14th Nov 2017 Kick Off 12 midday 2pm 3pm 30 minutes
Tues 21st Nov 2017 Week 1 12 midday 2pm 3pm 60 minutes
Tues 28th Nov 2017 Week 2 12 midday 2pm 3pm 60 minutes
Tues 5th Dec 2017 Week 3 12 midday 2pm 3pm 60 minutes
Tues 12th Dec 2017 Week 4 12 midday 2pm 3pm 60 minutes
Tues 19th Dec 2017 Week 5 12 midday 2pm 3pm 60 minutes

ANZ
Date Topic Time Auckland Time Sydney Time Perth Duration
Wed 15th Nov 2017 Kick Off 5pm 3pm 12 midday 30 minutes
Wed 22nd Nov 2017 Week 1 5pm 3pm 12 midday 60 minutes
Wed 29th Nov 2017 Week 2 5pm 3pm 12 midday 60 minutes
Wed 6th Dec 2017 Week 3 5pm 3pm 12 midday 60 minutes
Wed 13th Dec 2017 Week 4 5pm 3pm 12 midday 60 minutes
Wed 20th Dec 2017 Week 5 5pm 3pm 12 midday 60 minutes

Euro
Date Topic Time London Time Berlin Time Moscow Duration
Wed 15th Nov 2017 Kick Off 8pm 9pm 11pm 30 minutes
Wed 22nd Nov 2017 Week 1 8pm 9pm 11pm 60 minutes
Wed 29th Nov 2017 Week 2 8pm 9pm 11pm 60 minutes
Wed 6th Dec 2017 Week 3 8pm 9pm 11pm 60 minutes
Wed 13th Dec 2017 Week 4 8pm 9pm 11pm 60 minutes
Wed 20th Dec 2017 Week 5 8pm 9pm 11pm 60 minutes

Category:

Bulk Discounts

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

  • Register and pay for 3 people, get 10% discount on total amount
  • Register and pay for 5 people, get 20% discount on total amount
  • Register and pay for 7 or more people, get 30% discount on total amount

For custom on-site training, please contact Matt directly to discuss your needs.

Product Description

Semester Timings

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

Course Syllabus

The course will follow the chapters in my book as outlined below.

Course Coverage: Kickoff Week

Video Session:Course Overview

Chapters to Study during the Week
None! This week is just to get to say hi 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
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();DIVIDE()

Course Coverage: Week 2

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

Chapters to Study during the Week
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()

Course Coverage: Week 3

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

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

Course Coverage: Week 4

Video Session: Time Intelligence, Custom Time Intelligence Explained

Chapters to Study during the Week
Chapter Topics Covered
Chapter 14 DAX Topic: Time Intelligence
Chapter 15 DAX Topic: RELATED() and RELATEDTABLE()
Chapter 16 Concept: Disconnected Tables

Course Coverage: Week 5

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

Chapters to Study during the Week
Chapter Topics Covered
Chapter 17 Concept: KPIs and Multiple Data Tables
Chapter 18 Concept: Cube Formulas
Chapter 20 Next Steps on Your DAX Journey
Wrap-Up

Reviews

There are no reviews yet.

Be the first to review “Super Charge Power BI Online Training”

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