What this view is for Busopp.core_details is the starting point for all sales pipeline reporting. It represents a single business opportunity in its simplest, most recognisable form and provides the identity and linkage needed to explore the rest of the pipeline. If you’re asking “what opportunities do we have, and how do they connect to … Read more
The Sales Pipeline DataMarts are designed to help you move confidently from opportunities, through orders, and on to invoices — without having to relearn the data model each time. The most important thing to remember is this: these views are meant to be combined. Once you understand the pattern, building modular, reusable reporting becomes much … Read more
The meta_codes, meta_dates (and any derived meta_values) views are intentionally long and thin. This structure: That said, long thin tables aren’t always the easiest shape to work with directly in a reporting tool. Shaping meta data into a report-friendly form Once you’ve applied some basic filtering (for example, keeping only the code or date types … Read more
This process describes how to take a new data source from landing → Bronze → DataMart view, and fully define its attribute lineage in myBMT. 1. Prepare and review the new data source 2. Catalogue and land the source 3. Plan the DataMart view(s) 4. Set up attribute lineage in myBMT For each new view … Read more
1. Core Detail Views Updated views Change Impact / Rationale 2. Project Meta Values Views Updated views Changes / Notes Risks / Considerations 3. Meta Codes Views Updated views Changes Impact / Rationale 4. Feedback Meta Satisfaction View View Changes / Notes Action 5. Infrastructure OSH Records View Changes / Notes Impact 6. Base Architecture … Read more
Version: 1.0Owner: Regional Finance DirectorPrepared by: Data Engineering 1. Purpose The purpose of this report is to provide clear and consistent visibility of margin performance across all active projects, comparing the originally approved bid margin with the latest forecast outturn margin. The report will support financial oversight, early risk identification, and commercial performance management at project, PRU, and regional levels. 2. Objectives 3. … Read more
Bulk‑generate and (optionally) execute DROP VIEW statements for a subset of views in a given schema When to use this Safety checklist
What are Deployment Pipelines? Pipeline Structure Stage Comparison in UI Item Pairing & Status Selective Deployment Deployment Rules Lakehouse & Deployment Pipelines in Fabric Deployment pipelines move Lakehouse metadata, including shortcuts, but do not copy data or table schemas. After deployment, shortcuts still point to the original source, and the Lakehouse will be empty unless … Read more
1. Opportunity Pipeline Data Sources (NA & EUR) Files: Summary:New data sources created to support the Opportunity Pipeline Dashboard covering North America and Europe. Details: 2. Customer Feedback Meta Codes Files: Summary:Initial release of the remaining components required to complete the CSMS dataset. Details: 3. Project Meta Codes – PMN File: Summary:Enhancement to stabilise the … Read more
When working with Git repositories in Azure DevOps, you might need to move a file from one folder to another without losing its history. The best way to do this is by using the git mv command. This ensures Git recognizes the move as a rename and keeps the file’s commit history intact. Why Not … Read more