What this book covers?
Chapter 1, Analysis Services in SQL Server 2019, introduces Analysis Services and the steps to install the tools used in the rest of the book.
Chapter 2, Choosing the SQL Server 2019 Analytic Model for Your BI Needs, presents multidimensional and tabular models of Analysis Services and provides reasons to choose between them.
Chapter 3, Preparing Your Data for Multidimensional Models, outlines how to organize data into star schemas to support multidimensional models.
Chapter 4, Building a Multidimensional Cube in SSAS 2019, covers the necessary steps to build the multidimensional model, complete with facts, dimensions, and partitions.
Chapter 5, Adding Measures and Calculations with MDX, illustrates how to expand a multidimensional model with measures and calculations created with MDX and how to query a multidimensional model with MDX.
Chapter 6, Preparing Your Data for Tabular Models, covers the steps required to build a Power Pivot model in Excel and prep data for work with tabular models.
Chapter 7, Building a Tabular Model in SSAS 2019, shows how to build tabular models using standard refresh, Direct Query, and Power Query, and how to import a Power Pivot model to create a tabular model.
Chapter 8, Adding Measures and Calculations with DAX, elucidates the steps to query a model with DAX and expand the model using DAX to create measures, columns, and calculated tables.
Chapter 9, Exploring and Visualizing Your Data with Excel, highlights the use of Excel to visualize the data from the models after the models have been created.
Chapter 10, Creating Interactive Reports and Enhancing Your Models in Power BI, focuses on the use of Power BI to create modern reports using both multidimensional and tabular models.
Chapter 11, Securing Your SSAS Models, engages in imparting knowledge and implementing various patterns to secure multidimensional and tabular models.
Chapter 12, Common Administration and Maintenance Tasks, provides steps to manage models by helping in understanding the backup and restore operations, scaling options, and performance techniques.