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
       

© 2019 by ShareQL