Conception d'une solution de BI avec SQL Server 2012 - MS20467

Objectifs

Design a data warehouse. - Design a Reporting Services solution. - Design an ETL solution. - Design an Excel reporting solution. - Monitor and optimize a BI solution. - Plan a BI delivery solution. - Plan a BI infrastructure. - Plan a SharePoint Serve

Programme

Cours en Français, support en anglais

Module 1 : Planning a BI Solution
– Elements of a BI Solution
– Planning a BI Project
– The Microsoft BI Platform

Module 2 : Planning a BI Infrastructure
– Planning a Data Warehouse Infrastructure
– Planning an ETL Infrastructure
– Planning Analysis Services Infrastructure
– Planning Reporting Services Infrastructure

Module 3 : Designing a Data Warehouse
– Designing a Logical Schema
– Designing a Physical Schema

Module 4 : Designing an ETL Solution
– Planning for Data Extraction
– Planning for Data Transformation
– Planning for Data Loading
– Planning for SSIS Package Deployment

Module 5 : Designing Analytical Data Models
– Options for Analytical Models
– Data Model Design Considerations

Module 6 : Planning a BI Delivery Solution
– Considerations for BI Delivery
– Choosing a Delivery Approach

Module 7 : Designing a Reporting Services Solution
– Designing Reports
– Considerations for Report Execution
– Planning a Reporting Solution

Module 8 : Designing an Excel-Based Reporting Solution
– Using Excel for Data Reporting and Analysis
– PowerPivot in Excel
– Power View in Excel

Module 9 : Planning a SharePoint Server BI Solution
– Introduction to SharePoint Server as a BI Platform
– Planning Security for a SharePoint Server BI Solution
– Planning Reporting Services Configuration
– Planning PowerPivot Configuration
– Planning for PerformancePoint Services

Module 10 : Monitoring and Optimizing a BI Solution
– Overview of BI Monitoring
– Monitoring and Optimizing the Data Warehouse
– Monitoring and Optimizing Analysis Services
– Monitoring and Optimizing Reporting Services

Module 11 : Planning BI Operations
– Overview of BI Operations
– Automating ETL Tasks
– Post ETL Tasks
– Planning a Backup Strategy for a BI Solution

Recherches

Tout le site Le catalogue

Liens directs