Microsoft SQL Server 2005 Analysis Services Step by Step (Paperback)

Reed Jacobson, Stacia Misner, Hitachi Consulting

  • 出版商: MicroSoft
  • 出版日期: 2006-04-26
  • 定價: $1,200
  • 售價: 2.5$299
  • 語言: 英文
  • 頁數: 400
  • 裝訂: Paperback
  • ISBN: 0735621993
  • ISBN-13: 9780735621992
  • 相關分類: MSSQLSQL
  • 立即出貨(限量) (庫存=2)

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

商品描述

Description

Your hands-on, step-by-step guide to building business intelligence solutions for the enterprise.

Teach yourself the fundamentals of SQL Server Analysis Services—one step at a time. With this practical, learn-by-doing tutorial, you get the guidance you need to build flexible and powerful solutions that meet the analytical needs of your organization.

Discover how to:

•Start building cubes using the Microsoft Visual Studio 2005 Business Intelligence designers
•Create dimensions and measure groups to build, browse, and modify OLAP cubes
•Design objects to handle unique financial analysis requirements
•Improve query performance with aggregations and user hierarchies
•Customize cubes with multi-dimensional expressions (MDX) and other advanced design techniques
•Use actions to integrate Web pages, reporting applications, and drillthrough capabilities with cubes
•Manage role-based security and restrict data access
•Deploy and maintain a database in a production environment

CD features
•All practice exercises and answer files
•Fully searchable eBook

商品描述(中文翻譯)

描述

這是一本實用的、逐步指導企業建立商業智能解決方案的實作指南。透過這本實用的學習教程,您可以自學 SQL Server Analysis Services 的基礎知識。您將獲得所需的指導,以建立靈活且強大的解決方案,滿足組織的分析需求。

學習如何:
- 使用 Microsoft Visual Studio 2005 商業智能設計工具來建立立方體
- 建立維度和度量組,以建立、瀏覽和修改 OLAP 立方體
- 設計物件以滿足獨特的財務分析需求
- 通過聚合和用戶層次結構提高查詢性能
- 使用多維表達式(MDX)和其他高級設計技巧自定義立方體
- 使用操作將網頁、報表應用程序和立方體的鑽取功能集成在一起
- 管理基於角色的安全性並限制數據訪問
- 在生產環境中部署和維護數據庫

附帶光碟功能:
- 所有練習和答案文件
- 可全文搜索的電子書