Enterprise Data Warehousing Solution
Applebee’s International implemented an enterprise data warehouse (EDW) from Teradata with data analysis capabili- ties that helped management acquire an accurate understand- ing of sales, demand, and costs. An EDW is a data repository whose data is analyzed and used throughout the organization to improve responsiveness and ultimately net earnings. Each day, Applebee’s collects data concerning the previous day’s sales from hundreds of point-of-sale (POS) systems located at every company-owned restaurant. The company then organ- izes this data to report every ticket item sold in 15-minute inter- vals. By reducing the amount of time required to collect POS data from two weeks to one day, the EDW has enabled man- agement to respond quickly to guests’ needs and to changes in guests’ preferences. With greater knowledge about their customers, the company is better equipped to market and pro- vide services that attract customers and build loyalty.