Enterprise Data Warehousing Solution
Applebee’s International implemented an enterprise data
warehouse (EDW) from Teradata with data analysis capabilities
that helped management acquire an accurate understanding
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 organizes
this data to report every ticket item sold in 15-minute intervals.
By reducing the amount of time required to collect POS
data from two weeks to one day, the EDW has enabled management
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 provide
services that attract customers and build loyalty.