Assignment Task:

The Case  

Olympus is a professional sports services provider, on a mission to enhance every client’s performance potential, and contribute positively to their respective sporting careers. This translates into three business objectives: increase sporting performance, reduce risk of injury and improve overall fitness.  

Olympus operates on a subscription-based model, where an athlete (or sportsperson) interested to obtain sport management services pay an upfront membership fee and a monthly subscription. Having been in business for the past ten years, the CEO at Olympus is confident that the substantial accumulation of data in operational systems can be capitalised to improve the effectiveness and efficiency of each business operation. She is keen to implement an organisation-wide data warehousing solution to explore this potential. She has approached an analytics consultancy firm to start on this project. The business requirements analysis and feasibility study were completed on a positive note.  
 
You have been recruited as the dimensional model specialist to complete the data warehouse design phase.  

Tasks 
 
1. Requirements: Identify current and future decision-making needs and information requirements of the organisation. Determine the number of dimensional models required (with justification).

2. SQL: Compile SQL statements, based on given information and ER diagrams, to address five decision-making needs identified above. Use of advanced SQL syntax is required as this task aims to assess your knowledge of SQL.  

3. Design: Follow Kimball’s dimension design process to create the identified models. Revise each model by applying the fact table and dimension table techniques. Provide a data dictionary (a description of each table in each model outlining the purpose, attributes and data types).  

4. Demonstration: Demonstrate how each dimensional model can be used to respond to current and future business questions and decision-making scenarios. Articulate how the dimensional model can lead to effective decisions. 

 

This Management Assignment has been solved by our Management Experts at UniLearnO. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

Eureka! You've stumped our genius minds (for now)! This exciting new question has our experts buzzing with curiosity. We can't wait to craft a fresh solution just for you!

  • Uploaded By : Alex Cerry
  • Posted on : March 28th, 2019

Whatsapp Tap to ChatGet instant assistance