Accounting Information System Question Answer 2022

Running head: ACCOUNTING INFORMATION SYSTEM
Accounting Information System
Name of the Student
Name of the University
Author Note

ACCOUNTING INFORMATION SYSTEM1
Table of Contents
Question 1:.......................................................................................................................................2
2. Portraying the Payroll table:....................................................................................................2
3. Discussing, justifying and illustrating two more functions that can be included to help with
the decision-making process:.......................................................................................................2
Question 2:.......................................................................................................................................3
1. Describing the growth of business intelligence in the past few decades (Analysis of the
growing trend of business intelligence of previous years):.........................................................3
2. Briefly illustrating at least 2 features of commonly used business intelligence tools that
support the business decision-making:........................................................................................6
Executive Dashboard:..................................................................................................................6
Interactive Reports:......................................................................................................................7
Question 3........................................................................................................................................7
Regulations Brought in After the Scandal...................................................................................8
Reference.......................................................................................................................................10

ACCOUNTING INFORMATION SYSTEM2
Question 1:
2. Portraying the Payroll table:
3. Discussing, justifying and illustrating two more functions that can be included to
help with the decision-making process:
In addition to VLOOKUP method, certain functions like ‘INDEX MATCH’ and ‘IF
associated with AND or OR’ can be applied in the above mentioned framework. It is possible to
obtain the correct information based on the calculation done by using ‘INDEX MATCH’
function, just like ‘VLOOKUP’, that can depict the exact payroll of the employees which is
shown by the above table. The ‘INDEX MATCH’ method also helps in deriving the maximum
overtime earnings of the employees as depicted in the above list.

ACCOUNTING INFORMATION SYSTEM3
Question 2:
1. Describing the growth of business intelligence in the past few decades (Analysis
of the growing trend of business intelligence of previous years):
Figure 1: Chart Showing Big Data
(Source: Statista.com 2019)
The above graph portrays an overall increase in the big data trend that has improved with
the progression of the time period. The revenue trend of big data and business analytics
worldwide from the year 2015-2020 is expected to have an abrupt exponential increase. The
graphical analysis of the historical trend illustrating the revenues of big data and business
analytics worldwide indicates that their overall performance has improved from 122 billion in
the year 2015 to 166 billion in the year 2018. For the year 2022, the total revenue to be earned is
anticipated to rise to about 260 billion. This prediction regarding the big data trend and business
analytics implies a positive growing tendency of the business intelligence across the whole
world. The entire anticipation is done, completely based on the growth of the business
intelligence observed in the early fiscal years. In the view of Chen, Chiang and Storey (2018), as