Purpose: Data Analysis and Online Analytical Processing (OLAP) SSAS is a tool used for analyzing large volumes of data. It supports both multidimensional and tabular models, enabling complex data analysis and the creation of OLAP cubes for fast querying and reporting.

Purpose: Reporting and Data Visualization SSRS is a server-based reporting platform that allows you to create, manage, and deliver a wide variety of interactive and paginated reports. It supports a range of data sources and enables users to design reports that can be rendered in various formats. MSBI provides a comprehensive and integrated solution for managing, analyzing, and reporting on data, making it a powerful tool for organizations looking to leverage their data for business intelligence.

1. SSIS Framework/Architecture
2. SSIS Package Architecture Overview
3. Development and Management Tools
4. The Import and Export Wizard

1. Data Flow Overview
2. Data Sources
3. Data Destinations
4. Data Flow Transformations
5. Data Viewers

1. Excel Source
2. Flat File Source
3. OLE DB Source
4. XML Source

1. Aggregate Transformation
2. Audit Transformation
3. Character Map Transformation
4. Conditional Split Transformation
5. Copy Column Transformation
6. Derived Column Transformation
7. Data Conversion Transformation
8. Multicast Transformation
9. OLE DB Command Transformation
10. Percentage Sampling Transformation
11. Row Count Transformation
12. Sort Transformation
13. Union All Transformation

1. Lookup Transformation
2. Merge Transformation
3. Merge Join Transformation
4. Slowly Changing Dimension Transformation
5. Pivot Transformation
6. Export Transformation
7. Import Transformation
8. Unpivot Transformation

1. Data Reader Destination
2. Excel Destination
3. Flat File Destination
4. OLE DB Destination

1. Control Flow Overview
2. Precedence Constraints
3. The Execute SQL Task
4. The Bulk Insert Task
5. The File System Task
6. The FTP Task
7. The Send Mail Task
8. Bulk Insert Task
9. Data Flow Task
10. Execute DTS 2000 Package Task
11. Execute Package Task
12. Execute Process Task
13. Web Service Task
14. XML Task

1. For Loop Container
2. For Each Loop Container
3. Sequence Container

1. Variables Overview
2. Variable scope
3. SSIS system variables
4. Using variables in control flow
5. Using variables in data flow
6. Using variables to pass information between packages
7. Property expressions
8. Configuration Overview
9. Configuration options
10. Configuration discipline

1. SSIS debugging overview
2. Configuring Package Logging
3. Breakpoints in SSIS
4. Event handler in SSIS
5. Configure Error output in Data Flow
6. Data Viewers
7. Configure Check Points
8. Transactions in SSIS
9. SSIS Security

1. Introduction to SSIS scripting
2. The SSIS script editor
3. The SSIS object model
4. Script in Control flow: The Script Task
5. Script in Data flow: The Script Component
6. Introduction to SSIS component development

1. Create Configuration Files
2. Implement Logging
3. Different Deployment Options
4. Executing packages using utilities – DTExec and DTExecUI
5. Schedule SSIS Packages with SQL Server Agent Jobs
6. Monitoring Jobs in SQL Server
7. Call SSIS Packages in Stored Procedures
8. Call SSIS Packages in command prompt