- Basics of presenting large volumes of data in an understandable format, Data Warehouse - basics and design
- SQL Server Integration Services (SSIS) - Solutions
- Optimise performance in Data Warehouse
- Manage large volumes of data
- Configure control and data flows, logging
- Troubleshooting and debugging
- SQL Server Analysis Services (SSAS)
- Business Intelligence through OLAP (Online Analytical Processing)
- The data cube - Dimensions, perspectives and basic operations
- SQL Server Reporting Services (SSRS)
- Configuring and deploying reports - Optimum visualisation (i.e. Maps), report generator)
- Data mining outlook - Overview and concepts
- Applications in and with SQL Server, Excel, Visio, PowerPivot, SharePoint; calculated elements
- Performance monitoring with scorecards KPIs, web analytics
- Self-service BI with Power View and PowerPivot