Business Intelligence (BI) for the Mid-Market
Business Intelligence (BI) applications are no longer out of reach for the small- and mid-market.
In February 2002, Gowers began working with Datavision to construct a simple BI tool to track property management and point-of-sale transactions. He kept costs down by using an older, free version of Datavision’s Applix TM1. Using Applix as the back end, Gowers paid Datavision $40,000 to build an ETL (extract, transform and learn) interface tool to manipulate and display the data. The application allowed the resort to track sales, such as ski rental revenue, beverage purchases and the number of lodging nights paid, on a per-skier basis. Sales could also be tracked by day and time. In the past, the resort had no way to measure sales other than in the aggregate, and those sales were stored in disparate business unit databases. This meant it took days, sometimes weeks, to collect, collate and distribute the data to executives. The resort thus had less time to develop special marketing campaigns to drive business during slow periods or to respond to unexpected upticks in business.
Within months of implementing the BI tool, Gowers was able to show the restaurant, ski rental and lodging businesses when their sales dipped or increased. Working with marketing, these businesses now could increase sales by knowing when to push incentives to customers. Sales for the resort’s hospitality business have increased 67 percent in the past four years, an increase Gowers attributes in part to better business intelligence. In 2005, he used this earlier success to persuade business unit leaders to invest $50,000 in a more up-to-date version of Applix to make it easier to incorporate new products and services.
The updated system soon paid off. For example, the ski shop typically would run out of ski boots on weekends, limiting revenue from lift ticket sales and ski rentals. Simply put, the resort had too many big boots and not enough midsize boots, which resulted in fewer rentals. The shop needed to shift its boot buying patterns to meet demand. But how best to do that?
Gowers turned to the updated BI application. He ran an analysis of the rental data to determine how to pay for more purchases of the midsize footwear by reducing purchases of large-size boots. The project started last winter, and by the end of the season, the ski shop had increased rental revenue by as much as 15 percent without raising its boot budget. By not turning away skiers, Gowers says, the resort had more satisfied customers, which, while hard to measure, certainly means more repeat business.



