PBI Reporting Wiki - Recent changes [en-gb]

Reporting DB

David.weller — Fri, 29 May 2026 15:59:28 GMT

Main Page

David.weller — Fri, 29 May 2026 14:26:35 GMT

QMS: PBI Reporting

← Older revision		Revision as of 16:26, 29 May 2026
Line 6:		Line 6:

	* [[Report User Guides]] – Instructions on how to interpret, and utilize each Power BI report effectively.		* [[Report User Guides]] – Instructions on how to interpret, and utilize each Power BI report effectively.
	* [[Reporting DB]] - Breakdown of all tables and columns, with suggested hints for data modelling.		* [[Reporting DB]] - Breakdown of all tables and columns, with suggested hints for data modelling for external sources who want to model our reporting data.

	* [[Error Reporting]] – Guidelines on how to report issues or discrepancies in existing reports to ensure data accuracy and reliability.		* [[Error Reporting]] – Guidelines on how to report issues or discrepancies in existing reports to ensure data accuracy and reliability.

Reporting DB

David.weller — Fri, 29 May 2026 14:26:06 GMT

← Older revision		Revision as of 16:26, 29 May 2026
(One intermediate revision by the same user not shown)
Line 3:		Line 3:

	The information below has the assumption that you understand databases, and have knowledge in PBI development and data management.		The information below has the assumption that you understand databases, and have knowledge in PBI development and data management.

			Currently we have only added the tables / columns for the information we know is required.

	=== Every Table ===		=== Every Table ===
Line 50:		Line 52:
	!Notes		!Notes
	\|-		\|-
	\|id		\|carrier_id
	\|~~database record~~ id		\|id for the carrier
	\|		\|
	\|-		\|-
			\|name
			\|name of the carrier / supplier
	\|		\|
			\|-
			\|site_id
			\|the site (entity) is carrier / supplier is on
	\|		\|
			\|-
			\|is_gsa
			\|the carrier / supplier is gsa
	\|		\|
	\|-		\|-
			\|parent_id
			\|the parent carrier / supplier for this carrier
			\|this will be null if the carrier is a parent.
			\|-
			\|carrier_class
			\|supplier class
			\|airline, truck, sea freight etc..
			\|-
			\|carrier_subclass
			\|subclass for the carrier
	\|		\|
			\|-
			\|created_at
			\|when the carrier was created
	\|		\|
			\|-
			\|updated_at
			\|the last time the carrier was updated
	\|		\|
	\|}		\|}
			=== Table: dim_customers ===
			'''Columns:'''







	= Helpers =		= Helpers =
	N/A - Will update as questions come through.		N/A - Will update as questions come through.

Reporting DB

David.weller — Fri, 29 May 2026 11:54:31 GMT

Created page with "= Raw Tables, Columns and Suggested Modelling = To access the reporting database, you will need an account creating. Please follow the correct process and raise a ticket via the [https://helpdesk.dcbi.aero/ helpdesk]. They will provide you account, address and access. The information below has the assumption that you understand databases, and have knowledge in PBI development and data management. === Every Table === Within every table there is 2 consistent columns, t..."

New page

= Raw Tables, Columns and Suggested Modelling =
To access the reporting database, you will need an account creating. Please follow the correct process and raise a ticket via the [https://helpdesk.dcbi.aero/ helpdesk]. They will provide you account, address and access.

The information below has the assumption that you understand databases, and have knowledge in PBI development and data management.

=== Every Table ===
Within every table there is 2 consistent columns, to save repeating data - these columns will be shared here.

==== Columns ====
{| class="wikitable"
!Column Name
!Description
!Notes
|-
|id
|Database id
|
|-
|portal
|Which QMS instance the data is from.
|Currently to identify, ATC, HAE, ACS, GA ZA, and AirCross.
|}

=== Table: dim_cargo_type ===

==== Columns: ====
{| class="wikitable"
!Column Name
!Description
!Notes
|-
|cargo_type_id
|cargo type id
|used when referenced in other tables.
|-
|description
|description
|
|-
|tariff_service_code
|service code that can be linked to the cargo type
|
|}

=== Table: dim_carriers ===
'''Columns:'''
{| class="wikitable"
!Column Name
!Description
!Notes
|-
|id
|database record id
|
|-
|
|
|
|-
|
|
|
|}

= Helpers =
N/A - Will update as questions come through.

Main Page

David.weller — Fri, 29 May 2026 08:49:20 GMT

← Older revision		Revision as of 10:49, 29 May 2026
Line 6:		Line 6:

	* [[Report User Guides]] – Instructions on how to interpret, and utilize each Power BI report effectively.		* [[Report User Guides]] – Instructions on how to interpret, and utilize each Power BI report effectively.
	* [[~~Data Lake Extracts~~]] ~~– Includes data lake extracts~~, ~~column descriptions, and example formulas~~ for ~~calculating key metrics~~.		* [[Reporting DB]] - Breakdown of all tables and columns, with suggested hints for data modelling.

	* [[Error Reporting]] – Guidelines on how to report issues or discrepancies in existing reports to ensure data accuracy and reliability.		* [[Error Reporting]] – Guidelines on how to report issues or discrepancies in existing reports to ensure data accuracy and reliability.

Data Lake Extracts

David.weller — Fri, 29 May 2026 08:45:05 GMT

David.weller deleted page Data Lake Extracts content was: "== Overview == This section provides a detailed overview of the data lake extracts used for reporting QMS data. It includes a comprehensive list of available data exports, clear descriptions of each column, and practical example formulas that can be used to calculate key performance metrics. This information is intended to support both analysts and developers in...", and the only contributor was "David.weller" (talk)

Invoice Reconciliation Extract

David.weller — Fri, 29 May 2026 08:44:54 GMT

David.weller deleted page Invoice Reconciliation Extract content was: "== Overview == This extract provides detailed data from the automated invoice reconciliation process, helping to streamline billing accuracy and support faster issue resolution. It includes both matched and unmatched charge lines, giving users clear visibility into which charges have been automatically verified and which may require further investigation or manu...", and the only contributor was "David.weller" (talk)

Pre-Invoice Processing Extract

David.weller — Fri, 29 May 2026 08:44:45 GMT

David.weller deleted page Pre-Invoice Processing Extract content was: "== Overview == This extract contains data generated by the pre-invoice automation process. It highlights both matched and mismatched charge lines before the final invoice is issued, allowing users to review and validate billing data in advance. By identifying discrepancies early, the extract helps prevent errors from reaching the final invoice stage, reduces the...", and the only contributor was "David.weller" (talk)

Post-Flight Progress Extract

David.weller — Fri, 29 May 2026 07:52:10 GMT

David.weller deleted page Post-Flight Progress Extract content was: "== Overview == Includes all data related to automated post-flight updates, such as flight status changes and carrier-provided updates, to support operational visibility after departure. This extract specifically indicates when the automation retrieved post-flight information for a booking. == Extract Data == {| class="wikitable" |+ !Column !Description |- |mast...", and the only contributor was "David.weller" (talk)

Quotations Charges Extract

David.weller — Fri, 29 May 2026 07:50:48 GMT

David.weller deleted page Quotations Charges Extract content was: "== Overview == Captures all the different charges for all the jobs coming out of QMS. == Extract Data == === Existing Extract === {| class="wikitable" |+ !Column !Description |- |quotation_id |Link back to the main quotation/job |- |charge_code |Charge type (e.g. LINEHAUL, FS, XB) |- |buy_min_cost |Minimum buy-side cost |- |buy_rate |Buy-side rate appl...", and the only contributor was "David.weller" (talk)

Quotations Extract

David.weller — Fri, 29 May 2026 07:50:39 GMT

David.weller deleted page Quotations Extract content was: "== Overview == Captures all job-related data from QMS, including every stage of the shipment lifecycle—from pre-quotes and formal quotations to bookings and automation sync events. This extract offers a complete view of how a job progresses through the system, making it ideal for tracking and analyzing conversion rates, booking efficiency, and automation cover...", and the only contributor was "David.weller" (talk)

Main Page

David.weller — Fri, 29 May 2026 07:50:13 GMT

David.weller undeleted page Main Page (4 revisions) mistake

Main Page

David.weller — Fri, 29 May 2026 07:49:47 GMT

David.weller deleted page Main Page content was: "== QMS: PBI Reporting == This wiki serves as the central hub for all information related to Power BI and reporting for QMS. It provides comprehensive documentation, including detailed user guides for all active reports, as well as guidance for users working with the data lake. ===Wiki Contents=== * Report User Guides – Instructions on how to interpret, and utilize each Power BI report effectively. * Data Lake Extracts – Includes data lake extracts, column descrip..."