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 5 weeks. You also have 1 Kickoff week and 1 week off for extra study. 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.
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
|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|