Brainmatics

Designing Business Intelligence Solutions with Microsoft SQL Server 2012

Pada training ini, peserta akan belajar bagaimana merancang dan mengimplementasikan infrasturktur Business Intelligence (BI). Peserta akan belajar mendesain dan instalasi database. Training ini berfokus pada desain, instalasi dan pemeliharaan platform Business Intelligence (BI). Training ini juga dapat membantu anda mempersiapkan diri untuk mengikuti ujian Microsoft 70-467 (Designing Business Intelligence Solutions with Microsoft SQL Server).

 

OBJECTIVES

  1. Mampu membuat perancangan komponen solusi dari BI.
  2. Mampu membuat perancangan infrastruktur BI.
  3. Mampu mendesain sebuah data warehouse.
  4. Mampu mendesain solusi ETL.
  5. Mampu membuat perancangan analisa model data.
  6. Mampu mendeliver solusi BI.
  7. Mampu membuat solusi desain reporting service.
  8. Mampu merancang solusi pelaporan Exel.
  9. Mampu membuat perancangan untuk solusi Sharepoint Server BI.
  10. Mampu memantau dan mengoptimalkan solusi BI.

TARGET AUDIENCE

  1. BI professionals
  2. Database professionals

SKILL REQUIREMENTS

  1. Mempunyai basic pemahaman tentang modeling untuk data warehouse.

CONTENT

1. Planning a BI Solution

    1.1. Elements of a BI Solution
    1.2. The Microsoft BI Platform
    1.3. Planning a BI Project

2. Planning SQL Server Business Intelligence Infrastructure

    2.1. Considerations for BI Infrastructure
    2.2. Planning Data Warehouse Hardware

3. Designing a Data Warehouse

    3.1. Data Warehouse Design Overview
    3.2. Designing Dimension Tables
    3.3. Designing Fact Tables
    3.4. Designing a Data Warehouse Physical Implementation

4. Designing an ETL Solution

    4.1. ETL Overview
    4.2. Planning Data Extraction
    4.3. Planning Data Transformation
    4.4. Planning Data Load

5. Designing Analytical Data Models

    5.1. Introduction to Analytical Data Models
    5.2. Designing an Analytical Data Model
    5.3. Designing Dimensions
    5.4. Enhancing Data Models

6. Planning a BI Delivery Solution

    6.1. Considerations for Delivering BI
    6.2. Common Reporting Scenarios
    6.3. Choosing a Reporting Tool

7. Designing a Reporting Services Solution

    7.1. Planning a Reporting Services Solution
    7.2. Designing Reports
    7.3. Planning Report Consistency

8. Designing a Microsoft Excel-Based Reporting Solution

    8.1. Using Excel for Data Analysis and Reporting
    8.2. PowerPivot for Excel
    8.3. Power View for Excel

9. Planning a SharePoint Server BI Solution

    9.1. Introduction to SharePoint Server as a BI Platform
    9.2. Planning Security for a SharePoint Server BI Solution
    9.3. Planning Reporting Services Configuration
    9.4. Planning PowerPivot Configuration
    9.5. Planning for PerformancePoint Services

10. Monitoring and Optimizing a BI Solution

    10.1. Overview of BI Monitoring
    10.2. Monitoring and Optimizing the Data Warehouse
    10.3. Monitoring and Optimizing Analysis Services
    10.4. Monitoring and Optimizing Reporting Services

11. Operating a BI Solution

    11.1. Overview of BI Operations
    11.2. ETL Operations
    11.3. Data Warehouse Operations
    11.4. Analysis Services Operations
    11.5. Reporting Services Operations