Creating Power BI Reports (Advanced)

GENERAL

• Understanding and Analysing Data for Business Intelligence

• Overview of Power BI Report Server (on-premises)

• An introduction to Machine Learning for Power BI

• Understanding how Power BI and Azure intersect

DATA & MODEL LAYERS

• Designing Complex Data Models in Power BI

• understanding common database schemas, e.g. Star and Snowflake

• understanding how Data Modelling can impact performance

• Advanced Data Wrangling with "M" and the Query Builder (i.e. shaping data and transforming tables in preparation for analysis).

• Analysing and resolving data quality issues

• Using Parameters

• Working with Dates, ISO8601, using Date Tables, and performing Time Series Analysis

• DAX and DAX Studior

  • Recap of Basic DAX Functions

  • Handling Errors

  • Aggregators and Iterators

  • Basic Table Functions, e.g. EVALUATE, FILTER, VALUES etc.

  • Variables

  • Time Intelligence Calculations

  • Calculation Groups

  • Hierarchies

  • Manipulating Tables

  • Advanced DAX concepts and Statistical Analysis using DAX

• Debugging and optimising reports with Performance Analyzer and DAX Studio

• An introduction to the Dataverse

SECURITY

• Row and Object Level Security

• Managing Security Roles

• Applying Sensitivity Labels

VISUALISATION LAYER

• Shaping Reports according to the needs of multiple audiences

• Using AI Visuals

• Integrating a Power App into a Report

• Creating a Custom visualisation (with R or Python)

• Allow users to personalise visualisations

APP SERVICE

(The "app service" is Microsoft's name for the web portal https://app.powerbi.com)

• Scheduling Data Refreshes

• Creating a Data Flow 

  • Demo the creation of a data flow. Get students to connect to the data flow (need to verify this is possible). 

  • Awareness of deployment pipelines.

• Creating a Data Mart

  • Demo and understanding of Data Flows vs Data Marts. 

• Training a Machine Learning Model

ASSIGNMENT

• Presentation of a Power BI dashboard to peers (final session)