Expert Cube Development with SSAS Multidimensional Models

Chris Webb, Alberto Ferrari, Marco Russo

  • 出版商: Packt Publishing
  • 出版日期: 2014-02-21
  • 售價: $2,130
  • 貴賓價: 9.5$2,024
  • 語言: 英文
  • 頁數: 402
  • 裝訂: Paperback
  • ISBN: 1849689903
  • ISBN-13: 9781849689908
  • 海外代購書籍(需單獨結帳)

買這商品的人也買了...

商品描述

For Analysis Service cube designers this is the hands-on tutorial that will take your expertise to a whole new level. Written by a team of Microsoft SSAS experts, it digs deep to optimize your Business Intelligence capabilities.

Overview

  • Design SQL Server Analysis Services cubes, dimensions, and calculations from the experts!
  • Add calculations to the cube, including implementing currency conversion and a date tool dimension
  • Use security to control access to data in your cube

In Detail

Microsoft's SQL Server Analysis Services 2012 Multidimensional is an OLAP server that allows end users to analyze large amounts of business data quickly and easily, using a variety of tools including Excel, and to create their own reports without IT involvement. It is part of the Microsoft SQL Server suite of tools and has been used widely on Business Intelligence projects for the last 15 years; it is now the most commonly used OLAP server in the world.

Expert Cube Development with SSAS Multidimensional Models will teach you tips and tricks for cube design from some of the most experienced Analysis Services experts in the world. Topics covered include designing dimensions and cubes, implementing common MDX calculations, security and performance tuning.

The book takes you through the whole lifecycle of Analysis Services cube development, from how data warehouse design affects your cube, through cube and dimension design to performance tuning and monitoring. Some previous experience of Analysis Services is assumed – the focus is on best practices and design patterns.

The book starts off with a discussion of data warehouse design and how it relates to Analysis Services. Following on from that, best practices relating to Analysis Services cube and dimension design are covered, including topics such as optimizing dimension attribute relationships and handling fact tables that contain data at different granularities.

Next, the book looks at using MDX to implement common business calculations, and then moves on to more advanced problems like currency conversion calculations and creating a date tool dimensions.

Finally security, performance tuning, automation of administrative tasks and monitoring usage and performance each get their own chapter and subject such as dynamic security roles, using Profiler to diagnose query performance problems and automating partition creation are also dealt with.

What you will learn from this book

  • Build a data mart suitable for use with Analysis Services
  • Work with a thread pool effectively
  • Create and configure an Analysis Services project in SQL Server Data Tools
  • Use the Dimension Wizard and the Dimension Editor to build dimensions
  • Create measure groups and associate them with dimensions
  • Design cubes and dimensions and also implement common calculations in MDX
  • Explore the security model, including dimension security and cell security, and implement dynamic security
  • Tune queries to get the best possible performance
  • Automate processing and partition creation
  • Monitor your cube to see who's actually using it

Approach

An easy-to-follow guide full of hands on examples of real-world Analysis Services cube development tasks. Each topic is explained and placed in context, and for the more inquisitive reader, there also more in-depth details of the concepts used.

商品描述(中文翻譯)

對於分析服務立方體設計師來說,這是一本實踐教學,將提升您的專業知識到一個全新的水平。由一個微軟SSAS專家團隊撰寫,深入挖掘優化您的商業智能能力。

概述:
- 從專家那裡學習設計SQL Server Analysis Services立方體、維度和計算!
- 在立方體中添加計算,包括實現貨幣轉換和日期工具維度
- 使用安全性控制對立方體中的數據進行訪問

詳細內容:
微軟的SQL Server Analysis Services 2012多維是一個OLAP服務器,允許最終用戶快速輕鬆地分析大量的商業數據,使用包括Excel在內的各種工具,並且可以在不涉及IT的情況下創建自己的報表。它是微軟SQL Server工具套件的一部分,並且在過去的15年中在商業智能項目中被廣泛使用;現在它是世界上最常用的OLAP服務器。

《Expert Cube Development with SSAS Multidimensional Models》將向您介紹一些世界上最有經驗的分析服務專家的立方體設計技巧和技巧。涵蓋的主題包括設計維度和立方體、實現常見的MDX計算、安全性和性能調優。

本書將帶您完成整個分析服務立方體開發的生命周期,從數據倉庫設計如何影響您的立方體,到立方體和維度設計,再到性能調優和監控。假設您具有一些分析服務的經驗-重點是最佳實踐和設計模式。

本書首先討論數據倉庫設計及其與分析服務的關聯。接著,介紹了與分析服務立方體和維度設計相關的最佳實踐,包括優化維度屬性關係和處理包含不同粒度數據的事實表等主題。

接下來,本書介紹使用MDX實現常見業務計算,然後深入探討更高級的問題,如貨幣轉換計算和創建日期工具維度。

最後,安全性、性能調優、自動化管理任務和監控使用和性能等各自獲得一章,並處理動態安全性角色、使用分析器診斷查詢性能問題和自動化分割創建等主題。

您將從本書中學到的內容:
- 構建適用於分析服務的數據集市
- 有效地使用線程池
- 在SQL Server數據工具中創建和配置分析服務項目
- 使用維度精靈和維度編輯器構建維度
- 創建度量組並將其與維度關聯
- 設計立方體和維度,並在MDX中實現常見計算
- 探索安全模型,包括維度安全和單元格安全,並實現動態安全性
- 調優查詢以獲得最佳性能
- 自動化處理和分割創建
- 監控您的立方體以查看實際使用情況

這是一本易於理解的指南,充滿了實際的分析服務立方體開發任務的實例。每個主題都有解釋並放在上下文中,對於更好奇的讀者,還提供了更深入的概念細節。