Some of my recent thoughts on design, development, and the tech industry.
Deploying Azure Resources with VS Code
Utilizing a Bicep script template for resource deployment via VS Code, the Azure CLI, and Azure DevOps CD pipelines.
Power BI DAX Masterclass
Best practices and key patterns for Power BI DAX: calculated columns vs. measures, date tables, iterator functions, CALCULATE, time intelligence, and more.
Data Catalog 3.0: Rise of the Active Metadata Platform
How the role of the data catalog has evolved from passive inventory to active metadata platform, and where it sits in the modern data stack and data mesh architecture.
dbt on Databricks: Data Transformation Pipelines
How to connect dbt Cloud to Databricks Unity Catalog — step by step: SQL Warehouse, Unity Catalog, access tokens, project initialisation, and repository setup.
Power BI Incremental Refresh
How incremental refresh works in Power BI — partitioning, change detection, step-by-step setup, and the license and data source limitations you need to know.
Microsoft Fabric as an All-in-One Analytics Solution
A deep dive into Microsoft Fabric — OneLake, Workspaces, Lakehouse, Warehouse, Apache Spark, and how it compares to Data Mesh and decentralised approaches.
Set Power BI Row-Level Security to SAP Cost Center
How to implement dynamic Row-Level Security (RLS) in Power BI using SAP authorization tables — restricting data access by cost center based on the logged-in user.
Dynamic Management Views (DMVs)
How to use DMVs to create documentation for a Power BI data model — querying tables, columns, measures, relationships, and dependencies in DAX Studio and SSMS.
Orchard Core Shapes: Demystifying the View Data Model
How Orchard Core Shapes work as a dynamic view data model — creating, rendering, and extending shapes with data, metadata, Liquid templates, and strongly typed models.
General Delta Table Processing
A Python OOP approach for creating and updating Databricks Delta Tables — building a reusable, metadata-driven processing class based on the four pillars of object-oriented programming.
