Top Visited Websites 

1. Prepare 

1.1 Source: https://www.kaggle.com/datasets/thedevastator/the-top-websites-in-the-world?resource=download

1.2 About the Data:

One CSV file of less than an MB was available.

2. Process

2.1 Tools Used:

Google Sheets

SQL BigQuery

Tableau

2.2 Data Cleaning and Sorting:

The column ‘Category’ consisted of the main category and sub category.

This column was split and another column was made for the sub category. 

The ranking order was arranged from 0 - 49 to 1 - 50

by formula =A2 + 1 (output is 2) in Google sheets

(Note: - A2 is 1)

3. Analysis 

3.1 Creating new table for Main category 

3.2 Creating a new table for Sub-Category

4.Share

4.1 Most Popular Main Category 

1.   We can see that 48% of the top 50 websites across globe are in Computers Electronics and Technology

2.   News and Media Publishers are 16%

3.   2% are Science and Education and Travel and Tourism

4.2 Popular Sub-Category 

1.   Social Media and Networks is 30%, which is the most popular sub-category from the top 50 websites.

2.   Followed by Search Engines, which is 13%.

3.   One of the least popular are Animation & comics and Accommodation & Hotels with only 2.78% visits.

4.3 Countries with Top 50 Websites

From top 50 websites across world, 30 websites are based in United States, followed by Russia with 5 websites and China with 4.

Based on the above information, we can conclude that:
1. US have dominance in the global website landscape. 
2. It grants the US an influential voice on the internet.
3.  It allows US-based platforms to shape online discourse and influence public opinion on a global scale.
4.  Helps in building a positive brand image and reputation for American companies.

These are few advantages US have for having most popular websites around the globe.