Microsoft Power BI Portfolio in a Day

About Course

In this Sweatpants BI course, we’ll cover a range of Power BI and data visualization topics through four full-length guided projects and an extra fifth project with suggested topics and business questions. Using datasets focused on market insights, real estate, a fake Florida-based coffee chain, and more, you will gain experience performing a variety of Power Query transformations, writing various levels of DAX code, designing gorgeous Power BI reports, building impactful data visuals, and applying next-level user experience techniques. At the end of this course, you will have a variety of new tools on hand to design a great BI portfolio to flex your data visualization and reporting skills!

This course is designed for people with a decent foundation in Power BI. If you’re a beginner, you are more than welcome to tag along but you may find yourself lost from time to time. Check out the Sweatpants BI course, Power Pivoting: Microsoft Power BI for Career Changers if you’re new to Power BI and need more background or, based on your budget, check out the Sweatpants BI YouTube channel for some free guidance on topics like DAX and Power Query Editor. Otherwise, if you know the ropes but are looking for some help building out your first Power BI portfolio and gaining a variety of great reporting and design techniques, look no further. This might be the course for you!

In this course, you will learn a variety of approaches to building Power BI reports through four full-length, guided projects.
You will also learn how to evaluate a dataset and how to ask the right questions that lead to designing smart, narrative-driven visualizations
You will also learn tons of BI design techniques, including how to build stunning tools, how to apply bookmarks, how to build tooltips, slicer panels & more
Finally, you will walk away with the foundation to build an impressive four-project portfolio (5 if you complete the additional dataset with guided questions)

Course Content

1. Introduction

001. Course Introduction.mp4

00:00

2. Project 1 – MarketMindz Market Research Assignment

001. Introduction and Kick-Off.mp4

00:00
002. Part 1 Understanding the Problem Statement (Dataset Attached).mp4

00:00
003. Part 2 Reviewing the Data.mp4

00:00
004. Part 3 Transforming the Data.mp4

00:00
005. Part 4 Evaluating Campaign Performance.mp4

00:00
006. Part 4 Evaluating Campaign Performance (Continued).mp4

00:00
007. Part 5 Evaluating Buyer Composition.mp4

00:00
008. Part 6 Uncovering Purchase Drivers.mp4

00:00
009. Part 7 Designing Your Layout – Choosing a Color Palette.mp4

00:00
010. Part 7 Designing Your Layout – Page Background.mp4

00:00
011. Part 7 Designing Your Layout – Designing a MarketMindz Logo.mp4

00:00
012. Part 7 Designing Your Layout – Applying Your Designs.mp4

00:00
013. Part 8 Designing a Beautiful Report – Campaign Performance.mp4

00:00
014. Part 8 Designing a Beautiful Report – Campaign Performance Continued.mp4

00:00
015. Part 8 Designing a Beautiful Report – Buyer Composition.mp4

00:00
016. Part 8 Designing a Beautiful Report – Buyer Composition Continued.mp4

00:00
017. Part 8 Designing a Beautiful Report – Purchase Drivers.mp4

00:00
018. Part 8 Designing a Beautiful Report – Purchase Drivers Continued.mp4

00:00
019. Part 9 Finishing Touches & Storytelling Elements.mp4

00:00

3. Project 2 – Kraken Koffee Sales Infographic

001. Introduction and Kick-Off.mp4

00:00
002. Part 1 Examining the Kraken Koffee Sales Dataset.mp4

00:00
003. Part 2 Modeling the Kraken Koffee Sales Dataset.mp4

00:00
004. Part 3 Determining the Kraken Koffee Story.mp4

00:00
005. Part 4 Some Basic DAX.mp4

00:00
006. Part 4 Some Less Basic DAX.mp4

00:00
007. Part 4 No DAX Whatsoever, I Promise..mp4

00:00
008. Part 5 Kraken Koffee Summary Visuals.mp4

00:00
009. Part 6 Kraken Koffee Time-Series Visuals.mp4

00:00
010. Part 7 Kraken Koffee Forecast Calculation.mp4

00:00
011. Part 7 Kraken Koffee Forecast Continued.mp4

00:00
012. Part 7 Kraken Koffee Forecast Data Label.mp4

00:00
013. Part 7 Kraken Koffee Forecast Data Visuals.mp4

00:00
014. Part 8 Working with a Pre-Determined Color Palette.mp4

00:00
015. Part 8 Designing an Infographic Canvas.mp4

00:00
016. Part 8 Designing a Cool KPI Card Section Outside of Power BI.mp4

00:00
017. Part 8 Cutting Out Text Boxes.mp4

00:00
018. Part 8 Adding Some Nautical Elements to Our Design.mp4

00:00
019. Part 8 Importing Our Design to Power BI.mp4

00:00
020. Part 9 Integrating Data Visuals into the Infographic Design – Summary Section.mp4

00:00
021. Part 9 Integrating Data Visuals into the Infographic Design – Time Section.mp4

00:00
022. Part 9 Integrating Data Visuals into the Infographic Design – Forecast Section.mp4

00:00
023. Part 10 Smart Narrative for Summary Section.mp4

00:00
024. Part 10 Smart Narrative for Time-Series Section.mp4

00:00
025. Part 10 Smart Narrative for Forecast Section.mp4

00:00

4. Project 3 – Austin Housing Market Insights

001. Introduction and Kick-Off.mp4

00:00
002. Part 1 – Data Exploration.mp4

00:00
003. Part 2 – Data Cleaning.mp4

00:00
004. Part 2 – Fact and Dimension Tables.mp4

00:00
005. Part 2 – School Dimension.mp4

00:00
006. Part 2 – Remaining Dimension Tables.mp4

00:00
007. Part 2 – Modeling Text Data and Reducing Data Models.mp4

00:00
008. Intermission – Changing Visual Interactions from Cross-Highlighting to Filtering.mp4

00:00
009. Part 3 – Summary KPIs Using the New and Improved Card Visual.mp4

00:00
010. Part 3 – Summary Insights.mp4

00:00
011. Part 4 – Working with Geolocational Data.mp4

00:00
012. Part 4 – Working with School Insights and Dynamic Legend Groups.mp4

00:00
013. Part 4- Using Field Parameters to Explore Drivers of Home Prices.mp4

00:00
014. Part 4 – Which Words Are Used to Describe Homes at Different Price Points.mp4

00:00
015. Part 4 – Using the Key Influencers Visual to Identify Drivers of Listing Price.mp4

00:00
016. Part 5 – Choosing a Color Palette (Again).mp4

00:00
017. Part 5 – Designing a Layout for Austin Real Estate Insights Data.mp4

00:00
018. Part 5 – Migrating Your Design and Color Palette to Power BI.mp4

00:00
019. Part 6 – Integrating Our Design with Our Summary Insights View.mp4

00:00
020. Part 6 – Integrating Our Design with Our Location View.mp4

00:00
021. Part 6 – Integrating Our Design with Our School View.mp4

00:00
022. Part 6 – Integrating Our Design with Our Features View.mp4

00:00
023. Part 7 – Building Buttons for Bookmark Navigation.mp4

00:00
024. Part 7 – Setting Up a Custom Slicer Panel.mp4

00:00
025. Part 8 – Setting Up a Tooltip Report Page.mp4

00:00
026. Part 9 – Designing a Simple, Effective Cover Page.mp4

00:00

5. Project 4 – HR People Analytics Report

001. Introduction and Kick-Off.mp4

00:00
002. Part 1 – Data Exploration & Modeling.mp4

00:00
003. Part 2 – Measure Tables.mp4

00:00
004. Part 3 – Headcount Calculation.mp4

00:00
005. Part 3 – Employee Retention Calculation.mp4

00:00
006. Part 3 – Employee Turnover Calculation.mp4

00:00
007. Part 4 – Visualizing Headcount.mp4

00:00
008. Part 4 – Visualizing Retention.mp4

00:00
009. Part 4 – Visualizing Turnover.mp4

00:00
010. Part 5 – Choosing a Color Palette.mp4

00:00
011. Part 5 – Designing Your Report Pages.mp4

00:00
012. Part 6 – Integrating Your Design & Data Visuals – Headcount.mp4

00:00
013. Part 6 – Integrating Your Design & Data Visuals – Retention.mp4

00:00
014. Part 6 – Integrating Your Design & Data Visuals – Turnover.mp4

00:00
015. Part 7 – Building an Interactive Slicer Panel.mp4

00:00
016. Part 7 – Building an Interactive Tooltip Page.mp4

00:00
017. Part 8 – Designing a Cool Cover Page for Your Report.mp4

00:00

6. Project 5 – WineMag Wine Reviews

7. Publishing Your Portfolio and Wrapping Things Up

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

1. Introduction

001. Course Introduction.mp4

2. Project 1 – MarketMindz Market Research Assignment

001. Introduction and Kick-Off.mp4

002. Part 1 Understanding the Problem Statement (Dataset Attached).mp4

003. Part 2 Reviewing the Data.mp4

004. Part 3 Transforming the Data.mp4

005. Part 4 Evaluating Campaign Performance.mp4

006. Part 4 Evaluating Campaign Performance (Continued).mp4

007. Part 5 Evaluating Buyer Composition.mp4

008. Part 6 Uncovering Purchase Drivers.mp4

009. Part 7 Designing Your Layout – Choosing a Color Palette.mp4

010. Part 7 Designing Your Layout – Page Background.mp4

011. Part 7 Designing Your Layout – Designing a MarketMindz Logo.mp4

012. Part 7 Designing Your Layout – Applying Your Designs.mp4

013. Part 8 Designing a Beautiful Report – Campaign Performance.mp4

014. Part 8 Designing a Beautiful Report – Campaign Performance Continued.mp4

015. Part 8 Designing a Beautiful Report – Buyer Composition.mp4

016. Part 8 Designing a Beautiful Report – Buyer Composition Continued.mp4

017. Part 8 Designing a Beautiful Report – Purchase Drivers.mp4

018. Part 8 Designing a Beautiful Report – Purchase Drivers Continued.mp4

019. Part 9 Finishing Touches & Storytelling Elements.mp4

3. Project 2 – Kraken Koffee Sales Infographic

001. Introduction and Kick-Off.mp4

002. Part 1 Examining the Kraken Koffee Sales Dataset.mp4

003. Part 2 Modeling the Kraken Koffee Sales Dataset.mp4

004. Part 3 Determining the Kraken Koffee Story.mp4

005. Part 4 Some Basic DAX.mp4

006. Part 4 Some Less Basic DAX.mp4

007. Part 4 No DAX Whatsoever, I Promise..mp4

008. Part 5 Kraken Koffee Summary Visuals.mp4

009. Part 6 Kraken Koffee Time-Series Visuals.mp4

010. Part 7 Kraken Koffee Forecast Calculation.mp4

011. Part 7 Kraken Koffee Forecast Continued.mp4

012. Part 7 Kraken Koffee Forecast Data Label.mp4

013. Part 7 Kraken Koffee Forecast Data Visuals.mp4

014. Part 8 Working with a Pre-Determined Color Palette.mp4

015. Part 8 Designing an Infographic Canvas.mp4

016. Part 8 Designing a Cool KPI Card Section Outside of Power BI.mp4

017. Part 8 Cutting Out Text Boxes.mp4

018. Part 8 Adding Some Nautical Elements to Our Design.mp4

019. Part 8 Importing Our Design to Power BI.mp4

020. Part 9 Integrating Data Visuals into the Infographic Design – Summary Section.mp4

021. Part 9 Integrating Data Visuals into the Infographic Design – Time Section.mp4

022. Part 9 Integrating Data Visuals into the Infographic Design – Forecast Section.mp4

023. Part 10 Smart Narrative for Summary Section.mp4

024. Part 10 Smart Narrative for Time-Series Section.mp4

025. Part 10 Smart Narrative for Forecast Section.mp4

4. Project 3 – Austin Housing Market Insights

001. Introduction and Kick-Off.mp4

002. Part 1 – Data Exploration.mp4

003. Part 2 – Data Cleaning.mp4

004. Part 2 – Fact and Dimension Tables.mp4

005. Part 2 – School Dimension.mp4

006. Part 2 – Remaining Dimension Tables.mp4

007. Part 2 – Modeling Text Data and Reducing Data Models.mp4

008. Intermission – Changing Visual Interactions from Cross-Highlighting to Filtering.mp4

009. Part 3 – Summary KPIs Using the New and Improved Card Visual.mp4

010. Part 3 – Summary Insights.mp4

011. Part 4 – Working with Geolocational Data.mp4

012. Part 4 – Working with School Insights and Dynamic Legend Groups.mp4

013. Part 4- Using Field Parameters to Explore Drivers of Home Prices.mp4

014. Part 4 – Which Words Are Used to Describe Homes at Different Price Points.mp4

015. Part 4 – Using the Key Influencers Visual to Identify Drivers of Listing Price.mp4

016. Part 5 – Choosing a Color Palette (Again).mp4

017. Part 5 – Designing a Layout for Austin Real Estate Insights Data.mp4

018. Part 5 – Migrating Your Design and Color Palette to Power BI.mp4

019. Part 6 – Integrating Our Design with Our Summary Insights View.mp4

020. Part 6 – Integrating Our Design with Our Location View.mp4

021. Part 6 – Integrating Our Design with Our School View.mp4

022. Part 6 – Integrating Our Design with Our Features View.mp4

023. Part 7 – Building Buttons for Bookmark Navigation.mp4

024. Part 7 – Setting Up a Custom Slicer Panel.mp4

025. Part 8 – Setting Up a Tooltip Report Page.mp4

026. Part 9 – Designing a Simple, Effective Cover Page.mp4

5. Project 4 – HR People Analytics Report

001. Introduction and Kick-Off.mp4