In the previous parts of this series (Part I and Part II) we covered how to structure Delta tables using partitioning and clustering strategies. In this third installment we focus on advanced table configurations, performance diagnostics and optimal runtime environment setup…
Delta Table Optimization in Fabric (Part II): ZORDER, partitionBy and clusterBy
Optimizing Delta tables in Microsoft Fabric inevitably comes down to choosing the right partitioning strategy. ZORDER, partitionBy and clusterBy are the three main tools at your disposal, and each one behaves very differently depending on your table’s query pattern. In the…
Delta Table Optimization in Fabric (Part I): Fragmentation
Optimizing Delta table performance is one of the most common challenges in Fabric environments. In this first post, we establish the starting point: the test environment, the methodology, and the metrics we will use throughout the series to evaluate each optimization…
Incremental Refresh & Real Time with Direct Query in Power BI
Welcome to the best Data & Cloud blog. In today’s post, we’re going to talk about Hybrid tables: Incremental refresh & Real-time with DirectQuery. Let’s get started! The Power BI updates in May have come with a lot of new features….
Create your Business Intelligence Project for less than 164€ per month – BI Low Cost Serie (2/3)
Welcome to the second part of the Business Intelligence Projects Series in Low Cost Mode. In this second post, we are going to deploy a much more professional project. Unlike the architecture of the previous entry, this one will be fully…
Create your Business Intelligence Project for less than 7€ per Month – BI Low Cost Series (1/3)
In today’s post, I present a series of posts that will deal with 3 different Business Intelligence projects: low, medium and high cost. Depending on the volume of data and resources of our clients, we will know when to decide one…
Calculated Groups: Reduce the number of measures to your SSAS Model
In today’s post we are going to talk about the Analysis Services Tabular Models, specifically one of the latest news published earlier this year: The Calculated Groups. The Calculated Groups allow us to shorten the number of measurements we have in…
💲 Learning to Convert Currencies with Power BI
When we work with multinational companies, one of the key parts of our model is the Conversion to different Currencies, since, payments are made from different countries with different currencies and the users who view the reports must be able to see them in…
BI Starter Pack (2/4) : Measures Calculated Groups
In my last Post, I showed you a much faster and more intuitive alternative than Visual Studio, the Tabular Editor. Surely many of you will have been testing this new application, so if you liked it and found it really useful, you can not…
BI Starter Pack (1/4) : The Alternative to Visual Studio
In today’s post I will show you a Business Intelligence tool that will be of great help when creating Analysis Models. Last September, I had the opportunity to attend the data event held every year in Madrid, the SQL Saturday. In one of the…