Business Data Analysis and Business Intelligence Assignment

This assignment solution addresses various aspects of business data analysis and business intelligence. It begins with calculations for employee payroll, including regular and overtime hours, and computes total pay. The solution then utilizes pivot tables to analyze overtime hours and determine charges for a construction company. Furthermore, it identifies and explains two key features of business intelligence tools: executive dashboards and what-if analysis. The executive dashboards are explained as a tool for summarizing complex data and presenting it in a digestible way for executives, and the what-if analysis is presented as a tool to evaluate the potential impacts of critical business decisions. The assignment concludes with a reference list. This solution is designed to help students understand the application of data analysis techniques in a business context.

Running head: FUTURE ASSIGNMENTS 2
Future Assignments 2
Name of the University
Name of the student
Authors note

1
FUTURE ASSIGNMEMTS 2
Table of Contents
Answer to Question 1:.....................................................................................................................2
Answer to Question 1.a:..............................................................................................................2
Answer to Question 1.b:..............................................................................................................2
Answer to Question 2:.................................................................................................................3
Answer to Question 3.a:..............................................................................................................3
Answer to Question 3.b:..............................................................................................................3
Answer to Question 3.c:..............................................................................................................4
Answer to Question 2:.....................................................................................................................4
Reference List..................................................................................................................................6

2
FUTURE ASSIGNMEMTS 2
Answer to Question 1:
Answer to Question 1.a:

3
FUTURE ASSIGNMEMTS 2
Answer to Question 1.b:
Answer to Question 2:
Employee Name Hours
worked
Regular
Hours
Overtim
e Hours
Hourly
Pay
Base
Amoun
t
Over-
Time
Total
Pay
Jennifer Leepoz 36 36 0 80 2880 0 2880
Kath Hudson 52 37 15 80 2960 1350 4310
Lara Bangle 40 37 3 50 1850 270 2120
Novak Djoker 37 37 0 30 1110 0 1110
Paris Holton 45 37 8 70 2590 720 3310
Rafael Nooderly 44 37 7 60 2220 630 2850
Ricky Mortini 52 37 15 60 2220 1350 3570
Russell Creak 34 34 0 80 2720 0 2720
Selina Geemak 30 30 0 40 1200 0 1200
Willard Smith 39 37 2 30 1110 180 1290
Total 409 359 50 580 20860 4500 25360

4
FUTURE ASSIGNMEMTS 2
Answer to Question 3.a:
Row Labels Sum of Over-
Time
Kath
Hudson
1980
Ricky
Mortini
1980
Grand
Total
3960
Answer to Question 3.b:
In this context, pivot table can be used as an important tool for decision making along
with functions that have been stated.
The determination of charge to ABL Construction by Simple Contracts Ltd. Is done by
using pivot tables and the amount is computed at $20330.
Employees at Level 4 and Above:
Values
Row Labels Sum of Hourly
Pay
Sum of Total
Pay
Jennifer
Leepoz
80 2940
Kath Hudson 80 4380
Paris Holton 70 3450
Rafael
Nooderly
60 3060
Ricky Mortini 60 3780
Russell Creak 80 2720
Grand Total 430 20330

5
FUTURE ASSIGNMEMTS 2
Answer to Question 3.c:
Answer to Question 2:
The two most prominent feature of commonly business intelligence tool has been identified as
follows:
Executive Dashboards- In general, business dashboards can be used as a powerful tool for the
executed as they are able to make a summary of a complicated data and present the same in a
digestible way. The executive dashboard’s main intention has been seen with lending guidance to
the key performance indicators which should be used in an appropriate manner. The use of
personalised dashboards has been seen to deliver and understand real time data for business
leaders, decision makers and enabling faster response to the various types of internal and
external events. In addition to this, the executives need to deliver easy to understand Key
performance indicators and summary information on a scheduled daily basis. Henceforth, an
executive dashboard is considered as a computer interface which displays the KPI with the
corporate officers need to run effectively for an enterprise. Moreover, the exception reporting
factor should be able to Allard is executed for unexpected events and scenarios which are seen to
require immediate action of any sort. The personalised form of data enables the decision-makers
for quickly bring a guesswork without having to create the irrelevant information (Fairhurst,
2015)

6
FUTURE ASSIGNMEMTS 2
What if analysis- Another important feature of commonly used business intelligence tool has
been considered with using what if analysis which enables the business to evaluate the potential
impacts of the critical business decision before they take place. The use of existing data can
further formulate strategies for achieving business targets and avoiding default “hit and miss”
approach, which helps the management in understanding the accurate strategy planning (Braun
and Clarke 2014). The main use of the what if analysis is seen in several types of financial
perspectives in which the management needs to decide the implications of having a project to
accept in a certain situation. The what if analysis performance is used with several types of tools
such as 1000minds, Ahoona, Altova MetaTeam, Analytica, Criterium Decision Plus, D-Sight,
DecideIT, Decision Lens, Expert Choice, Hiview3, Intelligent Decision System and Logical
Decisions (Bryman & Bell, 2015).

7
FUTURE ASSIGNMEMTS 2
Reference List
Bryman, A., & Bell, E. (2015). Business research methods. Oxford University Press, USA.
Fairhurst, D. S. (2015). Using Excel for business analysis: a guide to financial modelling
fundamentals. John Wiley & Sons