Table of Contents
Preface
Section 1: Choosing Your Model
Chapter 1: Analysis Services in SQL Server 2019
What is SQL Server Analysis Services anyway? 18
SQL Server Analysis Services is not SQL Server 18
SQL Server Analysis Services through the years 19
Why use SQL Server Analysis Services? 20
Optimized for reporting and analytics 20
Works great with Excel 22
Organized with end users in mind 22
What's new in SQL Server Analysis Services 2019? 24
Multidimensional models in 2019 24
Tabular models in 2019 24
What are the tools used with SQL Server Analysis Services? 27
SQL Server 2019 Developer edition 27
SQL Server Management Studio (SSMS) 45
Visual Studio with SQL Server Data Tools (SSDT) 47
One last thing – our sample data 51
Get Hands-On SQL Server 2019 Analysis Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
