Skip to main content
HomeSQLWhat and Where are the World's Oldest Businesses
Premium project

What and Where are the World's Oldest Businesses

Use joining techniques to discover the oldest businesses in the world.

Start Project
9 Tasks1,500 XP13,287 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 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

  1. 1
    The oldest business in the world
  2. 2
    How many businesses were founded before 1000?
  3. 3
    Which businesses were founded before 1000?
  4. 4
    Exploring the categories
  5. 5
    Counting the categories
  6. 6
    Oldest business by continent
  7. 7
    Joining everything for further analysis
  8. 8
    Counting categories by continent
  9. 9
    Filtering counts by continent and category




Data Manipulation
Richie Cotton HeadshotRichie Cotton

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.
See More


What do other learners have to say?