Most of what is written about AI in data work falls into two buckets: AI will replace developers within two years, or AI is glorified autocomplete. Both are wrong. After months of daily use on Microsoft Fabric engagements, the honest answer is that AI is not a people replacement but a power multiplier, and like…
Scenario 1: Multiple fact tables thar are not related to each other Solution: Relate every dimension with their respective fact tables. Identify the shared dimensions. Relate them with every fact. Sometimes this model is called constellation schema, where each fact table individually is a perfect star schema design because each one is related with a…
Query Folding is the capability of Power Query to delegate some of the transformations to the source to improve performance. In this post you will see its importance and good practices guide to achieve it. According to official documentation the following data sources support query folding: – Relational databases (SQL Server, Oracle, etc.). -OData sources (including…