Design of data strategy for a chosen scenario. 2400 word report on the data strategy des

My case study will revolve around Waitrose, the UK supermarket.

So far for my case study I’ve written the following.

My chosen case study will revolve around the UK supermarket Waitrose. I’ll be discussing how data can be used to improve the decision-making process within Waitrose. Strategic decision-making is a constant process, which incorporates the various strategies and policies in the organisation that that the targets of the organisation are fulfilled.

Strategic planning is required in the organisations because it helps the organisations to set the objectives that would be helpful for gaining profit for the company. The strategic planning of Waitrose, a large succession of British supermarkets in the food retail sector, is discussed for the better understanding of its importance in the business. The organisation, Waitrose, is considered as the constant rising retail store in the British supermarket and has the largest number of employees working under Waitrose.

The case study should represent a scenario where data can be used to improve the decision-making process. The submission should be in the form of a report of no more than 2400 word, see below for more details. Your report will be based on the material covered in the lectures and labs, but you are also expected to carry out your own research.

Your submission should contain the following sections:

v The Case Study (15 marks)

Ø A brief overview of your chosen case study, which clearly describes the scenario where data can be used to improve the decision-making process.

v The Data Requirements (15 marks)

Ø A detailed discussion of the data requirements of your scenario. This should include a discussion of both:

§ Internal data, data collected locally.

§ External data, data collected by external bodies.

v The Data Warehouse (30 marks)

Ø A discussion of data identified which would be suitable for storage in a data warehouse.

Ø An example and brief discussion of one suitable data schema. E.g. A star, snowflake or galaxy schema.

Ø Using examples from your scenario, discuss:

§ The ETL process.

§ Online Analytical Processing (OLAP).

v Big Data (25 marks)

Ø A discussion of data identified which would not be suitable for storage in a data warehouse.

Ø A discussion of reasons the data is not suitable for storage in a data warehouse.

Ø Using examples from your scenario, discuss a framework that could be used to collect, store and analyse this data.

v Conclusion (15 marks)

Ø This should include a summary of the report and suggest the most appropriate data strategy for your scenario.