SQL Server Data Warehouse BI Data Cube

- Basics of presenting large amounts of data in a clear form; Data warehouse - foundation and design - SQL Server Integration Services (SSIS) solutions - Optimize performance in the data warehouse - Managing large amounts of data - Set up control and data flow; 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) - Design and provision of reports - optimal displays (including maps); Report generator - Outlook data mining - overview and concepts - Applications in and with SQL Server, Excel, Visio, PowerPivot, SharePoint; Calculated elements - Performance monitoring with scorecards and KPIs; Web Analytics - Self-Service BI with Power View and PowerPivot