An important part of business is planning for the future and ensuring that the business survives changing market conditions. Some businesses do this remarkably well and last for hundreds of years. In this project, I explored data from BusinessFinancing.co.uk on the world's oldest businesses: when were they founded, and which industries do they belong to?
Like many business problems, the data is contained in several different datasets. In order to understand the world's oldest businesses, I used joining techniques to merge the data. From there, we applied manipulation tools such as grouping and filtering to answer questions about these historic businesses.
- The oldest business in the world
- How many businesses were founded before 1000?
- Which businesses were founded before 1000?
- Exploring the categories
- Counting the categories
- Oldest business by continent
- Joining everything for further analysis
- Counting categories by continent
- Filtering counts by continent and category