Overview

Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-768 Developing SQL Data Models certification exam, the second of two exams required for MCSA: SQL 2016 Business Intelligence Development certification.   Authored by Microsoft Data Platform MVP Stacia Varga, Exam Ref 70-768 Developing SQL Data Models 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.

Full Product Details

Author:   Stacia Varga
Publisher:   Microsoft Press,U.S.
Imprint:   Microsoft Press
Dimensions:   Width: 18.80cm , Height: 1.80cm , Length: 22.60cm
Weight:   0.620kg
ISBN:  

9781509305155

ISBN 10:   1509305157
Pages:   384
Publication Date:   04 July 2017
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Active
Availability:   In Print  
This item will be ordered in for you from one of our suppliers. Upon receipt, we will promptly dispatch it out to you. For in store availability, please contact us.

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 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 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 Configure Parallel, Sequential, and Writeback Processing Settings Skill 4.4. Create Key Performance Indicators (KPIs) and Translations

Reviews

Author Information

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.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions