Stacia Varga

Exam Ref 70-768 Developing SQL Data Models

• Broschiertes Buch

Produktbeschreibung

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.

Produktdetails

• Exam Ref
• Verlag: Microsoft Press, U.S.
• Seitenzahl: 384
• Erscheinungstermin: 4. Juli 2017
• Englisch
• Abmessung: 228mm x 187mm x 25mm
• Gewicht: 630g
• ISBN-13: 9781509305155
• ISBN-10: 1509305157
• Artikelnr.: 47085239

Autorenporträt

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.

Inhaltsangabe

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