Build This Project · Portfolio Guide

Sales Analytics Dashboard for Your Data Analyst Portfolio

SECTION 01Project overview

Here's what you'll build in this project:

• Business problem: A retail company wants to understand its sales performance across regions, products, and time periods.
• Your solution: An interactive dashboard that shows sales trends, top products, regional performance, and actionable insights.
• Tools: Choose Tableau, Power BI, or Python (Streamlit/Dash) — you can use any tool you're comfortable with.
• Outcome: A portfolio-ready dashboard that demonstrates data analysis, visualization, and business storytelling.

SECTION 02Data source

Here are the best data sources for this project:

SECTION 03Data preparation

Here's how to prepare your sales data:

import pandas as pd

# Load data
df = pd.read_csv('sales_data.csv')

# Check for missing values
df.isnull().sum()

# Convert date column
df['order_date'] = pd.to_datetime(df['order_date'])

# Create new columns
df['year'] = df['order_date'].dt.year
df['month'] = df['order_date'].dt.month
df['revenue'] = df['quantity'] * df['unit_price']

# Group by region
region_sales = df.groupby('region')['revenue'].sum().reset_index()

-- SQL data preparation
SELECT 
    region,
    DATE_TRUNC('month', order_date) AS month,
    SUM(quantity * unit_price) AS revenue,
    COUNT(DISTINCT customer_id) AS customers,
    SUM(quantity) AS units_sold
FROM sales
WHERE order_date >= '2023-01-01'
GROUP BY region, DATE_TRUNC('month', order_date)
ORDER BY region, month;

SECTION 04Dashboard design

Here are the key elements your dashboard should include:

SECTION 05Storytelling with data

Your dashboard should tell a story. Here's how:

• Start with the big picture: Show overall revenue and key metrics.
• Highlight trends: Are sales growing? Which months are strongest?
• Show regional differences: Which regions are performing best? Why?
• Identify top products: What are your best-selling products?
• Provide actionable insights: What should the business do differently?

SECTION 06Portfolio presentation

Here's how to present your project to employers:

• GitHub: Upload your code, data preparation scripts, and dashboard file.
• README: Write a clear README with project overview, tools used, and key insights.
• Screenshots: Add screenshots of your dashboard and key visualizations.
• Live demo: If possible, host a live version of your dashboard (Tableau Public, Power BI Service).
• LinkedIn post: Share your project on LinkedIn with a brief explanation.

SECTION 07Interview Q&A — sales dashboard project

SECTION 08Test yourself — sales dashboard project quiz

SECTION 09Frequently asked questions

SECTION 10Related reads