Data warehouse bus matrix

Published:

This essay has been submitted by a student. This is not an example of the work written by our professional essay writers.

1. Data Warehouse Bus Matrix

Business Process

Event

Event Session

Ticket

Promotion Outlet Batch

Customer

Ticket Sale Transaction

Ticket Sales

X

X

X

X

X

Client Invoice

X

X

X

X

X

X

2. Star Schema

3. Granularity

Fact Table Name

Fact Granularity

Brief Justification

Client Invoice

Client commission for each Batch

Atomic - The amount of commission received by the client for each Batch

Ticket Sales

Ticket Transactions for an Event

Atomic - Transaction data for each Ticket

4. Attribute Hierarchies

Dimension Table Name

Brief Justification

Attribute Hierarchies

Event

Every Business Process have Event details

Event name, Type Of Event, Client company Name, Client contact Phone No, Venue Name, Street Address, Suburb, Postcode, Venue manager, Venue Manager Phone No

Event Session

Description of the Session for the type of event when they are conducted

Event Session Number, Event Date, Session time, Venue Name, Manger Phone No

Ticket

Description for the Transaction details containing Date, Time and transaction details

Event Session, Event date, Session Time, Seat Number, transaction Date Time, payment Type

Dimension Table Name

Brief Justification

Attribute Hierarchies

Promotion outlet Batch

Description regarding the batches of tickets on which dates they have distributed to the outlets

Client Company Name, Business Name, Street Address, Suburb, Postcode, Contact Name, Contact PhoneNo, Outlet Category Name ,Category Description

Ticket Sale Transaction

Ticket sale details for each Transaction

Transaction Date Time, Payment type, payment Category, Credit Card type, ticket Sale Transaction No

Customer

Details of the Customers who purchased tickets Online

Customer First Name, Customer Last name, Customer Account No, Street Address, Suburb, Postcode, State, Country, Email Address, Contact Phone No

Transaction Payment Type

Details related to Transaction payment type and category

Payment category, Credit card type, Credit card name, Payment type Id

5. Design Features

Design Feature

Brief Description

Brief Justification

Degenerate Dimension

To retrieve the Client Invoice No and Client Invoice Date for outlet commission

The Commission details are stored in Flat Files,

Role play

Information regarding the Event session date and time

Type of event that is being conducted by the clients for the session

6. Business Questions

· Which ticket promotion outlets see the most tickets? Does this vary across different months or event types?

Select Client_Invoice_Fact_Table(Promotion_Outlet_Batch_Id, Quantity sold, Event_Session_Id,Ticket_Sale_Transaction_No)

What ticket batch sizes minimise the likelihood of outlets having unsold tickets whilst maximising profit? Client_Invoice_Fact_Table(Event_Session_Id,Ticket_Sale_Transaction_No )

· For which clients have we provided the most event tickets? How much do we make a year out of our top 5 clients?

Client_Invoice_Fact_Table(Event_Session_Id,Ticket_Sale_Transaction_No ) + Ticket_Sales_Fact_table (Customer_Id )

· How much commission did we pay to promoters in the last financial year? How does this compare to the past 5 years?

Client_Invoice_Fact_Table(Date_distributed,Event_Session_Id)

· From which online customer locations do the more expensive event tickets (e.g. premium and gold) sell?

Ans) Ticket_Sales_Fact_Table(Customer_Id,Event_Session_Id)

Writing Services

Essay Writing
Service

Find out how the very best essay writing service can help you accomplish more and achieve higher marks today.

Assignment Writing Service

From complicated assignments to tricky tasks, our experts can tackle virtually any question thrown at them.

Dissertation Writing Service

A dissertation (also known as a thesis or research project) is probably the most important piece of work for any student! From full dissertations to individual chapters, we’re on hand to support you.

Coursework Writing Service

Our expert qualified writers can help you get your coursework right first time, every time.

Dissertation Proposal Service

The first step to completing a dissertation is to create a proposal that talks about what you wish to do. Our experts can design suitable methodologies - perfect to help you get started with a dissertation.

Report Writing
Service

Reports for any audience. Perfectly structured, professionally written, and tailored to suit your exact requirements.

Essay Skeleton Answer Service

If you’re just looking for some help to get started on an essay, our outline service provides you with a perfect essay plan.

Marking & Proofreading Service

Not sure if your work is hitting the mark? Struggling to get feedback from your lecturer? Our premium marking service was created just for you - get the feedback you deserve now.

Exam Revision
Service

Exams can be one of the most stressful experiences you’ll ever have! Revision is key, and we’re here to help. With custom created revision notes and exam answers, you’ll never feel underprepared again.