Loading...

MS-20467 Designing Business Intelligence Solutions with Microsoft SQL Server 2014

Czas trwania kursu: 5 dni
Cena: 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