Airbnb Case Study


The purpose of the SQL case study is to create a real life experience of how airbnb home rentals performs in a neighbourhood. And if someone we’re looking to either use their home or invest in a rental property for this purpose, what kind of property should it be? By using their open-source data I’m able to write a script based on what kind of practical questions someone would answer and go through. Consider it a step to being proactive other than qualitative discussions with your neighbour, friends or reading reviews. This will be converted into answers and visualized on Tableau for the time being kindly enjoy.

                                                                                             What is the total of bookings in Edinburgh per quarter/year etc?

                                                                                                                  What neighbourhood has the most bookings?

                                                                                                                           What property has the least bookings?

                                                                                                                        What property has the most availability? Least demand?

                                                                                                                      How many rooms should I get/have?

                                                                                                                    How many nights should I post my listing for booking?