Hands-On SQL Server 2019 Analysis Services
This book will expand your ability to deliver meaningful, performant solutions to your organization. You’ll learn how to use an analytical engine for decision making and business analytics. With the help of this practical guide, you’ll also be able to work confidently with data and analytics.
Offered by
Difficulty Level
Intermediate
Completion Time
15h48m
Language
English
About Book
Who Is This Book 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.
Hands-On SQL Server 2019 Analysis Services
- About Book
- Who Is This Book For?
- Book Content
Book content
chapters • 15h48m total length
Analysis Services in SQL Server 2019
Choosing the SQL Server 2019 Analytic Model for Your BI Needs
Preparing Your Data for Multidimensional Models
Building a Multidimensional Cube in SSAS 2019
Adding Measures and Calculations with MDX
Preparing Your Data for Tabular Models
Building a Tabular Model in SSAS 2019
Adding Measures and Calculations with DAX
Exploring and Visualizing Your Data with Excel
Creating Interactive Reports and Enhancing Your Models in Power BI
Securing Your SSAS Models
Common Administration and Maintenance Tasks
Related Resources
Access Ready-to-Use Books for Free!
Get instant access to a library of pre-built books—free trial, no credit card required. Start training your team in minutes!