Hands-On SQL Server 2019 Analysis Services

Get up to speed with the new features added to Microsoft SQL Server 2019 Analysis Services and create models to support your business

▶What You Will Learn
⦁Determine the best analytical model using SSAS
⦁Cover the core aspects involved in MDX, including writing your first query
⦁Implement calculated tables and calculation groups (new in version 2019) in DAX
⦁Create and deploy tabular and multi-dimensional models on SQL 2019
⦁Connect and create data visualizations using Excel and Power BI
⦁Implement row-level and other data security methods with tabular and multi-dimensional models
⦁Explore essential concepts and techniques to scale, manage, and optimize your SSAS solutions

▶Key Features
⦁Explore tips and tricks to design, develop, and optimize end-to-end data analytics solutions using Microsoft's technologies
⦁Learn tabular modeling and multi-dimensional cube design development using real-world examples
⦁Implement Analysis Services to help you make productive business decisions

▶Who This Book Is For
This Microsoft SQL Server book is for BI professionals and data analysts who are looking for a practical guide to creating and maintaining tabular and multi-dimensional models using SQL Server 2019 Analysis Services. A basic working knowledge of BI solutions such as Power BI and database querying is required.

▶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.