1. What is Microsoft BI?
2. Using SSAS in BIDS
3. Intermediate SSAS
4. Cube Storage and Aggregation
5. MDX
6. New MDX Functions
1. Introduction to SQL Server Intigration services
2. SSIS for DBAs: Using SQL server Management Studio
3. Business Intelligence Development Studio (BIDS)
4. Introduction to control Flow
5. Advanced Control Flow
6. Introduction to Data Flow
7. Variable and Configurations
8. Debugging Error Handling And Logging
9. Advanced Data Flow
10. Extending SSIS through Custom Code
11. SSIS Package Deployment
12. SSIS Package Management
Reporting Services:
1. Introduction to SQL Server Reporting Services.
2. Creating Reports
3. Calculations and Formatting
4. Grouping and Sorting
5. Report Parameters
6. Creating Matrix Reports and Charts
7. Managing Reporting Services
8. Snapshots and Subscriptions
9. Ad-Hoc Reporting with Report Builder