SQL Server 2008 - Business Intelligence (70-448)
Training Course Curriculum:
Course Overview
Implementing Business Solutions
BI Concepts
Designing an OLAP System
Designing an Architecture
Module Review
Creating SSIS Packages
Creating Packages
Using Control Flow
Implementing Constraints
Module Review
Data Flows
Sources and Destination
Transformations
Transactions
Debugging
Module Review
Package Management
Event Handlers and Logging
Working with Code
Module Review
Deploying SSIS Packages
Deploying Packages
Securing Packages
Executing Packages
Module Review
Implementing Cubes
Data Sources and Data Source Views
Creating Cubes
Configuring Dimensions
Setting Up a Cube
Module Review
Configuring Cubes and Measures
Configuring Measures
MDX
Adding Functionality
Module Review
SSA Solutions
Configuring Security
Configuring Storage
Processing Cubes
Deploying Cubes
Module Review
Data Mining
Data Mining Basics
Building a Data Mining Model
Module Review
Creating Reports
Creating Basic Reports
Interactive Reports
Coding Reports
Module Review
Managing a Report Server
Configuring Reporting Services
Deploying Reports
Controlling Report Execution
Using Subscriptions
Securing Reporting Services
Module Review
Implementing the Report Builder
Report Models
Report Builder
Module Review
Course Review
Exam Preparation