bookmark Featured work

Management & Reporting for LCBO and TBS Vendors

DigThisData

Interpreting large data sets can be challenging. When the data is critical to your business success, it can be frustrating —until now.


Background


In Ontario, alcoholic beverage sales are controlled by a duopoly — The LCBO and The Beer Store. The Liquor Control Board of Ontario is a Crown corporation that retails and distributes alcoholic beverages throughout the province of Ontario. Similarly, The Beer Store is a privately run corporation that sells and distributes beer products throughout the province.

DigThisData for LCBO and TBS data

Given a territorial duopoly, beer, wine, and spirits vendors need only to concern themselves with sales and industry figures from two retailers. Together, the LCBO and TBS run over a 1400 locations in Ontario and volumes of data on inventory, sales, and performance is provided in crude and rudimentary formats.


Challenge


Beverage manufacturers and distributors are faced with the task of scrutinizing these large data sets to try and make sense of how their product performance is progressing. Files exported by the LCBO and TBS are character delimited, complicating any type of meaningful ingestion. At best, Excel spreadsheets can be purchased for an additional fee, however comparing week–over–week patterns, or monthly figures can be difficult to gauge.

Formats vary between the LCBO and TBS and understanding both sets of data requires twice the effort. DigThisData enables vendors to ingest their data for instant analysis.

The DigThisData Dashboard


Solution


DigThisData provides a unified platform for vendors to analyse their data. Initial setup only takes a few minutes and DigThisData instantly turns your raw, unreadable files into beautiful, dynamic charts and tables.

Retail store inventory levels are updated nightly to notify sales staff of locations requiring more product. Product orders can be generated, emailed, and stored for easy processing and reconciled automatically against inventory levels. See all the features at DigThisData.com


Now Available


DigThisData has recently launched with select customers. If you’re interested, a 14 day trial offer is available —no credit card required. Email sales with any questions, or give it a try.

Try DigThisData