One way is to do business analyse of the transaction data that has been collected. Business analytics involves the extensive use of:
• statistical and quantitative analysis methods;
• models of various types;
• various ways of illustrating finds; and
• fact-based management for problem solving.
For this lab you will be using MS Windows based MS Excel 2007/2010 for data analysis. The exercise will require the development and use of PivotTables, PivotCharts, and analysis. You may need to do some research and then apply the knowledge gained on how to do PivotTables and PivotCharts. To assist in how to do PivotTables. . You must use all the data found in the data file.
In this lab you will use a spreadsheet to model and design a solution to consolidate sales data in different forms in order to provide a report to management. Thus the information shown must be in summary form and only what is needed. Marks will be deducted for not following instructions. Only a MS Excel 2007 or 2010 (UC lab standards) file will be accepted.