Data & BI – Advanced · 3h 10m
Replace Power Query with pandas. SharePoint via Microsoft Graph API.
3 modules · 8 lessons
Module 1
Why Python ETL Over Power Query
10:00
Environment Setup: venv, pip, Jupyter
12:00
Pandas Crash Course for BI Developers
22:00
Module 2
Read Excel, CSV, and JSON Files
14:00
Data Cleaning: nulls, types, duplicates
18:00
Merging and Reshaping Data
16:00
Module 3
SharePoint via Microsoft Graph API
20:00
Write to Power BI via Python Script Visual
18:10