Microsoft Power BI Portfolio in a Day

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Introduction

Chapter 2: Project 1 – MarketMindz: Market Research Assignment

Lecture 1: Introduction and Kick-Off

Lecture 2: Part 1: Understanding the Problem Statement (Dataset Attached)

Lecture 3: Part 2: Reviewing the Data

Lecture 4: Part 3: Transforming the Data

Lecture 5: Part 4: Evaluating Campaign Performance

Lecture 6: Part 4: Evaluating Campaign Performance (Continued)

Lecture 7: Part 5: Evaluating Buyer Composition

Lecture 8: Part 6: Uncovering Purchase Drivers

Lecture 9: Part 7: Designing Your Layout – Choosing a Color Palette

Lecture 10: Part 7: Designing Your Layout – Page Background

Lecture 11: Part 7: Designing Your Layout – Designing a MarketMindz Logo

Lecture 12: Part 7: Designing Your Layout – Applying Your Designs

Lecture 13: Part 8: Designing a Beautiful Report – Campaign Performance

Lecture 14: Part 8: Designing a Beautiful Report – Campaign Performance Continued

Lecture 15: Part 8: Designing a Beautiful Report – Buyer Composition

Lecture 16: Part 8: Designing a Beautiful Report – Buyer Composition Continued

Lecture 17: Part 8: Designing a Beautiful Report – Purchase Drivers

Lecture 18: Part 8: Designing a Beautiful Report – Purchase Drivers Continued

Lecture 19: Part 9: Finishing Touches & Storytelling Elements

Chapter 3: Project 2 – Kraken Koffee Sales Infographic

Lecture 1: Introduction and Kick-Off

Lecture 2: Part 1: Examining the Kraken Koffee Sales Dataset

Lecture 3: Part 2: Modeling the Kraken Koffee Sales Dataset

Lecture 4: Part 3: Determining the Kraken Koffee Story

Lecture 5: Part 4: Some Basic DAX

Lecture 6: Part 4: Some Less Basic DAX

Lecture 7: Part 4: No DAX Whatsoever, I Promise.

Lecture 8: Part 5: Kraken Koffee Summary Visuals

Lecture 9: Part 6: Kraken Koffee Time-Series Visuals

Lecture 10: Part 7: Kraken Koffee Forecast Calculation

Lecture 11: Part 7: Kraken Koffee Forecast Continued

Lecture 12: Part 7: Kraken Koffee Forecast Data Label

Lecture 13: Part 7: Kraken Koffee Forecast Data Visuals

Lecture 14: Part 8: Working with a Pre-Determined Color Palette

Lecture 15: Part 8: Designing an Infographic Canvas

Lecture 16: Part 8: Designing a Cool KPI Card Section Outside of Power BI

Lecture 17: Part 8: Cutting Out Text Boxes

Lecture 18: Part 8: Adding Some Nautical Elements to Our Design

Lecture 19: Part 8: Importing Our Design to Power BI

Lecture 20: Part 9: Integrating Data Visuals into the Infographic Design – Summary Section

Lecture 21: Part 9: Integrating Data Visuals into the Infographic Design – Time Section

Lecture 22: Part 9: Integrating Data Visuals into the Infographic Design – Forecast Section

Lecture 23: Part 10: Smart Narrative for Summary Section

Lecture 24: Part 10: Smart Narrative for Time-Series Section

Lecture 25: Part 10: Smart Narrative for Forecast Section

Chapter 4: Project 3 – Austin Housing Market Insights

Lecture 1: Introduction and Kick-Off

Lecture 2: Part 1 – Data Exploration

Lecture 3: Part 2 – Data Cleaning

Lecture 4: Part 2 – Fact and Dimension Tables

Lecture 5: Part 2 – School Dimension

Lecture 6: Part 2 – Remaining Dimension Tables

Lecture 7: Part 2 – Modeling Text Data and Reducing Data Models

Lecture 8: Intermission – Changing Visual Interactions from Cross-Highlighting to Filtering

Lecture 9: Part 3 – Summary KPIs Using the New and Improved Card Visual

Lecture 10: Part 3 – Summary Insights

Lecture 11: Part 4 – Working with Geolocational Data

Lecture 12: Part 4 – Working with School Insights and Dynamic Legend Groups

Lecture 13: Part 4- Using Field Parameters to Explore Drivers of Home Prices

Lecture 14: Part 4 – Which Words Are Used to Describe Homes at Different Price Points?

Lecture 15: Part 4 – Using the Key Influencers Visual to Identify Drivers of Listing Price

Lecture 16: Part 5 – Choosing a Color Palette (Again)

Lecture 17: Part 5 – Designing a Layout for Austin Real Estate Insights Data

Lecture 18: Part 5 – Migrating Your Design and Color Palette to Power BI

Lecture 19: Part 6 – Integrating Our Design with Our Summary Insights View

Lecture 20: Part 6 – Integrating Our Design with Our Location View

Lecture 21: Part 6 – Integrating Our Design with Our School View

Lecture 22: Part 6 – Integrating Our Design with Our Features View

Lecture 23: Part 7 – Building Buttons for Bookmark Navigation

Lecture 24: Part 7 – Setting Up a Custom Slicer Panel

Lecture 25: Part 8 – Setting Up a Tooltip Report Page

Lecture 26: Part 9 – Designing a Simple, Effective Cover Page

Chapter 5: Project 4 – HR People Analytics Report

Lecture 1: Introduction and Kick-Off

Lecture 2: Part 1 – Data Exploration & Modeling

Lecture 3: Part 2 – Measure Tables

Lecture 4: Part 3 – Headcount Calculation

Lecture 5: Part 3 – Employee Retention Calculation

Lecture 6: Part 3 – Employee Turnover Calculation

Lecture 7: Part 4 – Visualizing Headcount

Lecture 8: Part 4 – Visualizing Retention

Lecture 9: Part 4 – Visualizing Turnover

Lecture 10: Part 5 – Choosing a Color Palette

Lecture 11: Part 5 – Designing Your Report Pages

Lecture 12: Part 6 – Integrating Your Design & Data Visuals – Headcount

Lecture 13: Part 6 – Integrating Your Design & Data Visuals – Retention

Lecture 14: Part 6 – Integrating Your Design & Data Visuals – Turnover

Lecture 15: Part 7 – Building an Interactive Slicer Panel

Lecture 16: Part 7 – Building an Interactive Tooltip Page

Lecture 17: Part 8 – Designing a Cool Cover Page for Your Report

Chapter 6: Project 5 – WineMag Wine Reviews

Lecture 1: Introduction and Kick-Off

Chapter 7: Publishing Your Portfolio and Wrapping Things Up

Lecture 1: Publishing Your Portfolio Pieces

Lecture 2: Thank You!