# vishwajeetkumarsingh/nike_dashboard architecture

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

- Interactive diagram: https://gitdiagram.com/vishwajeetkumarsingh/nike_dashboard
- Repository: https://github.com/vishwajeetkumarsingh/nike_dashboard

## Overview

##### Project type and purpose
- This is a business‑intelligence / data‑analytics project built in Power BI (a .pbix file) that ingests two tabular datasets (an Excel file and a CSV), performs ETL and modeling, and produces an interactive Nike sales dashboard (Overview, Insights, Performance pages) with images and slicers.

##### File structure
- Top‑level “Dashboard” folder holding the Power BI report file (Nike_Dashboard.pbix)
- “Data” folder containing the two raw source files (Excel, CSV)
- “Images” folder containing PNGs of dashboards and product visuals
- README.md describing datasets, features, visuals used, and process steps (Power Query, DAX, model)

##### Main components
a. Data Sources
- Nike US Sales Dataset (Excel)
- nike_2020_04_13 (CSV)
b. ETL / Data Preparation
- Power Query transformations (cleaning, type conversions, calendar table)
c. Data Model / Semantic Layer
- Tables and relationships (fact table + dimension tables, calendar)
- DAX measures (key measures table)
d. Presentation / Visualization Layer
- Report pages (Overview, Insights, Performance)
- Visual elements: slicers (image slicer), cards, charts, navigation buttons
- Static assets (shoe images)
e. Hosting / Distribution
- Power BI Service or embedded link (Interactive Dashboard Link)
- Version control (GitHub repo with .pbix, data, images, README)

##### Relationships and data flow
- From Data Model → DAX Calculation Engine → Visualization Layer
- From Visualization Layer → User via Power BI Service or embedded dashboard

##### Architectural patterns and design principles
- Layered architecture:
1) Data Ingestion, 2) Data Preparation, 3) Semantic Model, 4) Presentation
- Separation of concerns: ETL logic isolated in Power Query, business logic in DAX, UI in report pages
- Reusability: calendar table and measures shared across visuals

##### Relevant technologies, frameworks, libraries
- Power BI Desktop (.pbix)
- Power Query (M language)
- DAX for measure calculation
- Data sources: Excel, CSV
- Hosting: Power BI Service or NovyPro embed
- Git/GitHub for versioning

## Diagram (Mermaid)

```mermaid
flowchart TB
    %% Data Sources Layer
    subgraph "Data Sources"
        NSales["Nike US Sales Dataset (Excel)"]:::data
        CSV["nike_2020_04_13.csv"]:::data
    end

    %% ETL Layer
    subgraph "ETL / Power Query" 
        ETL["Power Query Transformations"]:::etl
    end

    %% Semantic Model Layer
    subgraph "Data Model & DAX"
        FactDim["Fact & Dimension Tables\n(Calendar Table)"]:::model
        Measures["DAX Measures"]:::model
    end

    %% Visualization Layer
    subgraph "Presentation / Visualization"
        Pages["Report Pages\n(Overview, Insights, Performance)"]:::viz
        ImagesAsset["Static Asset – Shoe Images"]:::viz
    end

    %% Hosting Layer
    subgraph "Hosting / Distribution"
        Service["Power BI Service / Embedded"]:::host
        Readme["Project Documentation (README.md)"]:::host
    end

    %% Data Flow
    NSales -->|Cleaning & Merging| ETL
    CSV -->|Cleaning & Merging| ETL
    ETL -->|Build Fact & Dimension| FactDim
    FactDim -->|Join & Calculate| Measures
    Measures -->|Populate Visuals| Pages
    ImagesAsset -->|Image Slicer & Cards| Pages
    Pages -->|Publish| Service
    Service -->|Access Dashboard| Users[("End Users")]:::host
    Users -->|Filters via Slicers| Measures

    %% Click Events
    click NSales "https://github.com/vishwajeetkumarsingh/nike_dashboard/blob/main/Data/Nike US Sales Datasets (1).xlsx"
    click CSV "https://github.com/vishwajeetkumarsingh/nike_dashboard/blob/main/Data/nike_2020_04_13.csv"
    click ETL "https://github.com/vishwajeetkumarsingh/nike_dashboard/blob/main/Dashboard/Nike_Dashboard.pbix"
    click FactDim "https://github.com/vishwajeetkumarsingh/nike_dashboard/blob/main/Dashboard/Nike_Dashboard.pbix"
    click Measures "https://github.com/vishwajeetkumarsingh/nike_dashboard/blob/main/Dashboard/Nike_Dashboard.pbix"
    click Pages "https://github.com/vishwajeetkumarsingh/nike_dashboard/blob/main/Dashboard/Nike_Dashboard.pbix"
    click ImagesAsset "https://github.com/vishwajeetkumarsingh/nike_dashboard/tree/main/Images/"
    click Readme "https://github.com/vishwajeetkumarsingh/nike_dashboard/blob/main/README.md"

    %% Styles
    classDef data fill:#cce5ff,stroke:#004085,color:#004085;
    classDef etl fill:#d4edda,stroke:#155724,color:#155724;
    classDef model fill:#ffe5b4,stroke:#cc8400,color:#cc8400;
    classDef viz fill:#e2d0f2,stroke:#5e2590,color:#5e2590;
    classDef host fill:#e2e3e5,stroke:#6c757d,color:#6c757d;
```
