微软数据库考试70-768: Exam Ref 70-768 Developing SQL Data Models

微软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