Retail teams often work with guesswork. They audit stores when sales fall, not before. Issues like broken coolers or bad pricing get fixed late, after the damage is done. A cooler might fail quietly for days, hurting sales the entire time. Prices might be off just enough to lose shoppers. Data is scattered. Cooler health lives in one system, sales in another, and pricing in a third. Insights don’t travel fast enough. No one sees the full picture in real time. Swapnil Joijode saw this problem up close. He decided it didn’t need to stay this way.
Swapnil is a Power BI Developer who reads data from various source systems and provides actionable insights to support retail analytics. He is a member of a team that builds tools to solve real problems in retail analytics. His work is simple in aim but sharp in design. He doesn’t make dashboards for looks. He builds them to show what matters, when it matters, and to whom. He introduced two models that changed how field teams work. One ties cooler performance to outlet sales. The other spots pricing gaps that risk market share. These tools help retail teams act early, not late. They show where to look first, what to fix, and what to watch next.
The cooler model came from a clear gap. People knew some coolers were hurting sales, but no one proved it with data. Swapnil built a system that linked smart cooler signals, like internal temperature, door use, and compressor cycles, with sales at the outlet level. The model showed patterns. Poor cooler health often lined up with falling sales. It gave field teams a list of failing assets to check. But not just by tech issues, but by business impact. That shift helped teams fix what mattered most, fast. It saved stock, time, and lost revenue.
The pricing tool tackled a different but just as costly issue. Brands knew price mattered, but didn’t always track it closely. Field teams did spot checks. Price lists were reviewed quarterly. There was no daily grip on what shoppers were seeing on shelves. Swapnil built logic that scanned prices by SKU, brand, region, and store type. The dashboard flagged overpriced or undercut items. It sorted them by risk. It showed where the brand was losing ground, and where it could win it back. The data turned into action. Not in months, in days.
Swapnil also contributed to the rollout and performance tuning of the IOT Cooler Dashboard, an internal tool built to link cooler performance metrics like temperature, power status, and location with store-level sales. Though he joined the project in its final stages, he played a key role in refining the DAX logic, ensuring data accuracy, and improving report responsiveness as it scaled to new clients. His continued ownership ensures the tool stays reliable as it’s adapted across bottling partners. He also helped extend its value by enabling product placement insights, tying shelf layout and customer access patterns to sales, and validating them through real-time planogram compliance checks.
Another core area of his work is pricing and space analytics. He built reports that track product pricing trends, spot outliers, and surface how different brands position themselves across store clusters. These dashboards help identify the most frequent price points by SKU, show shifts during promotions, and compare verticals by brand, manufacturer, or pack size. His “space share” reports go a layer deeper, translating shelf image data into insights about product visibility, stock availability, and brand presence in-store. The result is a richer understanding of where client products stand against competitors, and how store execution links to performance. These reports don’t just show data, they enable better decisions about where to invest shelf space, adjust pricing, and strengthen market presence.
Most dashboards stop at fixed charts. Swapnil’s tools do more. The cooler model triggers alerts when a unit drops in performance. The pricing tool uses heatmaps to show pricing pressure across regions. Each dashboard has custom DAX logic that filters insights by category and geography. These aren’t vanity features. They drive focus. A regional head can see which five stores need a fix this week. A pricing team can find where to adjust SKUs before the next push. These tools replaced slow reports with live maps of what matters most.
This wasn’t a quiet change. The dashboards started in pilot programs, but didn’t stay there. Senior managers flagged them as internal models worth expanding. New verticals, like shelf coolers and freezer formats, began using the same logic. Project leads brought Swapnil in to train others on the methods. BI teams asked him to document the work so it could scale across teams. The recognition wasn’t just about clean design. It was about impact. His tools worked. Teams used them. Results followed. That’s what earned attention inside and outside his group.
Field teams using the cooler model have already seen reductions in asset downtime. Sales teams are beginning to explore how pricing insights can link to share performance. Regional managers have started using the dashboards in their planning workflows. What began as internal pilots is now shaping up into broader templates. There are ongoing discussions about productizing these models so they can be packaged for client use. While the pricing dashboard is still under development and hasn’t yet been pitched to clients, it’s being refined with that goal in mind. Its early results have shown enough promise to attract internal interest for future deployment.
The impact shows in how others now think about retail data. Cooler health used to be an equipment issue. Pricing was a brand call. Sales told a different story. Swapnil’s work changed that. He showed the links. When a cooler drops in performance, it hurts sales. When a price slips out of range, the share drops. When those things get fixed early, brands recover. His models made that connection clear. Not with theory, but with hard data and repeat results. That shift in thinking is spreading across teams.
Recognition also came in less formal but just as strong ways. Leadership used his models as examples in planning decks. BI heads asked him to help shape documentation for others. His logic became the backbone of training for new analysts. In a field full of dashboards, his’ stood out for clarity, speed, and direct value. These tools didn’t just tell stories, they solved problems. That’s why others picked them up. They didn’t need an explanation. People saw the link between the insight and the fix.
Swapnil didn’t wait for problems to bubble up. He built systems that spot them early. That’s what makes his work matter. The dashboards don’t replace people, they guide them. They help sales teams focus. They help ops teams act. They show pricing teams where to adjust. That kind of real-time help is rare in retail, where reports often lag weeks behind. His tools give that edge back to the people making daily calls. And they do it with clear signals, not noise.
His work changed more than dashboards. It changed how teams think. Fixing a cooler now comes with sales data. Changing a price comes with risk flags. Planning a launch means scanning the model, not guessing. These changes stick because they help people do their jobs better. That’s the test that matters. And that’s where Swapnil’s work stands out. It didn’t just improve reports, it improved action. It gave people better tools, and those tools were delivered.
