World's Ranked Universities

Case study

World's Ranked Universities

The Question

I am working with this dataset (QS World ranked Universities (2018-2022) | Kaggle) from Kaggle about the ratings of universities around the world from 2018 until 2022.

The questions I will try to answer is :

1.      Which are the top 10 universities per year?

2.      Are there Universities that are consistently on the top ranks the past 5 years?

Team meeting

Cleaning

I downloaded the dataset and uploaded it on BigQuery.

The dataset seems pretty clean but I see that some universities are not ranked and a Country name is missing, so I use this query to view and save only the universities that have a rank and a Country:

There are 5.029 rows left

Some universities have been ranked twice in the same year. I don’t know why this happens and I don’t want to alter the points because this will change the universities rank. So, I will leave this information like that.

 I saved the last table locally as a csv file.

Then I uploaded the dataset in Tableau and created this visualisation that shows the map with the universities and their points.

Hero section image

Analysis

To see the top ranked universities i wrote this query:

I repeated for years 2019-2022. The results are shown in the table on the left,

Hero section image

Conclusions

 

We see that the last 5 years Harvard University is on the first place, University of Oxford is on the second and University of Cambridge is on the third. Top Universities are also Stanford University, Johns Hopkins University, Massachusetts Institute of Technology (MIT) UCL and Karolinska Institutet.