Tabular modeling in Microsoft SQL server analysis services /
Marco Russo and Alberto Ferrari
- Second Edition.
- Redmond, Washington : Microsoft Press, c2017
- xxii, 488 pages : illustrations ; 23 cm.
Includes index.
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 Direct Query -- 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.
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 models in-memory database to perform rapid analytics--whether you are new to Analysis Services or already familiar with its multidimensional model.