Power BI Play Group

Hi ,

Welcome to Power BI Play Date Course. Thank you so much for joining this class. Please bookmark this lesson plan page and visit it often to access your play toys & materials.

Your play time is valid for 2 years. Your membership expires on

About Lesson Plan

Power BI is quite dynamic. This is why I find it hard to teach it in any specific order. While this lesson plan acts as a guide, feel free to skip lessons or watch them in any other order that you find suitable.

Lesson Plan

Module 0 – Welcome & important announcements

Duration: 20 mins, please do not skip this 🙂

Module 1 – Getting Started with Power BI

Duration: 1.5 hrs

  1. Getting Started with Power BI – 1 hr
  2. How to create a quick sales dashboard with Power BI

Module 2 – Data management with Power Query

Duration: 1.5 hrs

Note: Watch Lesson 1 and come back for Lesson 2 once you finish Module 3 & 4.

  1. Working with Power Query – US Population data in Power BI
  2. Fetching data and processing – NZ Election information [ADVANCED]

Module 3 – Data Analysis with DAX

Duration: 1.5 hrs

  1. Getting started with DAX
  2. DAX 101 – continued
  3. Story telling with Power BI – putting all that DAX to good use

Module 4 – Executive Dashboards with Power BI

Duration: 9 hrs

Notes: 

  • There are 3 case studies (2 + 1 bonus) in this module. 
  • Watch one case study at a time. Allow plenty of time to practice the ideas and replicate the steps.
  • Feel free to create something on your own from the datasets and share them.
  • Revisit the lessons if you have doubts
  • Case study 1 & 2 can be viewed in any order. See case study 3 at last.
  1. Case study 1: Retail Dashboard – 3.5 hrs
  2. Case study 2: Budget vs. Actual Dashboard – 2 hrs
  3. Bonus case study – Executive dashboard with Storagemart – 3.5 hrs

Module 5 – Storytelling  & Data Play

Duration: 1+ hrs

The purpose of this module is to play with data to create stunning, interesting and fun visualizations. Every month, I will be adding 1 video to this module. As Power BI is constantly evolving, think of this module as your way to stay ahead.

Lessons:

  1. London in Future – Population pyramids & trends explored
  2. Squirrels in New York 

Module 6 – Tricks & Inspiration

Duration: 2+ hrs

The purpose of this module is to explain certain niche features of Power BI. While same ideas may have been used elsewhere, here you will find simple instruction on how to apply such a feature. More lessons will be added as Power BI evolves.

Lessons:

  1. Drillthrough feature
  2. Bookmarks
  3. Dynamic titles with conditional formatting
  4. Advanced labeling tricks for visuals
  5. Variance charts in Power BI