Olist Power BI Analytics — Knowledge Base

Welcome to the knowledge base for a Power BI portfolio project built on the public Olist Brazilian E-Commerce dataset.

This site is the "brain" of the project. It records:

• Learning notes — Power BI concepts explained as they are applied.
• Decisions (ADR) — the why behind every significant choice.
• Reference — the data dictionary for the star schema.
• Roadmap — what is done and what is planned next.

Project at a glance

Goal	Learn Power BI hands-on and build a portfolio-grade dashboard
Data	Olist Brazilian e-commerce (~100k orders, 2016–2018)
Stack	Python + pandas → Power BI (PBIP/TMDL) → MkDocs → GitHub Pages
Data license	CC BY-NC-SA 4.0 (attribution, non-commercial)
Code license	MIT

How the pieces fit together

flowchart LR
    A[Kaggle: Olist CSVs] --> B[Python pipeline<br/>clean + star schema]
    B --> C[data/processed/*.csv]
    C --> D[Power BI PBIP<br/>model + DAX + report]
    E[This knowledge base] -.documents.-> B
    E -.documents.-> D

Where to start

1. Read the Roadmap to see current status.
2. Skim the Decisions to understand the architecture.
3. Dive into the Learning notes for the Power BI concepts.