Python ETL for Microsofts Dashboard in a Day
Python script for creating a sqlite database out of the demo data
Download data and labs from https://aka.ms/diad_student
Edit diat-etl.py and set the data path
Run "pip install -r requirements.txt"
run "python diad-etl.py". Will take a couple of minutes and create the file sales.db
use a odbc driver for sqlite3 to connect to Power BI (or other tool)