Data Workshop for The Data Analyst
From Absolute Beginner level to advanced level ++
01
Introduction
-
The development of Self Service Business Intelligence
-
Introducing Power BI
-
How does Power BI fit in?
-
Power BI Service, Power BI desktop & Power BI Mobile
-
When to use Power BI Desktop Free versus Pro Signing up to the Power BI online service
-
Which sources of Data can I use?
-
The Microsfoft Data Environment (Azure Synapse & SSAS)
02
Core content
-
The BI Process
-
Data Model & Transformation
-
Power Query UI
-
Data Modelling
-
Power BI Templates & Parameters
-
Advanced Visualisations
-
Extended Topic B – Query Parameters (Dynamic Web Query)
-
Power Query M Formula Language
-
DAX – Contexts & Relationships
-
DAX – The Rules of Evaluation
-
DAX – Evaluation Contexts
-
Row Level Security
-
Advanced Report Features
-
Streaming Data Sources
-
APIs Data Sources
-
DAX Tools & Performance & Optimization
-
Data Project Management
03
HAnds-on exercices
It’s time to power-up your business intelligence skills! Through hands-on exercises, you’ll work on your own data project