6+ Hours of Video Instruction
Prepare for Microsoft Exam 70-768: Developing SQL Data Models and develop practical Business Intelligence (BI) skills with more than 6 hours of video instruction and hands-on demonstrations.
Description
SQL Server Analysis Services (SSAS) provides a robust semantic environment for modeling data in support of analytic and ad hoc reporting needs. With each release of SQL Server, SSAS functionality …
6+ Hours of Video Instruction
Prepare for Microsoft Exam 70-768: Developing SQL Data Models and develop practical Business Intelligence (BI) skills with more than 6 hours of video instruction and hands-on demonstrations.
Description
SQL Server Analysis Services (SSAS) provides a robust semantic environment for modeling data in support of analytic and ad hoc reporting needs. With each release of SQL Server, SSAS functionality is enhanced, with tabular models in particular becoming more capable and fully featured.
In this video, Scot Reagin couples discussion with demonstration to give you not just an understanding of the functional differences between multidimensional and tabular models, but also the context to understand where and why each should be implemented.
In addition to a comprehensive discussion of design and implementation topics, Scot covers techniques for developing queries using multidimensional and data analysis expressions, optimizing processing and query performance, and configuring and maintaining SSAS.
About the Instructor
Scot Reagin has a technology career that spans the entire history of what we now think of as Business Intelligence. Starting with software he developed for mini-computers in the early 1980s to the first Cube technologies of the 1990s and Self-Service BI and contemporary Predictive Analytics, Scot has consistently designed, developed, and delivered solutions for organizations across the evolving BI marketplace.
Scot is a TDWI Certified Business Intelligence Professional and Board Member of the Colorado Data Warehouse Institute. He is also a Certified Data Vault Data Modeler and active member of the Genesee Academy.
Skill Level
Introduction
SQL Server 70-768: Introduction
Lesson 1: Designing a Multidimensional Semantic Model
Learning objectives
1.1 Create a multidimensional database
1.2 Choose a dimensional model
1.3 Define attribute relationships
1.4 Create measures and measure groups
1.5 Define aggregation functions
Lesson 2: Designing a Tabular Semantic Model
Learning objectives
2.1 Create a tabular model
2.2 Deploy and process a tabular model
2.3 Configure tabular model storage and refresh settings
2.4 Configure user and data security
Lesson 3: Developing Queries Using MDX and DAX
Learning objectives
3.1 Understand MDX fundamentals
3.2 Use MDX calculated members and sets
3.3 Use MDX functions
3.4 Use the SCOPE statement
3.5 Create MDX solutions
3.6 Use the EVALUATE and CALCULATE functions
3.7 Create calculated measures
3.8 Perform data analysis with DAX
Lesson 4: Configuring and Maintaining SSAS
Learning objectives
4.1 Plan and deploy SSAS
4.2 Monitor performance
4.3 Identify bottlenecks and improve performance
4.4 Configure limits and model design
4.5 Configure partition processing
4.6 Configure dimension processing
4.7 Create KPIs in cubes
4.8 Create KPIs in tabular models
4.9 Create actions
4.10 Create translations
Summary
SQL Server 70-768: Summary