An Interactive Business Intelligence Framework for Retail Sales Analytics: A Coffee Roasters Case Study
This paper presents the design and development of an interactive Business Intelligence dashboard for a coffee roaster, utilizing Python, SQLite, Streamlit, Plotly, and Tableau to analyze retail sales data, identify revenue-driving products, and optimize inventory prioritization to enhance operational efficiency and strategic decision-making.
Original paper licensed under CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). This is an AI-generated explanation of the paper below. It is not written or endorsed by the authors. For technical accuracy, refer to the original paper. Read full disclaimer
Imagine you run a bustling coffee shop. Every day, you hand out hundreds of cups, bake dozens of pastries, and ring up sales. But here's the problem: you're drowning in a sea of receipts. You know something is selling well, but you can't tell if it's the fancy espresso or the plain muffin, or if you're wasting money stocking up on tea that nobody buys. It's like trying to find a specific needle in a haystack while wearing blindfolded.
This is exactly the puzzle Gunjan Sahoo tackled in a new research paper. The author built a "super-powered magnifying glass" for coffee shops (and other retail stores) called a Business Intelligence Framework. Think of it as a digital command center that takes all those messy, scattered receipts and turns them into a clear, interactive map of your business.
The Magic Machine
The author didn't use a giant, expensive mainframe computer. Instead, they built a lightweight, flexible toolkit using some popular digital ingredients: Python (the brain that does the math), SQLite (a sturdy little filing cabinet for the data), Streamlit (the friendly face that lets you click and play), and Plotly (the artist that draws the pictures). They also tested this setup alongside Microsoft Power BI and Tableau, which are like professional-grade dashboards used by big bosses.
The goal wasn't just to make pretty charts; it was to answer three big questions:
- Which products are actually making money?
- How should we organize our shelves?
- What should we do next?
The "80/20" Surprise
When the author fed the coffee shop's sales data into this new system, a classic pattern popped out, just like a hidden treasure map revealing itself. The system used something called Pareto Analysis (named after a guy named Pareto who noticed this pattern back in 1906).
The results were clear: approximately 80% of the total revenue was generated by a limited number of products.
In plain English? A tiny handful of your best-sellers are doing the heavy lifting, while a mountain of other items are just taking up space. The dashboard showed that specific items like Barista Espresso, Gourmet Brewed Coffee, and Premium Brewed Coffee were the heavy hitters. They were the "rock stars" of the shop. Meanwhile, categories like bakery and packaged goods were bringing in much less cash.
Sorting the Good from the "Meh"
To help the shop owner make sense of this, the system sorted everything into three buckets, known as ABC Classification:
- A-List: The superstars (like that Barista Espresso) that bring in the big money.
- B-List: The solid middle performers.
- C-List: The items that are just hanging around, not contributing much.
This isn't just a guess. The paper explicitly states that traditional reports often fail to give managers this kind of "timely visibility." Old-school reports are like looking at a photo of last year's weather; they tell you what happened, but they don't help you decide what to wear today. This new interactive dashboard, however, lets managers filter and explore the data in real-time. You can click on "Tea" and instantly see how it's doing compared to "Coffee," or zoom in on a specific week to see if a promotion worked.
What the Paper Doesn't Say
It's important to know what this tool isn't yet. The paper suggests that this framework is a great way to organize and visualize what you already know. It helps you see the "what" and the "where."
However, the paper admits this is a starting point. It does not claim to predict the future. The author notes that future versions of this system could use "machine learning" to guess how many coffees you'll sell next week or to recommend products to specific customers. But right now, this framework is about describing the present clearly, not predicting the future. It's a powerful telescope, but it's not a crystal ball.
Why It Matters
The main finding is that you don't need a billion-dollar IT department to get smart insights. By stitching together these lightweight, modern tools, a coffee roaster (or any small retailer) can turn a pile of receipts into a strategic plan.
The system proved that by identifying those top 20% of products that drive 80% of the revenue, managers can stop guessing. They can focus their inventory, pricing, and marketing on the items that actually matter. It's like realizing you only need to polish the front door and the main sign to make the whole shop look great, instead of scrubbing every single window in the building.
In short, this paper suggests that with the right digital toolkit, any business can stop drowning in data and start swimming in clarity. It turns the chaos of daily sales into a clear, actionable story, helping bosses make decisions based on facts rather than hunches.
Drowning in papers in your field?
Get daily digests of the most novel papers matching your research keywords — with technical summaries, in your language.