WeDeliver: Data Warehouse, Database Design and Report Analysis

This report provides a comprehensive analysis of the WeDeliver online delivery company's database and data warehousing requirements. It begins with an introduction to database management systems and their importance in organizing data for various business functions. The main body delves into data warehousing, explaining its role in integrating data from diverse sources to support analytical reporting and decision-making. It explores the Kimball's four-step dimensional design process, including selecting the business process, declaring the grain, identifying dimensions, and identifying facts. The report also examines star and snowflake schemas, illustrating their application in the WeDeliver system. The conclusion summarizes the key findings and emphasizes the significance of a well-designed database for the company's operational efficiency and strategic planning. The report also includes relevant references from books and journals.

Individual report: -
WeDeliver

Table of Contents

INTRODUCTION...........................................................................................................................1
MAIN BODY...................................................................................................................................2
Section 2: Data warehouse.....................................................................................................2
Data Warehousing.............................................................................................................2
Kimball’s four step dimensional design process...............................................................2
Star schema or a snowflake schema..................................................................................3
CONCLUSION................................................................................................................................3
REFERENCES................................................................................................................................3

INTRODUCTION
Database management system can be defined as the management of data which converts raw
data into relevant information in a digitalised manner with the help of software development in
an organization for various purposes (Setyawati, Wijoyo and Soeharmoko, 2020). The given
scenario is of the WeDeliver online delivery company who wants to make the proper and a
perfect database management system in order to record, modify, delete and many other functions
with data to perform data analysis operations for the future considerations in an organization.
The following discussion is made on the database preparation using entity relationship diagram
by creating primary and foreign keys with several tables associated with it, data warehousing,
data mining, business intelligence and NoSQL database with proper findings and conclusion in
context of the given scenario.
1

MAIN BODY
Section 2: Data warehouse
Data Warehousing
It is defined as the process of formulating, developing and using the data warehouse. Data
warehouse can be defined as the construction of data by integration of data from more than one
assorted sources that aids in analytical reporting, ad hoc queries or structured queries and the
most important is the decision making (Bhatia, 2019). The information which is gathered via
data warehousing can be used in various domains such as in making the strategies of production
is one of the area in which data warehousing can be used which means that data analysis
supports the company in predicting the inventory management and how much to keep or to use,
analysing customers is an another area in which data warehousing can be used which means that
it helps in analysing the demands of the customers and their taste and preferences as per the
recent trends and fashion and analysing the operations is also the one of the area in which data
warehousing can be used which means that it aids the company in total quality management and
the just in time management approaches in operations by analysing the data in depth. There are
various functions of data warehouse tools and utilities such as data extraction is one of the
function of data warehouse tools which means that retrieving of data is a necessary function to
make the use of data in an effective manner, data cleaning is an another function of data
warehouse tools which means that removing the unnecessary data or duplication of data so that
data and storage efficiency could be maintained, data transformation is also the one of the
function of data warehouse tools which means that updating of data is essential in order to use it
in an advanced manner and data loading is also an another function of data warehouse tools
which means that it is important to keep data which is relevant for the organization so that the
loading of it can be more quick than before which saves time and energy both. Data cleaning and
data transformation are essential functions for data warehousing in order to enhance the quality
of data and the results of data mining.
Kimball’s four step dimensional design process
Select the business process
2

It is the first step of Kimball’s dimensional design process that is the selection of the
business process which means that process of the business must be selected such as in what
domain or field the business is working or operating and here in the given case, it is the
WeDeliver online delivery system (Killough, 2018).
Declare the grain
It is the second step of Kimball’s dimensional design process that is the declaration of the
grain which means that representing the records of the fact table as it is in order to identify its
dimension as per the needs and requirements of the business and here in the given case, it is the
WeDeliver online delivery system’ s fact table formulated in previous section.
Identify the dimensions
It is the third step of Kimball’s dimensional design process that is the identification of the
dimensions which means that recognising the assorted dimension so that data analysis a per the
circumstances can be done perfectly and potentially and here in the given case, it is the
WeDeliver online delivery system (Darma, Utami and Aryani, 2019).
Identify the facts
It is the fourth step of Kimball’s dimensional design process that is the identification of
the facts which means that recognising the important figures which are essential in the
examination of data for the future considerations and here in the given case, it is the WeDeliver
online delivery system.
Star schema or a snowflake schema
Star schema can be defined as the simplest way or approach of data representation which
is most widely used to develop warehousing of data and dimensional data marts. It consists more
than one fact tables which are referenced to any of the name of dimension table. Here is the star
schema presented of the WeDelivery online delivery system.
3

Snowflake schema can be defined as the technical and logical arrangement of fact tables
in a more than one dimensional databases such that the E-R diagram rearranges or reallocates a
shape of snowflake. It is presented fact tables which are centralised in nature and are connected
to more than one dimensions. Here is the snowflake schema presented of the WeDelivery online
delivery system.
4

(Mohammed, 2019).
CONCLUSION
REFERENCES
Books and journal
Bhatia, P., 2019. Data mining and data warehousing: principles and practical techniques.
Cambridge University Press.
Darma, I.G.W., Utami, K.S. and Aryani, N.W.S., 2019. Data Warehouse Analysis to Support
UMKM Decisions using the Nine-step Kimball Method. International Journal of
Engineering and Emerging Technology. 4(1). pp.65-68.
Killough, B., 2018, July. Overview of the open data cube initiative. In IGARSS 2018-2018 IEEE
International Geoscience and Remote Sensing Symposium (pp. 8629-8632). IEEE.
Mohammed, K., 2019. Data Warehouse Design and Implementation Based on Star Schema vs.
Snowflake Schema. Int. J. Acad. Res. Bus. Soc. Sci, 9.
Setyawati, E., Wijoyo, H. and Soeharmoko, N., 2020. Relational Database Management System
(RDBMS).
5