MCSA SQL 2016 BI Development Exam Ref 2-pack: Exam Refs 70-767 and 70-768

by Jose Chinchilla, Stacia Varga

Overview

Direct from Microsoft, these Exam Refs are the official study guides for the new Microsoft 70-767 Implementing a SQL Data Warehouse and the new Microsoft 70-768 Developing SQL Data Models certification exams.

 

Exam Ref 70-767 Implementing a SQL Data Warehouse, the first book in this bundle (ISBN 978150936473), offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. It focuses on the specific areas of expertise modern IT professionals need to successfully build modern data warehouses to support advanced business intelligence solutions.

 

Written by Microsoft Data Platform MVP Stacia Varga, Exam Ref 70-768 Developing SQL Data Models, the second book in this bundle (ISBN 9781509305155), offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. It focuses on the specific areas of expertise modern database and business intelligence professionals need to succeed with SQL Server 2016 Analysis Services.

Product Details

ISBN-13:	9780134848860
Publisher:	Pearson Education
Publication date:	12/01/2017
Series:	Exam Ref
Sold by:	Barnes & Noble
Format:	eBook
Pages:	688
File size:	54 MB
Note:	This product may take a few minutes to download.

Table of Contents

Exam Ref 70-767 Implementing a SQL Data Warehouse

1. Design and Implement a Data Warehouse
2. Extract, Transform, and Load Data
3. Integrate Solutions with Cloud Data and Big Data
4. Build Data Quality Solutions

Exam Ref 70-768 Developing SQL Data Models

1: Design a Multidimensional Business Intelligence (BI) Semantic Model
2: Design a Tabular BI Semantic Model
3: Develop Queries Using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX)
4: Configure and Maintain SQL Server Analysis Services (SSAS)