TSA Dashboard: Difference between revisions
No edit summary |
No edit summary |
||
| Line 5: | Line 5: | ||
It supports exploratory analysis across the following core dimensions: | It supports exploratory analysis across the following core dimensions: | ||
Courses – Individual training programs and their performance | Courses – Individual training programs and their performance | ||
Booked Courses – Volume of confirmed bookings | Booked Courses – Volume of confirmed bookings | ||
Course Groups – High-level categories of training | Course Groups – High-level categories of training | ||
Companies – Customer-level breakdown, including which courses each company has purchased | Companies – Customer-level breakdown, including which courses each company has purchased | ||
Total Revenue – Overall and segmented income generated | Total Revenue – Overall and segmented income generated | ||
Revision as of 10:16, 7 April 2026
Summary
The TSA Report is a Power BI dashboard designed to provide comprehensive visibility into course bookings, participation, and revenue performance for training services delivered to corporate clients (companies).
It supports exploratory analysis across the following core dimensions:
Courses – Individual training programs and their performance Booked Courses – Volume of confirmed bookings Course Groups – High-level categories of training Companies – Customer-level breakdown, including which courses each company has purchased
Total Revenue – Overall and segmented income generated
The dashboard aggregates data from the orders and order_courses tables, focusing exclusively on confirmed/processed orders (where order_status >= 1).
Tables & Columns Included
| Database | Table | Columns |
|---|---|---|
Filters
| Filter | Description |
|---|---|
Data Transformation Applied
[To be added]
| Query | Calculations | Description |
|---|---|---|
Calculations
| Reference | Calculation | Description |
|---|---|---|