Report: Business Intelligence Implementation for Royal Dutch Shell, UK

This report provides a comprehensive analysis of business intelligence (BI) implementation at Royal Dutch Shell, UK. It begins with an executive summary, introduction, and literature review, followed by an in-depth discussion of BI models and their importance. The report addresses the problem stat...Read More

1 | P a g e
BUSINESS INTELLIGENCE

2 | P a g e
Table of Contents
Executive Summary...................................................................................................................4
Introduction................................................................................................................................5
Findings and analysis.................................................................................................................6
1.1 Literature review..............................................................................................................6
1.2 Discussion and analysis of the models of Business Intelligence and its importance.......6
1.3Problem statement...........................................................................................................10
1.4Aims and objectives........................................................................................................10
1.5 Implementation of Business Intelligence system for transforming business activities in
Royal Dutch Shell....................................................................................................................11
1.5.1 Cost management........................................................................................................11
1.5.2 Resource management................................................................................................12
1.5.3 Quality management...................................................................................................12
1.5.4 Risk management........................................................................................................12
1.5.5 Communication management......................................................................................13
1.5.6 Project blog.................................................................................................................14
1.5.7 Purpose and justification.............................................................................................15
1.5.8 Sponsor or supervisor recommendation......................................................................15
1.5.9 Research questions......................................................................................................15
1.5.10 Theoretical framework..............................................................................................16
1.6Methodology.......................................................................................................................17
1.6.1 Research and systems development method...............................................................17
1.6.2 Data collection or system design methods..................................................................17
1.6.3Ethical issues................................................................................................................17
1.6.4Compliance requirements.............................................................................................17
1.6.5Analysis of data............................................................................................................18
1.7Work breakdown structure and duration.............................................................................18

3 | P a g e
1.8 Gantt chart..........................................................................................................................19
1.9 Risk analysis.......................................................................................................................20
1.10 Conclusion and recommendations...................................................................................21
Reference list............................................................................................................................22

4 | P a g e
Executive Summary
The reason for this report will be to provide both the favourable circumstances that Hindrance
from utilizing the benefits of the business intelligence by providing benefits to the business,
Royal Dutch Shell, UK. Simultaneously it also provides additional factors to examine the
possibility in calculations which might be used to accomplish in figuring out which will be
considered to disclosure for data where it might make existing business alternately possibility
future clients.

5 | P a g e
Introduction
Business intelligence development starts on an experimental method, it need progressively
legitimated furthermore extended over the association. Likewise, as a result, that business
brainpower particular idea its innovation needsto beaccelerated. The business intelligence
will be a compelling figure for business focused on the investigation of the organization’s
contenders with. It helps to make key choices furthermore actually should settle on future
rotations. The association directors could assess qualities, shortcomings, and the competitors’
procedure by their skills, provisions also technologies, information where the majority of the
data is identified as per the competencies. Thus, the choices makers proceed to settle on best
possible methodologies adjust to the organization’s principle. Approach to a chance to be
introducing contends for business’s testing surroundings. Shrewdly,in this report, Royal
Dutch Shell of UK needs to provide aid towards superior expectation, which furthermore
deals with the dissection of the competitors’ method, and figure out from the disappointment
and victory simultaneously.

6 | P a g e
Findings and analysis
1.1 Literature review
In the words of Dooley et al.,(2018), it can be said haul benefits of the BI (business
intelligence), eludes all the technologies, requisitions and leads to more hones to the
collection, integration, analysis, and presentation that provides benefits of the business
majority of the data. The reason for business discernment action will be to help exceptional
business choice making (Elbashir et al., 2016). Essentially, the action of business intelligence
provides a framework that would provide data-driven choice for backing and developing
modern frameworks (DSS). Benefits of the business sagacity are now and again utilized
interchangeably for the preparation report card, inquiry devices and official data
frameworks(Mercuri, 2016).
Figure 1: The architecture of business intelligence
(Source: https://is.muni.cz/th/322817/fi_m/thesis_prikrylova.pdf)
As opined by Popovič and Jaklič (2015), benefits of the framework for business intelligence
action give historical, current, and predictive perspectives about the benefits of the business
operations. The majority often utilizing information that needs to be been assembled under
information warehouse or an information store and sporadically working starting with
operational information(Power et al., 2015).
1.2 Discussion and analysis of the models of Business Intelligence and its importance
The framework of Business Intelligence is not connected singly, yet it comprises of
interlocking the parts that must fill in together seamlessly to convey the benefits of the

7 | P a g e
business worth (Wang, 2016). It may be vital to note that there will be an assortment of
benefits of the BI(Business Intelligence) solutions, every serving different necessity (Qureshi
et al., 2017).Benefits of the Business Intelligence (BI) proselytes suitable data under
knowledge, accordingly permitting huge numbers endeavour errands with a chance to be
performed (Yeoh & Popovič, 2016).
However, it acquires a significant number of tests, which will provide benefits to the
respective business with the implementation of business intelligence (BI) tool, and methods
as well.
Figure 2: Evolution, applications and emerging research in BI
(Source: https://is.muni.cz/th/322817/fi_m/thesis_prikrylova.pdf)
As exhorted by Yeoh et al., (2015), it is said, the primary errands about promoting analytics
need aid to investigate client sales: the adequacy of an advertising crusade incorporates the
convoluted errands about forecasting, segmenting and mutually dissecting the data nearby
information hailing from web, mobile, and with the help of more GIS (geographical
frameworks).

8 | P a g e
Figure 3: Strategy for elaborating decision-making model
(Source: https://is.muni.cz/th/322817/fi_m/thesis_prikrylova.pdf)
RFM division permits marketers with target particular groups about clients for interchanges
that are significantly additional important to their specific conduct technique – and in this
way, the organization tends to produce a great part with higher rates for receiving the
response (Yeoh & Popovič, 2016). Like other division methods, RFM division may be a
capable route, which will recognise assemblies for clients for exceptional medication. RFM
remains to regency, money and frequency for developing the respective business (Gupta,
2018).
Figure 4: The RFM model
(Source: https://is.muni.cz/th/322817/fi_m/thesis_prikrylova.pdf)
With the implication of the magic quadrant of Gartner, the importance of business
intelligence can be studied as follows:
 It brings a continuous presence in the business for strengthening the growth of the
organization
 It can be used for the non-profitableorganizations as well
 It tends to incorporate the analytical component of the social media

9 | P a g e
Figure 5:Gartner’s magic quadrant – evaluation of commercial BI tools on the market
(Source: https://is.muni.cz/th/322817/fi_m/thesis_prikrylova.pdf)
The business intelligence will be a compelling figure for business focused on the
investigation of the organization’s contenders with. It helps to make key choices furthermore
actually should settle on future rotations (Yeoh & Koronios, 2016). The association directors
could assess qualities, shortcomings, and the competitors’ procedure by their skills,
provisions also technologies, information where the majority of the data is identified as per
the competencies (Wang, Wu & Zhang, 2015).
Figure 6: The Maturity model of Information
(Source: http://www.ijmae.com/files/accepted/345_final.pdf)
The maturity of the model of Gartner remains dependent upon three essential fields from
claiming the resources, procedures and engineering, whichincludes interoffice measures as
per five development levels. The five successive levels include tactical, unconscious,
concentrated, vital as well as pervasive.

10 | P a g e
Figure 7: The Maturity model of Gartner
(Source: http://www.ijmae.com/files/accepted/345_final.pdf)
1.3Problem statement
The significant objective from claiming benefits of the business intelligence framework may
stockpile about the previous information around a company's arrangements and uncover it
with respect to an approach that permits the experts in choice making with respect to the
choices developed (Trieu, 2017). On the contrary, this majority of the data sums a little part
of the thing that the organizations really oblige to function, furthermore, it controls becomes
worth (Wang, 2016). Same time it remains clinched alongside other situations for the client,
whichmight not need enthusiasm toward authentic information. Similarly, many people
understand that the organization manages for incessant change. Benefits of the business
intelligence can make the settings of the business for turning out being much jumbled (Storey
& Song, 2017).
1.4Aims and objectives
The aim of implementing business intelligence is to provide a framework that would provide
data-driven choice for backing and developing modern frameworks.
The objectives in implementing the Business Intelligence in Royal Dutch Shell can be studied
as follows:

11 | P a g e
 To understand the influence of integrated business plan for developing
interrelationships of business
 To understand the contribution of business intelligence in developing an effective
business structure
 To understand the influence of BI in moderating the quality of the business
organization
1.5 Implementation of Business Intelligence system for transforming business activities
in Royal Dutch Shell
1.5.1 Cost management
ACTIONS CHARGING
HOURS
CHARGE PER
HOUR (£)
TOTAL (£)
Entry of the
collected
information
30 9 270
Breakdown of the
collected data
45 5 225
Finalized project
expenditure
50 5 250
Making amends
with digital
solutions company
50 8 400
Composing final
draft
25 10 250
Total 1365
Table 1: Cost management
(Source: Created by the author)
1.5.2 Resource management

12 | P a g e
RESOURCES PLAN
 Development and framing of
questionnaire
Developing questionnaire as per the
feedback received from the correspondents
 Funding sources
Looking after the budget chart while
implementing business intelligence in the
organization
 Implementation of the equipment
required for Business intelligence
framework
Ensuring proper implementation of the
Business intelligence
Table 2: Resource management
(Source: Created by the author)
1.5.3 Quality management
The business intelligence will be a compelling figure for business focused on the
investigation of the organization’s contenders with. It helps to make key choices furthermore
actually should settle on future rotations (Psenka, Booty, & Duncan, 2018). The business
intelligence will be a compelling figure for business focused on the investigation of the
organization’s contenders with. It helps to make key choices furthermore actually should
settle on future rotations (Qureshiet al., 2017).
1.5.4 Risk management
OWNER OF THE RISKS RISK PROBABILITY (H,M,L)
 Project Administrator Lack of time management Medium

13 | P a g e
 Supervisor Bringing drastic changes in the
project
Medium
 Project Manager Insufficient financial supports High
Table 3: Risk management
(Source: Created by the author)
Figure 8: The risk assessment matrix
(Source: created by the author)
1.5.5 Communication management
WHAT WHO/TARGET FUNCTION WHEN/OCCURRENCE TYPE/PROCESS
The entire
Project
Team
Project
Executive
Discussing
the problems
with respect
to the survey
Once a week Initiating the
checklists of the
meeting
Team Members Obtaining
the status of
the projects
Once a week Obtaining the
status of the report
Risk 1
Risk 2
Risk 3

14 | P a g e
Developing
conversation
on the basis
of the status
of the budget
Once a week Drawing the
financial review
Survey
Respondent
s
Everyone (all
those who
participated
while conducting
the survey)
Discussing
the target of
the projects
and
executing it
accordingly
after a prior
detection of
the risks.
Daily Developing
overall review
Table 4: Communication management
(Source: Created by the author)
1.5.6 Project blog
Week 1 Arranging sponsorships and finance for introducing the
system
Week 2 Detecting the issues with respect to cost management
Week 3 Developing Hypotheses for conducting the analysis
Week 4 Detecting plan with respect to the risks observed
Week 5 Developing quality management program while detecting
the problems respect to the implementation of business

15 | P a g e
intelligence in Royal Dutch Shell
Week 6 Quality of study is framed and implemented
Table 5: Project blog that has been derived while conducting the project plan
(Source: created by the author)
1.5.7 Purpose and justification
The guideline for this work will be portrayed specific tribulations of systems that tend to
happen in a way of development to the organization for implementing business intelligence to
oversee economic, management issues and developmental process of Royal Dutch Shell
(Nasle, 2017). Furthermore, create methodologies, which should focus on the position of
trouble and resolve it accordingly.
1.5.8 Sponsor or supervisor recommendation
The sources of sponsorships for implementing the business intelligence in Royal Dutch Shell
include the following:
 Data warehouse
 Data mart
 BIDW
1.5.9 Research questions
It includes the followings:
 Discussing the problems while implementing BI in Royal Dutch Shell?
 The advantages of implementing Business Intelligence in Royal Dutch Shell?
 Developing strategies according to which BI can be implemented?

BUSINESS INTELLIGENCE
DATA WAREHOUSE DATA
MART
BIDW
DEVELOPED BUSINESS SYSTEM IN ROYAL DUTCH SHELL UK
16 | P a g e
1.5.10 Theoretical framework

17 | P a g e
1.6Methodology
1.6.1 Research and systems development method
The investigation provides the improvement that can be carried out with the help of three
approaches. The systems would be explanatory, exploratory and most importantly descriptive
(Poweret al., 2015). To perform the innovative work clinched alongside framework here
exploratory strategy is sought after. The exploratory system comprises of gathering
information possibly through review or by books, dissecting information (Kulkarni, Robles-
Flores & Popovič, 2017).
1.6.2 Data collection or system design methods
Gathering from claiming the realities, it will be carried by two diverse approaches. The first
approach is considered primary where the second approach tends to follow the first approach
(Popovič & Jaklič, 2015). In this research primary approach may go along which is
concerned for asking a number of inquiries from the respondents from hosting limitless
information around Business Intelligence for bringing innovation to the organization which
will be replied to an examination transform and the incidents if a chance to be kept the
mystery (Fink, Yogev & Even, 2017).
1.6.3Ethical issues
The significant objective from claiming benefits of the business intelligence framework may
stockpile about the previous information around a company's arrangements and uncover it
with respect to an approach that permits the experts in choice making with respect to the
mode of selections. On the contrary, this majority of the data sums a little part of the thing
that the organizations really oblige to function, furthermore, it control becomes worth (Choi,
Chan & Yue, 2017). The majority often utilizing information that needs to be been assembled
under an information warehouse or an information store and sporadically working starting
with operational information (Mercuri, 2016).
1.6.4Compliance requirements
The business intelligence will be a compelling figure for business focused on the
investigation of the organization’s contenders with. It helps to make key choices furthermore
actually should settle on future rotations (Elbashiret al., 2016). However, it acquires a

18 | P a g e
significant number of tests, which will provide benefits to the respective business with the
implementation of business intelligence (BI) tool, and methods as well.
1.6.5Analysis of data
Quantitative as well as Qualitative strategies ought to make the event that for conducting the
study of the report. In this procedure, an individual undergoes through an investigation that
consents to quantitative systems since it uses numerical and factual understanding for the
realities (Arnott, Lizama & Song, 2017).
1.7Work breakdown structure and duration
WORK BREAKDOWN STRUCTURE AND
DURATION THAT NEEDS TO BE
FOLLOWED FOR THE RESEARCH
START END DURATION
(DAYS)
Task 1: objectives and aims 16-06-
2018
18-06-2018 3 days
1.1 aims 16-06-
2018
17-06-2018 1 day
1.2 objectives 17-06-
2018
18-06-2018 1 day
Task 2: developing and shaping the
implementation plan
18-06-
2018
08-07-2018 20 days
2.1 finance projection 18-06-
2018
20-06-2018 3 days
2.2 future scope 20-06-
2018
25-06-2018 5 days
2.3 research quality 25-06-
2018
27-06-2018 2 days
2.4 purpose of the study conducted 27-06-
2018
01-07-2018 5 days
2.5 risk analysis with respect to the observations
drawn
01-07-
2018
08-07-2018 7 days
Task 3: the total work breakdown process 09-07- 07-08-2018 29 days

19 | P a g e
while conducting the study 2018
3.1 literature review of the study 09-07-
2018
12-07-2018 4 days
3.2 methodology implemented for the study 12-07-
2018
28-07-2018 15 days
3.3 data analysis for conducting the study 29-07-
2018
02-08-2018 5 days
3.4 data interpretation 02-08-
2018
07-08-2018 5 days
Task 4: Conclusion and recommendations 08-08-
2018
14-08-2018 7 days
4.1 proper stated recommendations developed 08-08-
2018
12-08-2018 5 days
4.2 conclusion drawn from the conducted
research
12-08-
2018
14-08-2018 2 days
Table 6: Work breakdown structure and duration
(Source: created by the author)
1.8 Gantt chart
Figure 9: The Gantt chart entry
(Source: created by the author)
Figure 10: The Gantt chart

20 | P a g e
(Source: created by the author)
1.9 Risk analysis
OWN
ER
OF
THE
RISK
S
RISK PROB
ABILI
TY
(H,M,
L)
RISK
PROBABILIT
Y
RISK
CONTINGEN
CY
RISK
MITIGAT
ION
Projec
t
Admi
nistra
tor
Lack
of
time
manag
ement
Mediu
m
It varies from
low probability
to high
Information
needs to be
gathered from
authentic
sources
Contingen
cy report
needs to be
followed
Super
visor
Bringi
ng
drastic
chang
es in
the
projec
t
Mediu
m
The probability
is low here
Follow the
GNATT chart
Following
with the
chart
GNATT
update
should be
made
Projec
t
Mana
ger
Insuffi
cient
financ
ial
suppo
rts
High Probability is
observed being
high here
The financial
report should
be focussed
Sponsors
are
required to
provide
support
Table 7: The Risk analysis
(Source: created by the author)

21 | P a g e
1.10 Conclusion and recommendations
RECOMMENDATIONS
THE MOST OBSERVED
RISKS THAT HAVE
BEEN DETECTED FROM
THE RESPECTED
SURVEY
STRATEGIES THAT
NEED TO BE
RECOMMENDED AS
PER THE OBSERVED
RISKS
DESCRIPTIONS TO THE
STRATEGIES THAT
HAVE BEEN
IMPLEMENTED AND
RECOMMENDED
 Lack of time
management
Lack of time management
brings failure to the
organization
Time helps to bring
successive growth
 Insufficient financial
supports
BI plan cannot be
implemented without basic
monetary support
Sufficient financial helps to
promote the organizational
firm from implementing the
system
Table 8: The recommendations that have been strategized to analyze the observed risks
(Source: created by the author)
THE DEDUCED CONCLUSION WITH ACCORDANCE TO THAT OF THE OBSERVATIONS
MADE
CONCLUSION 1 The risk with respect to finance should be
handled properly by implementing business
intelligence
CONCLUSION 2 Sufficient time management program should be
introduced to bring a growth over the
organization.
Table 9: The Conclusion drawn
(Source: Created by the author)

22 | P a g e
Reference list
Arnott, D., Lizama, F., & Song, Y. (2017). Patterns of business intelligence systems use in
organizations. Decision Support Systems, 97, 58-68.
Choi, T. M., Chan, H. K., & Yue, X. (2017). Recent development in big data analytics for
business operations and risk management. IEEE transactions on cybernetics, 47(1),
81-92.
Dooley, P.P., Levy, Y., Hackney, R.A. & Parrish, J.L., (2018). Critical value factors in
business intelligence systems implementations. In Analytics and Data Science (pp. 55-
78). Springer, Cham.
Elbashir, M.Z., Collier, P.A. & Davern, M.J., (2016). Measuring the effects of business
intelligence systems: The relationship between business process and organizational
performance. International Journal of Accounting Information Systems, 9(3), pp.135-
153.
Fink, L., Yogev, N., & Even, A. (2017). Business intelligence and organizational learning:
An empirical investigation of value creation processes. Information &
Management, 54(1), 38-56.
Gupta, A. (2018). Analysis of Real-Time Big Data: Its Applications and Challenges. Journal
of Data Mining and Management, 1(1, 2, 3).
Kulkarni, U. R., Robles-Flores, J. A., & Popovič, A. (2017). Business Intelligence Capability:
The Effect of Top Management and the Mediating Roles of User Participation and
Analytical Decision Making Orientation. Journal of the Association for Information
Systems, 18(7), 516.
Mercuri, M., (2016).Research & development in the Italian pharmaceutical industry and its
evolutionary perspective due to business intelligence systems and big data and analytics.
Nasle, A. (2017). U.S. Patent No. 9,557,723. Washington, DC: U.S. Patent and Trademark
Office.
Popovič, A. and Jaklič, J., 2015. Understanding the Influence of Business Intelligence
Systems on Information Quality: The Importance of Business Knowledge. Business
Intelligence: Concepts, Methodologies, Tools, and Applications: Concepts,
Methodologies, Tools, and Applications, p.96.
Power, D.J., Sharda, R. and Burstein, F., (2015). Decision support systems.John Wiley &
Sons, Ltd.

23 | P a g e
Psenka, M., Booty, M. D., & Duncan, B. (2018). U.S. Patent No. 9,866,561. Washington,
DC: U.S. Patent and Trademark Office.
Qureshi, N.A., Khan, B.A. & Saif, J.A., (2017). Business Intelligence Systems in the Holistic
Infrastructure Development Supporting Decision-Making in Organisations.
Storey, V. C., & Song, I. Y. (2017). Big data technologies and Management: What
conceptual modeling can do. Data & Knowledge Engineering, 108, 50-67.
Trieu, V. H. (2017). Getting value from Business Intelligence systems: A review and research
agenda. Decision Support Systems, 93, 111-124.
Wang, C.H., (2016). A novel approach to conduct the importance-satisfaction analysis for
acquiring typical user groups in business-intelligence systems. Computers in Human
Behavior, 54, pp.673-681.
Wang, J., Wu, X., & Zhang, C. (2015). Support vector machines based on K-means
clustering for real-time business intelligence systems. International Journal of
Business Intelligence and Data Mining, 1(1), 54-64.
Yeoh, W. & Koronios, A., (2016). Critical success factors for business intelligence
systems. Journal of computer information systems, 50(3), pp.23-32.
Yeoh, W. & Popovič, A., (2016).Extending the understanding of critical success factors for
implementing business intelligence systems. Journal of the Association for Information
Science and Technology, 67(1), pp.134-147.
Yeoh, W., Koronios, A. & Gao, J., (2015). Managing the implementation of business
intelligence systems: a critical success factors framework.