Tabular Modeling in Microsoft SQL Server Analysis Services, 2nd edition

Published by Microsoft Press (April 12, 2017) © 2017

  • Marco Russo
  • Alberto Ferrari

VitalSource eTextbook

ISBN-13: 9781509302901
Tabular Modeling in Microsoft SQL Server Analysis Services
Published 2017

Details

  • A print copy
  • Free shipping

Features

  • Tabular data modelling fundamentals

Create corporate-level business intelligence (BI) solutions

Create a semantic model and analyse data using the tabular model in SQL Server 2016 Analysis Services. 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 organisation'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
  • Optimise 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 virtualisation configurations
  • Deploy and manipulate tabular models from C# and PowerShell using AMO and TOM libraries

  • CHAPTER 1 Introducing the tabular model
  • CHAPTER 2 Getting started with the tabular model
  • CHAPTER 3 Loading data inside Tabular
  • CHAPTER 4 Introducing calculations in DAX
  • CHAPTER 5 Building hierarchies
  • CHAPTER 6 Data modeling in Tabular
  • CHAPTER 7 Tabular Model Scripting Language (TMSL)
  • CHAPTER 8 The tabular presentation layer
  • CHAPTER 9 Using DirectQuery
  • CHAPTER 10 Security
  • CHAPTER 11 Processing and partitioning tabular models
  • CHAPTER 12 Inside VertiPaq
  • CHAPTER 13 Interfacing with Tabular
  • CHAPTER 14 Monitoring and tuning a Tabular service
  • CHAPTER 15 Optimizing tabular models
  • CHAPTER 16 Choosing hardware and virtualization

Need help? Get in touch