Book Details
Create a semantic model and analyse 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.
Read more 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
- Authors Marco Russo, Alberto Ferrari Puerta
- ISBN13 9781509302772
- ISBN10 1509302778
- Pages 512
- Published 2026
- Fecha de publicación 13/05/2026
- Language German, French
Reviews and ratings
Tabular Modeling in Microsoft SQL Server Analysis Services (German, French)
- By
- Marco Russo, Alberto Ferrari Puerta
- |
- Microsoft Press (2026)
- 9781509302772



