I analysed an office‑supplies dataset in Excel to understand sales performance across products, categories, regions, and customer segments. My goal was to clean the data, build pivot‑table summaries, and design a dashboard that presents the most important insights clearly and visually.

I built pivot tables to analyse sales by product, category, region, and customer segment.

I grouped products and categories to make comparisons clearer and easier to interpret.

This gave me a structured foundation for building the dashboard.

How I Presented the Dashboard

I designed the dashboard to highlight the most important insights at a glance.

• I placed key KPIs at the top, such as total sales, total profit, number of orders, and average order value.

• I used bar charts to show top‑selling products and the most profitable categories.

• I added slicers for region, category, and customer segment so users can explore the data interactively.

• I used colour‑coding to separate categories visually and make trends easier to spot.

• I included a time‑series chart to show how sales change across months or years.

• I added a profit‑by‑category visual to highlight which areas drive the most value and which may need attention.

The dashboard provides a clean, simple way to explore office‑supplies performance from multiple angles.

Key Insights

Category Performance

• Technology and Furniture often generate the highest revenue, driven by high-value items such as printers, chairs, and desks.

• Office Supplies tends to have high order volume but lower profit margins due to lower-priced items and frequent discounts.

• Profitability varies widely across categories, showing where the business earns the most and where margins are weaker.

Product‑Level Insights

• A small number of products typically drive a large share of total sales.

• Some products show high sales but low profit, indicating heavy discounting or low margins.

• Other products have lower sales but strong profitability, making them valuable despite lower volume.

• Identifying these patterns helps highlight which products should be promoted, discounted, or reviewed.

Regional Trends

• Certain regions consistently outperform others in both sales and profit.

• Some regions show high sales but low profitability, suggesting higher discounting or higher shipping costs.

• Regional slicers help reveal where demand is strongest and where performance is weaker.

Customer Segments

• Business customers often generate higher revenue per order due to bulk purchases.

• Consumer segments may place more frequent but smaller orders.

• Segment analysis helps identify which groups drive the most value and which may need targeted marketing.

Time‑Series Patterns

• Sales often show seasonal patterns, with peaks during back-to-school periods or end‑of‑year office restocking.

• Profitability may fluctuate depending on discount cycles or promotional periods.

Tracking these trends helps forecast demand and plan inventory. 

Summary

This Excel dashboard project demonstrates my ability to clean and structure data, build pivot-based analyses, and design a clear, interactive dashboard. The final output highlights sales performance across products, categories, regions, and customer segments, providing a strong visual overview of how the office‑supplies business is performing and where opportunities for improvement exist. It shows how data can be transformed into insights that support better decision-making.