lab work ii
TRANSCRIPT
-
8/7/2019 Lab Work II
1/17
Lab Work II
DW in MS SQL Server
-
8/7/2019 Lab Work II
2/17
How to build DW?
Imported
(External / Internal)
Cleansedand
Organized
Load datamarts
-
8/7/2019 Lab Work II
3/17
Why do we need import?(Sometimes called by extract)
Heterogen format (csv, xls, txt, mdb, dll)
Heterogen DBMS (access, mysql, oracle, dll)
Heterogen fokus (HR, Finance, Production, dll) Heterogen lokasi fisik
Heterogen asal data (OLTP, proses agregat,
bank BI, CRM tool, ERP tool, dll) dll.
-
8/7/2019 Lab Work II
4/17
Why do we need cleansed/organized?(Sometimes called by transform)
Heterogen currency - membutuhkan proses
transform menjadi mata uang yang sejenis
Heterogen satuan - membutuhkan prosestransform menjadi satuan yang sejenis
Membutuhkan fungsi aggregat - sum, average,
count, percentage, ranging, dll
Heterogen penamaan field atau table - script
untuk update lastName menjadi lname
dll
-
8/7/2019 Lab Work II
5/17
Why do we need load?
Untuk mengisi data warehouse
Untuk mengisi data warehouse
Membuat cube
Membuat cube
Membuat pivot
Membuat pivot
Menemukan masalah
Menemukan masalah
Solve masalah
Solve masalah
-
8/7/2019 Lab Work II
6/17
Proses DW
DW
OLTP
CSV
Selecttable
-
8/7/2019 Lab Work II
7/17
Proses ETL
Video part 1 (38:06)
DSS & BI (Turban : 224)
Denormalisasi
(join all tables)
Data Warehouse
-
8/7/2019 Lab Work II
8/17
Data Cube
Dimensions (point of view)
Measures (money, sales volume, inventory)
Time (daily, weekly, monthly,)
-
8/7/2019 Lab Work II
9/17
Lets build a cube
-
8/7/2019 Lab Work II
10/17
Cube Schema
-
8/7/2019 Lab Work II
11/17
DW Concepts
-
8/7/2019 Lab Work II
12/17
DW Concepts
-
8/7/2019 Lab Work II
13/17
DW Concepts
-
8/7/2019 Lab Work II
14/17
Browse Data
-
8/7/2019 Lab Work II
15/17
Data Visualisasi
-
8/7/2019 Lab Work II
16/17
Dashboard - Pivot
-
8/7/2019 Lab Work II
17/17
End