Master Class Power BI in a Day
By Isabelle Van Campenhoudt
Data Platform MVP
Objectives
One day of the overview of Power BI.
At the end of the day, all the pieces of the puzzle should have been organized:
-
Connect to, import, and transform data from a variety of sources.
-
Define business rules and KPIs.
-
Explore data with powerful visualization tools.
-
Build stunning reports.
-
Share dashboards with their team and business partners, and publish them to the web.
Audience
Technical users, business users, decision-maker
Required material
pc or laptop with at least 8 GB ram and Power BI desktop (free) latest version installed
Schedule
AM --
-
Overview of Power BI ecosystem:
-
Power Platform in general,
-
BI usage and principles,
-
Power BI services vs Power BI desktop.
-
Corporate, Team, and Self-BI.
-
-
Consuming Reports:
-
How to explore reports and Dashboards. Workspace, Apps
-
Navigation, drills-downs, and drills through
-
Visuals interactions
-
Slicing and filtering
-
Bookmarks
-
Export and collaboration
-
-
PM – (hands-on)
-
Authoring Report 1-
-
Data extraction, Sources, Transformation
-
-
Authoring Report 2 -
-
Data model, Star schema, how and why
-
-
Authoring Report 3 –
-
Data Visualisation ,why and how
-
-
Authoring Report 4 –
-
Data calculation-introduction to DAX: calculated columns and measures
-