Skip to main content
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 XP

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

  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

Technologies

SQL SQL

Topics

Data Manipulation
Richie Cotton Headshot

Richie 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?

I've used other sites—Coursera, Udacity, things like that—but DataCamp's been the one that I've stuck with.

Devon Edwards Joseph
Lloyds Banking Group

DataCamp is the top resource I recommend for learning data science.

Louis Maiden
Harvard Business School

DataCamp is by far my favorite website to learn from.

Ronald Bowers
Decision Science Analytics, USAA