My Account
Log in Registration
All
Cart
Highlights
Fiction Books
Non-Fiction Books
Children's Books
Rare Books
Music
DVD & Blu-Ray
Video Games
Category
Wishlists
Cart
All
Free Shipping in Australia
Trustpilot
Proud to be B-Corp

Exam Ref 70-768 Developing SQL Data Models Stacia Varga

Exam Ref 70-768 Developing SQL Data Models By Stacia Varga

Exam Ref 70-768 Developing SQL Data Models by Stacia Varga

Reviews:
$22.99
Condition - Very Good
Only 2 left
Very Good$22.99New$70.09
SeriesExam Ref

Exam Ref 70-768 Developing SQL Data Models Summary

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

About Stacia Varga

Stacia Varga, Microsoft Data Platform MVP since 2011, has been helping organizations and individuals succeed with SQL Server Analysis Services since it launched in SQL Server 2000. She has authored or coauthored multiple books about BI (as Stacia Misner), and co-authored Introducing Microsoft SQL Server 2016. Varga trains and consults through her company, Data Inspirations; speaks frequently at SQL Server events; and leads SQL Server Society of Las Vegas.

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

Additional information

GOR008835288
9781509305155
1509305157
Exam Ref 70-768 Developing SQL Data Models by Stacia Varga
Stacia Varga
Exam Ref
Used - Very Good
Paperback
Microsoft Press,U.S.
20170627
384
N/A
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in very good condition, but if you are not entirely satisfied please get in touch with us

Customer Reviews - Exam Ref 70-768 Developing SQL Data Models