SSIS & SSAS Fundamentals
- SSIS – Objectives: Plan data transfer and staging solutions for an ETL operation
- Plan an SSIS Solution
- Design and implement data flows
- Incorporate logging, error handling, and reliability into a package
- Optimize an SSIS solution
- Deploy and operate an SSIS solution
- SSAS – Objectives: Implement Analytical Solutions using SQL Server Analysis Services
- Create multidimensional analysis solutions with SQL Server Analysis Services
- Implement dimensions in an Analysis Services Solution
- Implement measure and measure group in an Analysis Services Solution
- Query a multidimensional Analysis Service Solution
- Customize an Analysis Service cube