ICT100 Foundations of Information Systems Assessment 2022
Added on 2022-09-27
7 Pages1240 Words14 Views
|
|
|
Running head: ICT100 Foundations of Information Systems
ICT100 Foundations of Information Systems
Name of the Student
Name of the University
Author Note
ICT100 Foundations of Information Systems
Name of the Student
Name of the University
Author Note
Introduction:
In this particular assignment data analysis techniques are used to analyse the systems of
FUSION Company to find the best data warehouse system for the company. FUSION is
current undergoing through tough competition as a retail industry as many more companies
are producing similar kinds of products or providing services that are more customer friendly
and easily available. Hence, the company understood to survive in this competitive market,
the only option is to gather the past data of sales which is collected over entire business years
of the company and then to find useful insights of the data to target the customers with their
specific needs. Hence, modern information systems are the only way to survive in the
competitive market (Clayton 2016). At present the IT team of the company evaluated five
data warehouse systems from DW1 to DW5 as their performance specified by the different
software vendors. The performance data is given in the Assessment2-Datafile.xlx and
required properties of the data warehouses are computed and their descriptive statistics has
been calculated using suitable excel formulas as given in the excel file. Further, different
visualizations are created to understand the performance of each warehouse DW1 to DW5 in
different performance properties.
Data Warehouse selection:
In the excel file two properties of the five data warehouses are given and the rest four
properties are calculated using suitable excel formulas. Namely, the records and re-entry
required for system errors of each data warehouses are given. The property total records is
calculated after subtracting the re-entries from the records. Each dimension table of a
warehouse contains 50 records and hence total table of each warehouse is the total records
divided by 50. There are total of 8 databases in each warehouse and hence number of table in
each database is dimension tables by 8. The daily revenue from a warehouse is based on the
number of dimension tables per database and thus is computed by using vlookup function
from the daily revenue chart given below.
In this particular assignment data analysis techniques are used to analyse the systems of
FUSION Company to find the best data warehouse system for the company. FUSION is
current undergoing through tough competition as a retail industry as many more companies
are producing similar kinds of products or providing services that are more customer friendly
and easily available. Hence, the company understood to survive in this competitive market,
the only option is to gather the past data of sales which is collected over entire business years
of the company and then to find useful insights of the data to target the customers with their
specific needs. Hence, modern information systems are the only way to survive in the
competitive market (Clayton 2016). At present the IT team of the company evaluated five
data warehouse systems from DW1 to DW5 as their performance specified by the different
software vendors. The performance data is given in the Assessment2-Datafile.xlx and
required properties of the data warehouses are computed and their descriptive statistics has
been calculated using suitable excel formulas as given in the excel file. Further, different
visualizations are created to understand the performance of each warehouse DW1 to DW5 in
different performance properties.
Data Warehouse selection:
In the excel file two properties of the five data warehouses are given and the rest four
properties are calculated using suitable excel formulas. Namely, the records and re-entry
required for system errors of each data warehouses are given. The property total records is
calculated after subtracting the re-entries from the records. Each dimension table of a
warehouse contains 50 records and hence total table of each warehouse is the total records
divided by 50. There are total of 8 databases in each warehouse and hence number of table in
each database is dimension tables by 8. The daily revenue from a warehouse is based on the
number of dimension tables per database and thus is computed by using vlookup function
from the daily revenue chart given below.
Daily revenue chart:
Dimension tables/database Daily
Revenue
1 $1,000.00
2 $1,300.00
3 $1,600.00
4 $1,900.00
5 $2,200.00
Further the measures of central tendency namely minimum, maximum and average for each
property of the five warehouse are calculated by suitable formulas as given below.
DW1 DW2 DW3 DW4 DW5 Total Lowest
Highes
t Average
Records 1400 1300 1100 1800 1000 6600 1000 1800 1320
Re-Entry
Required
due to
system
errors 109 7 295 54 86
550.555
6
6.55555
6 295
110.111
1
Total
Records 1291
1293.44
4 805 1746 914
6049.44
4 805 1746
1209.88
9
Dimension
Tables 26 26 16 35 18
120.988
9 16.1 34.92
24.1977
8
Tables per 3.2 3.2 2.0 4.4 2.3 15.1236 2.0125 4.365 3.02472
Dimension tables/database Daily
Revenue
1 $1,000.00
2 $1,300.00
3 $1,600.00
4 $1,900.00
5 $2,200.00
Further the measures of central tendency namely minimum, maximum and average for each
property of the five warehouse are calculated by suitable formulas as given below.
DW1 DW2 DW3 DW4 DW5 Total Lowest
Highes
t Average
Records 1400 1300 1100 1800 1000 6600 1000 1800 1320
Re-Entry
Required
due to
system
errors 109 7 295 54 86
550.555
6
6.55555
6 295
110.111
1
Total
Records 1291
1293.44
4 805 1746 914
6049.44
4 805 1746
1209.88
9
Dimension
Tables 26 26 16 35 18
120.988
9 16.1 34.92
24.1977
8
Tables per 3.2 3.2 2.0 4.4 2.3 15.1236 2.0125 4.365 3.02472
End of preview
Want to access all the pages? Upload your documents or become a member.