# mhdmirzan/pizza-insights architecture

> Architecture diagram of the GitHub repository mhdmirzan/pizza-insights, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-08-23). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/mhdmirzan/pizza-insights
- Repository: https://github.com/mhdmirzan/pizza-insights

## Overview

##### Project Type and Purpose
- This is a Business Intelligence (BI) dashboard project built in Power BI to analyze pizza sales data.

##### File-Structure Analysis
- Top-level assets:
- order_details.csv, orders.csv, pizza_types.csv, pizzas.csv → raw data sources
- “pizza SQL codes/” → a collection of SQL scripts (“ETL layer”) transforming and aggregating those CSVs
- pizza_dashboard.pbix → Power BI Desktop file containing data model and reports
- Power BI & SQL pizza insights.pdf and Questions.txt → documentation and analysis questions
- No application code or microservices—this is a data pipeline + BI reporting solution.

##### README Insights
- Confirms a published Power BI report with a screenshot.

a. Main Components
1. Data Sources (CSV files)
2. ETL Layer (SQL scripts folder)
3. Staging & Data Model (fact and dimension tables)
4. Power BI Desktop (.pbix)
5. Power BI Service (cloud hosting and sharing)
6. Documentation Artifacts (PDF, Questions.txt)
b. Relationships & Data Flow
- Documentation feeding into analysis best practices or stakeholder review
c. Architectural Patterns & Principles
- ETL pipeline: extract raw data, transform via SQL, load into BI-ready schema
- Star schema in data model: facts (order_details) linked to dimensions (orders, pizzas, pizza_types)
- Self-service BI: one monolithic .pbix file with data model and visuals
d. Key Technologies & Frameworks
- Data storage: flat CSV files (source)
- Processing: SQL engine (could be local SQLite, SQL Server, or Power Query M if imported directly)
- Visualization: Power BI Desktop & Power BI Service

## Diagram (Mermaid)

```mermaid
flowchart TD
    subgraph "Data Ingestion"
        ODS[(orders.csv)]:::datasource
        ODD[(order_details.csv)]:::datasource
        PTS[(pizza_types.csv)]:::datasource
        PS[(pizzas.csv)]:::datasource
    end

    subgraph "ETL Layer"
        ETLFolder["ETL Scripts"]:::etl
        ETL1["Create Dimensions"]:::etl
        ETL2["Populate Fact_OrderDetails"]:::etl
        ETL3["Aggregate Metrics"]:::etl
    end

    subgraph "Data Model (Star Schema)"
        DimOrders["Dim_Orders"]:::model
        DimPizzas["Dim_Pizzas"]:::model
        DimPizzaTypes["Dim_PizzaTypes"]:::model
        Fact["Fact_OrderDetails"]:::model
    end

    subgraph "Reporting"
        PBIX["pizza_dashboard.pbix"]:::report
        Service["Power BI Service"]:::report
    end

    subgraph "Documentation"
        Readme["README.md"]:::doc
        DocsPDF["Insights.pdf"]:::doc
        DocsQ["Questions.txt"]:::doc
    end

    %% Data flow
    ODS --> ETLFolder
    ODD --> ETLFolder
    PTS --> ETLFolder
    PS --> ETLFolder

    ETLFolder --> ETL1
    ETLFolder --> ETL2
    ETLFolder --> ETL3

    ETL1 --> DimOrders
    ETL1 --> DimPizzas
    ETL1 --> DimPizzaTypes

    ETL2 --> Fact
    ETL3 --> Fact

    DimOrders --> Fact
    DimPizzas --> Fact
    DimPizzaTypes --> Fact

    Fact --> PBIX
    PBIX --> Service

    Readme --> ETLFolder
    DocsPDF --> PBIX
    DocsQ --> PBIX

    %% Click Events
    click ODS "https://github.com/mhdmirzan/pizza-insights/blob/main/orders.csv"
    click ODD "https://github.com/mhdmirzan/pizza-insights/blob/main/order_details.csv"
    click PTS "https://github.com/mhdmirzan/pizza-insights/blob/main/pizza_types.csv"
    click PS "https://github.com/mhdmirzan/pizza-insights/blob/main/pizzas.csv"
    click ETLFolder "https://github.com/mhdmirzan/pizza-insights/tree/main/pizza SQL codes/"
    click PBIX "https://github.com/mhdmirzan/pizza-insights/blob/main/pizza_dashboard.pbix"
    click DocsPDF "https://github.com/mhdmirzan/pizza-insights/blob/main/Power BI & SQL pizza insights.pdf"
    click DocsQ "https://github.com/mhdmirzan/pizza-insights/blob/main/Questions.txt"
    click Readme "https://github.com/mhdmirzan/pizza-insights/blob/main/README.md"

    %% Styles
    classDef datasource fill:#D6EAF8,stroke:#2980B9,color:#154360;
    classDef etl fill:#FCF3CF,stroke:#D68910,color:#B9770F;
    classDef model fill:#D5F5E3,stroke:#27AE60,color:#145A32;
    classDef report fill:#EBDEF0,stroke:#8E44AD,color:#512E5F;
    classDef doc fill:#F2F3F4,stroke:#BDC3C7,color:#566573;
```
