Image 1 of 5
Image 2 of 5
Image 3 of 5
Image 4 of 5
Image 5 of 5
Learn how to use Power BI to collect data, automatically clean it, set up data models, create DAX calculations, make interactive visualizations and produce rich data stories & business dashboards with this Masterclass by Microsoft MVP Chandoo. In this hands-on & in-depth program, you will learn how to work with Power Query, Power Pivot & Power BI seamlessly to solve business intelligence & data analysis problems.
Day 2: On this day, we will get deeper into Power BI by creating an executive dashboard system. You will understand the process of report design, data collection & refresh management, measure development, visual design, multi-page report development and visual storytelling techniques.
You will learn:
How to create a complex business report from scratch with Power BI
Mocking up and designing business reports
Using DAX functions like CALCULATE, ALL, FILTER & Date intelligence functions
Creating interactive tooltips
Setting up Bookmarks to make interactive reports
Using Drill-through
Using DAX to generate narrative statements for your reports (also smart narratives)
Forecasting & Trend analysis
Your Questions
Day 1: On this day, we will understand how Power BI really works by learning all about the Power BI Desktop application, data collection & clean-up with Power Query, data modeling & DAX calculations using Power Pivot, and building & formatting reports using visuals.
You will learn:
Power BI Desktop – How to use it?
Power BI vs Power Query vs. Power Pivot
Full length example of Power BI with sample dataset
Understanding Power BI Visual interactions & customizing them
Data cleanup and transformations with PQ
Using implicit vs. explicit measures (DAX)
Setting up a star schema data model
Creating and using DAX measures (simple to complex examples)
Interactive storytelling in Power BI
Saving & publishing your work
Your Questions