Furniture Sales Dashboard Development

Adewale

Adewale Adeyemi

📊 Case Study: Furniture Sales Dashboard (Excel)

🔹 Client Goal / Project Brief

A retail furniture company wanted to better understand its sales performance, shipping trends, and regional distribution across the United States. The client needed an interactive, visually appealing dashboard built in Excel to present key insights to stakeholders.

🔹 Tools Used

Microsoft Excel (Power Query, Pivot Tables, Pivot Charts, Slicers)
Custom Number Formatting
Conditional Formatting
Chart Styling & Layouts
Iconography and Shapes

🔹 Outcome

Client gained a clear overview of what categories were performing, where orders came from, and how shipping impacted delivery times.
The dashboard became a key tool for quarterly reporting and marketing strategy.

🔹 Skills Demonstrated

Data cleaning & modeling
Chart selection & customization
UX-focused dashboard layout
Interactive elements (slicers)
Storytelling with data

🔹 Want Something Similar?

If you're a business owner looking to turn raw sales data into a dashboard that tells a story and drives decisions, I'm here to help.
Like this project

Posted Jun 22, 2025

Developed an Excel dashboard for a furniture company to analyze sales and shipping trends.