BUSWB | Assignment 1 Data Warehousing and Bigdata | Business

Home Recent Questions BUSWB | Assignment 1 Data Warehousing and Bigdata | Business


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.


A professionally written report on the dimensional design activities undertaken for Olympus. This can be compiled as a series of topics of the abovementioned ‘to do’ list or formatted as a design document.

The report should be compiled in Microsoft Word, font size 11.

Report content should not exceed 8-10 pages (including diagrams). Diagrams have to be in the main body as it is a design document. If the number of pages are insufficient, you may include the data dictionary as an appendix.

You are free to make any assumptions with justification. Include these in the report, where applicable. Make realistic assumptions on any information (schema or business requirements) that may be missing in the above description.

Search Here

Latest Reviews

  • Kannon
    13 Jul, 2019

    I asked for essay help from Assignment Help 4 Me and I am happy that the essay writers completed my task on time. The prices they asked for are worth in comparison to the services rendered.

  • Liam
    13 Jul, 2019

    Assignment Help 4 Me is the best help provider. I took assistance to get my essay completed and I am glad that the writers delivered the quality content as they promised within the time committed.

  • Silas
    12 Jul, 2019

    Accounting is a very interesting subject but when it comes to assignment writing, I feel hard to get through the same. But, since the assignments have to be completed somehow, I preferred to avail online help from Assignment Help 4 Me. All thanks to them that they helped me complete my work on time at reasonable prices.

View All Reviews


Assignment Help 4 Me