DEV Community

Cover image for Exploratory Data Analysis Using SQL.
Theophilus1320
Theophilus1320

Posted on • Edited on

Exploratory Data Analysis Using SQL.

INTRODUCTION
In this project, I carried out an exploratory analysis on Internet Usage around the world. The dataset contains records of Internet Users of ALL the countries in the world as of 2018.
The dataset contains columns like Country, Internet Users, Population and Percentage.
Using SQL, I was able to run some queries through the dataset and get answers to some questions and also to get insights.

DATA PREPARATION AND CLEANING.
The dataset was first loaded into Microsoft Excel in order to “clean” the dataset, rename the columns, remove outliers and to check for consistency in the dataset.
Here is a picture of the dataset in Microsoft Excel:

Image description
A database was then created in MYSQL, and the dataset was imported into the SQL workbench in order to begin analysis.
Picture of the dataset after being imported into the SQL workbench:,

Image description
ANALYSIS:
Analysis was done to get answers to some very important questions and to get an understanding of the dataset.

1)Total sum of Internet Users in the entire world:

Image description
The query above shows the total number of internet users in the entire world is 3,663,346,115. as of 2018.

2)Country with the highest number of Internet Users:

Image description
China has the highest number of internet users in the world.
with 765,367,947 users.

3)Country with the Lowest number of internet users:

Image description
Ascension has the lowest number of internet users in the world, with just 361 users. It is a volcanic island located in the Atlantic Ocean, with a total population of only 806 people.

4)Top Five Countries by number of Internet Users:

Image description
China, India, United States, Brazil and Japan have the highest number of internet users in the world.

5)Bottom five countries by number of internet users:

Image description
Ascension, Niue, Wallis and Futuna, Montserrat and Falkland Islands have the lowest number of internet users in the world.

6) Difference In Internet Users Between the Country with Highest and Lowest Users:

Image description
There is a significant difference of 765,367,586 between the countries with the highest and lowest number of internet users.

7)Country with the Highest Percentage of Internet Users:

Image description
Andorra has the highest percentage of Internet users, at 99%

8) Country with the Lowest Percentage of Internet Users:

Image description
Eritrea has the lowest percentage of internet users in the world, at 1%

9) Country With the Highest Ratio of Internet Users to population:

Image description
The Falkland Islands, with a total population of 2,910 and 2,881 internet users, have the highest ratio of internet users to population, at 99%.

10)Correlation Between Internet Users and Population:

Here, I wanted to determine if there is any correlation or relationship between a country's population and the number of internet users.
Image description
The query revealed a correlation coefficient of 0.9. This indicates a strong positive association, suggesting that countries with larger populations tend to have more internet users.

Image of Timescale

Timescale – the developer's data platform for modern apps, built on PostgreSQL

Timescale Cloud is PostgreSQL optimized for speed, scale, and performance. Over 3 million IoT, AI, crypto, and dev tool apps are powered by Timescale. Try it free today! No credit card required.

Try free

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more

👋 Kindness is contagious

Immerse yourself in a wealth of knowledge with this piece, supported by the inclusive DEV Community—every developer, no matter where they are in their journey, is invited to contribute to our collective wisdom.

A simple “thank you” goes a long way—express your gratitude below in the comments!

Gathering insights enriches our journey on DEV and fortifies our community ties. Did you find this article valuable? Taking a moment to thank the author can have a significant impact.

Okay