Data Warehouse Design: A Case Study of Chemist Warehouse

Running head: DATA WAREHOUSE DESIGN
Data Warehouse Design: A Case Study of Chemist Warehouse
Name of the Student
Name of the University

DATA WAREHOUSE DESIGN 2
Executive Summary
In the report the design principles and the different way of data warehouse design is depicted.
The process that includes the maintenance, sales, and the services that are provided are selected.
These services and the dimensions are interconnected and the bus matrix is used to gives the
information about the interconnection. The dimension includes the flight ticket booking,
customers, clients and may more. Star schema can be created by using the derived bus matrix.
This report also contains the table of facts, granularity, dimension types and many more. The
dimensions that are undertaken are supported by these dimensions. The management also relies
on the data that are there within the warehouse.

DATA WAREHOUSE DESIGN 3
Table of Contents
1. Introduction:................................................................................................................................4
2. Data Warehouse Bus Matrix:.......................................................................................................4
3. Star Schema for the Data Marts:..................................................................................................5
3.1 Maintenance Fact Table:........................................................................................................5
3.2 Services Fact Table:...............................................................................................................6
3.3 Sales:......................................................................................................................................7
4. Fact Table, Granularity and Justification against Granularity:....................................................7
5. Justification and Attribute Hierarchy of the Dimension Tables:.................................................9
6. Data Warehouse Design Features:.............................................................................................12
7. Identification of Fields:..............................................................................................................14
8. Conclusion:................................................................................................................................17
Bibliography:.................................................................................................................................18

DATA WAREHOUSE DESIGN 4
1. Introduction:
Data ware house is also referred to as the store house that stores a large volume of data
that are from different sources that also help the management to undertake several decisions for
the organization (George, Kumar and Kumar 2015). The warehouse also used to analyze the data
that are oriented to some subject areas and Chemist Warehouse is one such example. The several
business processes within the organization and the primary tools that is termed as the bus matrix.
Star Schema is the data warehouse design representation in a graphical manner.
This report also consists the bus matrix, star schema tables that consists of the facts that
also maintain the granularity, design dimension, design, types and many other. The
datawarehouse is engaged with the process of collecting and managing the data within the
organization thus supporting in the functioning of the organization. Thus it is essential for data
warehouse to maintain and follow the aims and the objectives of the Chemist Warehouse.
2. Data Warehouse Bus Matrix:
Business
processes
Dimensions
DATE
WAREHOUSE
PRODUCT
STORE
CUSTOMER
PROMOTION
PHARMACISTS
VENDOR
PRODUCT
MEDIA
PATIENT
Retail sales X X X X X X X X