Profile avatar
datamozart.bsky.social
I'm making music from the data🎶 #PowerBI addict, Microsoft Data Platform MVP, O'Reilly Instructor, Pluralsight Author, blogger, speaker, learner...Father of 2, Barca and Messi fan⚽
400 posts 1,158 followers 246 following
Prolific Poster
Conversation Starter

📢NEW COURSE ALERT📢 Are you considering becoming a certified #MicrosoftFabric data engineer? Want to get that in-demand DP-700 badge? I have great news: my latest course at Pluralsight has just been published: Ingest and Transform Data in Microsoft Fabric! pluralsight.com/library/cour...

The excitement is now real! The "Fundamentals of Microsoft Fabric" book that @bweissman.bsky.social and I wrote (yes, I can now finally say "wrote") for @oreilly.bsky.social is currently available IN FULL at O'Reilly's learning platform: learning.oreilly.com/library/view...

Wrapped up a full-day training at the Data Platform Next Step. Together with my friend @brianbonk.bsky.social, we spent an entire day covering all the topics relevant for the DP-700 (Fabric Data Engineer) exam. A full house, packed with an amazing audience and plenty of great interaction

Finally made it to the fairytale Legoland and Data Platform Next Step! Looking forward for two days of learning, teaching, networking, and simply hanging out with like-minded people

#NotebookAllTheThings! Have you ever attended a session that is ENTIRELY run from a notebook?! So, "slides", useful links, markdown comments...Everything is inside the notebook! Oh, yes, and some code, of course😎 This Tuesday, at Data Platform Next Step in Billund... #MicrosoftFabric

October in Orlando, FL! If you want to learn about the fastest-growing analytics platform on the planet, I have a great idea - join me for a 2-day academy class at #SummitNA! Still not sure if this is for you? Check the details and grab your spot: www.summitna.com/academy/?se=...

Ever wondered how #PowerBI handles millions of rows at lightning speed? In this deep dive article, I explain what’s under the hood of Power BI. BONUS: A real-life use case where I managed to reduce the overall data model size by a whopping 90%! towardsdatascience.com/how-to-reduc...

Another day, another #MicrosoftFabric teaching! This time, all ready and set for the Fabric Analyst in a Day #FAIAD full-day workshop.

Ever wondered how Power BI handles millions of rows at lightning speed? Nikola Ilic's deep dive explains what’s under the hood — from VertiPaq’s in-memory columnar compression to the Formula & Storage Engines — and how to design faster, leaner data models.

NEW BLOG POST! Discover how to perform 5 essential data transformations in #MicrosoftFabric using PySpark, T-SQL, and KQL. Whether you're coding in Python, SQL, or Kusto, this post shows you how to clean, shape, and master your data - your way! data-mozart.com/triple-five-... #DP700 #DP600

June is #MicrosoftFabric month at O'Reilly! I'll be delivering three online live training, covering various aspects of the platform. 1️⃣ June 12th, Getting started with Microsoft Fabric - a gentle introduction into WHY and WHAT of Fabric, learning.oreilly.com/live-events/...

NEW SUBSTACK ARTICLE! Both features enable the "One Copy" mantra that #MicrosoftFabric heavily promotes. And, although they share a lot of similarities, they work completely differently behind the scenes, and have different use cases. datamozart.substack.com/p/mirroring-...

NEW VIDEO ALERT! Let's continue our #DP700 #DP600 learning journey! In this video, I show you how to implement numerous data transformations in #MicrosoftFabric, using PySpark, T-SQL, and KQL languages. youtu.be/C4rLcd5K7AQ

All ready and set for the Day 1 of my #PowerBI Data Analyst Bootcamp at @oreilly.bsky.social! Looking forward to spending the next three days with another cohort of aspiring Power BI professionals.

NEW VIDEO ALERT! Setting up OLS in #PowerBI requires an external tool. Not anymore! With the TMDL view, you can configure and manage the OLS directly in Power BI Desktop! In this video, I walk you step-by-step how it's set up. Plus, some bonus links you may find useful. youtu.be/8xOtCa0B-9s

NEW BLOG POST! Microsoft Fabric is all about the options. This article aims to provide guidance on the most common Fabric dilemma - which analytical storage engine to choose? data-mozart.com/stop-guessin... #MicrosoftFabric #lakehouse #DP700 #warehouse

One week to go! If you want to master all the skills necessary to pass the PL-300 exam (Power BI Data Analyst), join me next week for a 3-day immersive bootcamp at @oreilly.bsky.social. learning.oreilly.com/live-events/...

NEW SUBSTACK ARTICLE! If you were confused or felt lost with the Direct Lake mode in #MicrosoftFabric, I have "great" news for you - things just got even worse! We now have TWO different Direct Lake mode "flavors" - OneLake and SQL. open.substack.com/pub/datamoza...

NEW BLOG POST! A few days ago, I shared the infographic with key differences and use cases for both mirroring and shortcuts in #MicrosoftFabric. I decided to cover the same topic in the blog post, so that it doesn’t get lost. data-mozart.com/mirroring-vs...

NEW VIDEO ALERT! #MicrosoftFabric is all about the options! The same task can be completed in multiple different ways. In this video, you'll find a scenario-based guide to help you choose the right tool for the job! youtu.be/l_t0xR9Tw2M

Mirroring or shortcuts in #MicrosoftFabric? That's one of the questions I'm getting most frequently when being asked about accessing the external data. So, I've decided to create a simple infographic that depicts the differences between these two and some common use cases.

My dear #MicrosoftFabric friends, if you fancy some weekend reading, stop scrolling... Fundamentals of Microsoft Fabric book, that @bweissman.bsky.social and I wrote for @oreilly.bsky.social is almost there! As of today, you can read 12 chapters in the early release www.oreilly.com/library/view...

SOLD OUT! If you wanted to join @brianbonk.bsky.social and me for a full-day workshop about mastering data engineering with #MicrosoftFabric (DP-700) at the Data Platform Next Step on June 2nd - sorry, you are out of luck - there are no seats remaining!

NEW VIDEO ALERT! We dive deep into Direct Lake 2.0 (Direct Lake on OneLake) - the next evolution of high-speed, low-latency data loading. Learn how Direct Lake 2.0 improves over the original Direct Lake, enabling more efficient workloads. youtu.be/Z0tgA_pYK1s #MicrosoftFabric #PowerBI

NEW SUBSTACK ARTICLE! Once upon a time, handling streaming data was considered an avanguard approach. Nowadays, it's a necessity for many organizations. In this article, you'll learn how to deal with streaming data in #MicrosoftFabric. datamozart.substack.com/p/real-time-... #KQL

NEW BLOG POST! My dear #MicrosoftFabric and #PowerBI friends - 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😀😀😀 data-mozart.com/a-tale-of-tw...

Sunday reading! Sometimes, common #PowerBI requests can make you scratch your head. Learn how to implement an effective workaround to dynamically highlight data points based on the user selection. datamozart.substack.com/p/dynamicall...

One of the most common questions I'm getting from my clients is: What is the right #MicrosoftFabric SKU for us, and how much will it cost? Up until now, I've used a set of my own criteria to determine (or at least to approximate) the proper capacity size.

3... That's the number of free seats remained for Brian Bønk and my full day workshop Mastering DP-700 Fabric Data Engineer at Data Platform Next Step on June 2nd in Billund. If you want to solidify your #MicrosoftFabric skills and get ready for the exam, jump in! dataplatformnextstep.com/tickets/

Maybe #MicrosoftFabric stole the headlines recently, but #PowerBI is still the undisputed leader in the BI reporting area. If you want to learn Power BI and get ready for the PL-300 exam, I'll be running a highly popular 3-day bootcamp at @oreilly.bsky.social www.oreilly.com/live-events/...

NEW VIDEO ALERT! Spark settings in #MicrosoftFabric require a lot of understanding of the inner workings of this powerful engine. In this video, I'll walk you through all the configuration options, explaining not only WHAT, but also WHY you should something. youtu.be/Qrjf5a85hvw

Getting ready for the DP-700 Fabric Data Engineer exam? Microsoft just released the official practice test! This is a great way to check your knowledge before taking the real exam. Practice test: learn.microsoft.com/en-us/creden... #MicrosoftFabric

In case you missed it! Setting up OLS in #PowerBI requires an external tool. Not anymore! With the new TMDL view, you can configure and manage the OLS directly in Power BI Desktop! Step-by-step tutorial in the article below👇👇 datamozart.substack.com/p/how-to-set...

NEW BLOG POST! Spark settings in #MicrosoftFabric aren't just technical fine print - they are your ticket to immortality when it comes to Spark performance! This article can also help you prepare for the DP-700 (Fabric Data Engineer) exam. data-mozart.com/from-default...

How should I configure Spark settings in #MicrosoftFabric? What is an optimistic Spark job admission? Should I use pipelines or notebooks for data ingestion? Where can I monitor the execution of my Fabric workloads?

My dear #PowerBI and #MicrosoftFabric friends, my friend @datamozart.bsky.social and I will dissect all the Fabric news on our nxt #DataCenturials talk next Wednesday, 7:00 PM CET Join us here: www.youtube.com/live/QLsRjz1...

June is #MicrosoftFabric month at @oreilly.bsky.social! If you want to learn (almost) everything about the fastest-growing data analytics platform, or become a certified Fabric Analytics/Data Engineer, stop scrolling and spend June learning Fabric. I'll be doing 3 live trainings:

In case you missed it - a few days ago, I published an article (WARNING: it's a loooong one) about working with #PowerBI in the era of #MicrosoftFabric. Since it's already been read more than 2000 times, I thought it's worth sharing it here as well. datamozart.substack.com/p/power-bi-i...