Data Warehouse Bus Matrix

Data Warehouse Concept and Design
April 27
201
9
Student ID:
Student Name:

Report
Data Warehouse Bus Matrix
Data Marts
Business Processes
Serve
Patients
Retail Sales
Pay purchases by cash, cheque, bank
card, visa card and master card
x x
Pay purchases by American Express
Card
x x
Monitoring patient drug therapies x
Online Purchase x
Check balance of products x x
Observe hot selling products x
Notify central warehouse for orders of
products
x x
Receive delivered products x x
Update inventory database x x
Send weekly sales report to HQ x x
Store POS transaction x
Store receipt file for sales of products x
Send monthly sales report to HQ x x
Store VIP buyer card information of
customers
x x
Assign VIP classes to customers x x
Store product detail x x
Store promotion detail x
Analyse sales revenue x x
Maintain supply chains x x
Seek cost saving opportunities x
Negotiate agreements x x
Issue purchase requisitions x x
Issue purchase order x x
Track receipts x x
Authorize payments x x
Agreements for discount on goods x x
HQ distributes list of suppliers and
products to stores
x x

Generate business revenue x x
Analyse income for different products x x
Analyst customer behaviours x x
Analyse location performance x
Analyse business performance x x

Star Schema for Retail Sales Data Mart
( Dynamic News 2015)
(Kirpes D. n.d.)