TSA Dashboard: Difference between revisions

Revision as of 10:42, 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
tsa_reporting_db	order	id,order_status,company_id,user_id,ordered_by,currency,voucher_code,

Filters


Filter	Description

Data Transformation Applied

[To be added]


Query	Calculations	Description

Calculations

Reference	Calculation	Description

@@ Line 11: / Line 11: @@
   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).
+The dashboard aggregates data from the orders and order courses tables, focusing exclusively on confirmed/processed orders (where order status >= 1).
 == Tables & Columns Included ==
@@ Line 20: / Line 20: @@
 !Columns
 |-
-|
+|tsa_reporting_db
-|
+|order
-|
+|id,order_status,company_id,user_id,ordered_by,currency,voucher_code,
 |}