Tabular Modeling with SQL Server 2016 Analysis Services Cookbook

Derek Wilson

  • 出版商: Packt Publishing
  • 出版日期: 2017-01-27
  • 定價: $1,980
  • 售價: 6.0$1,188
  • 語言: 英文
  • 頁數: 372
  • 裝訂: Paperback
  • ISBN: 1786468611
  • ISBN-13: 9781786468611
  • 相關分類: Data ScienceMSSQLSQL
  • 立即出貨 (庫存=1)

相關主題

商品描述

About This Book

  • Build and deploy Tabular Model projects from relational data sources
  • Leverage DAX and create high-performing calculated fields and measures
  • Create ad-hoc reports based on a Tabular Model solution
  • Useful tips to monitor and optimize your tabular solutions

Who This Book Is For

This book is for SQL BI professionals and Architects who want to exploit the full power of the new Tabular models in Analysis Services. Some knowledge of previous versions of Analysis services would be helpful but is not essential.

What You Will Learn

  • Learn all about Tabular services mode and how it speeds up development
  • Build solutions using sample datasets
  • Explore built-in actions and transitions in SSAS 2016
  • Implement row-column, and role-based security in a Tabular Data model
  • Realize the benefits of in-memory and DirectQuery deployment modes
  • Get up to date with the new features added to SQL Server 2016 Analysis Services
  • Optimize Data Models and Relationships Usage

In Detail

SQL Server Analysis Service (SSAS) has been widely used across multiple businesses to build smart online analytical reporting solutions. It includes two different types of modeling for analysis services: Tabular and Multi Dimensional. This book covers Tabular modeling, which uses tables and relationships with a fast in-memory engine to provide state of the art compression algorithms and query performance.

The book begins by quickly taking you through the concepts required to model tabular data and set up the necessary tools and services. As you learn to create tabular models using tools such as Excel and Power View, you’ll be shown various strategies to deploy your model on the server and choose a query mode (In-memory or DirectQuery) that best suits your reporting needs.

You’ll also learn how to implement key and newly introduced DAX functions to create calculated columns and measures for your model data. Last but not least, you’ll be shown techniques that will help you administer and secure your BI implementation along with some widely used tips and tricks to optimize your reporting solution.

By the end of this book, you’ll have gained hands-on experience with the powerful new features that have been added to Tabular models in SSAS 2016 and you’ll be able to improve user satisfaction with faster reports and analytical queries.

Style and approach

This book takes a practical, recipe-based approach where each recipe lists the steps to address or implement a solution. You will be provided with several approaches to creating a business intelligence semantic model using analysis services.

商品描述(中文翻譯)

關於本書


  • 從關聯資料來源建立和部署表格模型專案

  • 利用 DAX 創建高效的計算欄位和度量值

  • 基於表格模型解決方案創建臨時報表

  • 有用的提示來監控和優化您的表格解決方案

本書適合對象

本書適合 SQL BI 專業人士和架構師,他們希望充分利用分析服務中新的表格模型的強大功能。對以前版本的分析服務有一定了解會有所幫助,但不是必需的。

您將學到什麼


  • 了解表格服務模式以及它如何加快開發速度

  • 使用示例數據集構建解決方案

  • 探索 SSAS 2016 中內置的操作和轉換

  • 在表格數據模型中實施行列和基於角色的安全性

  • 體驗內存和直接查詢部署模式的好處

  • 了解 SQL Server 2016 分析服務中新增的功能

  • 優化數據模型和關係使用

詳細內容

SQL Server Analysis Service (SSAS) 在多個企業中被廣泛使用,用於構建智能的在線分析報表解決方案。它包括兩種不同的分析服務建模類型:表格模型和多維模型。本書涵蓋了表格建模,它使用表格和關係以及快速的內存引擎,提供先進的壓縮算法和查詢性能。

本書首先快速介紹了建模表格數據所需的概念,並設置了必要的工具和服務。當您學習使用 Excel 和 Power View 等工具創建表格模型時,將展示各種部署模式(內存或直接查詢)以滿足您的報表需求。

您還將學習如何實施關鍵和新引入的 DAX 函數,為模型數據創建計算列和度量值。最後,您將學習一些技巧,幫助您管理和保護您的商業智能實施,以及一些廣泛使用的優化報表解決方案的技巧。

通過閱讀本書,您將獲得對 SSAS 2016 中新增的強大功能的實踐經驗,並能夠通過更快的報表和分析查詢提高用戶滿意度。

風格和方法

本書採用實用的食譜式方法,每個食譜列出了解決方案的步驟。您將獲得多種創建商業智能語義模型的方法,使用分析服務。