Catalog
details
Ajoutez votre titre ici
Ajoutez votre titre ici
POWER BI – LEVEL 1 – FUNDAMENTAL
Category
INFORMATION TECHNOLOGY
Subcategory
Data
Code
DAT004
Training Objectives
Recover, connect, query and associate heterogeneous data sources Clean and transform data to make them usable for future analysis Model and prepare their data Use all the wealth of Power Query features
Training Program
Module 1: How to recover data?
What is Power Query?
Connection to data sources
Data navigation and transformation
Objective of the ETL: data in the first normal form
Module 2: Data Transformation and Preparation
Advanced data processing
Use of transformation functions
Module 3: Advanced Data Transformation
Merge Tables
Pivot or deivot tables
Managing Errors and Missing Values
Drill down
Recover entire folder
Module 4: Automation and Optimization
Automation of repetitive tasks
Integration and updating of data
