Developing Global Management Competencies I: BI Report

This report delves into the application of business intelligence (BI) dashboards within an organization, specifically focusing on the New Castle FC. It begins by introducing the concept of BI dashboards, their adaptability, and their role in automating decision-making processes through data visualization. The report identifies the problem/opportunity as the optimal utilization of a BI dashboard across various departments, including purchase, salary, and customer satisfaction. It outlines the objectives of using a BI system, such as monitoring purchases, identifying system loopholes, and providing data-driven solutions. The report then explains key BI/data analytics systems, emphasizing their function in data analysis and presentation. A critical analysis and justification of a developed dashboard using Excel is provided, including data from the purchase department, customer satisfaction, and employee salary data. The report utilizes pivot tables and slicers in excel to create the dashboard. The report also includes an analysis of customer satisfaction levels, comparing satisfaction scores by agent and correlating them with the number of calls handled and resolution rates. Finally, the report examines the salary data of employees and footballers, offering insights into salary distribution and trends. The report concludes by highlighting the importance of data-driven decision-making for organizational improvement, using the New Castle FC as a case study.

Running head: BUSINESS INTELLIGENCE IN ORGANIZATION
Business intelligence in Organization
Name of the student
Name of the university
Authors note

1BUSINESS INTELLIGENCE IN ORGANIZATION
Introduction
The BI dashboard gives a rich UI that shows the data in a graphical structure utilizing
different components including tables. These components diminish the time spent on
dissecting the information utilizing databases and in this way help with automating the
business decision making process (Sluijter & Otten, 2017). Since a dashboard can be utilized
for various reasons by various individuals, it ought to be very adaptable for various clients
and various situations (Jelen & Syrstad, 2018). It should show just suitable data required by
the choice that are required to carry out their responsibility. The display components likewise
play a huge role in the decision making process. While showing data, the way (methods for
presentation) in which data is displayed is considered as important so that critical insights can
be depicted in simple manner that can be understood by any executive or employee.
Problem/opportunity
The data analysis study explicitly carried out to decide the ideal utilization of a
business insights dashboard among various departments (Purchase, salary and customer
satisfaction of the New caste FC. An efficient dashboard consisting and depicting different
insights provides a dense representation of an organization’s different departments
performance as well as sections that require improvement (Jelen & Syrstad, 2018). At the
point when structured properly, it is a simple to-utilize application where any sort of
subjective or quantitative information can be presented graphically and in a straightforward
way.
The main objective of utilizing Business Intelligence System for the New Castle FC
is to improve the administrations gave to provide following sections.

2BUSINESS INTELLIGENCE IN ORGANIZATION
 In order to screen the purchase and salary of the organization of the football
club.
 In order to give a knowledge in to the systems utilized by the organization and
recognize loopholes in them.
 In order to recognize the various types of economic and operational issues
faced by the club,
 In order to give an answer for the club by utilizing distinctive BI procedures.
 To plan a BI Framework such as Dashboards that can be utilized by the club,
to examine existing information in order to support them in taking business
key choices.
key business intelligence/data analytics systems
BI or the Business intelligence is an innovation driven procedure for investigating
information and exhibiting significant data to help end clients settle on progressively
educated business choices (Sluijter & Otten, 2017). BI incorporates an assortment of
applications and techniques that empower to gather information from inner frameworks and
outer sources, set it up for examination, create and run inquiries against the information, and
make reports, dashboards and information representations to make the logical outcomes
accessible to end clients and operational specialists.
BI information can incorporate recorded data, just as new information assembled from
source frameworks as it is created, empowering BI examination to help both key and strategic
basic leadership forms (Jelen & Syrstad, 2018). At first, BI instruments were fundamentally
utilized by information investigators and other IT experts who ran examinations and created
reports with question results for business clients. Progressively, in any case, business

3BUSINESS INTELLIGENCE IN ORGANIZATION
officials, financial experts, examination and specialists are utilizing BI programming
themselves, because of the advancement of self-administration BI and information disclosure
apparatuses.
Business insight joins a wide arrangement of information investigation applications,
including impromptu examination and questioning, venture revealing, online systematic
preparing, operational BI, cloud and programming as an administration BI, open source BI,
community oriented BI and so on (Jelen & Syrstad, 2018). BI innovation additionally
incorporates information representation programming for planning outlines and different
infographics, just as apparatuses for structure BI dashboards and execution scorecards that
show imagined information on business measurements and key execution pointers in a simple
to-get a handle on way.
Following are the features of the dashboards that are developed using g Excel.
Drill down in the dataset: it provides the ability to go from a rundown metric or view
to extra detail that gives more insights as well as breakout of the data.
Availability of Filters: Excel allows the users to characterize the extent of the
information in the dashboard to reflect their requirements (Sluijter & Otten, 2017). Channels
can either be worldwide (refining extension for the whole dashboard) or nearby (refining
degree for a particular outline or metric or view).
Export/print: Give users the capacity to mine data out of a dashboard. Fare to
positions that let clients accomplish more with the information like Excel and CSV as
opposed to PDF.
Comparison: Ability to see at least two subsets of the information next to each other.
A line diagram, for instance, may give the user a chance to see two agent’s performance
through independent lines.

4BUSINESS INTELLIGENCE IN ORGANIZATION
Alerts in the insights: Highlight data dependent on pre-characterized criteria. The
alarm might be enacted when a measurement goes outside of a specific limit.
Advanced representations: If it is valuable to indicate progressively complex
information in the dashboard, an assortment of cutting edge perceptions can help make it
absorbable. A couple of perception types to consider incorporate tree map, label cloud,
scatterplots and so on (Sluijter & Otten, 2017).
BI projects can likewise join types of cutting edge investigation, for example,
information mining, prescient examination, content mining, factual investigation and
enormous information examination (Jelen & Syrstad, 2018). Much of the time however,
progressed investigation ventures are directed and overseen by discrete groups of information
researchers, analysts, prescient modellers and other gifted examination experts.
The decision making process is a significant procedure for any organization like the
New Castle FC; Decisions made by administrators or the executives are exceptionally
important for the improved performance of the any organization. Thus the New Castle FC
should upgrade its vital decision making process depending upon the available data insights.
With the increase in information accumulation because of the developing worldwide market
and customization, the decision making process should be quick and progressively exact.
Critical analysis and justification of developed dashboard
For the New Castle FC, the purchase department takes care of the purchase of the
different elements that are required for the team and games such as football, gloves, energy
drinks and other relevant items. From the data set the following details are available
according to the regions in which they were bought.

5BUSINESS INTELLIGENCE IN ORGANIZATION
Eas
t
107
29
Nor
th
128
38
Sou
th
138
94
We
st
106
94
Following is the dash board created for the purchase department. The dashboard is
created with the help of the pivot tables and slicers available in the excel. Slicers tool in
Excel works as a graphic filters for the pivot charts that are creeated depending upon the
tables, pivot tables. With their chart data filtering qyuality it fits bet in the dashboards as
well as summary reports. Use of the slicer makes filtering of the seected data faster and
easier from any aspect using which slicers are generated.

6BUSINESS INTELLIGENCE IN ORGANIZATION
The Dataset contains data about the 6 months from January to June and for four
regions. For the month of january it can be seen that south region had the highest purchase
where as the west region has the lowwest purchse compared to other regions. Following is
the breakable for different months.
ENRGEY
DRINKS
49041
East 15023
North 13776
South 11816
West 8426
FOOTBALL 44228
East 7891
North 11907

7BUSINESS INTELLIGENCE IN ORGANIZATION
South 13591
West 10839
GLUVE
S
42339
East 8448
North 10689
South 11005
West 12197
JERSY 48964
East 13726
North 12927
South 10885
West 11426
MEDICAL
KIT
49734
East 11938
North 11460
South 13624

8BUSINESS INTELLIGENCE IN ORGANIZATION
West 12712
SHOES 45952
East 13514
North 9055
South 8431
West 14952
Grand
Total
280258
It can be stated from the above tables the maximum amount of purchase is done for
the Energy drinks for the team. Whereas, the gloves have the lowest amount of purchase.
In the next part, the customer satisfaction data is considered. In the first graph the
customer satisfaction score for different agents are compared. In the comparison it found that
employees like the Andrew, Benjamin, Oliver and Roy has the highest satisfaction rate where
as compared to that Homer, Bernard, Phillip, William have the lowest satisfaction score with
values ranging between the .5 to .6

9BUSINESS INTELLIGENCE IN ORGANIZATION
Alexander
Andrew
Ben
Benjamin
Bernard
Chester
Clyde
Edward
Elmer
Francis
George
Herman
Homer
Hugh
Jack
James
Jerry
Joe
Oliver
Oscar
Philip
Roy
Samuel
Stephen
Warren
Will
William
Willie
0
0.2
0.4
0.6
0.8
1
1.2
0.66
0.99
0.8
0.99
0.53
0.85
0.750.74
0.56
1
0.75
0.97
0.52
0.82
0.560.58
0.95
0.51
0.99
0.73
0.53
0.99
0.91
0.830.79
0.69
0.51
0.69
Satisfaction score compared by Agent
Total
Agent
Score
For the next section, the number of calls attended by different employees are
displayed in the chart where it can be seen that the employees with the highest number of
calls also has the better satisfaction rate.
August
Alfred
Arthur
Bert
Charlie
Clyde
Earl
Edwin
Floyd
Frederick
Harvey
Homer
Ira
James
Jim
Julius
Leonard
Marion
Oliver
Paul
Ray
Roy
Sidney
Tom
William
0
10
20
30
40
50
60
Number of Calls compared by Agents
Total
In the next part, the resolution rate by the agents are compared. In this part it can be
evident that Andrew, Holmer, William has the highest resolution rate.

10BUSINESS INTELLIGENCE IN ORGANIZATION
Alexander
Andrew
Ben
Benjamin
Bernard
Chester
Clyde
Edward
Elmer
Francis
George
Herman
Homer
Hugh
Jack
James
Jerry
Joe
Oliver
Oscar
Philip
Roy
Samuel
Stephen
Warren
Will
William
Willie
0
40
80
85 90 70 74 70 86 79 81 79 71 83 73 90 86 76 74 72 80 87 79 83 71 84 75 78 79 88 86
Resolution rate compare by Agent
Total
Axis Title
Rate
Thus it can be stated that the resolution rate and satisfaction rate is directly connected
with the number of attended calls.
In the next section the salary of the employees, footballers are compared and
analysed.
ANALYST 18290557
Africa 200706
Americas 6548194
Asia 7277633
Europe 3377102
Oceania 886922
COACH 18764263
Africa 526200
Americas 7315988
Asia 7839744
Europe 2202761
Oceania 879570
MANAGE 19597523

11BUSINESS INTELLIGENCE IN ORGANIZATION
R
Africa 504210
Americas 7194925
Asia 7729812
Europe 2849064
Oceania 1319512
PLAYER 17827275
Africa 383025
Americas 7309053
Asia 6521789
Europe 2832547
Oceania 780861
Grand
Total
74479618
Following chart depicts the salary of the employees in different months.
March
June
Jan
Feb
Apr
May
Jul
Aug
March
June
Jan
Feb
Apr
May
Jul
Aug
March
June
Jan
Feb
Apr
May
Jul
Aug
March
June
Jan
Feb
Apr
May
Jul
Aug
ANALYST COACH MANAGER PLAYER
0
200000
400000
600000
800000
1000000
1200000
1400000
1600000
592532
976177
628027
824326
934496
1071205
769506751925
647738
1124622
12749741231169
730458
1018112
645377643538600506
846596896093
1307676
995995
778661784702
984696971667
613315
757518
1346075
951863
1101758
756025810832
Comparison of Salary
In the above chart, it is found that for the managers the highest amount of salary is
disbursed in the month of February.

12BUSINESS INTELLIGENCE IN ORGANIZATION
Americas
Asia
Europe
Oceania
Americas
Asia
Europe
Oceania
Americas
Asia
Europe
Oceania
Americas
Asia
Europe
Oceania
ANALYST COACH MANAGER PLAYER
0
100000
200000
300000
400000
500000
600000
700000
800000
Total
For, the different employees and footballers of different countries is compared in the
above chart of the dashboard. In the analysis, it is found that, highest amount of salary is
provided to the employees from Asia. On the contrary the lowest amount of salary is
provided to the employees from Oceania.
Following is the monthly breakable for the salary of the employees that are provided
to them.
ANALYST 6548194
March 592532
June 976177
Jan 628027
Feb 824326
Apr 934496
May 1071205
Jul 769506
Aug 751925
COACH 7315988
March 647738
June 1124622

13BUSINESS INTELLIGENCE IN ORGANIZATION
Jan 1274974
Feb 1231169
Apr 730458
May 1018112
Jul 645377
Aug 643538
MANAGE
R
7194925
March 600506
June 846596
Jan 896093
Feb 1307676
Apr 995995
May 778661
Jul 784702
Aug 984696
PLAYER 7309053
March 971667
June 613315
Jan 757518
Feb 1346075
Apr 951863
May 1101758
Jul 756025

14BUSINESS INTELLIGENCE IN ORGANIZATION
Aug 810832
Grand
Total
28368160
Recommendations
From the analysis it is found that there is huge difference between the employees of
different employees of other countries and employees from Asia. Therefore, it is suggested to
employees from other countries so that the cost for the employees can be decreased and
evenly distributed.
The agents needs to be trained in such a way that, they can have better resolution for
the customers while receiving good number of call.
Conclusion
In any organization the excel based dash board helps in acquiring great change in the
business operation execution furthermore, as the decision making procedure should be
possible productively. The Dashboard detailing carries with it, eminent detailing and
management can have better insights without much of a stretch make and keep up the
dynamic reports. It is through the dynamic reports that will almost certainly explore through
the information just as look at the information from various sources. Dynamic reporting in
excel likewise helps in the contrasting the information from a few different sources over the
time. in order to put it plainly, Excel can bring total change the business process
improvement through the better insights.

15BUSINESS INTELLIGENCE IN ORGANIZATION
References
Silva, R. F. (2017). Excel Create and Learn-Dashboard: More than 250 images and, 4 Full
Exercises. Create Step-by-step a Dashboard.
Raef, B. (2017). 42: DESIGNING A DASHBOARD FOR EVALUATION THE BUSINESS-
IT ALIGNMENT STRATEGIES IN HOSPITALS ORGANIZATIONS. BMJ
open, 7(Suppl 1), bmjopen-2016.
Rad, R. (2018). Power BI and Excel. In Pro Power BI Architecture (pp. 411-432). Apress,
Berkeley, CA.
.Raubenheimer, J. (2017). Excel-lence in Data Visualization?: The Use of Microsoft Excel
for Data Visualization and the Analysis of Big Data. In Data Visualization and
Statistical Literacy for Open and Big Data (pp. 153-193). IGI Global.
Fang, J. (2018). Retrieving HTML and XBRL Data With Microsoft Excel 2010.
In Maximizing Social Science Research Through Publicly Accessible Data Sets (pp.
62-82). IGI Global.
Chien, T. W., Shao, Y., & Kuo, S. C. (2017). Development of a Microsoft excel tool for one-
parameter Rasch model of continuous items: an application to a safety attitude
survey. BMC medical research methodology, 17(1), 4.
Diamond, M., & Mattia, A. (2017). Data Visualization: An Exploratory Study into the
Software Tools Used by Businesses. Journal of Instructional Pedagogies, 18.
Jelen, B., & Syrstad, T. (2018). Microsoft Excel 2019 VBA and Macros. Microsoft Press.

16BUSINESS INTELLIGENCE IN ORGANIZATION
Reddy, C. S., Sangam, R. S., & Rao, B. S. (2019). A Survey on Business Intelligence Tools
for Marketing, Financial, and Transportation Services. In Smart Intelligent
Computing and Applications (pp. 495-504). Springer, Singapore.
Sluijter, J., & Otten, M. (2017, March). Business intelligence (BI) for personalized student
dashboards. In Proceedings of the Seventh International Learning Analytics &
Knowledge Conference (pp. 562-563). ACM.