Mysupermarket - Building a Business of Data Warehousing Foundations
BUILDING A BUSINESS MODEL ON DATA WAREHOUSING FOUNDATIONS:
Executive Summary
mySupermarket is a grocery shopping and comparison website which aims to provide customers with the best price for their shopping. This report examines how data warehousing provided mySupermarket with the foundation in which to build a successful enterprise, and allowed a subsequent expansion into the ‘business intelligence’ sector. The research draws attention to the problems and limitations that mySupermarket encountered including; coping with diverse sources of data streams, customer loyalty issues, achieving real-time data, data integrity and generating a sustainable revenue stream. These problems were tackled respectively through; building their own data warehouse, adopting a CRM strategy underpinned by their warehouse, adopting Microsoft’s SQL software, supermarket website ‘crawling’, offering ‘targeted’ advertising space and the realisation that the granularity of detail they offered, would allow them to expand into the ‘business intelligence’ sector. The report appreciates the importance of storing data, but concludes that data itself is the prerequisite to success, and that good management is needed to convert this data into meaningful information. It is therefore a combination of data warehousing and good management that has enabled mySupermarket to become a successful venture.
Introduction
“On the 31st August 2006, entrepreneur Johnny Stern received a seven-figure sum from investors to transform the way consumers shop for their groceries. From this, the price comparison site mySupermarket.co.uk was born and the company has utilised data warehousing to give consumers access to cheaper grocery shopping. The venture has not been without its problems, however four years on the company has withstood Adam Smith’s ‘Invisible Hand’[1] and grown into a c.£10m company...”
mySupermarket is a grocery shopping and comparison site that allows customers to
Executive Summary
mySupermarket is a grocery shopping and comparison website which aims to provide customers with the best price for their shopping. This report examines how data warehousing provided mySupermarket with the foundation in which to build a successful enterprise, and allowed a subsequent expansion into the ‘business intelligence’ sector. The research draws attention to the problems and limitations that mySupermarket encountered including; coping with diverse sources of data streams, customer loyalty issues, achieving real-time data, data integrity and generating a sustainable revenue stream. These problems were tackled respectively through; building their own data warehouse, adopting a CRM strategy underpinned by their warehouse, adopting Microsoft’s SQL software, supermarket website ‘crawling’, offering ‘targeted’ advertising space and the realisation that the granularity of detail they offered, would allow them to expand into the ‘business intelligence’ sector. The report appreciates the importance of storing data, but concludes that data itself is the prerequisite to success, and that good management is needed to convert this data into meaningful information. It is therefore a combination of data warehousing and good management that has enabled mySupermarket to become a successful venture.
Introduction
“On the 31st August 2006, entrepreneur Johnny Stern received a seven-figure sum from investors to transform the way consumers shop for their groceries. From this, the price comparison site mySupermarket.co.uk was born and the company has utilised data warehousing to give consumers access to cheaper grocery shopping. The venture has not been without its problems, however four years on the company has withstood Adam Smith’s ‘Invisible Hand’[1] and grown into a c.£10m company...”
mySupermarket is a grocery shopping and comparison site that allows customers to
References: Beyon-Davies, P (2004) – Database Systems, 3rd edition, Palgrave, Basingstoke, pp. 527-538 and 547-553 Bose, R (2002) – Customer Relationship Management: Key concepts for IT success, Vol Blastland, M & Dilnot, A (2007) – The Tiger That Isn’t: Seeing a World Through Numbers Burchill, J (Aug 2010) – The Independent: So the Prince of Green Hypocrites is going on tour Cooper et al. (2000) – Data Warehousing Supports Corporate Strategy at First American Corporation Vol. 24, No. 4 Champion, D & Coombs, C (2010) – Handout: BSC070 Enterprise Information Systems Cheeseman, G (June 2010) – Triple Pundit: Is It Ethical For BP To Buy Oil-Spill-Related Google Search Terms? Davenport, T IEEE Computer (Dec 1991) – Special Issue on Heterogeneous Distributed Database Systems, 24(12) Inmon, W.H Kimball, R & Ross, M (2002) – The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, 2nd edition Martin et al., (2005): 193 – Managing Information Technology 5th Edition, Pearson Education Inc, pp Mintel Intelligence (Oct 2009) - Web Aggregators, UK Murray, G (1994) - The Second 'Equity Gap ': Exit Problems for Seed and Early Stage Venture Capitalists Perry, J (Nov 2009) – Dunnhumby: A lifetime of loyalty? RetailWeek Poole, J et al Smith, A (1959) – ‘The Theory of Moral Sentiments’ Vandermay, J (2001) – Considerations for Building a Real-time Data Warehouse ----------------------- [1] A term coined by Adam Smith in his first book ‘The Theory of Moral Sentiments’ (1959)