Roni's Mac Bar Sales Dashboard

Dashboard
Average Time of Day Chart
Total Sales Over Time Chart
Top 10 Most Popular Options Chart

Inspiration

We were inspired by the idea of helping a small business make smarter decisions through data. Roni’s Mac Bar, a local Texas favorite, had plenty of sales data but needed a clear way to see trends, peak hours, and popular menu items. We aimed to build a tool that turns raw data into meaningful insights for efficient, everyday decision-making.

What it does

The dashboard provides an intuitive view of Roni's Mac Bar's sales performance, showing monthly sales trends, top-selling items, peak business hours, and customer preferences. Key insights help Roni’s team optimize staffing, plan inventory, and adjust menu offerings to meet demand.

How we built it

We used Streamlit for a clean, interactive interface and Plotly to enable hover functionality for detailed data views. Pandas handled the data processing, while Matplotlib and Seaborn added visual customization. The entire dashboard updates with real-time filters, allowing users to drill down by month and day.

Challenges we ran into

Integrating interactive features like hover functionality required switching to Plotly, which presented a learning curve. We also faced challenges with inconsistent data formats across monthly files, needing extra data cleaning to ensure smooth analysis.

Accomplishments that we're proud of

We’re proud of creating a dashboard that’s both user-friendly and valuable. It’s rewarding to know this tool can help Roni's Mac Bar make data-backed decisions quickly. The hover feature adds an extra layer of interactivity, making it easy to explore data without overwhelming details.

What we learned

We deepened our skills in data visualization, especially with interactive libraries like Plotly, and learned how to design dashboards that are simple but powerful. We also gained insights into handling real-world data issues, like inconsistent formats and missing values.

What's next for Roni's Mac Bar Sales Dashboard

Next, we’d like to add predictive analytics to forecast busy times and track seasonal trends. We’re also considering customer feedback integration and further customization to meet Roni's evolving needs.