Large Liquor Retailer Boosts Sales and Forecasts Trends with BI Solution

  • Built an automated data and analytics solution in Qlik that replaced their manual Excel based reporting
  • Reports show product line performance, customer buying habits, and online vs. in-store purchases
  • With solution, company can do accurate forecasting in local markets

“Analytics8 was extremely helpful and responsive. We had spent hours building excel spreadsheets and running cumbersome queries to manually run the data, but Analytics8 was able to automate the process so now our time is spent analyzing and using the data instead of preparing and running the data.” — Director of Finance

Business Need

A large liquor retailer wanted to harness their data and analytics to improve sales, customize marketing offers and promotions, and retain customers. Their analytics solution was outdated, contained unused data and dashboards, and only provided high level Sales and Margin information. To understand how different business units were performing (Beer vs Wine vs Sprits sales), analysts were manually exporting data from NetSuite and Excel, and there was no uniform approach to analysis across business units. The process was time consuming, prone to errors, and did not provide the insight they needed to proactively grow their business.

Solution

We started by conducting strategic planning sessions to fully understand their reporting and analysis needs. Once we understood their requirements, we built an automated data and analytics solution in Qlik that replaced their manual Excel based reporting with a standardized set of reports for across the business. Reports include:

  • Product line performance – beer, wine, and spirit sales, with the ability to drill down into local markets
  • Customer buying habits – history of purchases
  • Online sales – details about online sales, with the ability to track shipping

These reports allowed them to see how individual products were performing as well as the ability to forecast trends in the local market pertaining to selection and availability of product. With our solution, the business will be able to perform assortment and inventory planning more accurately and detailed than before.

Results

This company moved from manual, error prone Excel reporting to intelligently tracking business performance in a uniform manner. They have quick access to sales numbers and can easily see which product mixes perform the best in each market, including online. With a clearer picture of customer profiles and buying habits, this company can more effectively target their marketing and offer the most appealing products to their customers.


Ready to start automating your processes?

Sign up for a data strategy session, and one of our analytics experts will consult with your company about your data and analytics strategy.

Contact Us

National Office Telephone | Mon-Fri 8:30am-5:30pm CT

Data Strategy Session

To thrive with your data, your people, processes, and technology must all be data-focused. This may sound daunting, but we can help you get there. Sign up to meet with one of our analytics experts who will review your data struggles and help map out steps to achieve data-driven decision making.

Learn More →

Fill out this form to get a 30-minute Data Strategy Session with one of our analytics experts.