Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model (Paperback)

Marco Russo, Alberto Ferrari, Chris Webb

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

商品描述

Build agile and responsive Business Intelligence solutions

Analyze tabular data using the BI Semantic Model (BISM) in Microsoft® SQL Server® 2012 Analysis Services—and discover a simpler method for creating corporate-level BI solutions. Led by three BI experts, you’ll learn how to build, deploy, and query a BISM tabular model with step-by-step guides, examples, and best practices. This hands-on book shows you how the tabular model’s in-memory database enables you to perform rapid analytics—whether you’re a professional BI developer new to Analysis Services or familiar with its multidimensional model.

Discover how to:

  • Determine when a tabular or multidimensional model is right for your project
  • Build a tabular model using SQL Server Data Tools in Microsoft Visual Studio® 2010
  • Integrate data from multiple sources into a single, coherent view of company information
  • Use the Data Analysis eXpressions (DAX) language to create calculated columns, measures, and queries
  • Choose a data modeling technique that meets your organization’s performance and usability requirements
  • Optimize your data model for better performance with xVelocity storage engine
  • Manage complex data relationships, such as multicolumn, banding, and many-to-many
  • Implement security by establishing administrative and data user roles

商品描述(中文翻譯)

建立敏捷且具有回應性的商業智能解決方案

使用 Microsoft® SQL Server® 2012 Analysis Services 中的 BI Semantic Model (BISM) 分析表格資料,並發現一種更簡單的方法來建立企業級的商業智能解決方案。在三位商業智能專家的帶領下,您將學習如何透過逐步指南、範例和最佳實踐來建立、部署和查詢 BISM 表格模型。這本實踐指南書籍將向您展示,透過表格模型的內存資料庫,您可以進行快速分析,無論您是一位對 Analysis Services 新手的專業商業智能開發人員,還是對其多維模型非常熟悉。

了解如何:
- 判斷表格模型或多維模型對於您的專案而言何者更適合
- 使用 Microsoft Visual Studio® 2010 中的 SQL Server Data Tools 建立表格模型
- 整合來自多個來源的資料,建立一個統一且一致的公司資訊視圖
- 使用 Data Analysis eXpressions (DAX) 語言來建立計算欄位、度量和查詢
- 選擇符合組織性能和可用性需求的資料建模技術
- 透過 xVelocity 儲存引擎優化資料模型以提升效能
- 管理複雜的資料關聯,例如多欄位、分段和多對多
- 透過建立管理和資料使用者角色來實施安全性