Prepare and clean a curated dataset

Assignment Help Database Management System
Reference no: EM132715292

DATA VISUALISATION & STORY TELLING ASSIGNMENT

1. INTRODUCTION
The goal of this assignment is to design and implement a dashboard and/or interactive visualisations that allow you to explore a given dataset. You will be involved in cleaning and preparing the data where necessary, exploring the data, designing your visualisations, and implementing your dashboard using Tableau Desktop.

This assignment constitutes 30% of your overall DV module grade. It is an individual assignment.

2. OBJECTIVES
a) Understand, prepare and clean a curated dataset.
b) Identify meaningful exploratory questions from the dataset.
c) Design a multitude of visualisations to effectively derive answers to the declarative and exploratory questions identified earlier.
d) Perform data story telling using a dashboard and/or interactive visualisations for target audience.

3. ABOUT THE DATASET
Have you ever wondered when the best time of the year to book a hotel room is? Or what is the optimal length of a hotel stay in order to get the best daily rate? The hotel_bookings.csv dataset can help you to explore and perhaps find some answers to these questions.

This data set contains hotel reservations information for a city hotel and a resort hotel, and includes information such as when the booking was made, length of stay, the number of adults, children, and/or babies, and the number of available parking spaces, among other things.

The metadata of the hotel_bookings.csv dataset is provided in the accompanying
metadata.txt file.

4. ASSIGNMENT REPORT RECOMMENDED STRUCTURE
You may use the following pointers to structure your report. You should include visuals, diagrams and/or tables where appropriate to enhance your report's readability.

1) Project Objectives
• Provide a list of primary exploratory questions you are trying to answer with your visualisation(s).
• Provide the background on why your proposed target audience or others should care.
• The questions may evolve over the course of the project. Update this part by adding or removing exploratory questions you consider necessary in the course of your analysis.

2) Data Preparation
• Describe the state of the data (e.g. is it clean, is it complete). Do you expect to do substantial data cleanup?
• How will you prepare your data so that it is suitable for exploration and analysis? Describe the steps involved in detail.
• Did you perform further research to better understand the context of the data and metadata? Elaborate on the process and describe any further findings.

3) Exploratory Data Analysis and Visualisation
• Perform univariate and multivariate analysis on your dataset.
• Using descriptive analytics techniques (i.e. statistical analysis, correlation analysis and basic visualisations etc), document your findings.
• Identify the core findings and insights that help to answer the exploratory questions identified earlier. Create the visualisations accordingly.
• What are the different visualisations you have considered? Justify the design decisions you made using visualisation and design principles.
• Describe each visualisation by highlighting the exploratory questions it answers.
• Where necessary, explain how to interpret the visualisations in order to answer the exploratory questions (e.g. interactive elements).

4) Dashboard
• From your library of visualisations created earlier, identify suitable ones to create a dashboard. Recall that dashboards should incorporate only visualisations related to one main topic.
• Depending on your exploratory questions, create multiple dashboards to aid you in performing your video recorded data story telling presentation subsequently.

Guidelines for Assignment Report
• Include all the screenshots of your visualisations and dashboards in your Report.
• Provide clear images showing the key design and interactive elements where necessary.

5. PRESENTATION AND DATA STORY TELLING
Using your dashboards and visualisations, you are required to submit a video recorded presentation to perform data storytelling and share your findings. The video recorded presentation should not exceed 5 minutes. Video recorded presentations which exceed the allotted time will be penalized.

You must record your video presentation using Microsoft Teams.

After completion of your video recorded presentation, you are required to submit the link to your video (from Microsoft Stream). Instructions to submit your video recorded presentation link are provided in the following section.

Attachment:- Assignment Specifications.rar

Reference no: EM132715292

Questions Cloud

Develop work breakdown structure : Create a project schedule that lists all of the core activities, dates (start and finish), and resources to complete your project.
Coso framework of internal controls : The COSO framework of internal controls is practiced within companies around the world.
Major components of data warehouse architecture : Explain the major components of a data warehouse architecture, including the various forms of data transformations needed to prepare data for a data warehouse.
How statement impact perceived legitimacy of companies : The following quote appeared in an article entitled 'Business and society in the coming decades', which was available on the website of McKinsey Company.
Prepare and clean a curated dataset : Design and implement a dashboard and/or interactive visualisations that allow you to explore a given dataset. You will be involved in cleaning and preparing
Cyber-attack can cause economic damage : There are a variety of ways that a cyber-attack can cause economic damage.
Blockchain Technology for HR : Use Wufoo to develop an input form using some of the key fields from your project (Blockchain Technology for HR).
Discuss in which entity control lies : The finance director is concerned that he might be required to consolidate some of these investments, pursuant to AASB 10. Details of the investment.
What technical and nontechnical barriers : What technical and/or nontechnical barriers do YOU foresee in YOUR organization when it comes to implementing IT security policies? Explain

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd