4

Building an End-to-End Analytics System – Data Warehouse

While the world of data and analytics makes a shift to the lake-centric approach introduced in the previous chapter, there are still many scenarios that are well served by a traditional data warehouse. Teams of developers often have deep, longstanding SQL skills that can be easily applied to the development of a data warehouse. Other times, an enterprise data lake or lakehouse could feed data into downstream data warehouses that are purpose-built by various business units (BUs) or departments that serve as the gold layer in a medallion architecture. In some smaller organizations, there just isn’t the need for the added complexity of a lakehouse when data is being centralized from all ...

Get Learn Microsoft Fabric now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.