Power BI Complete Course
The fastest way to go from a complete newbie to an advanced Power BI user
Dates: 8, 9 Nov 2022
Location: WeWork, 70 Wilson St, London EC2A 2DB
The fastest way to go from a complete newbie to an advanced Power BI user
Dates: 8, 9 Nov 2022
Location: WeWork, 70 Wilson St, London EC2A 2DB
The fastest way to go from a complete newbie to an advanced Power BI user
Dates: 8, 9 Nov 2022
Location: WeWork, 70 Wilson St, London EC2A 2DB
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