B9DA111: Data Storage Solutions for Data Analytics - IT Computer Science Assignment Help

Assignment Task

Details of Assignment brief
Following is the breakdown of tasks allocated for this assessment.
1. Data Warehouse is developed to obtain business intelligence from data. Develop a proof of concept data warehouse/mart (using dimensional model) capturing data from an existing data source(s). Document your reasons for selecting the subject area(s), identify key stakeholders, formalise the business vision for developing the data warehouse from the given data source. Also explain the insights that a company may attain from the given data. It should be reflected in the reports and visuals.
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 SSIS or by writing SQL statements.
4. Produce four reports in support of the requirements outlined in section 1 using SSRS. Also produce four visualisations using Tableau and discuss them. Develop a dashboard in Tableau to show the visuals.
5. Multiple studies have been done comparing the performance of graph databases and relational ones. Use a relational database such as Adventure Works (or you can use any other relational database of your choice) as data source and implement a graph database in Neo4J. Write any seven queries in SQL and CQL to use as evidence to compare both databases and discuss the results to demonstrate the differences of storing/retrieving data in/from relational and graph databases. Note: These queries must provide useful information from the database.
6. Overall report including references/bibliography.
7. Individual Contribution Report
o Every student must write an individual contribution report based on the reflection of learning. You must also write about your contributions to this work. Word count: 500

This B9DA111-IT Computer Science Assignment has been solved by our IT Computer Science Experts at My Uni Paper. 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 Turn tin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.