Exam Ref 70-768 Developing SQL Data Models

by Stacia Varga

Prepare for Microsoft Exam 70-768–and help demonstrate your real-world mastery of Business Intelligence (BI) solutions development with SQL Server 2016 Analysis Services (SSAS), including modeling and queries. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level.

Focus on the expertise measured by these

• Design a multidimensional BI semantic model

• Design a tabular BI semantic model

• Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX)

• Configure and maintain SSAS

This Microsoft Exam

• Organizes its coverage by exam objectives

• Features strategic, what-if scenarios to challenge you

• Assumes you are a database or BI professional with experience creating models, writing MDX or DAX queries, and using SSAS

377 pages, Kindle Edition

Published May 5, 2017

Reviews

[numbworks · Rating 5 out of 5]

Very clearly written and very comprehensive. It contains knowledge that I didn't read in any other book about the topic, such as performance optimization for both multidimensional and tabular models. It may be worth to read some parts again in the future - for ex. multidimensional mode.