# rushit004/powerbi-data-analytics-portfolio architecture

> Architecture diagram of the GitHub repository rushit004/powerbi-data-analytics-portfolio, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-15). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/rushit004/powerbi-data-analytics-portfolio
- Repository: https://github.com/rushit004/powerbi-data-analytics-portfolio

## Overview

This repository is a portfolio of four Power BI analytics projects. Their common workflow runs from supplied datasets through Power Query cleaning, data modeling and DAX to interactive reports; each project adds distinct analysis or delivery capabilities. The README also documents paginated reporting and automation integrations. No source excerpts were provided, so relationships below are limited to those explicitly described in the portfolio README; some implementation details are represented at directory level.

Main entry points: [`05_Financial Dashboard/Automation`](https://github.com/rushit004/powerbi-data-analytics-portfolio/tree/main/05_Financial%20Dashboard/Automation) (Data pipeline), [`02_Global Super Store`](https://github.com/rushit004/powerbi-data-analytics-portfolio/tree/main/02_Global%20Super%20Store) (Retail analysis), [`01_IPL Dashboard in Power BI/Report/ipl dashboard.pbix`](https://github.com/rushit004/powerbi-data-analytics-portfolio/blob/main/01_IPL%20Dashboard%20in%20Power%20BI/Report/ipl%20dashboard.pbix) (Interactive report), [`03_Advanture Works/Report/Adventure Works.pbix`](https://github.com/rushit004/powerbi-data-analytics-portfolio/blob/main/03_Advanture%20Works/Report/Adventure%20Works.pbix) (Sales dashboard)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_ipl["IPL Analytics"]
  node_ipl_data[("Season datasets")]
  node_ipl_prep["Query and model"]
  node_ipl_measures["DAX analysis<br/>[ipl dashboard.pbix]"]
  node_ipl_report["Interactive report<br/>[ipl dashboard.pbix]"]
  node_ipl_features["Match and player insights<br/>[ipl dashboard.pbix]"]
end

subgraph group_retail["Global Retail"]
  node_retail_data[("Global retail data")]
  node_retail_prep["Query and model"]
  node_retail_analysis["Retail analysis"]
  node_retail_report["Interactive dashboard"]
  node_retail_invoice["Paginated invoices"]
end

subgraph group_adventure["Adventure Works"]
  node_adventure_data[("Sales datasets")]
  node_adventure_model["Star schema and DAX"]
  node_adventure_report["Sales dashboard"]
  node_adventure_flow["Sales email flow"]
end

subgraph group_financial["Financial Risk"]
  node_financial_source[("Daily survey files")]
  node_financial_automation["Data pipeline"]
  node_financial_model["Credit-risk model"]
  node_financial_report["Risk dashboard"]
end

node_analyst(("Report user"))
node_power_automate{{"Power Automate"}}
node_outlook["Outlook"]
node_drive["Google Drive API"]

node_ipl_data -->|"cleans and models"| node_ipl_prep
node_ipl_prep -->|"feeds analysis"| node_ipl_measures
node_ipl_measures -->|"drives report"| node_ipl_report
node_ipl_report -->|"presents insights"| node_ipl_features
node_analyst -->|"explores"| node_ipl_report
node_retail_data -->|"cleans and models"| node_retail_prep
node_retail_prep -->|"feeds analysis"| node_retail_analysis
node_retail_analysis -->|"drives dashboard"| node_retail_report
node_retail_analysis -->|"supports invoices"| node_retail_invoice
node_analyst -->|"explores"| node_retail_report
node_adventure_data -->|"feeds modeling"| node_adventure_model
node_adventure_model -->|"drives dashboard"| node_adventure_report
node_analyst -->|"explores"| node_adventure_report
node_adventure_report -->|"emails summary"| node_adventure_flow
node_adventure_flow -->|"uses"| node_power_automate
node_outlook -->|"starts pipeline"| node_financial_automation
node_power_automate -->|"orchestrates"| node_financial_automation
node_financial_automation -->|"uses API"| node_drive
node_financial_automation -->|"produces combined data"| node_financial_source
node_financial_source -->|"feeds scoring"| node_financial_model
node_financial_model -->|"drives dashboard"| node_financial_report
node_analyst -->|"explores"| node_financial_report

click node_ipl_data "https://github.com/rushit004/powerbi-data-analytics-portfolio/tree/main/01_IPL%20Dashboard%20in%20Power%20BI/indian-premier-league-ipl-all-seasons"
click node_ipl_prep "https://github.com/rushit004/powerbi-data-analytics-portfolio/tree/main/01_IPL%20Dashboard%20in%20Power%20BI"
click node_ipl_measures "https://github.com/rushit004/powerbi-data-analytics-portfolio/blob/main/01_IPL%20Dashboard%20in%20Power%20BI/Report/ipl%20dashboard.pbix"
click node_ipl_report "https://github.com/rushit004/powerbi-data-analytics-portfolio/blob/main/01_IPL%20Dashboard%20in%20Power%20BI/Report/ipl%20dashboard.pbix"
click node_ipl_features "https://github.com/rushit004/powerbi-data-analytics-portfolio/blob/main/01_IPL%20Dashboard%20in%20Power%20BI/Report/ipl%20dashboard.pbix"
click node_retail_data "https://github.com/rushit004/powerbi-data-analytics-portfolio/blob/main/02_Global%20Super%20Store/DataSet/GlobalSuperstore.xlsx"
click node_retail_prep "https://github.com/rushit004/powerbi-data-analytics-portfolio/tree/main/02_Global%20Super%20Store"
click node_retail_analysis "https://github.com/rushit004/powerbi-data-analytics-portfolio/tree/main/02_Global%20Super%20Store"
click node_retail_report "https://github.com/rushit004/powerbi-data-analytics-portfolio/blob/main/02_Global%20Super%20Store/Reports/globalsuperstore.pbix"
click node_retail_invoice "https://github.com/rushit004/powerbi-data-analytics-portfolio/blob/main/02_Global%20Super%20Store/Reports/Paginated%20report.rdl"
click node_adventure_data "https://github.com/rushit004/powerbi-data-analytics-portfolio/tree/main/03_Advanture%20Works/Datasets"
click node_adventure_model "https://github.com/rushit004/powerbi-data-analytics-portfolio/tree/main/03_Advanture%20Works"
click node_adventure_report "https://github.com/rushit004/powerbi-data-analytics-portfolio/blob/main/03_Advanture%20Works/Report/Adventure%20Works.pbix"
click node_adventure_flow "https://github.com/rushit004/powerbi-data-analytics-portfolio/tree/main/03_Advanture%20Works"
click node_financial_source "https://github.com/rushit004/powerbi-data-analytics-portfolio/tree/main/05_Financial%20Dashboard/Data"
click node_financial_automation "https://github.com/rushit004/powerbi-data-analytics-portfolio/tree/main/05_Financial%20Dashboard/Automation"
click node_financial_model "https://github.com/rushit004/powerbi-data-analytics-portfolio/tree/main/05_Financial%20Dashboard"
click node_financial_report "https://github.com/rushit004/powerbi-data-analytics-portfolio/blob/main/05_Financial%20Dashboard/Report/Financial_Project.pbix"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_ipl_data,node_ipl_prep,node_ipl_measures,node_ipl_report,node_ipl_features,node_analyst toneBlue
class node_retail_data,node_retail_prep,node_retail_analysis,node_retail_report,node_retail_invoice toneAmber
class node_adventure_data,node_adventure_model,node_adventure_report,node_adventure_flow,node_drive toneMint
class node_financial_source,node_financial_automation,node_financial_model,node_financial_report toneRose
class node_power_automate,node_outlook toneIndigo
```

## Components

### IPL Analytics

- [Season datasets](https://github.com/rushit004/powerbi-data-analytics-portfolio/tree/main/01_IPL%20Dashboard%20in%20Power%20BI/indian-premier-league-ipl-all-seasons): `01_IPL Dashboard in Power BI/indian-premier-league-ipl-all-seasons`
- [Query and model](https://github.com/rushit004/powerbi-data-analytics-portfolio/tree/main/01_IPL%20Dashboard%20in%20Power%20BI): `01_IPL Dashboard in Power BI`
- [DAX analysis](https://github.com/rushit004/powerbi-data-analytics-portfolio/blob/main/01_IPL%20Dashboard%20in%20Power%20BI/Report/ipl%20dashboard.pbix): `01_IPL Dashboard in Power BI/Report/ipl dashboard.pbix`
- [Interactive report](https://github.com/rushit004/powerbi-data-analytics-portfolio/blob/main/01_IPL%20Dashboard%20in%20Power%20BI/Report/ipl%20dashboard.pbix): `01_IPL Dashboard in Power BI/Report/ipl dashboard.pbix`
- [Match and player insights](https://github.com/rushit004/powerbi-data-analytics-portfolio/blob/main/01_IPL%20Dashboard%20in%20Power%20BI/Report/ipl%20dashboard.pbix): `01_IPL Dashboard in Power BI/Report/ipl dashboard.pbix`

### Global Retail

- [Global retail data](https://github.com/rushit004/powerbi-data-analytics-portfolio/blob/main/02_Global%20Super%20Store/DataSet/GlobalSuperstore.xlsx): `02_Global Super Store/DataSet/GlobalSuperstore.xlsx`
- [Query and model](https://github.com/rushit004/powerbi-data-analytics-portfolio/tree/main/02_Global%20Super%20Store): `02_Global Super Store`
- [Retail analysis](https://github.com/rushit004/powerbi-data-analytics-portfolio/tree/main/02_Global%20Super%20Store): `02_Global Super Store`
- [Interactive dashboard](https://github.com/rushit004/powerbi-data-analytics-portfolio/blob/main/02_Global%20Super%20Store/Reports/globalsuperstore.pbix): `02_Global Super Store/Reports/globalsuperstore.pbix`
- [Paginated invoices](https://github.com/rushit004/powerbi-data-analytics-portfolio/blob/main/02_Global%20Super%20Store/Reports/Paginated%20report.rdl): `02_Global Super Store/Reports/Paginated report.rdl`

### Adventure Works

- [Sales datasets](https://github.com/rushit004/powerbi-data-analytics-portfolio/tree/main/03_Advanture%20Works/Datasets): `03_Advanture Works/Datasets`
- [Star schema and DAX](https://github.com/rushit004/powerbi-data-analytics-portfolio/tree/main/03_Advanture%20Works): `03_Advanture Works`
- [Sales dashboard](https://github.com/rushit004/powerbi-data-analytics-portfolio/blob/main/03_Advanture%20Works/Report/Adventure%20Works.pbix): `03_Advanture Works/Report/Adventure Works.pbix`
- [Sales email flow](https://github.com/rushit004/powerbi-data-analytics-portfolio/tree/main/03_Advanture%20Works): `03_Advanture Works`

### Financial Risk

- [Daily survey files](https://github.com/rushit004/powerbi-data-analytics-portfolio/tree/main/05_Financial%20Dashboard/Data): `05_Financial Dashboard/Data`
- [Data pipeline](https://github.com/rushit004/powerbi-data-analytics-portfolio/tree/main/05_Financial%20Dashboard/Automation): `05_Financial Dashboard/Automation`
- [Credit-risk model](https://github.com/rushit004/powerbi-data-analytics-portfolio/tree/main/05_Financial%20Dashboard): `05_Financial Dashboard`
- [Risk dashboard](https://github.com/rushit004/powerbi-data-analytics-portfolio/blob/main/05_Financial%20Dashboard/Report/Financial_Project.pbix): `05_Financial Dashboard/Report/Financial_Project.pbix`

### Other components

- **Report user**
- **Power Automate**
- **Outlook**
- **Google Drive API**

## Connections

- Season datasets → Query and model: cleans and models (evidence: `README.md`)
- Query and model → DAX analysis: feeds analysis (evidence: `README.md`)
- DAX analysis → Interactive report: drives report (evidence: `README.md`)
- Interactive report → Match and player insights: presents insights (evidence: `README.md`)
- Report user → Interactive report: explores (evidence: `README.md`)
- Global retail data → Query and model: cleans and models (evidence: `README.md`)
- Query and model → Retail analysis: feeds analysis (evidence: `README.md`)
- Retail analysis → Interactive dashboard: drives dashboard (evidence: `README.md`)
- Retail analysis → Paginated invoices: supports invoices (evidence: `README.md`)
- Report user → Interactive dashboard: explores (evidence: `README.md`)
- Sales datasets → Star schema and DAX: feeds modeling (evidence: `README.md`)
- Star schema and DAX → Sales dashboard: drives dashboard (evidence: `README.md`)
- Report user → Sales dashboard: explores (evidence: `README.md`)
- Sales dashboard → Sales email flow: emails summary (evidence: `README.md`)
- Sales email flow → Power Automate: uses (evidence: `README.md`)
- Outlook → Data pipeline: starts pipeline (evidence: `README.md`)
- Power Automate → Data pipeline: orchestrates (evidence: `README.md`)
- Data pipeline → Google Drive API: uses API (evidence: `README.md`)
- Data pipeline → Daily survey files: produces combined data (evidence: `README.md`)
- Daily survey files → Credit-risk model: feeds scoring (evidence: `README.md`)
- Credit-risk model → Risk dashboard: drives dashboard (evidence: `README.md`)
- Report user → Risk dashboard: explores (evidence: `README.md`)