Jump to content

Main public logs

Combined display of all available logs of PBI Reporting Wiki. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).

Logs
(newest | oldest) View (newer 50 | ) (20 | 50 | 100 | 250 | 500)
  • 13:54, 29 May 2026 David.weller talk contribs created page Reporting DB (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...") Tag: Visual edit
  • 10:45, 29 May 2026 David.weller talk contribs 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))
  • 10:44, 29 May 2026 David.weller talk contribs 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))
  • 10:44, 29 May 2026 David.weller talk contribs 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))
  • 09:52, 29 May 2026 David.weller talk contribs 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))
  • 09:50, 29 May 2026 David.weller talk contribs 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))
  • 09:50, 29 May 2026 David.weller talk contribs 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))
  • 09:50, 29 May 2026 David.weller talk contribs undeleted page Main Page (4 revisions) (mistake)
  • 09:49, 29 May 2026 David.weller talk contribs 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...")
  • 13:09, 10 April 2026 David.weller talk contribs created page Trouble Shooting & FAQs (Created page with "[To be update by Collins]") Tag: Visual edit
  • 10:43, 2 April 2026 David.weller talk contribs created page Row Level Security Setup Guide (Created blank page) Tag: Visual edit
  • 10:43, 2 April 2026 David.weller talk contribs created page TSA Dashboard (Created page with " == Summary == == Tables & Columns Included == {| class="wikitable" |+ !Database !Table !Columns |- | | | |} == Filters == {| class="wikitable" |+ ! style="width: 25%;" |Filter ! style="width: 75%;" |Description |- | | |} == Data Transformation Applied == [To be added] {| class="wikitable" |+ !Query !Calculations !Description |- | | | |} == Calculations == {| class="wikitable" ! style="width: 20%;" |Reference ! style="width: 40%;" |Calculation ! style="width: 40%;" |...")
  • 10:42, 2 April 2026 David.weller talk contribs deleted page Dashboard (content was: " == Summary == == Tables & Columns Included == {| class="wikitable" |+ !Database !Table !Columns |- | | | |} == Filters == {| class="wikitable" |+ ! style="width: 25%;" |Filter ! style="width: 75%;" |Description |- | | |} == Data Transformation Applied == [To be added] {| class="wikitable" |+ !Query !Calculations !Description |- | | | |} == Calculations == {...", and the only contributor was "David.weller" (talk))
  • 10:41, 2 April 2026 David.weller talk contribs created page Dashboard (Created page with " == Summary == == Tables & Columns Included == {| class="wikitable" |+ !Database !Table !Columns |- | | | |} == Filters == {| class="wikitable" |+ ! style="width: 25%;" |Filter ! style="width: 75%;" |Description |- | | |} == Data Transformation Applied == [To be added] {| class="wikitable" |+ !Query !Calculations !Description |- | | | |} == Calculations == {| class="wikitable" ! style="width: 20%;" |Reference ! style="width: 40%;" |Calculation ! style="width: 40%;" |...") Tag: Visual edit
  • 12:58, 29 January 2026 David.weller talk contribs created page Datacair EY Performance Report - Airway Bills (Created page with "== Summary == TBC == Filters == {| class="wikitable" |+ !Filter !Description |- |TBC |TBC |- |} == Data Transformation Applied == {| class="wikitable" |+ !Query !Transformations |- |TBC |TBC |- |} == Calculations == {| class="wikitable" |+ !Columns !Calculation !Description |- |TBC |TBC |TBC |- |}") Tag: Visual edit: Switched
  • 12:58, 29 January 2026 David.weller talk contribs created page Datacair EY Performance Report - Detail (Created page with "== Summary == TBC == Filters == {| class="wikitable" |+ !Filter !Description |- |TBC |TBC |- |} == Data Transformation Applied == {| class="wikitable" |+ !Query !Transformations |- |TBC |TBC |- |} == Calculations == {| class="wikitable" |+ !Columns !Calculation !Description |- |TBC |TBC |TBC |- |}") Tag: Visual edit: Switched
  • 12:26, 29 January 2026 David.weller talk contribs deleted page Datacair EY Performance Report (content was: "== Summary == This report provides a weekly overview of operational performance by tracking AWBs, execution status, pending workload, customer issues (CAMS), and closure rates. Using simple metrics, filters by station and date, and clear percentage changes, it helps teams quickly identify performance trends, growth areas, and operational risks to support timely and data-driven decisions. == Filters == {| class="wikitable" |+ !Filter !Description |- |Station |Filters the repor...")
  • 12:25, 29 January 2026 David.weller talk contribs created page Datacair EY Performance Report - Dashboard (Created page with "== Summary == This report provides a weekly overview of operational performance by tracking AWBs, execution status, pending workload, customer issues (CAMS), and closure rates. Using simple metrics, filters by station and date, and clear percentage changes, it helps teams quickly identify performance trends, growth areas, and operational risks to support timely and data-driven decisions. == Filters == {| class="wikitable" |+ !Filter !Description |- |Station |Filters th...") Tag: Visual edit: Switched
  • 15:28, 26 January 2026 David.weller talk contribs created page NCR - DataCair Tickets (Created page with "== Summary == TBC == Filters == {| class="wikitable" |+ !Filter !Description |- |Example filter |Filter description |} == Data Transformation Applied == {| class="wikitable" |+ !Query !Transformations |- |Example Query | Example transformations |} == Calculations == {| class="wikitable" |+ !Columns !Calculation !Description |- |Example |Example calc |Example description |}") Tag: Visual edit: Switched
  • 15:25, 26 January 2026 David.weller talk contribs deleted page NCR Page (content was: "== Summary == This page forms part of the Non-Conformance Report for Datacair. It consolidates data from both the NCR Database and the SupportPal Non-Conformance Tickets. The report provides a unified view of non-conformance data across entities, combining records from both sources. It offers a high-level overview of staff attendance and work rates, enabling quick and easy analysis across all entities. == Filters == {| class="wikitable" |+ !Filter !Description |- |Date |Filte...")
  • 15:25, 26 January 2026 David.weller talk contribs created page NCR - Staff Logs (Created page with "== Summary == This page forms part of the Non-Conformance Report for Datacair. It consolidates data from both the NCR Database and the SupportPal Non-Conformance Tickets. The report provides a unified view of non-conformance data across entities, combining records from both sources. It offers a high-level overview of staff attendance and work rates, enabling quick and easy analysis across all entities. == Filters == {| class="wikitable" |+ !Filter !Description |- |Date...") Tag: Visual edit: Switched
  • 17:31, 20 January 2026 David.weller talk contribs created page Datacair EY Performance Report (Created page with "== Summary == tbc == Filters == {| class="wikitable" |+ !Filter !Description |- |TBC |TBC |- |TBC |TBC |- |TBC |TBC |} == Data Transformation Applied == {| class="wikitable" |+ !Query !Transformations |- |TBC |TBC |- |TBC |TBC |- |TBC |TBC |} == Calculations == {| class="wikitable" |+ !Columns !Calculation !Description |- |TBC |TBC |TBC |- |TBC |TBC |TBC |- |TBC |TBC |TBC |}")
  • 15:26, 21 November 2025 David.weller talk contribs created page Aldo Report (Created page with "==Summary== ==Filters== {| class="wikitable" |+ ! style="width: 25%;" | Filter !! style="width: 75%;" | Description |- | TBC|| TBC |} == Data Transformation Applied == [To be added] {| class="wikitable" |+ !Query !Calculations !Description |- | | | |} ==Calculations== {| class="wikitable" |- ! style="width: 20%;" | Reference !! style="width: 40%;" | Calculation !! style="width: 40%;" | Description |- | TBC ||<pre>TBC</pre>|| TBC |}")
  • 15:26, 21 November 2025 David.weller talk contribs created page Customer Overall TY (Created page with "==Summary== ==Filters== {| class="wikitable" |+ ! style="width: 25%;" | Filter !! style="width: 75%;" | Description |- | TBC|| TBC |} == Data Transformation Applied == [To be added] {| class="wikitable" |+ !Query !Calculations !Description |- | | | |} ==Calculations== {| class="wikitable" |- ! style="width: 20%;" | Reference !! style="width: 40%;" | Calculation !! style="width: 40%;" | Description |- | TBC ||<pre>TBC</pre>|| TBC |}")
  • 15:26, 21 November 2025 David.weller talk contribs created page Quarterly (Created page with "==Summary== ==Filters== {| class="wikitable" |+ ! style="width: 25%;" | Filter !! style="width: 75%;" | Description |- | TBC|| TBC |} == Data Transformation Applied == [To be added] {| class="wikitable" |+ !Query !Calculations !Description |- | | | |} ==Calculations== {| class="wikitable" |- ! style="width: 20%;" | Reference !! style="width: 40%;" | Calculation !! style="width: 40%;" | Description |- | TBC ||<pre>TBC</pre>|| TBC |}")
  • 15:26, 21 November 2025 David.weller talk contribs created page Quotes Summary (W+M) (Created page with "==Summary== ==Filters== {| class="wikitable" |+ ! style="width: 25%;" | Filter !! style="width: 75%;" | Description |- | TBC|| TBC |} == Data Transformation Applied == [To be added] {| class="wikitable" |+ !Query !Calculations !Description |- | | | |} ==Calculations== {| class="wikitable" |- ! style="width: 20%;" | Reference !! style="width: 40%;" | Calculation !! style="width: 40%;" | Description |- | TBC ||<pre>TBC</pre>|| TBC |}")
  • 15:25, 21 November 2025 David.weller talk contribs created page Quotes Overview (W+M) (Created page with "==Summary== ==Filters== {| class="wikitable" |+ ! style="width: 25%;" | Filter !! style="width: 75%;" | Description |- | TBC|| TBC |} == Data Transformation Applied == [To be added] {| class="wikitable" |+ !Query !Calculations !Description |- | | | |} ==Calculations== {| class="wikitable" |- ! style="width: 20%;" | Reference !! style="width: 40%;" | Calculation !! style="width: 40%;" | Description |- | TBC ||<pre>TBC</pre>|| TBC |}")
  • 15:25, 21 November 2025 David.weller talk contribs created page Detail (W+M) (Created page with "==Summary== ==Filters== {| class="wikitable" |+ ! style="width: 25%;" | Filter !! style="width: 75%;" | Description |- | TBC|| TBC |} == Data Transformation Applied == [To be added] {| class="wikitable" |+ !Query !Calculations !Description |- | | | |} ==Calculations== {| class="wikitable" |- ! style="width: 20%;" | Reference !! style="width: 40%;" | Calculation !! style="width: 40%;" | Description |- | TBC ||<pre>TBC</pre>|| TBC |}")
  • 15:24, 21 November 2025 David.weller talk contribs created page Overall YTD (Created page with "==Summary== ==Filters== {| class="wikitable" |+ ! style="width: 25%;" | Filter !! style="width: 75%;" | Description |- | TBC|| TBC |} == Data Transformation Applied == [To be added] {| class="wikitable" |+ !Query !Calculations !Description |- | | | |} ==Calculations== {| class="wikitable" |- ! style="width: 20%;" | Reference !! style="width: 40%;" | Calculation !! style="width: 40%;" | Description |- | TBC ||<pre>TBC</pre>|| TBC |}")
  • 12:20, 30 September 2025 David.weller talk contribs created page Job Finder (Created page with " == Summary == This is for the page "Job Finder" page that is a part of the Yield, Weight and Revenue GSA Report. == Filters == {| class="wikitable" |+ !Filter !Description |- | | |} == Data Transformation Applied == {| class="wikitable" |+ !Query !Transformations |- | | |} == Calculations == {| class="wikitable" |+ !Columns !Calculation !Description |- | | | |}") Tag: Visual edit
  • 12:20, 30 September 2025 David.weller talk contribs created page Site Summary (Created page with " == Summary == This is for the page "Site Summary" page that is a part of the Yield, Weight and Revenue GSA Report. == Filters == {| class="wikitable" |+ !Filter !Description |- | | |} == Data Transformation Applied == {| class="wikitable" |+ !Query !Transformations |- | | |} == Calculations == {| class="wikitable" |+ !Columns !Calculation !Description |- | | | |}") Tag: Visual edit
  • 12:19, 30 September 2025 David.weller talk contribs created page Weight By Carrier (Created page with " == Summary == This is for the page "Weight By Carrier" page that is a part of the Yield, Weight and Revenue GSA Report. == Filters == {| class="wikitable" |+ !Filter !Description |- | | |} == Data Transformation Applied == {| class="wikitable" |+ !Query !Transformations |- | | |} == Calculations == {| class="wikitable" |+ !Columns !Calculation !Description |- | | | |}") Tag: Visual edit
  • 12:19, 30 September 2025 David.weller talk contribs created page Weight v Revenue Week-On-Week (Created page with " == Summary == This is for the page "Weight v Revenue Week-On-Week" page that is a part of the Yield, Weight and Revenue GSA Report. == Filters == {| class="wikitable" |+ !Filter !Description |- | | |} == Data Transformation Applied == {| class="wikitable" |+ !Query !Transformations |- | | |} == Calculations == {| class="wikitable" |+ !Columns !Calculation !Description |- | | | |}") Tag: Visual edit
  • 12:19, 30 September 2025 David.weller talk contribs created page Yield Week-On-Week (Created page with " == Summary == This is for the page "Yield - Week-On-Week" page that is a part of the Yield, Weight and Revenue GSA Report. == Filters == {| class="wikitable" |+ !Filter !Description |- | | |} == Data Transformation Applied == {| class="wikitable" |+ !Query !Transformations |- | | |} == Calculations == {| class="wikitable" |+ !Columns !Calculation !Description |- | | | |}") Tag: Visual edit
  • 12:18, 30 September 2025 David.weller talk contribs created page Yield - Group Overview (Created page with " == Summary == This is for the page "Yield - Group Overview" page that is a part of the Yield, Weight and Revenue GSA Report. == Filters == {| class="wikitable" |+ !Filter !Description |- | | |} == Data Transformation Applied == {| class="wikitable" |+ !Query !Transformations |- | | |} == Calculations == {| class="wikitable" |+ !Columns !Calculation !Description |- | | | |}") Tag: Visual edit
  • 14:27, 17 September 2025 David.weller talk contribs created page Quotations Charges Extract (Created page with "== 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 applied |- |cost_value |Calculated buy-side cost value |- |cost_currency |Currency for cost values |- |sale_mi...") Tag: Visual edit
  • 14:29, 15 August 2025 David.weller talk contribs created page File:Report-performance-mastercarrier.png
  • 14:29, 15 August 2025 David.weller talk contribs uploaded File:Report-performance-mastercarrier.png
  • 14:28, 15 August 2025 David.weller talk contribs created page File:Report-quote-mastercarrier.png
  • 14:28, 15 August 2025 David.weller talk contribs uploaded File:Report-quote-mastercarrier.png
  • 14:27, 15 August 2025 David.weller talk contribs created page File:Report-revnueandbookings-mastercarrier.png
  • 14:27, 15 August 2025 David.weller talk contribs uploaded File:Report-revnueandbookings-mastercarrier.png
  • 14:09, 15 August 2025 David.weller talk contribs created page Sales Performance (Created page with "== Summary == == Filters == {| class="wikitable" |+ !Filter !Description |- | | |} == Data Transformation Applied == {| class="wikitable" |+ !Query !Transformations |- | | |} == Calculations == {| class="wikitable" |+ !Columns !Calculation !Description |- | | |}")
  • 14:09, 15 August 2025 David.weller talk contribs created page Quotes (Created page with "== Summary == == Filters == {| class="wikitable" |+ !Filter !Description |- | | |} == Data Transformation Applied == {| class="wikitable" |+ !Query !Transformations |- | | |} == Calculations == {| class="wikitable" |+ !Columns !Calculation !Description |- | | |}")
  • 14:08, 15 August 2025 David.weller talk contribs created page Revenue & Booking Overview (Created page with "== Summary == == Filters == {| class="wikitable" |+ !Filter !Description |- | | |} == Data Transformation Applied == {| class="wikitable" |+ !Query !Transformations |- | | |} == Calculations == {| class="wikitable" |+ !Columns !Calculation !Description |- | | |}")
  • 14:46, 14 August 2025 David.weller talk contribs created page File:Report-ncrpage-reportanalysis.png
  • 14:46, 14 August 2025 David.weller talk contribs uploaded File:Report-ncrpage-reportanalysis.png
  • 14:45, 14 August 2025 David.weller talk contribs created page File:Report-ncrpage-entitybreakdown.png
  • 14:45, 14 August 2025 David.weller talk contribs uploaded File:Report-ncrpage-entitybreakdown.png
  • 14:43, 14 August 2025 David.weller talk contribs created page File:Report-ncrpage-root-cause.png
(newest | oldest) View (newer 50 | ) (20 | 50 | 100 | 250 | 500)
Retrieved from "https://wiki-reporting.qms-portal.aero/index.php?title=Special:Log"