Modernizing Sales & Marketing Analytics for a Cannabis Retailer
How Solvenna helped a cannabis retailer modernize sales & marketing analytics, unlock data-driven insights, and drive revenue growth through unified retail dashboards.
THE CHALLENGE
A leading multi-state cannabis retailer was struggling with fragmented reporting and inconsistent performance insights. Sales data lived in Dutchie, promotional activity was spread across multiple spreadsheets, and leadership lacked a single, trusted view of performance across stores. Reports were time-consuming to compile, there was no executive-level agreement on KPIs, and conflicting numbers often eroded confidence.
These challenges slowed down decision-making and limited the retailer’s ability to optimize pricing, promotions, and growth strategies. And these challenges are not unique to cannabis; any organization operating across multiple systems and locations, from retail and CPG to healthcare and hospitality, faces similar hurdles when retail data is siloed and reporting isn’t standardized. This is where Solvenna came in.
THE SOLUTION
Help our client achieve unified, reliable, and actionable sales and marketing performance reporting with the following goals:
Clean and standardize data from multiple Dutchie instances, other systems and various MS Excel sources.
Build a single source of truth for sales, pricing, and discount analysis.
Build Power BI dashboards delivering real-time insights on sales, profitability, and promotions by location.
Empower leadership with accurate, actionable data to inform pricing, discounting, and marketing strategies.
“I have worked with some of Solvenna’s analysts for a while and have always been impressed by their deep expertise and thorough approach. In my new role, their team applied their broad knowledge of retail and data analytics to help us better understand market dynamics and how they impact our business. Their insights have been invaluable in shaping our strategy, and their ability to translate complex data into actionable recommendations sets them apart. I highly recommend Solvenna to anyone looking for data-driven solutions to navigate an evolving market.”
Rhonda BaslerDirector of Revenue at Elevate Cannabis
THE RESULTS
A Data-Driven Transformation
Data Integration & Standardization
Solvenna tackled the foundational data issues by thoroughly wrangling and validating Dutchie and other data sources. We identified discrepancies in field names and values resolving these inconsistencies. We combined and appended sales data from all locations into a single, unified dataset, enabling seamless multi-store performance analysis. Eliminating manual steps.
Advanced Power BI Reporting Suite
We developed a robust suite of Power BI dashboards, offering the client real-time insights into key business drivers. Dashboards included, but not limited to:
- Location Performance: Visualizing revenue, sales volume, and profitability across all retail locations.
- Sales Performance: Monitoring overall sales trends and identifying top-performing products and categories.
- Price/Volume/Mix Analysis: Understanding the impact of pricing changes and product mix on revenue growth.
- Discounting Analysis: Evaluating discount strategies, including discount performance by category.
- Promotion Analysis: Measuring the effectiveness of promotional campaigns to optimize future efforts.
Curious about Waterfall Charts? They’re a great tool for showing how individual factors add up to the big picture.
Operational Efficiency & Actionable Insight
With standardized data and automated dashboards, the client significantly reduced manual reporting time, enabling their team to shift from data preparation to data-driven decision-making. Leadership can now quickly identify underperforming stores, assess the ROI of discount and promotion strategies, and fine-tune pricing to drive revenue growth.
Elevating Strategic Decisions
The client is now equipped with a powerful analytics framework that supports their growth ambitions. They have transitioned from fragmented, unreliable reporting to a streamlined, data-driven operation. This transformation has empowered their team to make informed, confident decisions that drive both top-line and bottom-line performance.
Business Impact and What Comes Next
While this engagement focused on a cannabis retailer, the lessons learned apply broadly to any organization navigating multiple systems, manual processes, and inconsistent metrics.
WE CAN HELP
Is your organization struggling with sales, pricing, or promotional data? Let Solvenna help you unlock actionable insights and power your growth through data-driven strategies. Contact us today to start the conversation!