Agenda

1 - GET STARTED WITH MICROSOFT DATA ANALYTICS

Data Analytics and Microsoft
Getting Started with Power BI
Tour and use the Power BI service
Power BI in the Enterprise
Knowledge Check

2 - PREPARE DATA IN POWER BI

Get data from various data sources
Optimize performance
Resolve data errors
Knowledge Check

3 - CLEAN, TRANSFORM, AND LOAD DATA IN POWER BI

Data shaping
Enhance the data structure
Data Profiling
Knowledge Check

4 - DESIGN A DATA MODEL IN POWER BI

Introduction to data modeling
Working with tables
Dimensions and Hierarchies
Knowledge Check

5 - CREATE MEASURES USING DAX IN POWER BI

Introduction to DAX
DAX context
Advanced DAX
Knowledge Check

6 - OPTIMIZE MODEL PERFORMANCE

Using Variables
Fine-tune the data model
Optimize DirectQuery Models
Create and manage Aggregations
Knowledge Check

7 - CREATE REPORTS

Design a report
Enhance the report
Knowledge Check

8 - CREATE DASHBOARDS

Create a Dashboard
Real-time Dashboards
Enhance a Dashboard
Knowledge Check

9 - CREATE PAGINATED REPORTS IN POWER BI

Paginated report overview
Create Paginated reports
Knowledge Check

10 - PERFORM ADVANCED ANALYTICS

Advanced Analytics
Data Insights through AI visuals
Knowledge Check

11 - CREATE AND MANAGE WORKSPACES

Creating Workspaces
Sharing and Managing Assets
Knowledge Check

12 - MANAGE DATASETS IN POWER BI

Parameters
Datasets
Knowledge Check

13 - ROW-LEVEL SECURITY

Security in Power BI
Knowledge Check