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

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.

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

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)

If you find an error, you can report it to us through our Submit errata page.