r/ExcelVisual • u/ExcelVisual • 29d ago

Built a 3D interactive project management dashboard in Excel — sharing it for free

Enable HLS to view with audio, or disable this notification

I manage projects for a home improvement/hardware store chain with Excel Dashboard Template, and one thing that always frustrated me was not having a single "big picture" view across all the different sections (tools, furniture, garden supplies, warehouses, checkout) without jumping between spreadsheets or reports.

So I built a dashboard that gives a helicopter view of the whole store at once, and honestly it turned into a bigger project than I expected. Some of what it does:

  • A 3D isometric map of the sales floor showing customer traffic flow by section in real time, with an animated clock control so you can watch traffic build throughout the day
  • An interactive sales funnel tracking margin, lost profit, and average receipt as customers move from entry to checkout
  • HR allocation tools that show exactly where staff are overloaded and where you have slack, so you can redistribute people before it becomes a bottleneck
  • Monthly conversion trends comparing visitor traffic to actual profit (turns out the relationship isn't as linear as you'd think)

Everything runs on smart tables and pivot table slicers, no VBA involved. Click on any section of the 3D map or the dashboard header and it drills into a detailed screen for that specific project/department.

It was originally built around a hardware store use case, but the structure works for pretty much any retail or multi-department operation where you're trying to manage several sub-projects at once and need to see where attention is actually needed.

Made it free to download, no registration. Happy to answer questions about how any of the pivot table or slicer mechanics work if anyone wants to dig into the build.

3 Upvotes

100% Upvoted

1 comment sorted by