top of page

Continent Comparison Dashboard

This project involves creating an Excel dashboard to analyze and compare statistics across different continents. The dataset includes information on population, area, growth rates, and world coverage for each continent. The goal is to visualize key metrics and trends to provide insights into demographic and geographic characteristics of continents.

The process of creating an Excel dashboard for continent statistics involves several key steps. First, data is collected by importing the continent statistics dataset into Excel, which includes information on population, area, growth rates, and world coverage for each continent. Next, the data is cleaned by removing duplicates, handling missing values, and standardizing formats. Following this, data exploration is conducted by calculating summary statistics and identifying trends through pivot tables. The dashboard is then created by designing an interactive layout with sections for key metrics, visualizations such as bar charts, pie charts, and line charts, and incorporating slicers and filters for user interactivity. Finally, the data is analyzed to gain insights into population distribution, area coverage, growth rates, and global representation of each continent. This comprehensive approach ensures a visually appealing and informative dashboard that provides valuable insights into the demographic and geographic characteristics of continents.

Parth Arora

bottom of page