Write a report for Fusion Company

Assignment Help Management Information Sys

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

Reference no: EM132360580

Questions Cloud

What are the functions of the equipment : Obtain a copy of the manufacturer's instructions for the business equipment that you use in your workplace. What are the functions of the equipment?

What do you feel practical and still within legal obligation : There is much controversy on record keeping. Agencies require records after each session, and private therapists say less is better so courts cannot interpret.

Describe the detrements of not conducting : Assess and present which part of the staffing procedure were not done properly Describe the detrements of not conducting a Human Resource Planning.

Implementation of signal processing algorithms in matlab : Signal decimation and interpolation in MATLAB and System Eigen function and Eigen Value - Determine the system difference equation in the form.

Write a report for Fusion Company : ICT100 Foundations of Information Systems Assignment, King's Own Institute, Australia. Write a report for Fusion Company

Evaluate organizational influences on project management : Evaluate organizational influences on project management and methods utilized for staffing, managing, and executing projects.

Explain the assumptions on which objective methods are based : Explain the assumptions on which objective methods are based, and provide an analysis of empirical research testing the validity of the assumptions.

Discuss two important aspects of organizational control : Discuss two (2) important aspects of organizational control. Which aspect is most important for organizational success?

How you find your accommodations arrangements : Think about how you decide on where to go, how you find your accommodations and/or travel arrangements, and what tools you decide to use to come to a decision.

Reviews

len2360580

8/25/2019 10:48:17 PM

Word Count: 1000. Part 1- Excel sheet and Part 2- Report (1,000 words). Submission: On the submission link in Moodle, there are two tabs: Part 1 and Part 2. Submit the Excel spreadsheet in Part 1 and the Report (Word format) in Part 2 on or before due date. Do not compress the files as a zip folder. Marking Criteria: The assessment will be marked based on the following criteria: Correct use of Excel formulas and graphs. Well-written and directly answers the question. Provides supported argument with at least two references (from academic journals and books). Demonstrates knowledge of the subject matter. Draws a conclusion based on argument.

Write a Review

Required(*) Message

User Account

All Pages