The Modern Data Warehouse in Azure
- 304 pages
- 11 hours of reading
Build a modern data warehouse on Microsoft's Azure Platform that is flexible, adaptable, and fast—quick to assemble, reconfigure, and deliver results for informed decision-making. This guide eliminates the outdated, slow data warehousing projects that drained resources and provided outdated business intelligence. It demonstrates how to construct a data warehouse solution by connecting specific Azure technologies tailored to your business needs. You will learn to implement various architectural patterns using batches, events, and streams for both data lake technology and SQL databases. The book covers managing metadata and automation to speed up development while ensuring resilience at all levels. It also explains how to integrate analytic solutions like Power BI and Azure Analysis Services to foster data-driven decision-making that propels your business forward. You'll gain insights into improving implementation speed and flexibility in data warehousing systems, including making informed choices about design, architecture, and infrastructure, such as selecting the right SQL engine for your organization. Additionally, it addresses ETL/ELT structures and numerous accelerators to aid implementation and ensure resilience. Data warehouse developers and architects will find this resource invaluable for advancing their skills in cloud-based implementations.
