20768 : Developing SQL Data Models

The primary audience for this course are database professionals who need to fulfil BI Developer role to create enterprise BI solutions. 
Primary responsibilities will  include:

• Implementing multidimensional databases by using SQL Server Analysis Services
• Creating tabular semantic data models for analysis by using SQL Server Analysis Services

Before attending this course, students must have:

• Experience of querying data using Transact-SQL

After completing this course, students will be able to:

• Describe the components, architecture, and nature of a BI solution

• Create a multidimensional database with Analysis Services

• Implement dimensions in a cube

• Implement measures and measure groups in a cube

• Use MDX syntax

• Customize a cube

• Implement a tabular database

• Use DAX to query a tabular model

• Use data mining for predictive analysis

Module 1: Introduction to Business Intelligence and Data Modeling

Module 2: Creating Multidimensional Databases

Module 3: Working with Cubes and Dimensions

Module 4: Working with Measures and Measure Groups

Module 5: Introduction to MDX

Module 6: Customizing Cube Functionality

Module 7: Implementing a Tabular Data Model by Using Analysis Services

Module 8: Introduction to Data Analysis Expression (DAX)

Module 9: Performing Predictive Analysis with Data Mining

Vui lòng bấm "Course Outline" để xem thêm nội dung chi tiết.