AI-Powered Sales Performance Analytics: Developing a Smart Dashboard for Revenue Optimisation in the Indian Jewellery Manufacturing Sector

The Crystal Ball for Gold Shops

Imagine you are running a massive lemonade stand, but instead of lemons, you are selling gold necklaces, diamond rings, and silver bracelets. Now, imagine that the price of lemons changes every single minute based on what's happening in a different country, and your customers only show up in huge crowds during specific holidays. That is the wild world of the Indian jewellery industry. It is a place where data is everywhere—millions of transactions, thousands of designs, and prices that dance to the rhythm of global markets—but for a long time, the people running these shops have been trying to navigate this storm with a paper map and a compass made of guesswork.

This paper lives in the world of Business Intelligence and Data Science. Think of these fields as the art of turning a messy pile of raw numbers into a clear, glowing picture that helps you make smart choices. The study leans on a few big ideas: AI Analytics, which is like giving your computer a brain to spot patterns humans might miss; Dynamic Capabilities, which is the ability of a business to pivot and change direction quickly when the market shifts; and User Acceptance, which simply asks, "Do the people actually using this new tool find it helpful?" Why does anyone care? Because in a business where a wrong guess can mean losing a fortune or missing a massive sales boom, having a tool that predicts the future isn't just a luxury—it's the difference between thriving and just surviving.

---

The Paper's Big Adventure: From Spreadsheet Chaos to AI Clarity

This research story follows a team of researchers who decided to help Emerald Jewel Industry India Ltd, one of Asia's biggest gold jewellery manufacturers, stop guessing and start knowing. For years, this company, which makes over 24 tonnes of jewellery a year with more than 500,000 unique designs, was relying on old-school spreadsheets. It was like trying to drive a Ferrari while looking in the rearview mirror; the reports told them what happened last month, but by the time they got the report, it was too late to fix next week's problems.

The team built a Smart Dashboard using a tool called Microsoft Power BI. Think of this dashboard as a high-tech cockpit for the company. Instead of staring at endless rows of numbers, the staff can now see interactive charts, ask the computer questions in plain English (or even Tamil!), and get instant answers. But they didn't just build it and hope for the best; they tested it rigorously. They looked at real sales data from 2023 to 2025 and asked 120 employees—from salespeople to managers—what they thought of the new system.

What They Found: The Gold in the Data

The results were as clear as a polished diamond. First, the data confirmed what many suspected but needed proof for: Gold is still the king, making up 40.2% of all units sold. But the story didn't stop there. They discovered that 52.0% of all the money comes from branches in Tamil Nadu, proving that local roots matter more than global reach in this specific market.

The most dramatic finding was about timing. The paper shows that demand isn't spread out evenly; it explodes during festivals. Just one month, November 2024 (which includes the festival of Dhanteras), accounted for a massive 15.3% of the entire year's sales volume. That is a huge spike! Without a smart system, a shop might run out of stock right when customers are lining up, or worse, have too much gold sitting idle when no one is buying. The new dashboard uses AI to predict these spikes, acting like a weather forecast for sales, helping the company prepare 90 days in advance.

Does the New Tool Actually Work?

The researchers didn't just look at sales numbers; they asked the people using the tool if it helped. The answer was a resounding yes. 67.5% of the staff rated the dashboard as "useful" or "highly useful." This wasn't just a feeling; the numbers backed it up. The team used statistical tests to prove that the dashboard wasn't just a pretty screen. They found a very strong link (a correlation of 0.831) between how effective the staff thought the dashboard was and how well the sales revenue performed. In fact, the dashboard's ability to track revenue, product performance, and branch success explained 69.0% of why the tool was considered effective.

The study also proved that one size does not fit all. When they compared different branches, they found significant differences in how they performed. A "one-size-fits-all" strategy would fail because the customers in Dubai are different from those in Chennai. The dashboard helps managers see these differences clearly so they can tailor their plans for each location.

What the Paper Says It Is NOT

It is important to note what this paper does not claim. The authors are careful to say that this is a study of one specific company. While the methods they used could work elsewhere, they do not claim that this dashboard will automatically fix every jewellery shop in the world. They also admit that the AI models rely on past data, so if something totally unexpected happens—like a sudden, crazy spike in gold prices that has never happened before—the AI might not predict it perfectly. The paper suggests that the tool is a powerful step forward, but it is not a magic wand that solves every problem instantly.

The Bottom Line

In simple terms, this paper shows that when a traditional, complex business like jewellery manufacturing swaps its old spreadsheets for a smart, AI-powered dashboard, it doesn't just look cooler—it performs better. The staff loves it, the numbers prove it works, and it helps the company see the future clearly enough to prepare for the biggest sales days of the year. It suggests that in a world where gold prices and customer moods change by the minute, the only way to stay ahead is to let the data do the heavy lifting.