This question has two parts- Assignment 2a (Business Intelligence Application Design) & Assignment 2b (Data Warehouse Design)
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.
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.
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.
To export a reference to this article please select a referencing stye below:
My Assignment Help. (2020). Data Warehouse Concepts And Design. Retrieved from https://myassignmenthelp.com/free-samples/cse5dwd-data-warehouse-concepts-and-design.
"Data Warehouse Concepts And Design." My Assignment Help, 2020, https://myassignmenthelp.com/free-samples/cse5dwd-data-warehouse-concepts-and-design.
My Assignment Help (2020) Data Warehouse Concepts And Design [Online]. Available from: https://myassignmenthelp.com/free-samples/cse5dwd-data-warehouse-concepts-and-design
[Accessed 22 October 2020].
My Assignment Help. 'Data Warehouse Concepts And Design' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/cse5dwd-data-warehouse-concepts-and-design> accessed 22 October 2020.
My Assignment Help. Data Warehouse Concepts And Design [Internet]. My Assignment Help. 2020 [cited 22 October 2020]. Available from: https://myassignmenthelp.com/free-samples/cse5dwd-data-warehouse-concepts-and-design.
With time, MyAssignmenthelp.com 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.
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
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
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
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
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
Just share requirement and get customized Solution.
Our writers make sure that all orders are submitted, prior to the deadline.
Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.
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.
Our writers can provide you professional writing assistance on any subject at any level.
Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.
Get all your documents checked for plagiarism or duplicacy with us.
Get different kinds of essays typed in minutes with clicks.
Calculate your semester grades and cumulative GPa with our GPA Calculator.
Balance any chemical equation in minutes just by entering the formula.
Calculate the number of words and number of pages of all your academic documents.
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
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
the question 4 ,5 and 6 are fully right so hey can u do question 2 or 1 for me plz
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...