Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model (Paperback)
暫譯: Microsoft SQL Server 2012 分析服務:BISM 標準模型 (平裝本)

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 語意模型 (BISM) 分析表格數據,並發現創建企業級商業智慧解決方案的更簡單方法。在三位商業智慧專家的指導下,您將學習如何構建、部署和查詢 BISM 表格模型,並透過逐步指南、範例和最佳實踐來實現。本書以實作為主,展示了表格模型的內存數據庫如何使您能夠進行快速分析—無論您是新接觸 Analysis Services 的專業商業智慧開發人員,還是熟悉其多維模型的使用者。

發現如何:

- 確定何時使用表格模型或多維模型適合您的專案
- 使用 Microsoft Visual Studio® 2010 中的 SQL Server Data Tools 建立表格模型
- 將來自多個來源的數據整合成公司資訊的單一一致視圖
- 使用數據分析表達式 (DAX) 語言創建計算欄位、度量和查詢
- 選擇符合您組織性能和可用性要求的數據建模技術
- 使用 xVelocity 儲存引擎優化您的數據模型以獲得更好的性能
- 管理複雜的數據關係,例如多欄位、分組和多對多
- 通過建立管理和數據使用者角色來實施安全性