Home > Store

Exam Ref 70-768 Developing SQL Data Models

Register your product to gain access to bonus material or receive a coupon.

Exam Ref 70-768 Developing SQL Data Models

Best Value Purchase

Book + eBook Bundle

  • Your Price: $43.19
  • List Price: $71.98
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

More Purchase Options

Book

  • Your Price: $31.99
  • List Price: $39.99
  • Usually ships in 24 hours.

eBook (Watermarked)

  • Your Price: $25.59
  • List Price: $31.99
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

About

Features

  • Authoritative and complete MCSA Exam 70-768 preparation content, straight from Microsoft
  • Covers key skills associated with creating solutions based on SSAS 2016 multidimensional and tabular models, and implementing and maintaining OLAP cubes
  • Organized by exam objectives for efficient study
  • Strategic, what-if scenarios challenge exam candidates, helping them master the big-picture thinking the exam demands
  • Contains up-to-date exam preparation tips from a highly-respected Microsoft MVP

Description

  • Copyright 2017
  • Dimensions: 7-3/8 X 9
  • Pages: 400
  • Edition: 1st
  • Book
  • ISBN-10: 1-5093-0515-7
  • ISBN-13: 978-1-5093-0515-5

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 objectives:

• 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 Ref:

• 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

Downloads

Downloads

Follow the instructions to download this book's sample files.

  1. Click the Download button below to start the download.
  2. If prompted, click Save.
  3. Locate the .zip file on your computer. Right-click the file, click Extract All, and then follow the instructions.
Download

 
Also available for download is the URL list from each chapter. Click the Download button below to start the download.

Download

Sample Content

Table of Contents

1: Design a Multidimensional Business Intelligence (BI) Semantic Model
Skill 1.1. Create a Multidimensional Database by Using Microsoft SQL Server Analysis Services (SSAS)
Skill 1.2. Design and Implement Dimensions in a Cube
Skill 1.3. Implement Measures and Measure Groups in a Cube

2: Design a Tabular BI Semantic Model
Skill 2.1. Design and Publish a Tabular Data Model
Skill 2.2. Configure, Manage, and Secure a Tabular Model

Skill 2.3. Develop a tabular model to access data in near real time

3: Develop Queries Using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX)
Skill 3.1. Create Basic MDX Queries
Skill 3.2. Implement Custom MDX Solutions

Skill 3.3. Create formulas by using the DAX language

4: Configure and Maintain SQL Server Analysis Services (SSAS)
Skill 4.1. Plan and Deploy SSAS
Skill 4.2. Monitor and Optimize Performance
Skill 4.3. Configure and Manage Processing
Skill 4.4. Create Key Performance Indicators (KPIs) and Translations

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership