- Integrate: Define, debug, deploy, manage and secure SQL Server Integration Services (SSIS) packages that extract, transform, and load data from an OLTP database into an SSAS cube and a relational data warehouse; -Analyze: Define, deploy, process, manage and secure SQL Server Analysis Services (SSAS) cubes, mining models, dimensions, hierarchies, calculations, translations, and Key Performance Indicators (KPIs); -Report: Define, deploy, manage, and secure SQL Server Reporting Services (SSRS) reports that consume data stored in SSAS cubes and in the relational data warehouse and deliver reports to business users.