Top-Down and Bottom-Up Approaches in Microsoft Fabric


 

Nikola Ilic, best known as Data Mozart, published a great article and video about how to make semantic model data available in Microsoft Fabric. This allows the data to be used in lakehouses or data warehouses.

One major question that arises is, “should we use a top-down or bottom-up (or both) approach in Microsoft Fabric?” This decision especially affects custom projects built for large corporations.

What’s Top-down approach?

Top-down is the name we use for the traditional and old centralized approach. A team of data engineers uses ETL to create a centralized data intelligence repository. After the repository is ready,