Read While You Wait - Get immediate ebook access, if available*, when you order a print book

The Modern Data Warehouse in Azure

Building with Speed and Agility on Microsoft’s Cloud Platform

Authors: How, Matt

Free Preview
  • Provides you with a process for building a complete data warehouse solution in Azure
  • Shares key accelerators for implementation from the author’s personal experience
  • Teaches you how to implement data contracts and metadata management
see more benefits

Buy this book

eBook $34.99
price for USA
  • ISBN 978-1-4842-5823-1
  • Digitally watermarked, DRM-free
  • Included format: EPUB, PDF
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Softcover $44.99
price for USA
  • ISBN 978-1-4842-5822-4
  • Free shipping for individuals worldwide
  • Immediate ebook access, if available*, with your print order
  • Usually dispatched within 3 to 5 business days.
About this book

Build a modern data warehouse on Microsoft's Azure Platform that is flexible, adaptable, and fast—fast 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 Azure Analysis Services to empower data-driven decision making that drives your business forward toward a pattern of success.
This book teaches you how to employ the Azure platform in a strategy to dramatically improve implementation speed and flexibility of data warehousing systems. You will know how to make correct decisions in design, architecture, and infrastructure such as choosing which type of SQL engine (from at least three options) best meets the needs of your organization. You also will learn about ETL/ELT structure and the vast number of accelerators and patterns that can be used to aid implementation and ensure resilience. Data warehouse developers and architects will find this book a tremendous resource for moving their skills into the future through cloud-based implementations.

What You Will Learn

  • Choose the appropriate Azure SQL engine for implementing a given data warehouse
  • Develop smart, reusable ETL/ELT processes that are resilient and easily maintained
  • Automate mundane development tasks through tools such as PowerShell
  • Ensure consistency of data by creating and enforcing data contracts
  • Explore streaming and event-driven architectures for data ingestion
  • Create advanced staging layers using Azure Data Lake Gen 2 to feed your data warehouse

Who This Book Is For
Data warehouse or ETL/ELT developers who wish to implement a data warehouse project in the Azure cloud, and developers currently working in on-premise environments who want to move to the cloud, and for developers with Azure experience looking to tighten up their implementation and consolidate their knowledge

About the authors

Matt How is a professional consultant and international conference speaker who is passionate about data, analytics, and automation. Having spoken at several large conferences across the world, he is committed to sharing knowledge and insight with the wider community. Specializing in the design and delivery of modern data warehouse solutions using the Microsoft Azure Platform, Matt focuses on simplicity and resilience above all when designing cloud solutions. With a growing focus on data science, he is now researching techniques to integrate artificial intelligence capabilities into the modern data warehouse at scale.


Table of contents (9 chapters)

Table of contents (9 chapters)

Buy this book

eBook $34.99
price for USA
  • ISBN 978-1-4842-5823-1
  • Digitally watermarked, DRM-free
  • Included format: EPUB, PDF
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Softcover $44.99
price for USA
  • ISBN 978-1-4842-5822-4
  • Free shipping for individuals worldwide
  • Immediate ebook access, if available*, with your print order
  • Usually dispatched within 3 to 5 business days.

Services for this book

Loading...

Bibliographic Information

Bibliographic Information
Book Title
The Modern Data Warehouse in Azure
Book Subtitle
Building with Speed and Agility on Microsoft’s Cloud Platform
Authors
Copyright
2020
Publisher
Apress
Copyright Holder
Matt How
eBook ISBN
978-1-4842-5823-1
DOI
10.1007/978-1-4842-5823-1
Softcover ISBN
978-1-4842-5822-4
Edition Number
1
Number of Pages
XXII, 282
Number of Illustrations
138 b/w illustrations
Topics

*immediately available upon purchase as print book shipments may be delayed due to the COVID-19 crisis. ebook access is temporary and does not include ownership of the ebook. Only valid for books with an ebook version. Springer Reference Works and instructor copies are not included.