Data Storage Solutions for Data Analytics
MSc in Data Analytics
Assessment Brief
- Module Title: Data Storage Solutions for Data Analytics Module Code: B9DA102 Module Leader: Dr Shazia A Afzal Stage (if relevant): Award Assessment Title: Design and Development of data storage solutions for analysis Assessment Number (if relevant): 1 Assessment Type: Lab Work and Report Restrictions on Time/Length : +/- 10% N/A Individual/Group: Group Assessment Weighting: 40% for the report including technical work and 20% for Presentation Issue Date: Week 4 Hand In Date: Week 11 (17th April 2021) Planned Feedback Date: TBC Mode of Submission: Online via Moodle
AssignmentTutorOnline
Every student must submit their assignment on Moodle on or before the due date.
Assignments will not be accepted via Email.
Details of assignment brief
Total: 100 Marks (weighting: 40%)
Following is the breakdown of tasks allocated for this assessment.
- 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.
(11 marks)
Note: Use data sources other than Kaggle (if possible)
- Develop and present a suitable schema for the data warehouse. Discuss your reasons for the design.
(15 marks)
- 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.
(14 marks)
- 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.
(20 marks)
- Multiple studies compare the performance of graph and relational databases. Use any relational database such as Adventure Works as data source and implement a graph database in Neo4J. Write any seven queries in SQL and CQL to use as an 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.
(20 marks)
- Overall report including references/bibliography.
(10 marks)
- Individual Contribution Report
- 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: 600 (10 marks)
Note: Use font: Calibri, font-size: 12, 1.15 line spacing.
Presentation (20%)
Presentations will be held in the week 12 at the allocated times
Time allowed: 15 minutes +- 2 minutes
Every group member has to present.
At the time of presentation, all projects/code must be ready for demonstration. Q/A session may need more time so be prepared.
(Marks will be deducted for time taken more than the allocated time).
Marks Breakdown
| Visual Appeal | No errors in spelling, grammar and punctuation. Clear and concise information on each slide. Visually appealing/engaging. | 5% marks |
| Comprehension | Extensive knowledge of topic. Complete understanding of assignment. Accurately answering all questions posed. | 5% marks |
| Presentation Skills | Engaging with audience and getting audience’s attention. Appropriate speaking volume & body language. Prepared and rehearsed. | 5% marks |
| Content | Concise summary of the topic. Comprehensive and complete coverage of information. | 5% marks |
Deliverables:
- Report (Microsoft Word) including
- Source of Data
- Vision and Business Requirements for the Development of Data Warehouse (First Part)
- Data warehouse Design (produced in Visio or in a similar system)
- Data Warehouse (development scripts) as Appendix
- ETL (project screenshots and project OR SQL code)
- Visualisations.
- Explanation of every section
- References/Bibliography
- SSRS Reports (pdf/excel) – must be include in the submission
- SSIS Project – must be included in submission
- All queries including SQL and CQL, Neo4j screen shots and explanation – must be included in submission
- Presentation slides
- Individual Contribution Report
General Assessment Submission Requirements for Students:
- Online assignments must be submitted no later than the stated deadline.
- All relevant provisions of the Assessment Regulations must be complied with.
- Extensions to assignment submission deadlines will be not be granted, other than in exceptional circumstances. To apply for an extension please go to http://www.dbs-students.com/Registrar/ and download the Assignment Extension Request Form.
- Marks will be deducted for late submissions.
- Students are required to retain a copy of each assignment submitted, and the submission receipt.
- Assignments that exceed the word count will be penalised.
- Students are required to refer to the assessment regulations in their Student Guides and on the Student Website.
- Dublin Business School penalises students who engage in academic impropriety (i.e. plagiarism, collusion and/or copying). Please refer to the attached referencing guidelines for information on correct referencing.
What is referencing and why is it necessary?
Please follow this link to the Harvard Style Referencing Guide – all referencing is required in this format.