Global Sales Performance Dashboard

Difficulty
Beginner
Estimated Time
12 Hours
Portfolio Value
Medium
Interview Value
High
Global Sales Performance Dashboard

The Business Problem

The executive team is flying blind. They don't know which product lines are profitable and which regions are losing money. They need a single pane of glass to make quarter-end decisions.

Project Overview

In this project, you will act as a Junior Data Analyst for a global retail company. Your manager has handed you a messy, raw CSV file containing years of global sales data. You need to clean it, structure it, and build an interactive dashboard that executives can use to track performance by region, product line, and time.

Step-by-Step Implementation

Follow this structured path to complete the project successfully.

1

Step 1: Download & Inspect

Download the dataset from Kaggle. Open it in Excel and identify missing values, incorrect date formats, and duplicates.

2

Step 2: Data Cleaning

Create a 'Working Data' tab. Use formulas like TRIM, PROPER, and IFERROR to sanitize the columns. Extract the Year and Month from the raw date column.

3

Step 3: Pivot Tables

Insert 4-5 Pivot Tables on a separate sheet. Calculate Total Revenue by Region, Sales by Product Category, and a Monthly Trend timeline.

4

Step 4: Visualization

Create Bar Charts, Line Charts, and a Map based on your Pivot Tables. Move all charts to a blank 'Dashboard' sheet.

5

Step 5: Interactivity

Insert Slicers and a Timeline. Connect them to all Pivot Tables so one click filters the entire dashboard.

Expected Output

A highly visual, single-page Excel dashboard with cohesive colors where clicking on a specific 'Region' slicer instantly updates all charts to reflect only that region's data.

Common Mistakes to Avoid

  • Leaving gridlines on the dashboard sheet (looks unprofessional).
  • Forgetting to select 'Report Connections' on Slicers.
  • Using pie charts with too many categories.

More Beginner Projects

Personal Finance & Budget Tracker
Available

Personal Finance & Budget Tracker

Build a highly functional personal finance tracker in Google Sheets to automate expense categorization and budget alerts.

Beginner
8 Hours
Google Sheets
Data EntryExcel Formulas+1
View Project