TSA Dashboard - Revision history

Hendry.mwamburi: /* Data Transformation Applied */

2026-04-08T12:23:34Z

Data Transformation Applied

← Older revision		Revision as of 14:23, 8 April 2026
Line 171:		Line 171:


			\|}This table shows all individual orders for Courses delivered to Customers (Companies).
			{\| class="wikitable"
			\|'''Column'''
			\|'''Description'''
			\|-
			\|'''Order ID'''
			\|Unique identifier for each booking/order
			\|-
			\|'''Date'''
			\|The date the order was placed or the course was scheduled
			\|-
			\|'''Company'''
			\|Name of the customer/company that booked the training.
			\|-
			\|'''Course Name'''
			\|Name of the training course (e.g. '''General Security Awareness Training (GSAT)''')
			\|-
			\|'''Course ID'''
			\|Internal code for the course.
			\|-
			\|'''Course Group'''
			\|Category/group the course belongs
			\|-
			\|'''Price Per Person'''
			\|Cost charged per participant for the training
			\|-
			\|'''Users With Booked Courses'''
			\|Number of people who attended/booked this specific order.
			\|-
			\|'''Min Price'''
			\|This is the fixed price for the course.
			\|-
			\|'''Total Income'''
			\|Revenue generated from that specific order (in this data per row)
	\|}		\|}

2026-04-08T12:16:06Z

Calculations

← Older revision		Revision as of 14:16, 8 April 2026
Line 169:		Line 169:
	Only '''valid orders''' (orders with order_status >= 1) are included in the calculation.		Only '''valid orders''' (orders with order_status >= 1) are included in the calculation.

	\|-
	~~\|Booked Courses~~
	~~\|Booked Courses =~~
	~~CALCULATE(~~

	~~DISTINCTCOUNT(order_courses[course_id]),~~

	~~FILTER(~~

	~~orders,~~

	~~orders[order_status] >= 1~~

	)

	)
	~~\|The measure counts distinct course_id values from the order_courses table but only for orders whose status indicates they are '''confirmed or processed'''.~~

	\|}		\|}

2026-04-08T12:15:41Z

Calculations

← Older revision		Revision as of 14:15, 8 April 2026
Line 187:		Line 187:
	\|The measure counts distinct course_id values from the order_courses table but only for orders whose status indicates they are '''confirmed or processed'''.		\|The measure counts distinct course_id values from the order_courses table but only for orders whose status indicates they are '''confirmed or processed'''.

	\|-
	~~\|Booked Courses~~
	~~\|Booked Courses =~~
	~~CALCULATE(~~

	~~DISTINCTCOUNT(order_courses[course_id]),~~

	~~FILTER(~~

	~~orders,~~

	~~orders[order_status] >= 1~~

	)

	)
	~~\|The measure counts distinct course_id values from the order_courses table but only for orders whose status indicates they are '''confirmed or processed'''.~~
	\|}		\|}

2026-04-07T13:32:35Z

Calculations

← Older revision		Revision as of 15:32, 7 April 2026
Line 124:		Line 124:

	\|-		\|-
	\|~~Booked Courses~~		\|Total Income
	\|~~Booked Courses~~ =		\|Total Income =
	~~CALCULATE(~~		VAR _total_person =

	~~DISTINCTCOUNT~~(~~order_courses[course_id]),~~		CALCULATE(

	~~FILTER~~(		SUMX(

	~~orders~~,		order_courses,

	orders[order_status] >= 1		order_courses[price_per_person] * [Users With Booked Courses]

			),

			orders[order_status] >= 1,

			NOT(ISBLANK(order_courses[id]))

	)		)

	)
	\|The measure ~~counts distinct course_id values~~ from ~~the order_courses table but only for orders whose status indicates they are~~ '''~~confirmed or processed~~'''.		VAR _minprice =

			CALCULATE(

			SUM(order_courses[min_price]),

			orders[order_status] >= 1,

			NOT(ISBLANK(order_courses[id]))

			)

			RETURN

			_total_person + _minprice
			\|'''The measure is''' used to calculate the '''total revenue generated from booked courses'''.
			It combines:

			Income generated '''per person per course'''

			Additional '''minimum course pricing'''

			Only '''valid orders''' (orders with order_status >= 1) are included in the calculation.

	\|-		\|-

2026-04-07T13:30:27Z

Calculations

@@ Line 105: / Line 105: @@
 ! style="width: 40%;" |Calculation
 ! style="width: 40%;" |Description
 |-
 |Booked Courses

2026-04-07T13:29:49Z

Calculations

← Older revision		Revision as of 15:29, 7 April 2026
Line 106:		Line 106:
	! style="width: 40%;" \|Description		! style="width: 40%;" \|Description
	\|-		\|-
	\|		\|Booked Courses
	\|		\|Booked Courses =
	\|		CALCULATE(

			DISTINCTCOUNT(order_courses[course_id]),

			FILTER(

			orders,

			orders[order_status] >= 1

			)

			)
			\|The measure counts distinct course_id values from the order_courses table but only for orders whose status indicates they are '''confirmed or processed'''.
	\|}		\|}

2026-04-07T10:02:12Z

Filters

← Older revision		Revision as of 12:02, 7 April 2026
Line 79:		Line 79:

	\|-		\|-
	\|~~Company~~		\|Course Group
	\|Helps the user filter values by ~~company~~		\|Helps the user filter values by course Group

	\|-		\|-
	\|~~Company~~		\|Date
	\|Helps the user filter values by ~~company~~		\|Helps the user filter values by date range
	\|}		\|}

2026-04-07T09:59:10Z

Filters

← Older revision		Revision as of 11:59, 7 April 2026
Line 74:		Line 74:
	! style="width: 25%;" \|Filter		! style="width: 25%;" \|Filter
	! style="width: 75%;" \|Description		! style="width: 75%;" \|Description
			\|-
			\|Company
			\|Helps the user filter values by company

			\|-
			\|Company
			\|Helps the user filter values by company

	\|-		\|-
	\|Company		\|Company

2026-04-07T09:58:48Z

Filters

← Older revision		Revision as of 11:58, 7 April 2026
Line 75:		Line 75:
	! style="width: 75%;" \|Description		! style="width: 75%;" \|Description
	\|-		\|-
	\|		\|Company
	\|		\|Helps the user filter values by company
	\|}		\|}

2026-04-07T09:30:52Z

Tables & Columns Included

← Older revision		Revision as of 11:30, 7 April 2026
Line 66:		Line 66:
	\|tsa_reporting_db		\|tsa_reporting_db
	\|invoince exchange rates		\|invoince exchange rates
	\|id,invoice_id,from_currency,to_currency,exchange_rate,created_at~~,updated_at~~		\|id,invoice_id, order_id, from_currency,to_currency, exchange_rate,created_at
	\|}		\|}