Brainmatics

Building Data Warehouse with SQL Server 2012

Popularity : author-post-ratingauthor-post-ratingauthor-post-ratingauthor-post-ratingauthor-post-rating

Data warehouse merupakan suatu sistem yang mengkonsolidasikan data secara periodik dari sistem-sistem yang ada ke dalam suatu penyimpanan dimensional. Pada umumnya, data warehouse menyimpan data histori beberapa tahun dan di-query untuk keperluan business intelligence atau aktifitas analisis lainnya. Data warehouse diperbaharui secara batch, tidak setiap terjadinya transaksi pada sistem sumber tersebut.

Pada training ini, Anda mengenal lebih dalam tentang data warehouse dan bagaimana data histori disimpan untuk keperluan BI atau aktifitas analisis lainnya sampai pada pemeliharaan data tersebut untuk waktu yang cukup lama.

 

OBJECTIVES

 

AUDIENCE

 

PREREQUISITES

1. Memiliki pengalaman bekerja dengan database relational
2. Memiliki pengetahuan tentang normalisasi database
3. Mampu membuat tabel da hubungan antar tabel
4. Mampu membuat query dengan Transact-SQL

 

CONTENT

1. Data Warehouse Logical Design

1.1. Introducing Star and Snowfake Schemas
1.2. Designing Dimensions
1.3. Designing Fact Tables

2. Implementing a Data Warehouse

2.1. Implementing Dimensions and Fact Tables
2.2. Managing the Performance of a Data Warehouse
2.3. Loading and Auditing Loads

3. Creating SSIS packages

3.1. Using the SQL Server Import and Export Wizard
3.2. Developing SSIS Packages in SSDT
3.3. Introducing Control Flow, Data Flow, and Connection Managers

4. Designing and Implementing control flow

4.1. Connection Managers
4.2. Control Flow Tasks and Containers
4.3. Precedence Constraints

5. Designing and Implementing Data flow

5.1. Defning Data Sources and Destinations
5.2. Working with Data Flow Transformations
5.3. Determining Appropriate ETL Strategy and Tools

6. Enhancing control flow

6.1. SSIS Variables
6.2. Connection Managers, Tasks, and Precedence Constraint Expressions
6.3. Using a Master Package for Advanced Control Flow

7. Enhancing Data flow

7.1. Slowly Changing Dimensions
7.2. Preparing a Package for Incremental Load
7.3. Error Flow

8. Creating a Robust and Restartable Package

8.1. Package Transactions/ol>
8.2. Checkpoints
8.3. Event Handlers

9. Implementing Dynamic Packages

9.1. Package-Level and Project-Level Connection Managers and Parameters
9.2. Package Confgurations

10. Auditing and Logging

10.1. Logging Packages
10.2. Implementing Auditing and Lineage
10.3. Preparing Package Templates

11. Installing SSIS and Deploying Packages

11.1. Installing SSIS Components
11.2. Deploying SSIS Packages

12. Executing and Securing Packages

12.1. Executing SSIS Packages
12.2. Securing SSIS Packages

13. Troubleshooting and Performance Tuning

13.1. Troubleshooting Package Execution
13.2. Performance Tuning

14. Installing and Maintaining Data Quality Services

14.1. Data Quality Problems and Roles
14.2. Installing Data Quality Services
14.3. Maintaining and Securing Data Quality Services

15. Implementing Master Data Services

15.1. Defning Master Data
15.2. Installing Master Data Services
15.3. Creating a Master Data Services Model

16. Managing Master Data

16.1. Importing and Exporting Master Data
16.2. Defning Master Data Security
16.3. Using Master Data Services Add-in for Excel

17. Creating a Data Quality Project to Clean Data

17.1. Creating and Maintaining a Knowledge Base
17.2. Creating a Data Quality Project
17.3. Profling Data and Improving Data Quality

18. SSIS and Data Mining

18.1. Data Mining Task and Transformation
18.2. Text Mining
18.2. Preparing Data for Data Mining

19. Implementing Custom Code in SSIS Packages

19.1. Script Task
19.2. Script Component
19.3. Implementing Custom Components

20. Identity Mapping and De-Duplicating

20.1. Understanding the Problem
20.2. Using DQS and the DQS Cleansing Transformation
20.3. Implementing SSIS Fuzzy Transformations

 

INSTRUCTOR

 

Image

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.