Subject Code : B9DA102
Assessment Task:
B9DA102: Data Storage Solutions for Data Analytics Report Writing Assessment Answer 

Following is the breakdown of tasks allocated for this assessment.

1. Develop a proof of concept data warehouse / data mart using dimensional modelling by capturing data from an existing data source(s). Preferably do not use North-wind database as it will be used for demonstration purposes during lectures. Document your reasons for selecting the subject area(s), identify key stakeholders, formalise the vision and goals and requirements for developing the data warehouse

2. Develop and present a suitable schema for the data warehouse. Discuss your reasons for the design. 

3. Using Microsoft SQL Server, implement your tables and extract, transform and load data from the operational source(s) into the data warehouse. This can be done using any available tool such as SSIS or by writing SQL statements. 

4. Produce four reports in support of the requirements outlined in section 1 using suitable tool(s) (SSRS and / or Tableau). Also produce four visualisations using suitable tool(s) (R and/or Python and/or Tableau / PowerBI) and discuss

5. “A good data warehousing professional is always scouting for new sources of data that can be applied to business intelligence … Plus, analysis can be richer and more open ended if you work with original XML documents, the same way you’d work with any detailed source data”. In this spirit and to enhance an understanding of XML, develop an XML Schema based on the data warehouse data that a cube may capture and apply it to develop an XML document.

6. Implement a part of your source database or data warehouse as graph database using Neo4j technologies. Discuss the use of graph databases in comparison to relational databases.

 

This B9DA102: Report Writing Assessment Answer has been solved by our Report Writing 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 : Noah
  • Posted on : December 03rd, 2018

Whatsapp Tap to ChatGet instant assistance