Data Analytics Archives

The future of data leadership: key strategies, challenges, and emerging trends

Data leadership drives smarter decisions, stronger governance, and competitive advantage. Discover the key pillars, challenges, and strategies for 2026 and...

06 October 2026 12 min read

An image showing Power BI running on a laptop.

John Kerski in PowerBI

Power BI Project (PBIP) is now generally available. Here’s why that matters – and how it works

PBIP is Power BI's generally available project format. Learn how it stores reports as TMDL and PBIR files, works with...

29 September 2026 15 min read

Tony Davis in Security, Privacy & Compliance

How test data management helps meet DORA’s resilience testing requirements

Learn how test data management helps financial institutions meet DORA's resilience testing and ICT risk requirements without exposing sensitive data.…

21 September 2026 11 min read

Greg Low in SQL Server

How to mirror data from SQL Server to Microsoft Fabric: complete guide

Learn all about Microsoft Fabric mirroring for SQL Server: how it works, what's new in 2025, setup, limitations, and troubleshooting.…

07 September 2026 9 min read

John Kerski in PowerBI

How to use the Power BI Desktop Bridge to automate tasks in Power BI Desktop and GitHub Copilot

Learn how Microsoft's Power BI Desktop Bridge and Fabric AI Skills let GitHub Copilot edit and hot-reload Power BI reports....

12 August 2026 15 min read

Aisha Bukar in Databases

MySQL vs PostgreSQL: spatial data types, functions, and migration pitfalls explained

MySQL and PostgreSQL both support spatial data, but work very differently. This guide breaks down types, indexing, functions, and key...

05 August 2026 15 min read

John Kerski in Microsoft Fabric

How to automate Fabric data agent testing with promptfoo and GitHub Actions

Learn how to automate Fabric Data Agent testing using promptfoo, service principals, and GitHub Actions - step-by-step guide. No more...

10 July 2026 13 min read

Simple Talk Editor in Career

From anthropology to analytics: how to build a data career with no prior experience (10 tips from a Microsoft MVP)

No computer science degree, no clear plan - just deliberate moves and the right communities. Here's what Kristyna Ferris learned...

12 June 2026 10 min read

John Kerski in PowerBI

Never ship a broken semantic model again: how to build automated tests in Power BI with user-defined functions

Learn how to test Power BI semantic models using User-Defined Functions and PQL.Assert. Catch errors early and automate testing with...

02 June 2026 13 min read

Joydip Kanjilal in AI

Why AI-driven workflows are important (and how to implement them)

AI-driven workflow automation and orchestration help businesses improve efficiency, automate complex processes, and make real-time decisions. Learn how they work,...

22 May 2026 10 min read

John Kerski in AI

How DataOps principles help to reduce GenAI risk and improve data quality

Learn how DataOps principles improve trust, quality, and governance when using GenAI in data solutions. Tips for for Git, testing,...

08 May 2026 10 min read

John Kerski in Data Analytics

Power BI TMDL View: Benefits, Security Risks & Best Practices

Explore the benefits and hidden risks of Power BI’s TMDL View. Learn how to safely use TMDL scripts with expert...

11 August 2025 9 min read

Koen Verbeeck in General Analytics

Scripting Dimension Tables with dbt Macros: Type 1 and Type 2 SCD Patterns for Data Warehouses

Building dimension tables with dbt macros - Type 1 (overwriting changes) and Type 2 (preserving history with effective dates) slowly...

16 July 2025 10 min read

John Kerski in Data Analytics

13 Things I wish I knew about Power Query (when I first started)

When I first started with Power Query, it was in Excel, through the Power Pivot feature. I was amazed at...

03 July 2025 11 min read

Gogula Aryalingam in Data Analytics

Unlocking Infor CloudSuite data: Making the most of it with Stream Pipelines

In my experiences building end-to-end analytics solutions, I often need to connect to a variety of different systems to bring...

01 July 2025 17 min read

Dennes Torres in Microsoft Fabric

Query Lineage in Fabric Lakehouses

I already wrote about query performance analysis in lakehouses, but one secret was left behind: The capability to track the...

02 May 2025 7 min read

Koen Verbeeck in General Analytics

Loading a Date Dimension in Microsoft Fabric Warehouse with dbt Macros: Complete Tutorial with Generated Calendar Table

Building a date dimension table in Microsoft Fabric Warehouse using dbt macros - generating date rows with dbt's sequence utilities,...

23 April 2025 8 min read

Dennes Torres in Microsoft Fabric

Query Performance Analysis in Lakehouses

You may have already discovered the 4 special views the lakehouse has in the queryinsights schema to track query performance....

09 April 2025 4 min read

Dennes Torres in Microsoft Fabric

Fabric Database: Advanced Vector Search Features

A few weeks ago, I delivered some sessions about vector search in Fabric Databases and Azure SQL. Let’s talk about...

02 April 2025 6 min read

Dennes Torres in Microsoft Fabric

Fabric: Query a SQL Endpoint from a Notebook

Let’s analyse why we would like to query an SQL Endpoint. Once we understand why, we can dig into how...

26 March 2025 5 min read