SQL Server Datawarehouse BI cube données

- 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