Business analytics

This assignment will required you to go through the full data analysis cycle from looking for the data to then validate the quality of the data. you cleanse the data then you transform the data into the format that is easy to work with. then you will analyse the data, visualise the data.

Aside from the STR data, you also required to look for some maybe other qualitative data or other information about the Miami markets. what are the data that can be good to cross analysis with the STR data because STR data typical hotel performance data in terms of their occupancy the ADR and the RevPAR, however this is not enough to tell us exactly what happened in Miami in terms of why people come to Miami, how many arrivals international, domestic. Are there any specific events conventions that has happened in the markets that has high demand to hotel rooms etc.

The portfolio is divided into 5 sections. each sections are 2 pages maximum. if you didn’t use a whole 2 pages some section it can be use for another section. e.g. section 1 you use only 1 page section 2 you might want to write more you can use 3 pages for that section.

section 1– if there are specific thing you want to comment on. you can screenshot of that specific section of that dataset and then do annotate. not the whole dataset just the example.

section 2- cleaning the data. demonstrate different methods of techniques that you have decided and applied to prepare your dataset for cleansing. The data need to demonstrate how you identify e.g. duplicate mistakes why you need to remove certain columns etc.

-Focusing on how the data are cleansed and how the data has been transformed ready to be analysed. do a screenshot of what you did and do annotation to show what other steps has been done.

section 3-it is about analysing the data, so demonstrate how the data analyse are analysed explaining what’s the approaches what’s the techniques and what other models, you have adopted in your analysis. say what you have done and why that has been done.

section 4– choose different charts, graphs etc. to visualised your result. demonstrate to us why these things, has been selected e.g. Why you choose a pie chart rather than a bar a bar chart.

section 5– reporting key finding. don’t need to repeat your visualisation again but can refer back to those charts