{"batchcomplete":"","continue":{"lecontinue":"20260402084325|81","continue":"-||"},"query":{"logevents":[{"logid":91,"ns":0,"title":"Reporting DB","pageid":63,"logpage":63,"revid":551,"params":{},"type":"create","action":"create","user":"David.weller","timestamp":"2026-05-29T11:54:31Z","comment":"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...\""},{"logid":90,"ns":0,"title":"Data Lake Extracts","pageid":0,"logpage":17,"params":{},"type":"delete","action":"delete","user":"David.weller","timestamp":"2026-05-29T08:45:05Z","comment":"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 \"[[Special:Contributions/David.weller|David.weller]]\" ([[User talk:David.weller|talk]])"},{"logid":89,"ns":0,"title":"Invoice Reconciliation Extract","pageid":0,"logpage":19,"params":{},"type":"delete","action":"delete","user":"David.weller","timestamp":"2026-05-29T08:44:54Z","comment":"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 \"[[Special:Contributions/David.weller|David.weller]]\" ([[User talk:David.weller|talk]])"},{"logid":88,"ns":0,"title":"Pre-Invoice Processing Extract","pageid":0,"logpage":20,"params":{},"type":"delete","action":"delete","user":"David.weller","timestamp":"2026-05-29T08:44:45Z","comment":"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 \"[[Special:Contributions/David.weller|David.weller]]\" ([[User talk:David.weller|talk]])"},{"logid":87,"ns":0,"title":"Post-Flight Progress Extract","pageid":0,"logpage":18,"params":{},"type":"delete","action":"delete","user":"David.weller","timestamp":"2026-05-29T07:52:10Z","comment":"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 \"[[Special:Contributions/David.weller|David.weller]]\" ([[User talk:David.weller|talk]])"},{"logid":86,"ns":0,"title":"Quotations Charges Extract","pageid":0,"logpage":39,"params":{},"type":"delete","action":"delete","user":"David.weller","timestamp":"2026-05-29T07:50:48Z","comment":"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 \"[[Special:Contributions/David.weller|David.weller]]\" ([[User talk:David.weller|talk]])"},{"logid":85,"ns":0,"title":"Quotations Extract","pageid":0,"logpage":21,"params":{},"type":"delete","action":"delete","user":"David.weller","timestamp":"2026-05-29T07:50:39Z","comment":"content was: \"== Overview == Captures all job-related data from QMS, including every stage of the shipment lifecycle\u2014from 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 \"[[Special:Contributions/David.weller|David.weller]]\" ([[User talk:David.weller|talk]])"},{"logid":84,"ns":0,"title":"Main Page","pageid":1,"logpage":1,"params":{"count":{"revisions":4,"files":0}},"type":"delete","action":"restore","user":"David.weller","timestamp":"2026-05-29T07:50:13Z","comment":"mistake"},{"logid":83,"ns":0,"title":"Main Page","pageid":1,"logpage":1,"params":{},"type":"delete","action":"delete","user":"David.weller","timestamp":"2026-05-29T07:49:47Z","comment":"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]] \u2013 Instructions on how to interpret, and utilize each Power BI report effectively. * [[Data Lake Extracts]] \u2013 Includes data lake extracts, column descrip...\""},{"logid":82,"ns":0,"title":"Trouble Shooting & FAQs","pageid":62,"logpage":62,"revid":547,"params":{},"type":"create","action":"create","user":"David.weller","timestamp":"2026-04-10T11:09:46Z","comment":"Created page with \"[To be update by Collins]\""}]}}