Takehome Midterm Exam I545 Data Warehouse TheoryOdd2223

MIDTERM EXAM ODD SEMESTER ACADEMIC YEAR 2022/2023
STUDY PROGRAM OF INFORMATION SYSTEMS

FACULTY OF ENGINEERING AND INFORMATICS
UNIVERSITAS MULTIMEDIA NUSANTARA
Subject : IS545 – Data Warehouse (Theory) Date :

Lecturer(s) : Iwan Prasetiawan, S.Kom.,M.M. Time : 4 days calendar
Jansen Wiratama, S.Kom., M.Kom.
Irmawati, S. Kom., M. Kom.
Form : Essay / Project Type : Onsite / Takehome
EXAM CONDITIONS / INSTRUCTIONS:

1. Give a clear and complete answer according to the question asked.
2. Please remember! answer all questions according to the field of business that you must
choose from the list of choices that must be in accordance with the class you are taking.
3. Answer files in MS. Format the Word document with the name specified in e-Learning.
4. The answers and case study scenarios cannot be the same as the case studies given in
the lecture material.
5. If the same student answers are found, then both do not get a score.
COURSE SUB LEARNING OUTCOMES (SUB-CLO):
SUB LEARNING OUTCOMES (SUB-CLO)

ELO
Code Deskripsi
CLO-2 Students are able to describe general concepts and descriptions of Data Warehouse and ELO-C
Sub-CLO-1 Business Intelligence environments including the 4 levels of accompanying knowledge–C2
CLO-3 Students are understanding and be able to implement ETL functions to reshape relevant data from
Sub-CLO-3 source systems for storage in data warehouses–C3
ELO-D
CLO-3 Students are able to implement the ETL process using the Pentaho Data Integration (PDI)
Sub-CLO-4 application and apply the PDI Job and Transformation concept-C3
CLO-1 Students are understanding and be able to make the basis for the design of multidimensional
Sub-CLO-5 data models for the logical design of data warehouses to support the company/business
management decision-making process-C4 ELO-B
CLO-1 udents are able to implement Star and Snowflake schemas which are used to design relational
Sub-CLO-7 model data consisting of fact/dimensional tables-C3;
QUESTIONS:
Background
You work as a Data Warehouse Developer at UMN IT Consulting, which is currently handling several
Data Warehouse development and implementation projects in several corporate clients in several
industrial fields below:
KELAS IS545-A KELAS IS545-B KELAS IS545-C
a) Bisnis Perumahan a) Jasa Logistik a) Jasa Asuransi
b) Produsen Sepatu b) Produsen Mobil b) Produsen Sepeda Motor
c) Produsen Alat2 Pertanian c) Produsen Alat2 Rumah Tangga c) Produsen Ban Kendaraan
d) Produsen Furnitur d) Produsen Alat tulis d) Produsen Obat-obatan
e) Produsen Pakaian/ Fashion e) Produsen Alat2 Olah raga e) Produsen Kerajinan/ Etnik
f) Jasa Transportasi f) Bisnis Online / e-Commerce f) Jasa Pergudangan
Page 1 of 4
The management of UMN IT Consulting assigns you to one of the above industrial fields, please choose
which industry field suits your passion to be able to successfully complete the development and
implementation of the Data Warehouse in the company's clients you choose.
your chosen field/business and named your company choosen as “...industrial field............./
.......company name............” to answer the following questions.
*** For answers that are equipped with workflow diagrams and picture illustrations, it will be obtain
the added value for your exam assessment result.
1. CLO2-Sub-CLO 1 Weight 20%

Fill in an your explanation for each part of the pyramid below according to the company you
choose for the Data Warehouse you plan to build.
Page 2 of 4
Illustrate simply and effectively your planned ETL process.

Hint: for example, the Transformation process with input and output in a spreadsheet format
file that makes it easy to perform data analysis and visualization as well as facilitate user
understanding in the company where you work for.

Completely describe the ETL process you are planning in question no. 2) above using an
illustration of the Job and Transformation process using the PDI application along with an
explanation.
.
4. CLO1-Sub-CLO 7 Weight (20%)
Create a star schema from data owned by the company you work for, explain the intent and
purpose of using the star schema.
5. CLO1-Sub-CLO 5 Weight (30%)

The management of UMN IT Consulting asks for the progress of the development and
implementation of the Data Warehouse that you have completed at your company's client, then
you immediately make and submit the report.
Create your report above in accordance with the completion of the planned Data Warehouse
development work with the following report format:
a) Chapter I Preface/ Introduction,

 Contains business objectives to be achieved through the planned Data
Warehouse design;
 The goals can be in the form of the strategic goals of your company's
clients or the business problems they are facing.
b) Chapter II Problem Analysis,

Determine (minimum 2 kinds) of needs/questions/information/analysis needed
by your company's clients, which they will obtain through the Data Warehouse,
Hint: for example, an analysis of the sales value of products/services per
type/type of customer for several sales locations per year, and so on as a
solution to achieving goals or solving problems.
c) Chapter III Problem Solving,

Explain the solution that you build in the Data Warehouse that is planned in the
form of a description equipped with an output layout image for each answer in
number 4) above.
Assessment rubric (for each of the above questions):
Assessment criteria
Assessment Aspect Very Less Deficient Good Good Excellent
< 45 45-54 55-69 70-84 ≥ 85
Theory compatibility
Depth of analysis
Case suitability
Page 3 of 4
References: Created by: Approved by:

on behalf of the Lecturer Team
1. Lecture Materials I to VII
2. Teaching Reference Book
(Iwan Prasetiawan, S.Kom., M.M.) (Ririn Ikana Desanti, S.Kom., M.Kom.)

Course Coordinator Head of Study Program
Page 4 of 4

Takehome Midterm Exam I545 Data Warehouse TheoryOdd2223

Uploaded by

Copyright:

Available Formats

Takehome Midterm Exam I545 Data Warehouse TheoryOdd2223

Uploaded by

Document Information

Original Description:

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Takehome Midterm Exam I545 Data Warehouse TheoryOdd2223

Uploaded by

Copyright:

Available Formats

MIDTERM EXAM ODD SEMESTER ACADEMIC YEAR 2022/2023

STUDY PROGRAM OF INFORMATION SYSTEMS

Subject : IS545 – Data Warehouse (Theory) Date :

EXAM CONDITIONS / INSTRUCTIONS:

COURSE SUB LEARNING OUTCOMES (SUB-CLO):

SUB LEARNING OUTCOMES (SUB-CLO)

1. CLO2-Sub-CLO 1 Weight 20%

2. CLO3-Sub-CLO 3 Weight 10%

Illustrate simply and effectively your planned ETL process.

3. CLO3-Sub-CLO 4 Weight 20%

5. CLO1-Sub-CLO 5 Weight (30%)

a) Chapter I Preface/ Introduction,

b) Chapter II Problem Analysis,

c) Chapter III Problem Solving,

Assessment rubric (for each of the above questions):

References: Created by: Approved by:

(Iwan Prasetiawan, S.Kom., M.M.) (Ririn Ikana Desanti, S.Kom., M.Kom.)

You might also like