Excel/CSV Sales Data Cleaning & Dashboard

A client-ready Streamlit application that transforms messy Excel or CSV sales files into cleaned data, a data-quality report, business KPIs, and an interactive dashboard.

Live Demo

Try the deployed application:

Open the Excel/CSV Sales Dashboard

Screenshots

Data Quality Report

KPI Dashboard

Interactive Sales Charts

Cleaned Data and Downloads

Features

• Upload CSV, XLSX, or XLS files
• Standardize column names
• Detect missing required columns
• Remove empty and duplicate rows
• Parse dates and numeric fields
• Show a data-quality audit
• Filter by date, region, category, and product
• Calculate sales and profit KPIs
• Display interactive Plotly charts
• Download cleaned and filtered results
• Automated tests for cleaning and KPI logic

Required input fields

Order Date, Order ID, Product, Category, Region, Quantity, Sales, Profit

Run locally

python -m venv .venv

Windows PowerShell:

.venv\Scripts\Activate.ps1
pip install -r requirements.txt
streamlit run app.py

Run tests:

pytest

Deploy

Push the repository to GitHub, create a new Streamlit Community Cloud app, and set app.py as the main file.

Portfolio deliverables

• Public GitHub repository
• Live Streamlit demo
• Sample dataset
• Screenshots
• Reusable source code
• Setup instructions

Limitations

The input must contain the required business fields. Complex company-specific rules may require additional configuration.