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.

 

AUDIENCE

1. BI professionals
2. Database professionals

 

PREREQUISITES

Menguasai Materi Building Data Warehouse with SQL Server 2012.

 

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. Usig 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

 

INSTRUCTOR

 

Satya Sanjaya

Menamatkan pendidikan tinggi jurusan teknik mesin di Universitas Indonesia Jakarta. Aktif sebagai konsultan dan telah menyelesaikan banyak project dibidang System Programmer Administrator dan Database Administrator, seperti dalam penerapan Microsoft Windows NT Server, Microsoft SQL Server, Microsoft Sharepoint, dan ASP.Net MVC. Sekarang aktif sebagai pengajar / trainer diberbagai training center di Jakarta, untuk materi training berbasis Microsoft seperti Visual Basic, Visual Interdev , SQL Server, Visual Studio.Net, Microsoft Windows Server, Microsoft SharePoint, Microsoft Project, Crystal Report.