Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (Microsoft 70-467 Course)

Course Outline

Module 1

• Course Introduction
• Course Modules
• Introduction to Data Warehousing
• On-Line Transaction Processing (OLTP) vs. OLAP
• Data Warehousing
• Data Warehouse Architecture
• Creating a Data Warehouse
• Presenting On-Line Analytical Processing (OLAP) Data
• OLTP vs. OLAP Demonstration
• Exam Scenarios
• Module Review

Module 2

• Designing a Data Warehouse
• Data Modeling
• Data Warehouse Schemas
• Time Dimensions
• Data Modeling Considerations
• Implementing a Data Model
• Logical Model
• Physical Model
• Working with Dimensions and Fact Tables
• Exam Scenarios
• Module Review

Module 3

• Extraction, Transformation, and Load (ETL) with SSIS
• Introduction to SQL Server Integration Services (SSIS)
• Upgrading SSIS Packages
• SSIS Tools
• Introduction to Data Flow Tasks
• Data Sources
• Transformations
• Destinations
• Control Flow
• Variables
• Expressions
• Precedence
• Containers
• Control Flow Containers
• Transactions
• Package Execution with Checkpoints
• Working with SSIS Packages
• Exam Scenarios
• Module Review

Module 4

• Deploying and Securing Packages
• Deploying Options
• Deploying Packages
• Deploying Projects
• Securing Packages
• Deploying and Securing Packages
• Exam Scenarios
• Module Review

Module 5

• SQL Server Reporting Services (SSRS)
• Introduction to Reporting Services
• SSRS Reports Creation and Delivery
• SSRS Reports
• Grouping
• Expressions
• Drilldown
• Parameters
• Drillthrough
• Visual Components
• Creating Reports within Reporting Services
• Exam Scenarios
• Module Review

Module 6

• SSRS Reports
• Deploying Reports
• Report Security
• Report Execution
• Report Caching
• Report Snapshot
• Subscriptions
• Data Alerts
• Deploying Reports and Report Security
• Exam Scenarios
• Module Review

Module 7

• Multidimensional Cubes
• Introduction to Cubes
• Components of a Multidimensional Cubes
• Measures
• Measure Format and Aggregation Functions
• Measure Groups
• Aggregations
• Dimensions
• Dimension Storage
• Dimensions Hierarchies
• Grouping and Sorting
• Actions
• Perspectives
• Key Performance Indicators
• Translations
• SSAS Security
• Cell Permissions
• Dimension Permissions
• Creating and Configuring a Cube
• Exam Scenarios
• Module Review

Module 8

• Tabular Data Models
• Introduction to Tabular Data Models
• PowerPivot
• Working with PowerPivot
• Linked and Non-Linked Tables
• PowerPivot Features
• Server Based Tabular Data Models
• Creating a Tabular Data Model
• Tabular Models with SSDT
• Workspace Database
• Tabular Data Model
• Tabular Data Model Security
• Creating a Tabular Data Model Using PowerPivot
• Exam Scenarios
• Module Review

Module 9

• MDX/DAX
• Introduction to Multidimensional Expressions (MDX)
• Why Use MDX?
• MDX Syntax
• Sets
• Where is MDX Used?
• Introduction to Data Analysis eXpressions (DAX)
• Working with DAX
• DAX Functions
• DAX Queries
• Calculated Columns
• DAX Measures
• Multiple Relationships
• Exam Scenarios
• Module Review

Module 10

• Data Mining
• Introduction to Data Mining
• Data Mining Algorithms
• Data Mining Components
• Validating and Presenting Data Mining Models
• Creating a Data Mining Model
• Exam Scenarios
• Module Review
• Course Review