# pulengtshaba/training-management-analytics architecture

> Architecture diagram of the GitHub repository pulengtshaba/training-management-analytics, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-06). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/pulengtshaba/training-management-analytics
- Repository: https://github.com/pulengtshaba/training-management-analytics

## Overview

This repository is a Power BI training-management analytics project: operational records are prepared and modelled into measures and interactive reports for management audiences. The README documents the semantic model, analytical capabilities, report pages, Row-Level Security and Service deployment. No source excerpts are available, so the graph relies on README statements; links from the listed CSV files into the Power BI artifact are marked unverified.

Main entry points: [`powerbi/TrainingManagementAnalytics.pbix`](https://github.com/pulengtshaba/training-management-analytics/blob/main/powerbi/TrainingManagementAnalytics.pbix) (Data Preparation), [`data/branches.csv`](https://github.com/pulengtshaba/training-management-analytics/blob/main/data/branches.csv) (Branches), [`data/employees.csv`](https://github.com/pulengtshaba/training-management-analytics/blob/main/data/employees.csv) (Employees), [`data/training_programs.csv`](https://github.com/pulengtshaba/training-management-analytics/blob/main/data/training_programs.csv) (Training Programs)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_inputs["Training Data"]
  node_tms[("SQL / TMS")]
  node_branches["Branches<br/>[branches.csv]"]
  node_employees["Employees<br/>[employees.csv]"]
  node_programs["Training Programs"]
  node_events["Training Events"]
  node_participants["Event Participants"]
end

subgraph group_model["Analytics Model"]
  node_preparation["Data Preparation"]
  node_semantic[("Dimensional Model")]
  node_measures["DAX Measures"]
  node_time["Time Intelligence"]
end

subgraph group_reports["Reports"]
  node_executive["Executive Overview"]
  node_program["Program Performance"]
  node_employee["Employee Analysis"]
  node_branch["Branch Performance"]
  node_operationsreport["Training Operations"]
end

subgraph group_operations["Access and Delivery"]
  node_rls["Row-Level Security"]
  node_service["Power BI Service"]
end

node_audiences(("Business Users"))

node_tms -->|"provides data"| node_preparation
node_branches -.->|"feeds"| node_preparation
node_employees -.->|"feeds"| node_preparation
node_programs -.->|"feeds"| node_preparation
node_events -.->|"feeds"| node_preparation
node_participants -.->|"feeds"| node_preparation
node_preparation -->|"transforms into"| node_semantic
node_semantic -->|"supports"| node_measures
node_time -->|"uses date model"| node_semantic
node_measures -->|"powers"| node_executive
node_measures -->|"powers"| node_program
node_measures -->|"powers"| node_employee
node_measures -->|"powers"| node_branch
node_measures -->|"powers"| node_operationsreport
node_audiences -->|"analyze"| node_executive
node_audiences -->|"analyze"| node_program
node_audiences -->|"analyze"| node_employee
node_audiences -->|"analyze"| node_branch
node_audiences -->|"analyze"| node_operationsreport
node_rls -->|"restricts access"| node_semantic
node_service -->|"distributes reports"| node_audiences
node_executive -->|"deploys to"| node_service

click node_branches "https://github.com/pulengtshaba/training-management-analytics/blob/main/data/branches.csv"
click node_employees "https://github.com/pulengtshaba/training-management-analytics/blob/main/data/employees.csv"
click node_programs "https://github.com/pulengtshaba/training-management-analytics/blob/main/data/training_programs.csv"
click node_events "https://github.com/pulengtshaba/training-management-analytics/blob/main/data/training_events.csv"
click node_participants "https://github.com/pulengtshaba/training-management-analytics/blob/main/data/event_participants.csv"
click node_preparation "https://github.com/pulengtshaba/training-management-analytics/blob/main/powerbi/TrainingManagementAnalytics.pbix"
click node_semantic "https://github.com/pulengtshaba/training-management-analytics/blob/main/powerbi/TrainingManagementAnalytics.pbix"
click node_measures "https://github.com/pulengtshaba/training-management-analytics/blob/main/powerbi/TrainingManagementAnalytics.pbix"
click node_time "https://github.com/pulengtshaba/training-management-analytics/blob/main/powerbi/TrainingManagementAnalytics.pbix"
click node_executive "https://github.com/pulengtshaba/training-management-analytics/blob/main/powerbi/TrainingManagementAnalytics.pbix"
click node_program "https://github.com/pulengtshaba/training-management-analytics/blob/main/powerbi/TrainingManagementAnalytics.pbix"
click node_employee "https://github.com/pulengtshaba/training-management-analytics/blob/main/powerbi/TrainingManagementAnalytics.pbix"
click node_branch "https://github.com/pulengtshaba/training-management-analytics/blob/main/powerbi/TrainingManagementAnalytics.pbix"
click node_operationsreport "https://github.com/pulengtshaba/training-management-analytics/blob/main/powerbi/TrainingManagementAnalytics.pbix"
click node_rls "https://github.com/pulengtshaba/training-management-analytics/blob/main/powerbi/TrainingManagementAnalytics.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_tms,node_branches,node_employees,node_programs,node_events,node_participants,node_audiences toneBlue
class node_preparation,node_semantic,node_measures,node_time toneAmber
class node_executive,node_program,node_employee,node_branch,node_operationsreport toneMint
class node_rls,node_service toneRose
```

## Components

### Training Data

- **SQL / TMS**
- [Branches](https://github.com/pulengtshaba/training-management-analytics/blob/main/data/branches.csv): `data/branches.csv`
- [Employees](https://github.com/pulengtshaba/training-management-analytics/blob/main/data/employees.csv): `data/employees.csv`
- [Training Programs](https://github.com/pulengtshaba/training-management-analytics/blob/main/data/training_programs.csv): `data/training_programs.csv`
- [Training Events](https://github.com/pulengtshaba/training-management-analytics/blob/main/data/training_events.csv): `data/training_events.csv`
- [Event Participants](https://github.com/pulengtshaba/training-management-analytics/blob/main/data/event_participants.csv): `data/event_participants.csv`

### Analytics Model

- [Data Preparation](https://github.com/pulengtshaba/training-management-analytics/blob/main/powerbi/TrainingManagementAnalytics.pbix): `powerbi/TrainingManagementAnalytics.pbix`
- [Dimensional Model](https://github.com/pulengtshaba/training-management-analytics/blob/main/powerbi/TrainingManagementAnalytics.pbix): `powerbi/TrainingManagementAnalytics.pbix`
- [DAX Measures](https://github.com/pulengtshaba/training-management-analytics/blob/main/powerbi/TrainingManagementAnalytics.pbix): `powerbi/TrainingManagementAnalytics.pbix`
- [Time Intelligence](https://github.com/pulengtshaba/training-management-analytics/blob/main/powerbi/TrainingManagementAnalytics.pbix): `powerbi/TrainingManagementAnalytics.pbix`

### Reports

- [Executive Overview](https://github.com/pulengtshaba/training-management-analytics/blob/main/powerbi/TrainingManagementAnalytics.pbix): `powerbi/TrainingManagementAnalytics.pbix`
- [Program Performance](https://github.com/pulengtshaba/training-management-analytics/blob/main/powerbi/TrainingManagementAnalytics.pbix): `powerbi/TrainingManagementAnalytics.pbix`
- [Employee Analysis](https://github.com/pulengtshaba/training-management-analytics/blob/main/powerbi/TrainingManagementAnalytics.pbix): `powerbi/TrainingManagementAnalytics.pbix`
- [Branch Performance](https://github.com/pulengtshaba/training-management-analytics/blob/main/powerbi/TrainingManagementAnalytics.pbix): `powerbi/TrainingManagementAnalytics.pbix`
- [Training Operations](https://github.com/pulengtshaba/training-management-analytics/blob/main/powerbi/TrainingManagementAnalytics.pbix): `powerbi/TrainingManagementAnalytics.pbix`

### Access and Delivery

- [Row-Level Security](https://github.com/pulengtshaba/training-management-analytics/blob/main/powerbi/TrainingManagementAnalytics.pbix): `powerbi/TrainingManagementAnalytics.pbix`
- **Power BI Service**

### Other components

- **Business Users**

## Connections

- SQL / TMS → Data Preparation: provides data (evidence: `README.md`)
- Branches → Data Preparation: feeds
- Employees → Data Preparation: feeds
- Training Programs → Data Preparation: feeds
- Training Events → Data Preparation: feeds
- Event Participants → Data Preparation: feeds
- Data Preparation → Dimensional Model: transforms into (evidence: `README.md`)
- Dimensional Model → DAX Measures: supports (evidence: `README.md`)
- Time Intelligence → Dimensional Model: uses date model (evidence: `README.md`)
- DAX Measures → Executive Overview: powers (evidence: `README.md`)
- DAX Measures → Program Performance: powers (evidence: `README.md`)
- DAX Measures → Employee Analysis: powers (evidence: `README.md`)
- DAX Measures → Branch Performance: powers (evidence: `README.md`)
- DAX Measures → Training Operations: powers (evidence: `README.md`)
- Business Users → Executive Overview: analyze (evidence: `README.md`)
- Business Users → Program Performance: analyze (evidence: `README.md`)
- Business Users → Employee Analysis: analyze (evidence: `README.md`)
- Business Users → Branch Performance: analyze (evidence: `README.md`)
- Business Users → Training Operations: analyze (evidence: `README.md`)
- Row-Level Security → Dimensional Model: restricts access (evidence: `README.md`)
- Power BI Service → Business Users: distributes reports (evidence: `README.md`)
- Executive Overview → Power BI Service: deploys to (evidence: `README.md`)
