Data Warehousing and the Restaurant Industry

1
Data Warehousing and the Restaurant Industry
Individual Report

• Jenna Benson
• April 2, 2008

2
Data Warehousing

• Data warehousing a pool of data produced to
  support decision making
• Subject oriented
• Integrated
• Time variant
• Nonvolatile

3
Data Warehousing Contd

• Consolidate data from many sources
• Can store months or years of data
• Designed for query and analysis not transaction
  processing

4
Industry Use

• Becoming prominent in the fast food industry Eg.
  Taco Bell and KFC
• Just beginning to be used by resellers and
  vendors
• Low cost option web technology where the vendor
  runs the software
• Micro Systems Inc. sells data warehousing
  software to restauant industry

5
Why Restaurants?

• Gain competitive edge
• Helps employees understand strategy and goals of
  organization
• Allows for increased user access to information
• POS systems tactical information to strategic

6
Possible Data Uses

• Inventory control
• Table turnover
• Peak hours
• Top selling server
• Revenue (location comparison, yearly, daily etc.)

7
Possible Data Uses Contd

• Menu mix as percentage of sales
• Customer info. and retention
• Real time info. on sitting table count, revenue,
  items sold etc.
• Help see the relationship between certain
  entities and business strategy

8
(No Transcript)
9
Recommendations

• Small breakfast chains and independently owned
  operations
• Access to all staff within organization
• Used to support overall organization strategy
• Change decisions from tactical to strategic

10
Thank You!

• Questions or Comments?

11
References

• Turban, E., Turban, E., Aronson, J., Sharda, R.,
  and Liang, T. (2006) Decision Support and
  Business Intelligent Systems 8 ed. Prentice Hall
• Korzeniowski, P. (2000, Jan.) Data on the menu.
  Retrieved on March 27, 2008 from,
  http//www.crn.com/it-channel/18807257
• (2002). Data warehousing and OLAP for the fast
  food industry. Exclusive Ore Inc. Retrieved on
  March 27, 2008 from http//www.xore.com/casestudie
  s/case_study_fastfood.pdf
• (2005). Data warehousing concepts. Retrieved on
  April 8, 2008 from, http//download-uk.oracle.com/
  docs/cd/B19306_01/server.102/b14223/concept.htm