This document discusses information packages for analyzing data in a data warehouse. It describes key concepts like dimensions, hierarchies, granularity and provides examples. Dimensions are structures that categorize data to answer business questions. Hierarchies show relationships between dimension levels. Granularity refers to data detail levels. An example information package diagram for hotel occupancy analysis is presented with the hotel, room type, and time dimensions. Information packages define metrics, dimensions and drill/roll-up analyses required for a data warehouse.
This document discusses information packages for analyzing data in a data warehouse. It describes key concepts like dimensions, hierarchies, granularity and provides examples. Dimensions are structures that categorize data to answer business questions. Hierarchies show relationships between dimension levels. Granularity refers to data detail levels. An example information package diagram for hotel occupancy analysis is presented with the hotel, room type, and time dimensions. Information packages define metrics, dimensions and drill/roll-up analyses required for a data warehouse.
This document discusses information packages for analyzing data in a data warehouse. It describes key concepts like dimensions, hierarchies, granularity and provides examples. Dimensions are structures that categorize data to answer business questions. Hierarchies show relationships between dimension levels. Granularity refers to data detail levels. An example information package diagram for hotel occupancy analysis is presented with the hotel, room type, and time dimensions. Information packages define metrics, dimensions and drill/roll-up analyses required for a data warehouse.
This document discusses information packages for analyzing data in a data warehouse. It describes key concepts like dimensions, hierarchies, granularity and provides examples. Dimensions are structures that categorize data to answer business questions. Hierarchies show relationships between dimension levels. Granularity refers to data detail levels. An example information package diagram for hotel occupancy analysis is presented with the hotel, room type, and time dimensions. Information packages define metrics, dimensions and drill/roll-up analyses required for a data warehouse.
Download as PPTX, PDF, TXT or read online from Scribd
Download as pptx, pdf, or txt
You are on page 1/ 14
Information
Package Sufia Adha Putri sufia@ub.ac.id
Fakultas Ilmu Komputer Universitas Brawijaya
Fakultas Ilmu Komputer Universitas Brawijaya
An Information Package For Analyzing Sales
Fakultas Ilmu Komputer Universitas Brawijaya
Dimensions • A dimension is a structure that categorizes data in order to enable users to answer business questions.
• Example of dimensions are customers, products, and time.
Fakultas Ilmu Komputer Universitas Brawijaya
Hierarchy of Dimension • 1:n relationships between the levels of a hierarchy. Drill • Going up a level in the hierarchy is Down called rolling up and going down a level in the hierarchy is called drilling down. • Within the customer dimension, customers roll up to city. Then cities roll up to state. Then states roll up to country. Then countries roll up to subregion. Finally, subregions roll up to region. Roll Up
Fakultas Ilmu Komputer Universitas Brawijaya
Granularity • Granularity refers to the level of detail or summarization of the units of data in the data warehouse. • The more detail there is, the lower the level of granularity. The less detail there is, the higher the level of granularity. • For example, a simple transaction would be at a low level of granularity. A summary of all transactions for the month would be at a high level of granularity.
Fakultas Ilmu Komputer Universitas Brawijaya
Granularity
Fakultas Ilmu Komputer Universitas Brawijaya
Granularity
Fakultas Ilmu Komputer Universitas Brawijaya
Example of Hotel Occupancy • In this case, we want to come up with an information package for a hotel chain. The subject in this case is hotel occupancy. • We want to analyze occupancy of the rooms in the various branches of the hotel chain. • We want to analyze the occupancy by individual hotels and by room types. So, hotel and room type are critical business dimensions for the analysis. • As in the other case, we also need to include the time dimension. • In the hotel occupancy information package, the dimensions to be included are hotel, room type, and time.
Fakultas Ilmu Komputer Universitas Brawijaya
Information Package Diagram of Hotel Occupancy
Fakultas Ilmu Komputer Universitas Brawijaya
• The information package diagrams crystallize the information requirements for the data warehouse. • They contain the critical metrics measuring the performance of the business units, the business dimensions along which the metrics are analyzed, and the details of how drill-down and roll-up analyses are done.
Fakultas Ilmu Komputer Universitas Brawijaya
Information Package Diagram of Automaker Sales
Data pada facts dijadikan
measurement pada database OLAP. Data facts dijadikan field pada tabel fakta.
Fakultas Ilmu Komputer Universitas Brawijaya
Information Package Diagram of Automaker Sales
Setiap dimensi dijadikan tabel
dimensi yang berelasi dengan tabel fakta. Tabel dimensi dapat dinormalisasi (snowflake) maupun tidak (star).
Fakultas Ilmu Komputer Universitas Brawijaya
Referensi • Paulraj Ponniah • Oracle Data Warehouse Guide • Pentaho: Solusi Open Source untuk membangun Data Warehouse (Mulyana, 2014)
Fakultas Ilmu Komputer Universitas Brawijaya
Tugas 1 (Dikumpulkan hari ini) 1. Pilihlah salah satu contoh subyek bisnis atau organisasi berikut a) Penjualan toko roti area malang b) Persewaan motor area malang c) Pengiriman barang area indonesia d) Penerimaan Siswa SMA N se-kota malang e) Sistem Informasi Akademik Mahasiswa 2. Kemudian buatlah information package sebagai requirement dasar membuat datawarehouse. (asumsikan dulu measurement yang diinginkan oleh pihak eksekutif bisnis dan dimensi yang terlibat sesuai case study).
The MSP’s Guide to the Ultimate Client Experience: Optimizing service efficiency, account management productivity, and client engagement with a modern digital-first approach.
The MSP’s Guide to the Ultimate Client Experience: Optimizing service efficiency, account management productivity, and client engagement with a modern digital-first approach.
