Power BI

1 import data

Load data in PowerBI with ODBC connections

4 preprocess data create dim timestamp table

12 Load with data in Power BI with SQL

2 preprocess data create fact leqs table

1 import data

9 create visuals waterfall Zebra

5 preprocess data create dim entity table

7 create data model set table relations

13 Create KPIs with DAX measurements

6 preprocess data create dim kpis table

8 create visuals linechart

11 create dax calculations

3 preprocess data create fact actuals table

10 create filters