Description
Book SynopsisBuild a modern data warehouse on Microsoft's Azure Platform that is flexible, adaptable, and fastfast to snap together, reconfigure, and fast at delivering results to drive good decision making in your business. Gone are the days when data warehousing projects were lumbering dinosaur-style projects that took forever, drained budgets, and produced business intelligence (BI) just in time to tell you what to do 10 years ago. This book will show you how to assemble a data warehouse solution like a jigsaw puzzle by connecting specific Azure technologies that address your own needs and bring value to your business. You will see how to implement a range of architectural patterns using batches, events, and streams for both data lake technology and SQL databases. You will discover how to manage metadata and automation to accelerate the development of your warehouse while establishing resilience at every level. And you will know how to feed downstream analytic solutions such as Power BI and Az
Table of Contents1. The Rise of the Modern Data Warehouse2. The SQL Engine3. The Integration Engine4. The Ingestion Architecture5. The Role of the Data Lake6. The Role of the Data Contract7. Logging, Auditing, and Resilience8. Using Scripting & Automation
9. Beyond the Modern Data Warehouse
