The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
This is a retail sales and profit dashboard I built from scratch to turn complex spreadsheet data into easy-to-read visuals. The main goal of this project was to make a messy dataset meaningful so a business owner can instantly check how their store is performing.
Here is how I worked on this project:
Data Cleaning: I went through the entire raw file in Excel, filtered out bad entries, and organized the rows to make sure the dashboard numbers are completely accurate.
KPI Tracking: I used Excel formulas to pull out core business metrics, such as total revenue, total orders, and the overall profit margin (12.47%).
Designing Charts: I set up clean visuals to show key trends, like sales by shipping modes, customer segments, and a breakdown of top-performing products.
I also added dynamic slicers, so you can click on any region or year and the whole screen updates automatically. I handled this entire project manually from start to finish.
Tools used: Advanced Excel (Pivot Tables, Slicers, Formulas, Dashboard Design)
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Trending
retrofuturism
Share your favorite designs from the past exploring the distant future. Or your own take on the aesthetic 🚀
halftone
Dots. Texture. Grain. Let's see your designs using the halftone technique.
Midjourney
Creatives are showing off what they're making with Midjourney.
colorgrade
Video editors sound off: How do you enhance the mood of your video in color grading?
Related posts
UI Dashboard screen explorations with a different type of dither for expressing scale
amazing work Praveen
Data Cleaning, Analysis & Professional Dashboard
Transformed a raw business dataset into a clean, structured, and analysis-ready report using Microsoft Excel and Power Query.
Work Completed
Cleaned and standardized raw data
Removed data inconsistencies and formatting issues
Transformed and organized data using Power Query
Prepared the dataset for accurate analysis
Created Pivot Tables to summarize key business metrics
Analyzed bookings, revenue, and number of days
Designed a professional interactive Excel dashboard
Presented key KPIs and insights in a clear, easy-to-understand format
Structured the final report to support business decision-making
Skills Used
Microsoft Excel · Power Query · Data Cleaning · Data Transformation · Pivot Tables · Dashboard Design · Data Analysis · KPI Reporting
Outcome
Converted unstructured raw data into a clean analytical dataset and professional dashboard, making important business information easier to understand, monitor, and use for decision-making.
