Premium project
What and Where are the World's Oldest Businesses
Use joining techniques to discover the oldest businesses in the world.
Start Project9 Tasks1,500 XP12,240 Learners
Loved by learners at thousands of companies
Project Description
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, you'll explore 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 we'll explore is contained in several different datasets. In order to understand the world's oldest businesses, we will first need to use joining techniques to merge our data. From there, we can use manipulation tools such as grouping and filtering to answer questions about these historic businesses.
Project Tasks
- 1The oldest business in the world
- 2How many businesses were founded before 1000?
- 3Which businesses were founded before 1000?
- 4Exploring the categories
- 5Counting the categories
- 6Oldest business by continent
- 7Joining everything for further analysis
- 8Counting categories by continent
- 9Filtering counts by continent and category
Technologies
SQL
Topics
Data ManipulationRichie Cotton
See More
Data Evangelist at DataCamp
Richie is a Data Evangelist at DataCamp. He has been using R since 2004, in the fields of proteomics, debt collection, and chemical health and safety. He has released almost 30 R packages on CRAN and Bioconductor – most famously the assertive suite of packages – as well as creating and contributing to many others. He also has written two books on R programming, Learning R and Testing R Code.