Blog

We describe how to create a high level view of your digital assets, where everything is measured equally and actionable insights can be generated that allow you to optimise your budget and build a roadmap focused on business value.

Optimise Power BI report performance with analyzer tools. Discover essential techniques for efficient report development in this blog post.

C# has gradually been adding support for discards. This article explores how this evolution has led to some surprises.

Why traditional bottom-up data warehouse projects so often deliver compromised platforms — and how a top-down, action-oriented approach changes the outcome.

The first in a series of posts talking about how and why we migrated an application from Azure Functions to Azure Container Apps

Automate Excel tasks with Office Scripts & Power Automate. Get an overview and explore a practical example in this post.

Explore Microsoft Dependency Injection container's 3 lifetimes: transient, singleton, scoped. Learn their behaviors & importance in app dependencies.

Fix broken dev loop with containerized apps on Azure CLI for Windows. Learn a workaround to avoid using outdated Azure CLI versions.

In this blog we demonstrate how the Gherkin specification can be adapted to enable BDD to be applied to data engineering use cases.

Learn how to grant non-admin users access to Spark synchronized objects with SQL Serverless in Synapse Analytics using the Shared Metadata Model.

If you're interested in the Distributed Application Runtime (Dapr) and how it can simplify migrating existing workloads to use cloud platform services, then this series might be for you. In this post, we continue modifying the excellent Dapr Traffic Control sample application by swapping the MQTT-based messaging with Azure Storage Queues. We will also look at how you can use the Dapr programming model as an alternative to cloud-provider SDKs.

Explore Azure Synapse's 'Shared Metadata Model' feature. Learn how it syncs Spark tables with SQL Serverless, its benefits, and tradeoffs.

How CALCULATE silently turns a row context into a filter context in DAX — and why context transition prevents surprises in calculated columns and measures.

The stack and heap are central components of memory management in C# programs. This post aims to introduce the topic, with a number of worked examples.

Explore the impact of Excel's numeric precision rules on identifiers and learn about infamous data loss incidents caused by misuse in this post.

CALCULATE is the only DAX function that can change filter context. Jess explains how it works, its syntax, and how filter propagation flows through the data model.

How DAX's RELATED and RELATEDTABLE functions navigate one-to-many relationships in Power BI — with a Customer/Sales example showing row-context behaviour.

Discover how to extract insights from spreadsheets and CSV files using Pandas and Power BI in this blog post.

We're constantly using computer networks and the internet, especially as developers. The Web is the most important application on the Internet; this is the second of two posts aiming to explain the basics of the Web.

When a method creates its own dependencies, changing one class means changing every caller. ASP.NET Core's built-in DI container fixes this: here's how to refactor from tight coupling to constructor injection in three steps.

Explore filtering fact tables with Star Schemas and learn a clean method for filtering dimension tables by another dimension.

A tricky C# bug — combining multicast delegates with async Task-returning methods silently swallows results. Here's why it happens and how to avoid the trap.

Power BI's Field Parameters feature lets users toggle between measures in a single visual with no advanced modelling. Here's how to set it up, plus a DAX-based workaround for when you need more control.

Explore debugging NuGet packages, a less straightforward process, to troubleshoot app issues by stepping through code and diving into methods.

Explore DAX's DISTINCT table function in Power BI — how it returns unique values of a column in the current filter context, with worked Sales and Product examples.