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
Unified Introduction to the High/Low Drive Series Every organisation is shaped by people — not just their skills and roles, but the natural wiring patterns that influence how they think, communicate, decide, and work with others. Understanding these behavioural drivers can transform how teams collaborate, how leaders support their staff, and how individuals recognise their … Read more
Low D Profile — Series Analysis of Low Drives Low D profiles thrive when allowed to think broadly, creatively, and without constraint. They are natural big-picture thinkers who prefer vision to detail, concepts to minutiae, and freedom to rigid process. Environments with limited structure, minimal rules, and room for improvisation allow Low D individuals to … Read more