“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
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.
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:
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.
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.
Sign up for a data strategy session, and one of our analytics experts will consult with your company about your data and analytics strategy.
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.