Ana André, Laura Wuerz
Data Squad 21, Lisbon 20.09.2019
For this project, we put ourselves on the shoes of a consulting data team who was hired by a wealthy expanding hotel chain. The CEOs need data support to decide the location of a new hotel to be built in Europe. Sleepy Hotel Group owns medium-sized (25-99 rooms) hotels all over the world that offer accomodation in the low-mid price range. To help them, we went to the Eurostat Tourism Database and gathered the information we needed for our analysis and to create meaningful dashboards for decision making on the new hotel's location.
Criteria to choose the new hotel's location:
- Ocupation rate;
- Spending on hotel accomodation;
- Size of the existing hotels.
We used 3 different datasets:
- Net occupancy rate of bed-places and bedrooms in hotels and similar accommodation (NACE Rev. 2, I, 55.1) (from 2012 onwards)
- Hotels and similar accommodation (NACE Rev.2, I, 55.1) by size class: number of establishments, bedrooms and bed-places (from 2012 onwards)
- Expenditure on accommodation (from 2012 onwards) All our dataset where gathered on Eurostat database for Tourism.
Before starting to look for data, we put together a case scenario to narrow our data search. Dealing with the data was a very straightforward process: we found the data in Eurostat and explored the datasets to check if they suited our purposes. All our data cleaning and manipulation was done either on pandas (most of it) or excel. Before getting our hands on Tableau, we sketched some visualizations to be sure that we had all the data needed to create the dashboards. On our tableau workbook, we created our visualizations and built our dashboards and story. Finally, we drew some results and conclusions.
We used Trello to lay out a plan and keep track of all the actions we needed to perform to have the project ready on time.