SQL Server Analysis Services 2012 Cube Development Cookbook

Baya Dewald, Steve Hughes, Paul Turley

  • 出版商: Packt Publishing
  • 出版日期: 2013-12-26
  • 售價: $2,350
  • 貴賓價: 9.5$2,233
  • 語言: 英文
  • 頁數: 340
  • 裝訂: Paperback
  • ISBN: 1849689806
  • ISBN-13: 9781849689809
  • 相關分類: MSSQLSQL
  • 下單後立即進貨 (約3~4週)

商品描述

If you prefer the instructional approach to a lot of theory, this cookbook is for you. It takes you straight into building data cubes through hands-on recipes, helping you get to grips with SQL Server Analysis Services fast.

Overview

  • Develop Business Intelligence solutions using a multi-dimensional model as well as a tabular model
  • Explore cube maintenance with partitions and design effective aggregations, as well as analyzing options for scaling analytics solutions
  • Includes recipes for administering, securing, monitoring, and troubleshooting Analysis Services solutions

In Detail

Microsoft SQL Server is a relational database management system. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications. SQL Server Analysis Services adds OLAP and data mining capabilities for SQL Server databases. OLAP (online analytical processing) is a technique for analyzing business data for effective business intelligence.

This practical guide teaches you how to build business intelligence solutions using Microsoft's core product - SQL Server Analysis Services. The book covers the traditional multi-dimensional model which has been around for over a decade as well as the tabular model introduced with SQL Server 2012.

Starting with comparing MultiDimensional and tabular models - discussing the values and limitations of each, you will then cover the essential techniques for building dimensions and cubes. Following on from this, you will be introduced to more advanced topics, such as designing partitions and aggregations, implementing security, and synchronizing databases for solutions serving many users.

The book also covers administrative material, such as database backups, server configuration options, and monitoring and tuning performance. We also provide a primer on MultiDimensional eXpressions (MDX) as well as Data Analysis expressions (DAX) languages.

This book provides you with data cube development techniques, and also the ongoing monitoring and tuning for Analysis Services.

What you will learn from this book

  • Design commonly encountered dimensions
  • Extend your cubes to include advanced features such as actions, translations, and key performance indicators
  • Maintain cubes by adding/removing data using partitions
  • Administer Analysis Services instance
  • Scale out your solution by synchronizing cube data
  • Build tabular model solutions

Approach

A practical cookbook packed with recipes to help developers produce data cubes as quickly as possible by following step by step instructions, rather than explaining data mining concepts with SSAS.

Who this book is written for

If you are a BI or ETL developer using SQL Server Analysis services to build OLAP cubes, this book is ideal for you. Prior knowledge of relational databases and experience with Excel as well as SQL development is required.

商品描述(中文翻譯)

如果您更喜歡實踐性的教學方法而不是理論,這本食譜對您來說非常適合。它直接帶您進入通過實踐來建立數據立方體,幫助您快速掌握 SQL Server Analysis Services。

概述:
- 使用多維模型和表格模型開發商業智能解決方案
- 通過分區進行立方體維護,設計有效的聚合,並分析擴展分析解決方案的選項
- 包括管理、安全、監控和故障排除 Analysis Services 解決方案的食譜

詳細內容:
Microsoft SQL Server 是一個關聯式數據庫管理系統。作為一個數據庫,它是一個軟件產品,其主要功能是根據其他軟件應用程序的請求存儲和檢索數據。SQL Server Analysis Services 為 SQL Server 數據庫添加了 OLAP 和數據挖掘功能。OLAP(在線分析處理)是一種用於有效商業智能分析業務數據的技術。

這本實用指南教您如何使用 Microsoft 的核心產品 - SQL Server Analysis Services 構建商業智能解決方案。本書涵蓋了傳統的多維模型,該模型已經存在了十多年,以及在 SQL Server 2012 中引入的表格模型。

從比較多維和表格模型開始 - 討論每個模型的價值和限制,然後您將學習構建維度和立方體的基本技術。接著,您將介紹更高級的主題,例如設計分區和聚合,實施安全性,以及為服務於多個用戶的解決方案同步數據庫。

本書還涵蓋了管理材料,例如數據庫備份,服務器配置選項以及監控和調整性能。我們還提供了關於多維表達式(MDX)和數據分析表達式(DAX)語言的入門指南。

本書提供了數據立方體開發技術以及持續監控和調整 Analysis Services 的方法。

您將從本書中學到:
- 設計常見的維度
- 擴展立方體以包括高級功能,如操作、翻譯和關鍵績效指標
- 通過添加/刪除分區來維護立方體
- 管理 Analysis Services 實例
- 通過同步立方體數據來擴展解決方案
- 構建表格模型解決方案

這是一本實用的食譜,充滿了按步驟指示開發人員快速生成數據立方體的方法,而不是解釋使用 SSAS 的數據挖掘概念。

本書適合商業智能或 ETL 開發人員使用 SQL Server Analysis Services 構建 OLAP 立方體。需要具備關聯式數據庫的知識以及 Excel 和 SQL 開發的經驗。