# hrishikesh26/powerbi-sales-performance-dashboard architecture

> Architecture diagram of the GitHub repository hrishikesh26/powerbi-sales-performance-dashboard, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-05-24). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/hrishikesh26/powerbi-sales-performance-dashboard
- Repository: https://github.com/hrishikesh26/powerbi-sales-performance-dashboard

## Overview

##### Project type and purpose
- This is a BI/dashboard project built in Power BI (SalesReport.pbix), designed to connect to AtliQ Hardware’s MySQL sales database, perform ETL and data modeling, compute DAX measures, and display interactive visuals for sales insights and decision-making.

##### File structure
- Top level:
- SalesReport.pbix (Power BI desktop file containing queries, model, visuals)
- db_dump.sql, db_dump_version_2.sql (MySQL dumps under sales-insights-data-analysis-project folder)
- ScreenRecordings/ (clips showing data tables, data model, measures, performance tuning)
- README.md & sales-insights-data-analysis-project/README.md (project description)

##### Key architectural components
a. Data Source
- MySQL database (live connection or imported via dumps).
b. ETL / Data Integration
- Power Query within Power BI: data cleaning (null removal), currency normalization, type conversions.
c. Data Model
- Star schema: central fact table (sales_transactions) with dimension tables (customers, products, markets, date).
d. Analytical Engine
- DAX measures for revenue, profit margins, YOY calculations, contribution percentages.
e. Visualization Layer
f. Reporting & Delivery
- Power BI Service (cloud workspace), scheduled data refresh, user access (web/mobile).
g. Optional Predictive Layer
- Embedded Python/R scripts or Power BI Forecast visuals.

##### Architectural patterns & design principles
- ETL/ELT pattern using Power Query
- Star schema for high-performance analytical queries
- Semantic layer (DAX measures) separating business logic
- Interactive, self-service BI design

- Data artifacts (SQL dumps, pbix file) in parallelogram form

## Diagram (Mermaid)

```mermaid
flowchart TD
    subgraph "Data Source"
        DB["MySQL Database"]:::storage
        SD1["/db_dump.sql/"]:::storage
        SD2["/db_dump_version_2.sql/"]:::storage
    end

    subgraph "Power BI Desktop (ETL & Modeling)"
        PBIX["/SalesReport.pbix/"]:::file
        PQ["Power Query\n(clean & normalize)"]:::etl
        DM["Data Model\n(Star Schema)"]:::model
        DAX["Analytical Engine\n(DAX Measures)"]:::analytics
    end

    subgraph "Performance & Predictive"
        PERF["Performance Tuning\n(query folding, incremental refresh)"]:::etl
        RPY["R/Python Scripts"]:::analytics
    end

    subgraph "Visualization & Delivery"
        VIS["Report Visuals\n(interactive charts)"]:::viz
        SVCS["Power BI Service"]:::service
    end

    user["End User\n(Web/Mobile)"]:::user

    DB -->|"live connection"| PQ
    SD1 -->|"import dump"| PQ
    SD2 -->|"import dump"| PQ
    PQ -->|"build model"| DM
    DM -->|"compute measures"| DAX
    DAX -->|"render visuals"| VIS
    VIS -->|"publish report"| SVCS
    SVCS -->|"scheduled refresh"| DB
    PERF -.-> PQ
    PERF -.-> DM
    DM -->|"predictive data"| RPY
    SVCS -->|"access dashboard"| user

    click SD1 "https://github.com/hrishikesh26/powerbi-sales-performance-dashboard/blob/master/sales-insights-data-analysis-project/db_dump.sql"
    click SD2 "https://github.com/hrishikesh26/powerbi-sales-performance-dashboard/blob/master/sales-insights-data-analysis-project/db_dump_version_2.sql"
    click PBIX "https://github.com/hrishikesh26/powerbi-sales-performance-dashboard/blob/master/SalesReport.pbix"
    click PQ "https://github.com/hrishikesh26/powerbi-sales-performance-dashboard/blob/master/ScreenRecordings/data tables.mp4"
    click DM "https://github.com/hrishikesh26/powerbi-sales-performance-dashboard/blob/master/ScreenRecordings/data model.mp4"
    click DAX "https://github.com/hrishikesh26/powerbi-sales-performance-dashboard/blob/master/ScreenRecordings/Measures.mp4"
    click PERF "https://github.com/hrishikesh26/powerbi-sales-performance-dashboard/blob/master/ScreenRecordings/performance analysis.mp4"
    click VIS "https://github.com/hrishikesh26/powerbi-sales-performance-dashboard/blob/master/ScreenRecordings/Revenue analysis.mp4"
    click VIS "https://github.com/hrishikesh26/powerbi-sales-performance-dashboard/blob/master/ScreenRecordings/Profit analysis.mp4"
    click SVCS "https://github.com/hrishikesh26/powerbi-sales-performance-dashboard/blob/master/sales-insights-data-analysis-project/README.md"

    classDef storage fill:#c6f5c6,stroke:#006400
    classDef etl fill:#c6d8f5,stroke:#00008b
    classDef model fill:#f5d8c6,stroke:#8b4500
    classDef analytics fill:#f5c6c6,stroke:#8b0000
    classDef viz fill:#e5c6f5,stroke:#4b0082
    classDef service fill:#e0e0e0,stroke:#333333
    classDef file fill:#ffffcc,stroke:#666600
    classDef user fill:#f0f0f0,stroke:#333333,stroke-dasharray: 2 2
```
