Applying the GOSP Model to the Data Warehouse and Data Engineering

by

The GOSP (Governance-Oversight-Support-Perform) model can significantly enhance Data Warehouse (DWH) and Data Engineering processes. By focusing on structured governance, proactive oversight, enabling support, and high-performance delivery, this framework ensures robust and scalable data infrastructure aligned with organisational goals. Governance in Data Warehouse and Data Engineering Governance establishes the strategic direction and accountability framework for the … Read more

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 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 number of different files: 5Total number of missing … 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). Data Mapping We have mapped the fields from the source data to the target/template fields. 1️⃣ The source field name as provided. 2️⃣ 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