Business Intelligence Tools: Overview, Analysis, and Recommendations

This report provides a comprehensive overview of business intelligence (BI) tools, focusing on Yellowfin and Dundas BI. It explores the features of each tool, highlighting their capabilities in data visualization, analysis, and reporting. The report also delves into practical applications, including payroll calculations with examples, the use of COUNT IF functions, and conditional formatting for identifying customers likely to default on payments. The analysis emphasizes the importance of BI tools in modern business environments, offering recommendations for their implementation to gain a competitive edge. The report also includes an overview of the features of Yellowfin and Dundas BI. The document also includes payroll calculation and conditional formatting of the data.

Running Head: BUSINESS INTELLIGENCE 0
BUSINESS INTELLIGENCE TOOLS

BUSINESS INTELLIGENCE 1
Table of Contents
Overview....................................................................................................................................2
YellowFin...............................................................................................................................3
Features of Yellow Fin.......................................................................................................4
Dundas BI...............................................................................................................................4
Features of Dundas BI........................................................................................................4
Recommendations and Conclusion............................................................................................4
References..................................................................................................................................6

BUSINESS INTELLIGENCE 2
Overview
Business insight tools is a kind of the technology or the intelligent software which is planned
chiefly to recover the information, dissect the crude data and change the data into the
business knowledge programming. The applications for the most part read the information
which has been put away beforehand at various areas or locations all around the world. These
areas are likewise called the information distribution centre or the information bazaar. There
are several examples by which the business intelligence tools retrieves the data and
apparently recover the information are books, reports, messages, diaries, pictures and
different business sources (Cochran, 2018).
Ordinarily utilized for the questioning and the detailing the business intelligence tools can
amalgamate the arrangement of information, investigation and the applications which are
comprehensive of the specially appointed evaluation. There are various business insight
devices being built up each year. Maybe a couple of them which have been as of recently
presented are Dundas BI, yellow Fin, Tibco Spotfire and significantly more (Kimball, Ross,
Becker, Mundy and Thornthwaite, 2015).

BUSINESS INTELLIGENCE 3
(Source: Cochran, 2018)
YellowFin
Yellowfin BI is a business insight tool and 'start to finish' analytics stage that consolidates
perception, AI, and cooperation. Anyone can likewise effectively channel through huge
amounts of information with instinctive separating (for example checkboxes and radio
catches) also open up dashboards pretty much anyplace because of this current device's
adaptability in openness (versatile, site page, and so on). This provides the best data products
for the real data driven people. The yellow fin by name seems to be quite interesting just like
the directory of the information with the data clogged in it (YellowFin, 2018).
Yellow Fin forms the team with multiple support channels and the helps to scrutinize as well
as digitalise the market technologies. The Yellow Fin encourages the organizations by
providing the customised solutions to the customers according to their needs as well as the
preferences. Yellowfin ranked among the Top 5 analytics platforms across all 15 Gartner
Critical Capabilities for Analytics and Business Intelligence Platforms, 2018.

BUSINESS INTELLIGENCE 4
Features of Yellow Fin
 It is developed on the centralised architecture which provided the end to end business
solutions
 It comprises of web API and relational databases that help gather the information
without any hurdle or chaos.
 Yellow Fin is a data discovery and the clients can use with the assistance of the
Machine Learning.
 It is also available on the phone in the form of the application (YellowFin, 2018).
Dundas BI
In the real time there was a great need of the business intelligence tool and the serving that
has been satiated was due to the Dundas Bi, one of the most recommended business
intelligence tools in the corporate world. This tool helps to measure the performance and the
visualise the data on the dashboard so that clients can have easy access to them. The
dashboard of the Dundas BI allows the user to filter and sort the data (Dundas, 2017).
Features of Dundas BI
 The Dundas BI gives the simple, keen and the drop configuration device to make the
dashboards increasingly appealing
 The straightforwardness to redo and make individual dashboards is the fundamental
key driver of the Dundas BI insight programming (Dundas, 2017).
 The clients can ascertain propelled conditions with the assistance of the calculative
interface.
Recommendations and Conclusion
The above investigation gave an understanding of the business intelligence instrument and
assists in gaining learning of the on-going business knowledge tools. The Business intelligent
tools make the life of a person just as easy and simple and with its various highlights these
tools are used to analyse the data of the company and the clients. The facilitation of the data
with ease on any platform is the exact reason why the business intelligence tools are going to

BUSINESS INTELLIGENCE 5
drive the future. From this time forward, it is suggested that each association will introduce as
indicated by their spending limit to have an edge over the competitors by the use of the
business intelligence tools.

BUSINESS INTELLIGENCE 6
Payroll calculation
QUESTION 1 QUESTION 2
Level
Hourly
Pay
1 30
2 40
3 50
4 60
5 65
6 70
Employee
name
Classification
Level
Hourly Pay
Paris Holton 5 65
RickyMoritni 4 60
Jenifer Lopez 2 40
Selena
Geemak
2 40
Willard Smith 1 30
Russel Creak 6 70
Rafel Nooderly 4 60
Noovak
Djoker
1 30
Lara Bangle 3 50
Kath Hudson 6 70
Employee
name
Hours
worke
d
Regular
Hours
Overtim
e hours
Hourl
y pay
Base
amo
unt
Overt
ime
total pay
Noovak
Djoker
37 36
1 30 1080 30 1110
Willard
Smith
39 36
3 30 1080 90 1170
Lara Bangle 40 36 4 50 1800 200 2000
Kath Hudson 52 36 16 70 2520 1120 3640
Selena
Geemak
30 30
0 40 1200 0 1200
Paris Holton 45 36 9 65 2340 585 2925
Russel Creak 34 34 0 70 2380 0 2380

BUSINESS INTELLIGENCE 7
Jenifer Lopez 41 36 5 40 1440 200 1640
RickyMoritni 52 36 16 60 2160 960 3120
Rafel
Nooderly
44 36
8 60 2160 480 2640
Employee with
maximum
overtime earnings
Kath
Hudso
n
1120
QUESTION 3 COUNT IF
FUNCTIO
N
8
Customers who are likely to default
CONDITIONA
L
FORMATTIN
G
DATE AMOUNT DUE DATE OF
PAYMENT
PAID
ON
EXCEEDIN
G 45 DAYS
12/31/2019 5000 2/24/2020 2/4/2019 385.00 P
1/10/2020 6000 3/5/2020
2/24/201
9 375.00 Q
2/9/2020 7500 4/4/2020
2/14/201
9 415.00 R
2/29/2020 4000 4/24/2020 3/6/2019 415.00 S
3/10/2020 7200 5/4/2020 2/9/2019 450.00 T
3/30/2020 8200 5/24/2020
1/15/201
9 495.00 R
4/9/2020 3000 6/3/2020 2/4/2019 485.00 S
4/19/2020 4230 6/13/2020 3/1/2019 470.00 P
4/29/2020 5846 6/23/2020 3/2/2019 479.00 T
5/9/2020 6846 7/3/2020
6/10/201
9 389.00 Q
130.00

BUSINESS INTELLIGENCE 8
References
Cochran, S., (2018) How the use of business intelligence tools in the fistula sector can
improve surgical performance. Nepal Journal of Obstetrics and Gynaecology, 13(2).
Dundas, (2017) Dundas BI product features [online] Available from
https://www.dundas.com/dundas-bi/features [Accessed on 30th April 2019]
Kimball, R., Ross, M., Becker, B., Mundy, J. and Thornthwaite, W., (2015) The kimball
group reader: Relentlessly practical tools for data warehousing and business intelligence
remastered collection. John Wiley & Sons.
YellowFin, (2018) Insights that matter, when they matter [Online] Available from
https://www.yellowfinbi.com/ [Accessed on 30th April 2019]