Interactive-Sales-Dashboard
Joseph Uyana
Sales Data Cleaning and Dashboard Project
Project Overview
This project involves generating messy sales data, cleaning it, and creating a dashboard to visualize key business metrics. The goal is to simulate real-world data issues, apply data cleaning techniques, and present insights through a visually appealing dashboard.
Features
Messy Data Generation: Creates synthetic sales data with missing values, duplicates, and inconsistencies.
Data Cleaning: Processes and cleans the messy dataset to make it suitable for analysis.
Dashboard Creation: Generates key business metrics and visualizations.
Project Structure
Getting Started
Prerequisites
Ensure you have Python installed along with the required libraries:
Running the Project
Generate Messy Data
Run the following command to generate a dataset with errors: This creates
messy_sales_data.csv.Clean the Data
Run the cleaning script to remove duplicates, handle missing values, and correct inconsistencies: The cleaned data is saved as
cleaned_sales_data.csv.Analyze and Visualize
Use
cleaned_sales_data.csv to create visualizations and dashboards.Dashboard
The dashboard visualizes:
Monthly sales trends
Revenue breakdown by product
Sales distribution by region
Profit margin and growth
The dashboard was built in Power BI and is available in the
Dashboard folder as Interactive_Sales_Dashboard.pbix.Contribution
Feel free to contribute by improving the data cleaning process, adding new visualizations, or enhancing the dashboard.
Like this project
Posted Mar 20, 2025
This project generates messy sales data, cleans it, and visualizes key business metrics using an interactive Power BI dashboard.
Likes
0
Views
1
Timeline
Feb 20, 2025 - Mar 16, 2025
