$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

CSE5DWD Data Warehouse Concepts And Design

tag 0 Download14 Pages / 3,283 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT
  • Course Code: CSE5DWD
  • University: La Trobe University
  • Country: Australia


This question has two parts- Assignment 2a (Business Intelligence Application Design) & Assignment 2b (Data Warehouse Design)

Assignment Overview

You have been engaged by a client to design a business intelligence application and supporting data warehouse. Using the attached case study documents, you will identify the reporting requirements of the senior management users. You will produce prototype report designs and supporting multi-dimensional model in the form of Thomsen diagrams for a planned business intelligence application. You will then produce a multidimensional model specifying a data warehouse database schema in the form of a star-schema, consider data sourcing and provide recommendations for a technical architecture to support the business intelligence application.

The assignment is split into two submissions: the first for the application design, the second expanding on the first to include the data warehouse design.

For assignment 2a (Business Intelligence Application Design):

Using the information provided, design a series of reports and/or dashboards for the key users to help them find answers to their business questions. You may design these using any software tool you wish. The reports are prototypes only and will be submitted in hard copy, so they do not need to actually work as interactive reports.

Design a multi-dimensional schema using Thomsen diagrams to support your prototype design?Present your designs in a design specification report. Make sure to present your report professionally. You should include a proper cover-page, table of contents, and an introductory overview of your design that outlines your understanding of the key business requirements and provides an overview of your solution.

This section should also justify any key design decisions you’ve made, both in regard to the data visualisations chosen and the design of the multi- dimensional schema.

This should be followed by your prototype reports (annotated if necessary to explain your design concepts) and then the multi-dimensional model. You may add further sections to the report if you feel it necessary.

For assignment 2b (Data Warehouse Design):

Design a data warehouse schema using the star-schema approach based on your Thomsen diagrams in assignment 2a.?Consider options for the technical architecture for the data warehouse, recommending a structure with justifications.

Prepare a data dictionary for your star schema design that includes plain- language definitions for all entities and attributes. Further, for each attribute, you should indicate how the data for that attribute is obtained or derived, where relevant making reference to the source systems’ database schemas (see attached transaction processing system database schemas).

Supplement your design report from assignment 2a by adding in your data warehouse design. You may wish to amend your introductory overview to take into account the data warehouse content of the report. You should present your data warehouse schema, discussion of technical architecture options and data dictionary with mapping to the source systems as sections following the material already submitted in assignment 2a.

Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Unique Document

Under Evaluation

Get Money
into Your Wallet

Total 14 pages, 1 USD Per Page

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2020). Data Warehouse Concepts And Design. Retrieved from

"Data Warehouse Concepts And Design." My Assignment Help, 2020,

My Assignment Help (2020) Data Warehouse Concepts And Design [Online]. Available from:
[Accessed 22 October 2020].

My Assignment Help. 'Data Warehouse Concepts And Design' (My Assignment Help, 2020) <> accessed 22 October 2020.

My Assignment Help. Data Warehouse Concepts And Design [Internet]. My Assignment Help. 2020 [cited 22 October 2020]. Available from:

With time, has become one of the best college essay writing services. Our all rounded services give students the confidence to overcome assignment related issues. Our services are fast enough to meet most urgent deadlines. We are capable of delivering fast essay writing services with the help of our specially designed provisions and writers' teams. Our urgent essay help services guarantee most rapid delivery of assignment solutions. Some of our most popular essay services are application essay help, exploratory essay help, literary review essay help and argumentative essay help.

Latest It Write Up Samples

ISY2001 System Analysis And Design

Download : 0 | Pages : 6
  • Course Code: ISY2001
  • University: Australian Institute Of Higher Education
  • Country: Australia

Answer: Introduction FastDrivers is a company recently created that provides driving lessons and the company provides online booking of lessons for the customers in New South Wales. The company wants to design an online booking system which performs the activities that are described in this report. The purpose of this report is to provide an analysis and design of online booking system to serve the customers of FastDrivers. The structure of ...

Read More arrow

ITECH1103 Big Data And Analytics

Download : 0 | Pages : 7
  • Course Code: ITECH1103
  • University: Federation University Australia
  • Country: Australia

Answers: Introduction and Background: The University of Ballarat accomplished the research report on the basis of “Solar city project” data. The data for analysis was collected from households and businesses across two regions such as “Loddon Mallee” and “Grampians” to observe the transformations that arose because of the consumption of energy. The “IBM Watson Analytic” tool is utilised to analy...

Read More arrow

ITC508 Object Modelling

Download : 0 | Pages : 8
  • Course Code: ITC508
  • University: Charles Sturt University
  • Country: Australia

Introduction The automated car system (ACS) is a mechanical system, which is designed for making the parking system better and minimizing the area of parking system. Collin has car parking system but the system is not automated. The car parking system for Collin should be automated so that the system becomes better and the space for parking is minimized. The Collin parking system now has manual workers who maintains the parking system (Sudha et ...

Read More arrow

ICTICT511 IT Strategy

Download : 0 | Pages : 6
  • Course Code: ICTICT511
  • University: Victorian Institute Of Technology
  • Country: Australia

Answers: 1. Cost Benefit Analysis: This method is helpful to analyze business decisions. Here, the benefits at any specific situation or actions that are business related is been summed up. Next the cost related to the activities are been subtracted. Here, some analysts and consultants have been also building the model in order to put the dollar value over intangible items (McKeen & Smith 2014). The results of the assessment determine whethe...

Read More arrow

ITC505 ICT Project Management

Download : 0 | Pages : 14
  • Course Code: ITC505
  • University: Charles Sturt University
  • Country: Australia

Answer: Development of Online  management system for Stud Farm Part One: MOV - Measurable Organisational Value Rank Factor Description Metrics Measurable value Time frame 1 Operational The operations in the project are very important aspects for measurement of the online management system  that is to be managed. Plan for management of the project 8% decrease ...

Read More arrow

Save Time & improve Grade

Just share requirement and get customized Solution.

We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Add File

Error goes here




Overall Rating



Our Amazing Features


On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.


Plagiarism Free Work

Using reliable plagiarism detection software, only provide customized 100 percent original papers.


24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat. If you are unable to calculate word count online, ask our customer executives.


Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.


Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

Our Experts

Assignment writing guide
student rating student rating student rating student rating student rating 5/5

529 Order Completed

95% Response Time

Ivan Blank

PhD in Functional Human Biology

Wellington, New Zealand

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

154 Order Completed

97% Response Time

Harold Alderete

PhD in Economics

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

416 Order Completed

95% Response Time

Tyler Moore

MBA in Accounting

Washington, United States

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

1692 Order Completed

98% Response Time

Alfred Dodd

PhD in Computer and Information Science with specialization in Database

Wellington, New Zealand

Hire Me

FREE Tools


Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.


Essay Typer

Get different kinds of essays typed in minutes with clicks.


GPA Calculator

Calculate your semester grades and cumulative GPa with our GPA Calculator.


Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.


Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

Refer Just 5 Friends to Earn More than $2000

Check your estimated earning as per your ability




Your Approx Earning

Live Review

Our Mission Client Satisfaction

I had a great experience. Thank you so much for your great help! The work was so efficient and professional. I would definitely recommend to my friends


User Id: 190415 - 22 Oct 2020


student rating student rating student rating student rating student rating

Just amazing work to the person who did my assignment. Thanks a lot!! Hats of to you!!! Highly recommend to the expert who wrote my assignment. Thank you once again.. Cheers!!!!! :D :D :D


User Id: 476921 - 22 Oct 2020


student rating student rating student rating student rating student rating

the question 4 ,5 and 6 are fully right so hey can u do question 2 or 1 for me plz


User Id: 219126 - 22 Oct 2020


student rating student rating student rating student rating student rating

Well written and researched. I would never have chosen this topic but I thoroughly enjoyed reading the work. Very few amendments (American spelling vs British only which is a personal preference only and not a reflection on the work). Looking forward...


User Id: 226365 - 22 Oct 2020


student rating student rating student rating student rating student rating
callback request mobile
Have any Query?