Blog

This series focuses on maximizing data projects' impact via an iterative, insight discovery process, and synergy with cloud platforms like Azure Synapse.

Understanding the total cost of ownership is key to making informed decisions about technology investments.

This post gives an overview of Continuous Integrations and shows how you can implement it with GitHub Actions, with an accompanying example Python project

Explore how to share a function from a PowerShell module as a standalone script, without maintaining two code versions.

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

Define actionable insights by starting with a specific action, then identifying the questions, evidence and feedback loops that turn data into business value.

In this post we will talk through how to expand on a data team's creative skillset, without access to specialist photo editing software such as Photoshop or Illustrator.

I recently passed the PL-300 - Power BI Data Analyst exam. Here are some tips to prepare for it that I found useful!

Successful data projects start by forgetting about the data. Begin with business goals and the decisions that drive them, and let data follow the insight.

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 in Power BI. Jess explains how it works, its syntax, and how filter propagation flows.