Using the Wireframe Pattern

by

1. Purpose This guide shows how to build a Power BI report using the standard DataMart wireframe. It demonstrates how: The wireframe is not just a template — it is a working example of how reporting should be built. Please download your own version from here… https://app.powerbi.com/groups/3974c1cc-9a5c-4af9-b717-379013d17d53/reports/08af53f0-f4c9-41d8-b85e-c0f597947bf7/ReportSection?ctid=b52d5b10-ca0e-48a0-86ab-0a34fd628e8b&experience=power-bi 2. The Principle Engineering defines the data.Analysts define … Read more

Condensed META_TYPE Taxonomy for Analysts

by

1. Identity Core identifiers and object naming. PurposeObject identifiers. 2. Structural Keys Structural identifiers used to link datasets. PurposeIdentify or reference core business entities. 3. Commercial Context Customer and contractual relationships. PurposeDescribe commercial relationships and contracts. 4. Sales & Pipeline Sales organisation and opportunity tracking. PurposeAnalyse pipeline, opportunity probability, and sales ownership. 5. Financial Values … Read more

Guide to META_TYPES in the CDM Data Views

by

Purpose META_TYPE is used within CDM metadata views (such as meta_codes, meta_dates, and meta_values) to group related attributes into meaningful analytical categories. Rather than storing hundreds of unrelated attributes, META_TYPE provides a semantic grouping layer that helps analysts understand the nature of the data. Each row therefore follows a pattern similar to: OBJECT → META_TYPE … Read more

Data Dictionary Framework

by

Purpose The Data Dictionary is the overarching governance process used to maintain the meaning, structure, lineage, quality rules, and operational control of data assets across the Data Platform. Rather than existing as a single document or table, the Data Dictionary is delivered through a set of linked artefacts, each addressing a distinct aspect of data … Read more

Project.meta_codes roles

by

Provides project role assignment metadata in the standard CDM meta_codes structure, with regional view variants for APC, CAD, USD, UKS, and future IFS-aligned sourcing. Purpose The project.meta_codes_roles family provides a standardised project-role metadata pattern for identifying named project responsibilities against a project object. This allows project role assignments to be consumed consistently across regions even … Read more

How to Parameterise Dataflow Gen2 Destinations for Seamless Dev/Prod Deployment

by

Managing Dataflow Gen2 across multiple environments (Development and Production) can be a headache. By default, the destination Lakehouse or Warehouse IDs are hardcoded. This means when you deploy to a Production workspace, your dataflow might still try to write back to your Development environment. In this guide, I’ll show you a workaround to parameterize your … Read more

Release 93

by

Release 92 absorbed in DEV Pipeline Release validation 1. BusOpp (EUR & NA) – Structural Refactor Views affected What has changed We have refactored the MP8 / MP9 source logic to remove duplicated transformation code and consolidate the sources via an early UNION pattern. The primary driver was identification of multiple editions of the same … Read more

Release 91

by

Structural Consolidation, Export Alignment & ReportingUnit Introduction Overview Release 91 focuses on structural consistency across domains, export pattern alignment, identifier correction, and preparation for enhanced historical interrogation using get.myview. This is a maturity release.It strengthens foundations rather than introducing visible UI features. 1. Removal of Hard-Coded ACTIVE_FLAG Filtering Affected Domains Affected Views (cvw) Change Removed: … Read more

Modern Title & Emphasis Standards (Digital-First)

by

1. Never Use Underlining for Emphasis Rule:Underlining is reserved for hyperlinks. Full stop. Why? Underlining for emphasis is obsolete in professional digital documents. Exception: hyperlinks only. 2. Use Bold Intentionally — Not Emotionally Bold is not decoration. It is structural. Good uses of bold: Bad uses of bold: If everything is bold, nothing is. 3. … Read more