Course › Week 6

Week 6. Deliver BI people trust

Power BI, DAX, open-source BI, scheduled reports, reconciliation.

A pipeline is judged by the report at the end of it. This week you build Power BI models and DAX measures properly, design dashboards people read in ten seconds, deliver scheduled reports, and learn the open-source BI options for companies without Microsoft licences. You also learn reconciliation: proving a number is right.

Proof project 6: chain-dashboards: a Power BI report (with screenshots and a .pbix/PBIP project in git), a Metabase or Superset twin on Postgres, and an automated daily PDF/email report.

Days

1. Day 36 Power BI data models that stay fast 4h · learn 70m · lab 140m · ship 15m · review 15m
2. Day 37 DAX that is correct, not just working 4h · learn 80m · lab 130m · ship 15m · review 15m
3. Day 38 Dashboards people read in ten seconds 4h · learn 60m · lab 145m · ship 20m · review 15m
4. Day 39 Refresh, security and report delivery 4h · learn 70m · lab 135m · ship 20m · review 15m
5. Day 40 Open-source BI for companies without Microsoft licences 4h · learn 60m · lab 145m · ship 20m · review 15m
6. Day 41 Reconciliation, the skill that earns trust 4h · learn 70m · lab 135m · ship 20m · review 15m
7. Day 42 Proof 6: chain-dashboards, BI people can trust 4h · build 150m · README 60m · review 30m