DEV and PRD Usage, Expectations & Accountability Audience: Analysts, Report Authors, Data EngineersApplies to: Common Data Model (CDM), Data Marts, Power BI reportingPurpose: To ensure shared understanding of how data environments are intended to be used, and to protect confidence in reporting. 1. Purpose of Separation The separation between DEV (Development) and PRD (Production) environments … Read more
Modern data platforms are not built on single scripts or ad‑hoc notebooks. They rely on reusable, well‑designed utility functions that handle extraction, transformation, auditing, and historical tracking in a consistent way. This article walks through a real‑world Python utility module used in Microsoft Fabric, explaining every major function, what problem it solves, and how it … Read more
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
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
Sharing local file links to Power BI (.pbix) reports may seem convenient, but it creates significant risks for your data, your reports, and your organisation. Here’s why this approach should be avoided in any enterprise environment. 1️⃣ It Creates Multiple, Conflicting Versions of the Same Report When a .pbix file is shared via local file … Read more
Delta tables are a core feature of the Microsoft Fabric Lakehouse. They solve a lot of the problems you normally hit with data lakes, especially around trust, auditing, and knowing what actually happened to your data. At a basic level, Delta tables give you ACID transactions on top of lake storage, but the real value … 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
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
Low C Profile — Series Analysis of Low Drives The Low C profile reflects a restless wiring pattern. These individuals are energetic, fast-moving, and constantly seeking variety. They thrive on activity and adapt quickly when plans shift, priorities change, or new demands emerge. Restlessness is not a flaw in this profile — it is the … Read more