This week we welcome our early dashboard week due to the change of schedule. On the first day, we are asked to choose a topic and build a dashboard based on the Melbourne city Census of Land Use and Employment (CLUE) data.
Seeing that the latest data is taken from 2019, before the covid-19 pandemic, it reminds me of the old days when many industries were not severely affected by the pandemic. Apparently, if you started a business in an industry severely disrupted by the epidemic in 2019, such as the catering industry, you will suffer heavy losses. But if covid did not happen, is this a bad choice? I decided to build a dashboard to see if it would be good to open a pub in Melbourne in 2019 if there is no covid.
From the dashboard, you can see that starting in 2002, the number of bars in Melbourne increased to the peak in 2016 and then dipped to a local bottom in 2018. The growth curve was flattening. Perhaps investing in bars in 2019 is not a good idea. However, as can be seen from the divergent bar chart, starting from 2017, the number of newly opened bars has increased, and the number of closed bars has shown a downward trend. Combined with the continuously growing population forecast (get the data), there is still room for optimism in opening new bars in 2019.
The dashboard also allows you to explore the suburbs in which to open your pub. From the perspective of population growth, Port Melbourne seems to be the best choice to open a bar. However, as you can see, the data shows that the forecasted number of people aged 20 to 69 in Port Melbourne in 2019 is only 10 people (the population was collected in 2016). I don’t think this is a correct number, so we need to use this population data with caution.
If you want to explore your competitors, you can also click on a bar to see more details.
If you are interested in the dashboard, you can find it here.