Tabular Modeling in Microsoft SQL Server Analysis Services (2nd Edition) (Developer Reference)

Marco Russo

  • 出版商: MicroSoft
  • 出版日期: 2017-04-12
  • 售價: $2,160
  • 貴賓價: 9.5$2,052
  • 語言: 英文
  • 頁數: 512
  • 裝訂: Paperback
  • ISBN: 1509302778
  • ISBN-13: 9781509302772
  • 相關分類: MSSQLSQL
  • 立即出貨 (庫存 < 3)

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

商品描述

Build agile and responsive business intelligence solutions

Create a semantic model and analyze data using the tabular model in SQL Server 2016 Analysis Services to create corporate-level business intelligence (BI) solutions. Led by two BI experts, you will learn how to build, deploy, and query a tabular model by following detailed examples and best practices. This hands-on book shows you how to use the tabular model’s in-memory database to perform rapid analytics—whether you are new to Analysis Services or already 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 2015

• Integrate data from multiple sources into a single, coherent view of company information

• Choose a data-modeling technique that meets your organization’s performance and usability requirements

• Implement security by establishing administrative and data user roles

• Define and implement partitioning strategies to reduce processing time

• Use Tabular Model Scripting Language (TMSL) to execute and automate administrative tasks

• Optimize your data model to reduce the memory footprint for VertiPaq

• Choose between in-memory (VertiPaq) and pass-through (DirectQuery) engines for tabular models

• Select the proper hardware and virtualization configurations

• Deploy and manipulate tabular models from C# and PowerShell using AMO and TOM libraries

 

Get code samples, including complete apps, at: https://aka.ms/tabular/downloads

 

About This Book

• For BI professionals who are new to SQL Server 2016 Analysis Services or already familiar with previous versions of the product, and who want the best reference for creating and maintaining tabular models.

• Assumes basic familiarity with database design and business analytics concepts.

商品描述(中文翻譯)

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

使用 SQL Server 2016 Analysis Services 中的表格模型創建企業級商業智能(BI)解決方案,並進行數據分析。在兩位 BI 專家的帶領下,您將學習如何通過詳細的示例和最佳實踐來構建、部署和查詢表格模型。這本實踐指南將向您展示如何使用表格模型的內存數據庫進行快速分析,無論您是初次接觸 Analysis Services 還是已經熟悉其多維模型。

 

了解如何:

• 確定何時使用表格模型或多維模型適合您的項目

• 使用 Microsoft Visual Studio 2015 中的 SQL Server Data Tools 構建表格模型

• 將來自多個來源的數據集成為公司信息的一個統一且一致的視圖

• 選擇滿足組織性能和可用性要求的數據建模技術

• 通過建立管理和數據使用者角色來實施安全性

• 定義和實施分區策略以減少處理時間

• 使用 Tabular Model Scripting Language (TMSL) 執行和自動化管理任務

• 優化數據模型以減少 VertiPaq 的內存佔用

• 在表格模型中選擇內存(VertiPaq)和直接查詢(DirectQuery)引擎之間的選擇

• 選擇適當的硬件和虛擬化配置

• 使用 AMO 和 TOM 库從 C# 和 PowerShell 部署和操作表格模型

 

獲取代碼示例,包括完整的應用程序,請訪問:https://aka.ms/tabular/downloads

 

關於本書

• 適用於對 SQL Server 2016 Analysis Services 新手或已熟悉產品之前版本的 BI 專業人士,並希望獲得創建和維護表格模型的最佳參考資料。

• 假設讀者對數據庫設計和商業分析概念有基本的了解。