Descrizione del corso
This training course teaches database and business intelligence (BI) professionals how to plan and design a BI solution that is based on Microsoft SQL Server 2014 and other Microsoft BI technologies.
Programma
- Planning a BI Solution
- Elements of a BI Solution
- The Microsoft BI Platform
- Planning a BI Project
- Planning SQL Server Business Intelligence Infrastructure
- Considerations for BI Infrastructure
- Planning Data Warehouse Hardware
- Designing a Data Warehouse
- Data Warehouse Design Overview
- Designing Dimension Tables
- Designing Fact Tables
- Designing a Data Warehouse Physical Implementation
- Designing an ETL Solution
- ETL Overview
- Planning Data Extraction
- Planning Data Transformation
- Planning Data Loads
- Designing Analytical Data Models
- Introduction to Analytical Data Models
- Designing an Analytical Data Model
- Designing Dimensions
- Enhancing Data Models
- Planning a BI Delivery Solution
- Considerations for Delivering BI
- Common Reporting Scenarios
- Choosing a Reporting Tool
- Designing a Reporting Services Solution
- Planning a Reporting Services Solution
- Designing Reports
- Planning Report Consistency
- Designing a Microsoft Excel-Based Reporting Solution
- Using Excel for Data Analysis and Reporting
- PowerPivot for Excel
- Power View for Excel
- 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
- 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
- Operating a BI Solution
- Overview of BI Operations
- ETL Operations
- Data Warehouse Operations
- Analysis Services Operations
- Reporting Services Operations
