Archive - Head First Data

How to Perform Common Data Transformations in Microsoft Fabric!

Discover how to perform 5 essential data transformations in Microsoft Fabric using PySpark, T-SQL, and KQL.

Jul 3 •

June 2025

Stop Guessing! Choose the Right Fabric Engine for Your Data!

Microsoft Fabric is all about the options. This article provides a guidance on the most common Fabric dilemma - which analytical storage engine to…

Jun 14 •

May 2025

Mirroring vs. Shortcuts in Microsoft Fabric: Which One Should You Use?

Both features enable the "One Copy" mantra that Fabric heavily promotes. And, although they share a lot of similarities, they work completely…

May 24 •

A Tale of Two Direct Lakes in Microsoft Fabric

If you were confused or felt lost with the Direct Lake mode in Microsoft Fabric, I have "great" news for you - things just got even worse! We now have…

May 10 •

April 2025

Real-Time Intelligence in Microsoft Fabric – The Ultimate Guide!

Once upon a time, handling streaming data was considered avant-garde approach. Today, it's a necessity for many organizations. In this article, you'll…

Apr 27 •

How to set up Object-level security directly in Power BI Desktop

Setting up OLS in Power BI requires an external tool. Not anymore! With the new TMDL view, you can configure and manage the OLS directly in Power BI…

Apr 11 •

March 2025

Power BI in the Era of Microsoft Fabric - The Definitive Guide!

If you worked with Microsoft Power BI before Microsoft Fabric was announced, you might be (rightly) wondering – what’s all the fuss about?

Mar 28 •

Dynamically Highlight Data Points Based on Slicer Selection in Power BI!

Sometimes, common Power BI requests can make you scratch your head. Learn how to implement an effective workaround to dynamically highlight data points…

Mar 19 •

5 Clicks to WOW! Optimize your Power BI model in 2 minutes!

Optimizing Power BI semantic model doesn't always have to be a daunting and time-consuming task. You can often celebrate many quick and easy wins!

Mar 8 •

February 2025

FREE Learning Opportunity - Data Modeling for Power BI

A few days ago, while closing in on 5000 subscribers to my YouTube channel, I promised I'd do another free training for the data community.

Feb 28 •

Lock Up! Understanding Data Access Options in Microsoft Fabric

In this article, we are focusing on understanding different concepts and features to control data access in Microsoft Fabric on various levels

Feb 19 •

Welcome to the Head First Data subscriber chat!

A private space for us to converse and connect

Feb 8 •

#nojs-banner { position: fixed; bottom: 0; left: 0; padding: 16px 16px 16px 32px; width: 100%; box-sizing: border-box; background: red; color: white; font-family: -apple-system, "Segoe UI", Roboto, Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 13px; line-height: 13px; } #nojs-banner a { color: inherit; text-decoration: underline; } This site requires JavaScript to run correctly. Please turn on JavaScript or unblock scripts