# priyankfeb/pbi-assoc_onboarding architecture

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

- Interactive diagram: https://gitdiagram.com/priyankfeb/pbi-assoc_onboarding
- Repository: https://github.com/priyankfeb/pbi-assoc_onboarding

## Overview

##### Project Type & Purpose
- Type: A BI dashboard/report built in Power BI.
- Purpose: Track onboarding steps for associations, with dynamic timelines, status indicators, and “days on‐time” calculations.

##### Main Components
A. Data Sources
- External systems (e.g., SQL databases, CSVs/Excel files, SharePoint lists)
B. ETL / Data Preparation (Power Query)
- Data connectors and transformation steps.
C. Data Model (Tabular)
- Loaded tables, relationships, star schema.
D. Calculation Engine (DAX)
- Measures: Timeline SVG, Days On-Time, status logic.
- As a separate layer or sub-component within the Data Model.
E. Custom Visuals
- SVG graphics (imported from Figma designs).
F. Report Definition (Power BI Desktop)
- .pbix file containing pages, visuals, filters.
G. Deployment & Consumption
- Power BI Service (cloud).
- End-users / stakeholders via browser or mobile app.

##### Architectural Patterns & Principles
- Layered architecture:
– Ingestion layer (connectors)
– Transformation layer (Power Query)
– Semantic layer (Data Model + DAX)
– Presentation layer (Custom SVG + Report pages)
– Deployment layer (Power BI Service)
- Single source of truth: centralized tabular model.
- Separation of concerns: ETL vs. modeling vs. visualization.

##### Technology & Tooling Details
- Power BI Desktop & Service
- M (Power Query)
- DAX expressions
- SVG assets (exported from Figma)
- Figma (UI mockups)
- GitHub (version control for SVGs, .pbix metadata)

## Diagram (Mermaid)

```mermaid
flowchart TB
    %% Ingestion Layer
    subgraph "Ingestion Layer" 
        direction TB
        SQLDB["SQL Database"]:::external
        CSV["CSV / Excel Files"]:::external
        SP["SharePoint Lists"]:::external
        PQ["Power Query / M Scripts"]:::ingestion
        SQLDB -->|Ingest| PQ
        CSV -->|Ingest| PQ
        SP -->|Ingest| PQ
    end

    %% Semantic Layer
    subgraph "Semantic Layer" 
        direction TB
        DM["Data Model (Tabular)"]:::modeling
        DAX["DAX Calculation Engine"]:::modeling
        PQ -->|Load Tables| DM
        DM -->|Executes Measures| DAX
    end

    %% Visualization Layer
    subgraph "Visualization Layer"
        direction TB
        SVG["Custom SVG Visuals"]:::visual
        PBIX["PBIX Report Definition"]:::visual
        DAX -->|Feeds Data| SVG
        DM -->|Feeds Data| SVG
        SVG -->|Combined in| PBIX
    end

    %% Deployment Layer
    subgraph "Deployment & Consumption"
        direction TB
        PBIService["Power BI Service (Cloud)"]:::deployment
        Users["End Users / Stakeholders"]:::deployment
        PBIX -->|Publish| PBIService
        PBIService -.->|Read Access| Users
    end

    %% Project Documentation
    ProjectDoc["Project Documentation"]:::external
    click ProjectDoc "https://github.com/priyankfeb/pbi-assoc_onboarding/blob/main/README.md"

    %% Legend
    subgraph "Legend"
        direction TB
        L1["Cylinder: Data Sources"]:::external
        L2["Rectangle: Processing Steps"]:::ingestion
        L3["Cube: Semantic Model"]:::modeling
        L4["Paint Brush: Visualization"]:::visual
        L5["Cloud: Deployment"]:::deployment
    end

    classDef ingestion fill:#cce5ff,stroke:#3399ff,color:#004085;
    classDef modeling fill:#d4edda,stroke:#28a745,color:#155724;
    classDef visual fill:#fff3cd,stroke:#ffca2c,color:#856404;
    classDef deployment fill:#e2e3e5,stroke:#6c757d,color:#343a40;
    classDef external fill:#f8f9fa,stroke:#ced4da,color:#6c757d;
```
