Reference no: EM132360580 , Length: word count:1000
Foundations of Information Systems Assignment -
Assignment: Individual case study assessment composed of two submissions - Part 1- Excel sheet and Part 2- Report (1,000 words).
Assessment topic: Data Analysis with Excel and Report about modern information systems.
Purpose: In this assessment students are to critically analyse a given case study. Students will use an Excel spread sheet and its different functionalities to analyse the case study.
Assessment Details: FUSION Company is facing tough competition in the retail industry. The company has realised the only way to become competitive is to harness data it has collected over the years with the use of modern information systems. As a starting point, the company would like to acquire and implement a Data Warehouse system to be used in organising and analysing historical transaction data to support business decision-making. The I.T. team is evaluating five systems (DW1 to DW5) that were presented to them by software vendors. The given file Assessment2-Datafile.xlx contains the testing results for these Data Warehouses (X is the last two digits of your student ID). The assignment requires students to analyse the given case study and provide their recommendation for selection of the best Data Warehouse system for the company. The assignment has two main parts:
A. Data Analysis with Excel: Analyse the given data in Assessment2-Datafile.xlx after completing the tasks given. Analysis is based on the use of various excel formulas and graphs learned in class.
B. Report: Write a report for Fusion Company that must include the following sections:
- Introduction: Discuss how the use of modern Information Systems such as Data Warehouse and Business Intelligence can contribute to an organisation's competitive advantage.
- Data Warehouse Selection: Justify the selection of Data Warehouse based on the results generated in the excel sheet. The justification must be based on the two graphs.
- Importance of Data representation: Discuss the importance of correctly representing data for easy decision making.
- Conclusion: Must summarise the important parts of the report and should include recommendations for using information systems for competitive advantage.
- Reference List: At least two references from academic journals. In addition, proper in-text referencing is to be followed.
Details of Data Analysis with Excel: Download the file Assessment2-Datafile.xlx and complete the following tasks:
1. In the row labeled "Total Records", calculate net records after deducting "Re-Entry Required due to system errors" from "Records".
2. In the row labeled "Dimension Tables", calculate the dimension tables for the records by dividing Total Records by 50.
3. In the row labeled "Tables per Database (8 databases)", calculate the tables for each database by dividing Dimension Tables by 8.
4. In column G use the Sum function to give totals (for all systems) for each of the rows (rows 4 to 8).
5. In column G determine the lowest value (for all systems) for each of the rows (rows 4 to 8).
6. In column H determine the highest value (for all systems) for each of the rows (rows 4 to 8).
7. In column Q determine the arithmetic mean (for all systems) for each of the rows (rows 4 to 8).
8. The forecasted daily revenue gained from each system is based on tables per database that is used in analysis for sales and marketing campaigns. There are a total of 8 databases. Use a lookup table with a revenue that changes according to the number of Tables per Database - Up to 5 tables, the more tables analysed, the higher the revenue. You will use the range B8 to F8 (Tables per Database) for the formulas to calculate daily revenue. There is a table on the spreadsheet showing the Daily Revenue. Use either the Lookup function or VLookup function to find the daily revenue for all the systems (make sure to use referencing).
9. Create a Clustered Column chart for the Total Records. Remember to select the correct ranges and ensure the title of the chart is "Total Records".
10. Create a Pie chart showing the column "Re-entry required due to system errors". Remember to select the correct ranges and ensure the title of the chart is "System Errors".
Attachment:- Information Systems Assignment Files.rar