Julian.Kellett The Marketing_Campaign_Details_Plus view provides an enriched and detailed representation of campaign metadata, serving as a foundational dataset for analysing and managing marketing campaigns. This view is designed to offer a structured, high-level summary of campaign attributes, ensuring clarity and consistency for reporting and decision-making. Key Features: Use Cases: The Marketing_Campaign_Details_Plus view offers a solid foundation … Read more
Requirements & Design This document is used to outline details related to reporting requirements of the project. Specifically, this document captures the technical specifications that are required for the successful design and development of business reports. Report Technical Specifications This section is used to describe the detailed specification related to how NUIT will develop a … Read more
The GOSP (Governance-Oversight-Support-Perform) model can be applied to Data Governance and Security to create a structured, proactive framework that ensures data is managed ethically, securely, and in alignment with organisational goals. By addressing both governance and security under this model, organisations can build trust, maintain compliance, and safeguard their data assets. Governance in Data Governance … Read more
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
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
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
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
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®ion=apc&env=dev Data Mapping We have mapped the fields from the source data to the … Read more
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
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