Reference no: EM132623230

ICT601 Business Analytics - Murdoch University

Part A: Data Analysis

AirBnB is a company that facilitates short-term rentals (for more information about the company.

You have been provided with a spreadsheet that lists all of the properties that it lists for rent through Airbnb in Western Australia. You have also been provided with a listing of all of the bookings currently recorded for the final three months of 2020. The metadata for these two sheets is listed below.

You have been asked by the Westralian Tourism Commission to analyse this data in order to assist them with capacity planning for their various tourism attractions.

More specifically, the Tourism Commission wishes to know the following:
1. Top 10 localities by number of properties listed
2. Overall nights booked between October and the end of 2020 and how they change from week to week
3. Comparison of Metropolitan and Regional nights booked between October and the end of 2020 and how it changes from week to week
4. Map showing number of bookings in postal codes where there are at least 100 nights booked Oct-Dec 2020
5. Total income for properties in Broome (and surrounding areas) - postcode 6725
What you have to do:
1. Analyse the dataset using Tableau and determine the answers to each of the questions above.
2. You should create at least one visualisation for each question that will help to illustrate how you arrived at the answer you did.

Asking Questions:

There will undoubtedly be things about this assignment you are not clear about. If that is the case, then you should ask a question! There will be an Assignment Discussion Forum on LMS where you can ask questions. If you do not feel comfortable asking a question in this environment, then please email your question to [email protected] Please try to be as clear as possible as to what it is you are asking. In that way, we will be more likely to be able to help you.
What you need to submit:

1. A Word document that includes the answers to the questions above. Each answer should have a brief explanation as to how you determined the answer and one or more visualisations (copied and pasted from Tableau) that illustrate the answer.
a. Each visualisation you copy into your Word document must have something that identifies the visualisation as being your work, for example:

2. A Tableau file that includes the visualisations you created in order to answer the questions. Please ensure that the Tableau sheets are named in such a way that it is clear as to which question is being answered. For example:

This part of the assignment is worth 50 marks, and will be marked thus:

Each of the five questions is worth 8 marks each:
- Answer
o Textual explanation
o Visualisation
• Appropriateness
• Design
- Explanation of process

Tableau file is worth a further 10 marks:
- Correct import of data file
- Correct set up of data file
- Inclusion of visualisations

About the data (metadata)
The datafile is called ICT601 Assignment 01 Data.xlsx. It contains two sheets, one called Bookings and one called Properties.

Part B: Analytics Platform Report

Select one Analytics and Business Intelligence Platform (not Tableau) from the list at:

Prepare a report on its capabilities. You should use sources external to the vendor as much as possible (and, of course, include the references for all sources to which you refer).

The report should be 1000 words in length (not including references) and should, at a minimum, include detail about what platform you investigated, what you found out about it, scenarios in which the platform is seen to perform well, and those where it might not be an appropriate choice.

Attachment:- Assignment Data.rar