MDX with Microsoft SQL Server 2016 Analysis Services Cookbook

$51.99

Taxes may apply at checkout.

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook

Over 70 practical recipes to analyze multi-dimensional data in SQL Server 2016 Analysis Services cubes

Databases Data warehousing Computer science

Authors: Tomislav Piasevoli, Sherry Li

Dinosaur mascot

Language: English

Published by: Packt Publishing

Published on: 30th November 2016

Format: LCP-protected ePub

Size: 33 Mb

ISBN: 9781786467881


Key Features

Updated for SQL Server 2016, this book helps you take advantage of the new MDX commands and the new features introduced in SSAS

Perform time-related, context-aware, and business related-calculations with ease to enrich your Business Intelligence solutions

Collection of techniques to write flexible and high performing MDX queries in SSAS with carefully structured examples

Book Description

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 if you are interested in doing more data analysis so that the management can make timely and accurate business decisions.

What you will learn

Grasp the fundamental MDX concepts, features, and techniques

Work with sets

Work with Time dimension and create time-aware calculations

Make analytical reports compact, concise, and efficient

Navigate cubes

Master MDX for reporting with Reporting Services (new)

Perform business analytics

Design efficient cubes and efficient MDX queries

Create metadata-driven calculations (new)

Capture MDX queries and many other techniques

Show moreShow less