Book

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook

This cookbook comes with over 70 practical recipes to help you analyze multi-dimensional data in SQL Server 2016 Analysis Services cubes and enable you to meet various real-world business requirements using MDX queries and calculations. With the help of examples, you’ll explore best practices and learn how to implement solutions to common problems.

Offered byPackt Logo

Difficulty Level

Intermediate

Completion Time

19h32m

Language

English

About Book

Who Is This Book For?

This book is for anyone who has been involved in working with multidimensional data. If you are a multidimensional cube developer, a multidimensional database administrator, or a report developer who writes MDX queries to access multidimensional cube, this book will help you. If you are a power cube user or an experienced business analyst, you will also find this book invaluable in your data analysis. This book is for you are interested in doing more data analysis so that the management can make timely and accurate business decisions.

Book content

chapters 19h32m total length

Elementary MDX Techniques

Working with Sets

Working with Time

Concise Reporting

Navigation

MDX for Reporting

Business Analyses

When MDX is Not Enough

Metadata-driven Calculations

On the Edge

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!

No credit card required