Hughes, Steven
Hands-On SQL Server 2019 Analysis Services: Design and query tabular and multi-dimensional models using Microsoft's SQL Server Analysis Services
- ISBN 13:
- 9781800204768
- author:
- Hughes, Steven
- format:
- Paperback / softback
- publisher:
- Packt Publishing Limited
- language:
- English
- Publication Year:
- 2020
- Pages:
- 474
- Dimensions:
- 23.5 x 19.1 x 2.4 centimeters (0
- Genre:
- Computers, Computer Science, Data Modeling,
- Condition:
- New
- Availability:
- Item usually sent within 5 working days
Description
Mastering Microsoft SQL Server 2019 Analysis Services is essential for creating data analytics solutions that support business decision-making. This comprehensive guide covers the new features and improvements in SSAS, helping you understand how to design, develop, and optimize end-to-end data analytics solutions.
You'll learn how to create multi-dimensional models with SSAS, expand on those models using MDX, and deploy tabular models using Microsoft Visual Studio and Management Studio. The book also provides tips and tricks for building measures, optimizing your design, and interacting with models using Excel and Power BI.
By the end of this book, you'll be able to choose the right model and build and deploy it to support the analytical needs of your business. You'll discover practices and tools for securing and maintaining your models once they are deployed, ensuring that your data analytics solutions remain effective and efficient.