Applying the GOSP Model to Data Analysis and Reporting

by

The GOSP (Governance-Oversight-Support-Perform) model can be effectively applied to enhance Data Analysis and Reporting. By aligning data processes with GOSP principles, organisations can achieve greater clarity, alignment, and consistency in their data strategies and deliverables. Governance in Data Analysis and Reporting Governance sets the foundation for structured, reliable, and ethical data management and reporting practices. … Read more

Executive Summary 

by

BMT strives to deliver clarity through complexity and, with this, we start at home. This Reporting Strategy provides the framework on how we will deliver internal reporting that is clean, accurate and best in class.  Purpose and Vision  The Reporting Strategy is designed to unify BMT’s approach to internal reporting, embedding consistent standards for quality, … Read more

Release 50

by

Alterations Business Opportunity Reporting with APAC The team are delighted to inform you that the current Opportunities from APAC are now available in PRD and can be reported upon I have crafted a report for your perusalhttps://app.powerbi.com/groups/5875d12b-85b8-434f-a42b-4d473cb8afe0/reports/573c53a0-cb82-4c98-a3c1-7d90c374ad0d/ReportSection?experience=power-bi Notes 1. ⚠️ DIFFERENT: busopp_details_APC.sql2. ⚠️ DIFFERENT: busopp_details_plus.sql3. ⚠️ DIFFERENT: busopp_details_plus_APC.sql4. ⚠️ DIFFERENT: busopp_value.sql5. ⚠️ DIFFERENT: busopp_value_APC.sql Total … Read more

Release 49

by

Additions Business Opportunity Details for APAC We are pleased to inform you that the list of current opportunities from APAC is now an integral part of the Data Warehouse (DEV Environment). The source data can be viewed as an SQL table here:https://bmt-dwh-uks-app-my.azurewebsites.net/index.php?module=app/splash/sql&grid=table&schema=sales&table=APAC_cr5a0_pipeline&rows=300&end=stg&region=apc&env=dev Data Mapping We have mapped the fields from the source data to the … Read more

Release 48

by

Additions New CTE Array Version for Customer OrderLine series Alterations Remove Company filter from Project.PurchaseOrderLine_202407 Notes 1. 🔴 MISSING IN PRD CONTAINER: customer_details_202411.sql2. 🔴 MISSING IN PRD CONTAINER: customer_orderlinestatus_202411.sql3. 🔴 MISSING IN PRD CONTAINER: customer_orderlinevalue_202411.sql4. 🔴 MISSING IN PRD CONTAINER: customer_orderline_202411.sql5. 🔴 MISSING IN PRD CONTAINER: customer_orderstatus_202411.sql6. 🔴 MISSING IN PRD CONTAINER: customer_order_202411.sql7. ⚠️ DIFFERENT: … Read more

Release 47

by

Alterations Busopp.Details_Plus (beta) Complete the CTE (modular array) to include Dates and Measures/Values Busopp.Value Full version of CTE (modular array) Busopp.Dates Add New SEQ (Link sequence style) Customer.Orderline_202409 Include Project ID from QFACT_PRE_ACCOUNTING_OL$ as coalesce(cfv.CF$_PROJECT_ID,precfv.CODENO_D,src.DIM_PROJECT_ID) as PROJECT_ID, Notes Total number of different files: 2Total number of missing files in DEV CONTAINER: 0Total number of missing files in … Read more

Release 46

by

Additions Customer Invoice for Array Version (202411) Notes Numbered Comparison Results:1. 🔴 MISSING IN PRD CONTAINER: customer_invoicestatus_202411.sql2. 🔴 MISSING IN PRD CONTAINER: customer_invoicevalue_202411.sql3. 🔴 MISSING IN PRD CONTAINER: customer_invoice_202411.sql4. ⚠️ DIFFERENT: customer_orderstatus.sql Total number of different files: 1Total number of missing files in DEV CONTAINER: 0Total number of missing files in PRD CONTAINER: 3

BusOpp.Dates

by

Purpose The Business Opportunity Dates view is designed to consolidate and standardise key date attributes related to business opportunities within the organisation. The Business Opportunity Dates view plays a critical role in tracking, analysing, and forecasting opportunity lifecycle events. By consolidating multiple date fields into a single structured dataset, it ensures better visibility, consistency, and … Read more

API Documentation: get.myhistory

by

Purpose The get.myhistory API and stored procedure facilitate interaction with the DataWarehouse, enabling users to retrieve historical views for analysis. Designed for PowerBI and Power Applications, it offers flexible parameters, customisable views, and outputs data in JSON format. By combining the adaptability of SQL stored procedures with a RESTful API, get.myhistory delivers a robust solution … Read more