Abstract
In the Mystery Shopping, Customer, and Market research field, data is collected about shopping experiences, customer reactions, store evaluations, employee evaluations, pricing evaluations, and brand/competitor evaluations. An efficient way of storing and formatting the data is needed to facilitate data analysis, data interpretation, and the generation of meaningful reports. This Masters project involves designing and developing a data warehouse to store evaluation data. It also involves creating a dynamic web-based tool to run analysis queries and generate meaningful reports from the data warehouse. The tasks of the project included client interviews, detailed analysis of an operational database, and understanding the current processes and steps taken to manually create summary reports. Important subject areas were then identified for creating data marts and implemented using an incremental approach. The data warehouse and analysis tool was developed using a Microsoft SQL Server 2008 database, and ASP and ASP.NET.