The Modern Data Warehouse in Azure: Building with Speed and Agility on Microsoft's Cloud Platform
暫譯: Azure 現代數據倉儲:在微軟雲平台上快速靈活地構建

How, Matt

  • 出版商: Apress
  • 出版日期: 2020-06-16
  • 售價: $2,370
  • 貴賓價: 9.5$2,252
  • 語言: 英文
  • 頁數: 323
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1484258223
  • ISBN-13: 9781484258224
  • 相關分類: Microsoft Azure
  • 海外代購書籍(需單獨結帳)

商品描述

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

商品描述(中文翻譯)

在微軟的 Azure 平台上建立一個現代化的資料倉儲,該資料倉儲靈活、可適應且快速——快速組合、重新配置,並快速提供結果以促進業務的良好決策。過去資料倉儲專案如同笨重的恐龍,耗時長、耗費預算,並且在十年前才告訴你該怎麼做的商業智慧(BI)已經一去不復返。本書將向您展示如何像拼圖一樣組裝資料倉儲解決方案,通過連接特定的 Azure 技術來滿足您的需求並為您的業務帶來價值。您將看到如何使用批次、事件和串流來實現一系列架構模式,適用於資料湖技術和 SQL 資料庫。您將發現如何管理元資料和自動化,以加速資料倉儲的開發,同時在每個層級建立韌性。您還將了解如何為下游分析解決方案(如 Power BI 和 Azure Analysis Services)提供數據,以促進數據驅動的決策,推動您的業務邁向成功的模式。

本書教您如何在策略中使用 Azure 平台,以顯著提高資料倉儲系統的實施速度和靈活性。您將知道如何在設計、架構和基礎設施方面做出正確的決策,例如選擇哪種類型的 SQL 引擎(至少有三種選擇)最符合您組織的需求。您還將了解 ETL/ELT 結構以及可以用來輔助實施和確保韌性的眾多加速器和模式。資料倉儲開發人員和架構師將發現本書是將他們的技能推向未來的絕佳資源,通過雲端實施。

您將學到的內容:
- 選擇適合的 Azure SQL 引擎以實施特定的資料倉儲
- 開發智能、可重用的 ETL/ELT 流程,這些流程具有韌性且易於維護
- 通過 PowerShell 等工具自動化日常開發任務
- 通過創建和執行數據合約來確保數據的一致性
- 探索用於數據攝取的串流和事件驅動架構
- 使用 Azure Data Lake Gen 2 創建高級暫存層以供應您的資料倉儲

本書適合對象:
希望在 Azure 雲端實施資料倉儲專案的資料倉儲或 ETL/ELT 開發人員,以及希望從本地環境轉移到雲端的開發人員,還有希望加強實施並整合知識的 Azure 經驗開發人員。

作者簡介

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.


作者簡介(中文翻譯)

馬特·豪是一位專業顧問和國際會議演講者,對數據、分析和自動化充滿熱情。他曾在全球多個大型會議上發表演講,致力於與更廣泛的社群分享知識和見解。馬特專注於使用 Microsoft Azure 平台設計和交付現代數據倉庫解決方案,在設計雲端解決方案時,他最重視簡單性和韌性。隨著對數據科學的日益關注,他目前正在研究將人工智慧能力大規模整合到現代數據倉庫中的技術。

最後瀏覽商品 (1)