By: Daniel Calbimonte | Comments (1) | Related: More > Professional Development Certifications
Problem
I want to take Exam 70-768, however I did cannot find too much material on internet to help me study. Do you have suggestions?
Solution
In this tip we will look at materials you can use for the Developing SQL Data Models exam.
What is the Microsoft 70-768 certification exam?
This exam is about creating and designing Multidimensional and Tabular databases.
Who should take the exam?
This is oriented towards BI developers or administrators in charge of large Business Intelligence databases in Multidimensional and Tabular Databases.
What are the Tabular and Multidimensional Databases?
These are special databases designed for reports. They are called OLAP (Online Analytical Processing) databases. They have a low number of transactions and they are used for reports with aggregations. Tabular is an in-Memory database and use RAM to store the data. Multidimensional databases are older and they are dependent on hard drive storage.
Which SQL Server 2012/2014 exam is similar to this one?
It is similar to exam 70-466. However, several topics were removed like reporting services, XMLA, AMO. In general, this new exam covers more topics than the older one. The data mining topic is back in the new exam.
Is this exam difficult?
Yes. MDX and DAX are topics that are always difficult even for experts. The performance topics are always complex topics that are not fully covered in books.
Which books would you recommend for this exam?
Here are some recommended books:
- Expert Cube Development with SSAS Multidimensional Models
- The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI
- Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model (Developer Reference)
- Tabular Modeling in Microsoft SQL Server Analysis Services (2nd Edition) (Developer Reference)
- DAX Patterns 2015
- Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model (Developer Reference)
- Tabular Modeling in Microsoft SQL Server Analysis Services (2nd Edition) (Developer Reference)
Are there some courses for this exam?
Yes, these are some courses.
- Course 20768B: Developing SQL Data Models
- Business Intelligence courses
- SQL Server Analysis Services (SSAS)
- Course Catalogue SolidQ
- Mastering DAX Video Course
- SSAS Tabular Workshop
- BI & Analytics Online Tutorials
- Implementing Tabular Data Models
- Implementing Data Models and Reports
Can you provide some links to study?
Gladly. Here are have some links:
Design and implement a data warehouse
- Create a multidimensional database by using Microsoft SQL Server Analysis Services (SSAS)
- Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014.
- Review DirectQuery in SSAS 2016, best practices and use cases
- Five Basic Steps for Implementing an Analysis Services Database
- Analysis Services Tutorials (SSAS)
- Partition Storage Modes and Processing
- Design and implement dimensions in a cube
- Introduction to Dimensions (Analysis Services - Multidimensional Data)
- Degenerate Dimensions
- Parent-Child Dimensions
- Data Warehousing: Dimensional Role-Playing
- Dimension Relationships
- Define a Referenced Relationship and Referenced Relationship Properties
- Data Mining Tutorials (Analysis Services)
- Data Mining Introduction
- Define a Many-to-Many Relationship and Many-to-Many Relationship Properties
- Slowly Changing Dimension in SSAS Cube
- Slowly Changing Dimension using SSIS
- Design Tip #152 Slowly Changing Dimension Types 0, 4, 5, 6 and 7
- Dimension Types
- Attribute Relationships
- Implement measures and measure groups in a cube
- Measures and Measure Groups
- Formatting SSAS Measures - SQL School Video
- SQL Server Analysis Services Measure Groups Tips
- SQL Server Analysis Service Levels of Granularity
- Defining Dimension Granularity within a Measure Group
- SSAS Interview Questions on Aggregations, Translations, Perspectives, and Security
- Use Aggregate Functions
- Define Semiadditive Behavior
Design a tabular BI semantic model
- Design and publish a tabular data model
- Tabular Modeling (Adventure Works Tutorial)
- Implementing Tabular Model Solutions
- See what's new in SQL Server Analysis Services 2016 Tabular Models
- Getting started with Tabular Model in SQL Server 2012 - Part 1
- Measures (SSAS Tabular)
- Getting started with the SQL Server 2012 Tabular Model - Part 2
- Relationships (SSAS Tabular)
- Partitions (SSAS Tabular)
- Perspectives (SSAS Tabular)
- Calculations (SSAS Tabular)
- Creating a Date Dimension in a Tabular Model
- Import from Power Pivot (SSAS Tabular)
- Tabular Model Solution Deployment (SSAS Tabular)
- Process Data (SSAS Tabular)
- Tabular query modes: DirectQuery vs. In-Memory
- DirectQuery Mode (SSAS Tabular)
- Configure, manage, and secure a tabular model
- Develop a tabular model to access data in near real time
Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX)
- Create basic MDX queries
- Chapter 1: MDX Training- Introduction to MDX
- MDX: Multidimensional Expressions (Course)
- CREATE SET Statement (MDX)
- Tuples
- TopCount (MDX)
- Implement custom MDX solutions
- Create formulas by using the DAX language
Configure and maintain SQL Server Analysis Services
- Plan and deploy SSAS
- Memory Properties
- SSAS Memory Configurations for Common Architectures
- Improving Analysis Services Performance and Scalability with SQL Server 2016 Service Pack 1
- Requirements and Considerations for Analysis Services Deployment
- Analysis Services and Solid State Disks
- SQL Data Layout Best Practices
- Managing Multiple Instances of Analysis Services
- Monitor and optimize performance
- Use SQL Server Profiler to Monitor Analysis Services
- Managing Server Side Analysis Services Profiler Trace
- Monitor Analysis Services with SQL Server Extended Events
- Identify Storage Engine and Formula Engine bottlenecks with new SSAS XEvents
- Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014.
- SQL Server 2008 R2 Analysis Services Operations Guide
- SSAS - Best Practices and Performance Optimization - Part 1 of 4
- Analysis Services Query Performance Top 10 Best Practices
- Maximum Capacity Specifications (Analysis Services)
- Configure and manage processing
- Create Key Performance Indicators (KPIs) and translations
Next Steps
There are several links that will be useful to you:
About the author
Daniel Calbimonte is a Microsoft SQL Server MVP, Microsoft Certified Trainer and 6-time Microsoft Certified IT Professional. Daniel started his career in 2001 and has worked with SQL Server 6.0 to 2022. Daniel is a DBA as well as specializes in Business Intelligence (SSIS, SSAS, SSRS) technologies.This author pledges the content of this article is based on professional experience and not AI generated.
View all my tips
