# sai-krishna-akkala/powerbi-dashboard architecture

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

- Interactive diagram: https://gitdiagram.com/sai-krishna-akkala/powerbi-dashboard
- Repository: https://github.com/sai-krishna-akkala/powerbi-dashboard

## Overview

This repository is a Power BI HR analytics project for exploring workforce distribution and employee attrition through an interactive dashboard. Its documented workflow runs from HR data preparation and transformation through modeling and DAX calculations to dashboard development and analysis, with regional row-level security as a separate capability. The PBIX is the only implementation artifact available, so dashboard stages share that path; relationships reflect the README workflow rather than inspected internals.

Main entry points: [`Attrition-dashboard.pbix`](https://github.com/sai-krishna-akkala/powerbi-dashboard/blob/main/Attrition-dashboard.pbix) (Power BI dashboard), [`Data/HR_Analytics.csv`](https://github.com/sai-krishna-akkala/powerbi-dashboard/blob/main/Data/HR_Analytics.csv) (HR analytics data)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Data preparation"]
  node_hr_data["HR analytics data<br/>[HR_Analytics.csv]"]
  node_sample_data["Sample data<br/>[sample-data.csv]"]
  node_preparation["Data preparation"]
  node_transformation["Data transformation"]
end

subgraph group_analysis["Analytics"]
  node_modeling["Data modeling"]
  node_dax["DAX calculations"]
  node_workforce["Workforce analytics"]
  node_attrition["Attrition analysis"]
end

subgraph group_experience["Dashboard and access"]
  node_visualization["Interactive visuals"]
  node_dashboard["Power BI dashboard"]
  node_insights["Insights and analysis"]
  node_rls["Regional RLS"]
end

node_hr_user(("HR analyst"))

node_hr_data -->|"prepares"| node_preparation
node_preparation -->|"transforms"| node_transformation
node_transformation -->|"models"| node_modeling
node_modeling -->|"feeds calculations"| node_dax
node_dax -->|"supports development"| node_dashboard
node_dashboard -->|"presents"| node_insights
node_hr_user -->|"explores"| node_dashboard
node_workforce -->|"visualizes"| node_visualization
node_attrition -->|"visualizes"| node_visualization
node_visualization -->|"forms"| node_dashboard
node_dashboard -->|"applies access controls"| node_rls

click node_hr_data "https://github.com/sai-krishna-akkala/powerbi-dashboard/blob/main/Data/HR_Analytics.csv"
click node_sample_data "https://github.com/sai-krishna-akkala/powerbi-dashboard/blob/main/Data/sample-data.csv"
click node_preparation "https://github.com/sai-krishna-akkala/powerbi-dashboard/blob/main/Attrition-dashboard.pbix"
click node_transformation "https://github.com/sai-krishna-akkala/powerbi-dashboard/blob/main/Attrition-dashboard.pbix"
click node_modeling "https://github.com/sai-krishna-akkala/powerbi-dashboard/blob/main/Attrition-dashboard.pbix"
click node_dax "https://github.com/sai-krishna-akkala/powerbi-dashboard/blob/main/Attrition-dashboard.pbix"
click node_workforce "https://github.com/sai-krishna-akkala/powerbi-dashboard/blob/main/Attrition-dashboard.pbix"
click node_attrition "https://github.com/sai-krishna-akkala/powerbi-dashboard/blob/main/Attrition-dashboard.pbix"
click node_visualization "https://github.com/sai-krishna-akkala/powerbi-dashboard/blob/main/Attrition-dashboard.pbix"
click node_dashboard "https://github.com/sai-krishna-akkala/powerbi-dashboard/blob/main/Attrition-dashboard.pbix"
click node_insights "https://github.com/sai-krishna-akkala/powerbi-dashboard/blob/main/Attrition-dashboard.pbix"
click node_rls "https://github.com/sai-krishna-akkala/powerbi-dashboard/blob/main/Attrition-dashboard.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_hr_data,node_sample_data,node_preparation,node_transformation toneBlue
class node_modeling,node_dax,node_workforce,node_attrition toneAmber
class node_visualization,node_dashboard,node_insights,node_rls toneMint
class node_hr_user toneIndigo
```

## Components

### Data preparation

- [HR analytics data](https://github.com/sai-krishna-akkala/powerbi-dashboard/blob/main/Data/HR_Analytics.csv): `Data/HR_Analytics.csv`
- [Sample data](https://github.com/sai-krishna-akkala/powerbi-dashboard/blob/main/Data/sample-data.csv): `Data/sample-data.csv`
- [Data preparation](https://github.com/sai-krishna-akkala/powerbi-dashboard/blob/main/Attrition-dashboard.pbix): `Attrition-dashboard.pbix`
- [Data transformation](https://github.com/sai-krishna-akkala/powerbi-dashboard/blob/main/Attrition-dashboard.pbix): `Attrition-dashboard.pbix`

### Analytics

- [Data modeling](https://github.com/sai-krishna-akkala/powerbi-dashboard/blob/main/Attrition-dashboard.pbix): `Attrition-dashboard.pbix`
- [DAX calculations](https://github.com/sai-krishna-akkala/powerbi-dashboard/blob/main/Attrition-dashboard.pbix): `Attrition-dashboard.pbix`
- [Workforce analytics](https://github.com/sai-krishna-akkala/powerbi-dashboard/blob/main/Attrition-dashboard.pbix): `Attrition-dashboard.pbix`
- [Attrition analysis](https://github.com/sai-krishna-akkala/powerbi-dashboard/blob/main/Attrition-dashboard.pbix): `Attrition-dashboard.pbix`

### Dashboard and access

- [Interactive visuals](https://github.com/sai-krishna-akkala/powerbi-dashboard/blob/main/Attrition-dashboard.pbix): `Attrition-dashboard.pbix`
- [Power BI dashboard](https://github.com/sai-krishna-akkala/powerbi-dashboard/blob/main/Attrition-dashboard.pbix): `Attrition-dashboard.pbix`
- [Insights and analysis](https://github.com/sai-krishna-akkala/powerbi-dashboard/blob/main/Attrition-dashboard.pbix): `Attrition-dashboard.pbix`
- [Regional RLS](https://github.com/sai-krishna-akkala/powerbi-dashboard/blob/main/Attrition-dashboard.pbix): `Attrition-dashboard.pbix`

### Other components

- **HR analyst**

## Connections

- HR analytics data → Data preparation: prepares (evidence: `README.md`)
- Data preparation → Data transformation: transforms (evidence: `README.md`)
- Data transformation → Data modeling: models (evidence: `README.md`)
- Data modeling → DAX calculations: feeds calculations (evidence: `README.md`)
- DAX calculations → Power BI dashboard: supports development (evidence: `README.md`)
- Power BI dashboard → Insights and analysis: presents (evidence: `README.md`)
- HR analyst → Power BI dashboard: explores (evidence: `README.md`)
- Workforce analytics → Interactive visuals: visualizes (evidence: `README.md`)
- Attrition analysis → Interactive visuals: visualizes (evidence: `README.md`)
- Interactive visuals → Power BI dashboard: forms (evidence: `README.md`)
- Power BI dashboard → Regional RLS: applies access controls (evidence: `README.md`)
