SQL Server 2008 Business Intelligence Boot Camp
About this Course
This 5 day boot camp course teaches students how to
implement an Integration Services solution, an Analysis Services
solution and a Reporting Services solution in an organization.
The course covers how to develop, deploy, and manage Integration
Services packages. It also discusses how to use the Analysis
Services development tools to create an Analysis Services database
and an OLAP cube, and how to use the Analysis Services management
and administrative tools to manage an Analysis Services
solution.
Furthermore, this course shows how to use the Reporting Services
development tools to create reports, and how to use the Reporting
Services management and administrative tools to manage a Reporting
Services solution.
Course Outline
Part 1
- Module 1: Introduction to Microsoft SQL Server Analysis
Services
- Module 2: Creating Multidimensional Analysis Solutions
- Module 3: Working with Cubes and Dimensions
- Module 4: Working with Measures and Measure Groups
- Module 5: Querying Multidimensional Analysis Solutions
- Module 6: Customizing Cube Functionality
- Module 7: Deploying and Securing an Analysis Services
Database
- Module 8: Maintaining a Multidimensional Solution
- Module 9: Introduction to Data Mining
Part 2
- Module 1: Introduction to SQL Server 2008 Integration
Services
- Module 2: Developing Integration Services Solutions
- Module 3: Implementing Control Flow
- Module 4: Implementing Data Flow
- Module 5: Implementing Logging
- Module 6: Debugging and Error Handling
- Module 7: Implementing Checkpoints and Transactions
- Module 8: Configuring and Deploying Packages
- Module 9: Managing and Securing Packages
Part 3
- Module 1: Introduction to Microsoft SQL Server Reporting
Services
- Module 2: Authoring Basic Reports
- Module 3: Enhancing Basic Reports
- Module 4: Manipulating Data Sets
- Module 5: Using Report Models
- Module 6: Publishing and Executing Reports
- Module 7: Using Subscriptions to Distribute Reports
- Module 8: Administering Reporting Services
- Module 9: Programming Reporting Services