Developing a dashboard for Wally's Office

I got to help Wally’s Office move from “Where is that number again?” to “Oh, there it is.” We started with a product list and sales history, and ended with a clean, responsive dashboard that surfaces the right answers fast: top products, strong regions, and revenue trends at a glance.

This isn’t a highlight reel. It’s a short, honest look at how we collaborated, trimmed the noise, and built something the team enjoys using every day.

The Customer

Wally’s Office is a small B2B stationery supplier serving offices across the U.S. They stock everything from pencils to desks and needed a clearer, faster way to understand what’s selling, where, and when. As a small business, Wally’s doesn’t have an analyst and they work primarily with Excel and CSVs in their day-to-day. Sometimes it’s hard to track the most valuable info, but they still want to see the big picture and trends. And we were here to help them! :)

The Starting Point

We began with two simple spreadsheets: product list and historical sales. Nothing fancy, just rows of orders and items. By exploring this data together, we saw the potential to answer the questions Wally’s team asks every day:

Which products are the top performers?
Which regions are doing best?
How is revenue trending over time?

The Build

We transformed those raw files into a clean, responsive dashboard that feels effortless to use:

Wally’s Dashboard

Overview: KPIs, filters, and charts

Instant KPIs front and center: Total Sales, Total Revenue, and the Top Product.

Meaningful visuals:

a Top-5 products chart that highlights revenue leaders (with the rest grouped as “Other”),
a Region performance view to spot where demand is strongest,
a Revenue trend line to see momentum at a glance.

Smart filters that match how the team thinks: by date, product, and minimum units.

A raw data table that respects the filters and can be exported in one click.

Wally’s Dashboard Table

Table and filtering

Desigh Choices

We chose a calm, clean theme with strong emphasis on KPIs and a few subtle animations to make interaction feel lively without getting in the way. I wanted to highlight the KPIs, add a fun hover animation, and use friendly icons as quick visual cues.

The layout adapts to tablets and phones, so managers can check performance on the go - quick and easy.

Wally’s Dashboard | KPIs, filters, and charts — Phone: KPIs, filters, and charts

Wally’s Dashboard | Table and filtering — Phone: Table and filtering

Development Environment

If you are interested in some technical details here is the drill:

I used an amazing framework called Dash (by Plotly) that lets you build beautiful dashboards using Python only! Python is one of those languages I love because of its versatility and simplicity. It lets you work with data, transform it, and find valuable insights in never-ending rows and columns. By using Python (Dash, pandas) and a bit of Bootstrap for a clean layout, I was able to develop this dashboard. The code is open, so feel free to peek and read the comments if you’d like to create something similar. :)

The Outcome

What used to be a tangle of spreadsheets is now a single source of truth. Wally’s team can:

spot best-selling products in seconds,
compare regions at a glance,
track revenue over time without manual slicing,
and export exactly the rows they need—already filtered.

It’s a simple tool that quietly upgrades everyday decisions. Overall, it was a fun, insightful project that took raw data and turned it into a living, useful interface - one that helps a growing business like Wally’s Office see itself more clearly every day. And that’s exactly what we’re here for! :)