1999 zł
KLUCZOWE ZAGADNIENIA
- tworzenie rozwiązań ETL
- budowanie modeli analitycznych
– model wielowymiarowy
– model tabelaryczny
- raportowanie przy użyciu Reporting Services
- Self-Service BI z wykorzystaniem Excela
– Power Piviot
– Power View
- integracja Reporting Services z SharePointem
- tworzenie poratu BI i interaktywnych Dashboardów w SharePoint przy wykorzystaniu „SharePoint Performance Points Services”
Przemysław Rosłon, Microsoft Certified Trainer
CERTYFIKACJE ZAWODOWE
Certyfikacja podstawowa |
CertyfIkacja specjalistyczna |
Certyfikacja ekspercka |
FUNDAMENTALS |
ASSOCIATE |
EXPERT |
Tematyka szkolenia pokrywa zagadnienia wymagane na ścieżce MCSE: Data Management and Analytics
Dowiedz się więcej o certyfikacjach Microsoft
POZIOM SZKOLENIA
podstawowy |
średniozaawansowany |
zaawansowany |
ekspercki |
100 |
200 |
300 |
400 |
TEMATYKA ZAJĘĆ
- Module 1: Planning a BI Solution
Elements of a BI Solution
Planning a BI Project
The Microsoft BI Platform
Lab : Planning BI Solutions
- Module 2: Planning SQL Server Business Intelligence Infrastructure
Considerations of BI Infrastructure
Planning Data Warehouse Hardware
Lab : Planning BI Infrastructure
- Module 3: Designing a Data Warehouse
Data Warehouse Design Overview
Designing Dimension Tables
Design FACT tables
Lab : Designing a Data Warehouse Logical Schema
- Module 4: Designing an ETL solution
ETL Overview
Planning for Data Extraction
Planning for Data Transformations
Planning for Data Loading
Lab : Designing an ETL Solution
- Module 5: Designing Analytical Data Models
Introduction to Analytical data Models
Designing Analytical Data Models
Lab : Designing Analytical Data Model
Lab : Designing Dimensions and Hierarchies
- Module 6: Planning a BI Delivery Solution
Considerations for BI delivery
Common Reporting Scenarios
Choosing a Reporting Tool
Lab : Planning a BI Delivery Solution
- Module 7: Designing a Reporting Services Solution
Planning a Reporting Solution
Designing Reports
Planning Report Consistency
Lab : Designing a Reporting Services Solution
- Module 8: Designing an Excel Based reporting Solution
Using Excel for Data Reporting and Analysis
PowerPivot in Excel
Power View in Excel
Lab : Designing and Excel Reporting Solution
- 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
Lab : Implementing a SharePoint Server BI Solution
Lab : Implementing PerformancePoint Services
- Module 10: Monitoring and Optimizing a BI Solution
Overview of BI Monitoring
Monitoring and Optimizing the Data Warehouse
Monitoring and Analyzing Analysis Services
Monitoring and Optimizing Reporting Services
Lab : Monitoring and Optimizing a BI Solution
- Module 11: Operating a BI Solution
Overview of BI Operations
ETL Operations
Data Warehouse Operations
Analysis Services Operations
Reporting Services Operations
Lab : Operating a BI Solution