Data Handling and Business Intelege

1. Identify and critically evaluate the current trends in data warehousing, business intelligence and data mining.

2. Demonstrate a comprehensive knowledge and systematic understanding of essential concepts and principles by using predictive analytic software.
Part 1 – 60% of 75% (1750 words)

Using the Superstore data set provided, determine the decline in sales/profits over the years, and evaluate the use of Excel for pre-processing, analysing and visualising the data.

You will also need to demonstrate how you can do this practically with the use of any one of Excel functions such as: IF, LOOKUP, PIVOT TABLES, charts, and graphs.