Top Ranking Institutions and Where to Find Them

The Aim of this blog:

The aim of this blog is to showcase what I have achieved on the Fourth day of the dashboard week.

What did I build:

C:UsersEricShangVideosThe Data SchoolDay 4 - GLOBAL 2000 LIST BY THE CENTER FOR WORLD UNIVERSITY RANKINGS2021-09-02 22_23_35-GLOBAL UNIVERSITY RANKINGS Dashboard_ Top Ranking Institutions and Where to Find.png

The dashboard I build is designed to find the best institution by subject and quality of the institution.

The data set that we used for day 4 of dashboard week is the GLOBAL 2000 LIST BY THE CENTER FOR WORLD UNIVERSITY RANKINGS, which I web scraped from from the cwur.org website.

What’s different about this challenge is that, we need to build the Tableau Dashboard on our Tableau server, instead of using Tableau Desktop.

To prepare the data for virtualization.

Firstly, I had to do parse the web scraped data.

Since there are two different pages that I need to web scrap, I had to do the same process twice.

Then, It’s a matter of uploading data source to our data school’s Tableau Server and build my Dashboard there.

The Dashboard in Action:

GLOBAL 2000 LIST BY THE CENTER FOR WORLD UNIVERSITY RANKINGS Dashboard in action

The Dashboard is used as shown above.

To start, the user need to select the Subject that they are interested in studying.

This will filter the Institutions, and list the top 10 institution for that subject.

Which is the left part of the wing chart.

The the user may filter to options such as Quality of Educations and Research Performance.

This will generate the right wing of the chart.

By observing the changing in ranking, this dashboard hopes to help the user find the best Institution that they can attend.

What Tool did I use in Alteryx ?

C:UsersEricShangVideosThe Data SchoolDay 4 - GLOBAL 2000 LIST BY THE CENTER FOR WORLD UNIVERSITY RANKINGS2021-09-02 22_55_05-Alteryx Designer x64 - GLOBAL UNIVERSITY RANKINGS By Subjects.yxmd.png

I started my workflow with Downloading the web page and then Text to Columned the downloaded data using Tab as a delimiter.

C:UsersEricShangVideosThe Data SchoolDay 4 - GLOBAL 2000 LIST BY THE CENTER FOR WORLD UNIVERSITY RANKINGS2021-09-02 22_58_00-Alteryx Designer x64 - GLOBAL UNIVERSITY RANKINGS By Subjects.yxmd.png

After finishing Splitting the the downloaded column in to different rows.

I move to parse the HTML web page using a combination of sample Tool, Regex and Text to Column.

C:UsersEricShangVideosThe Data SchoolDay 4 - GLOBAL 2000 LIST BY THE CENTER FOR WORLD UNIVERSITY RANKINGS2021-09-02 23_01_28-Alteryx Designer x64 - GLOBAL UNIVERSITY RANKINGS By Subjects.yxmd.png

Because there was a break up in format for two of the Institutions for Ornithology.

I had to separate it out from the rest of the data parsing workflow, and build a separated branch for it specifically and join it back to the others afterward.

C:UsersEricShangVideosThe Data SchoolDay 4 - GLOBAL 2000 LIST BY THE CENTER FOR WORLD UNIVERSITY RANKINGS2021-09-02 23_06_08-Alteryx Designer x64 - GLOBAL UNIVERSITY RANKINGS By Subjects.yxmd.png

After everything is finished, then it’s simply a matter of Cross Tab and output the Data.

But this is only half of the work done.

C:UsersEricShangVideosThe Data SchoolDay 4 - GLOBAL 2000 LIST BY THE CENTER FOR WORLD UNIVERSITY RANKINGS2021-09-02 23_09_25-Alteryx Designer x64 - GLOBAL WORLD UNIVERSITY RANKINGS - Top 2000.yxmd.png

C:UsersEricShangVideosThe Data SchoolDay 4 - GLOBAL 2000 LIST BY THE CENTER FOR WORLD UNIVERSITY RANKINGS2021-09-02 23_12_11-Alteryx Designer x64 - GLOBAL WORLD UNIVERSITY RANKINGS - Top 2000.yxmd.png

And this is the second half.

Since it’s very similar to the first workflow.

The only difference been the same tools been used differently.

I won’t go into too much details.