微软MCSA认证考试70-768 Developing SQL Data Models
Course OutlineModule 1: Introduction to Business Intelligence and Data ModelingThis module introduces key BI concepts and the Microsoft BI product suite.Lessons
Introduction to Business Intelligence
The Microsoft business intelligence platform
Lab : Exploring a BI Solution
Exploring a Data Warehouse
Exploring a data model
After completing this module, students will be able to:
Describe BI scenarios, trends, and project roles.
Describe the products that make up the Microsoft BI platform.
Module 2: Creating Multidimensional Databases
This module describes how to create multidimensional databases using SQL Server Analysis Services.Lessons
Introduction to Multidimensional Analysis
Data Sources and Data Source Views
Cubes
Overview of Cube Security
Configure SSAS
Monitoring SSAS
Lab : Creating a multidimensional database
Creating a Data Source
Creating and Configuring a data Source View
Creating and Configuring a Cube
Adding a Dimension to a Cube
After completing this module, you will be able to:
Describe considerations for a multidimensional database.
Create data sources and data source views.
Create a cube
Implement security in a multidimensional database.
Configure SSAS to meet requirements including memory limits, NUMA and disk layout.
Monitor SSAS performance.
Module 3: Working with Cubes and DimensionsThis module describes how to implement dimensions in a cube.Lessons
Configuring Dimensions
Defining Attribute Hierarchies
Implementing Sorting and Grouping Attributes
Slowly Changing Dimensions
Lab : Working with Cubes and Dimensions
Configuring Dimensions
Defining Relationships and Hierarchies
Sorting and Grouping Dimension Attributes
After completing this module, you will be able to:
Configure dimensions.
Define attribute hierarchies.
Implement sorting and grouping for attri
1