Generation Analysis Iteration - Examining Shell's Business Processes, Data Management Systems, and BI Tools

This report examines Shell's business processes, key decisions, digital transformation, data management systems, and business intelligent tools. It analyzes the company's operations and maintenance department, its use of centralized database management systems, and the potential benefits of big data and BI tools. The report also discusses the opportunities for intelligent tools and systems in the oil and gas sector.

Generation Analysis Iteration

TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................1
TASK – 1 (THE COMPANY AND THE BUSINESS PROCESSES)...........................................1
1.1 Business process map and flowchart............................................................................1
1.2 Key business decision...................................................................................................2
1.3 Business digital transformation........................................................................................3
TASK – 2 (DATA MANAGEMENT SYSTEMS).........................................................................4
2.1 Information or data management system.........................................................................4
2.2 Database management system..........................................................................................4
2.3 Big data for business........................................................................................................5
TASK 3: (BUSINESS INTELLIGENT (BI) TOOLS)....................................................................6
3.1 Opportunities for Intelligent Tools and Systems..............................................................6
3.2 Business Intelligent (BI) Support.....................................................................................7
3.3 Reflecting on the BI tools.................................................................................................7
CONCLUSION................................................................................................................................8
REFERENCES................................................................................................................................9

INTRODUCTION
Speaking in relation with the data analysis, it is one of the most crucial aspects because it
supports in analyzing the significant factors of the firm that possesses a lot of value in the
present market condition. the main aim of the current research report is to offer a detailed
examination of Shell, an international oil and gas company of UK with having expertise in
exploration, refining and marketing of oil, natural gas and chemicals. The report will focus on
the business processes of the company and will determine the key decisions being made in this
process. Further, it will also throw some light on the how the business process can be digital
transformed and will emphasize on the data management system. The final section will discuss
the opportunities for business intelligent tools and the manner in which they can support the
business.
TASK – 1 (THE COMPANY AND THE BUSINESS PROCESSES)
1.1 Business process map and flowchart
Shell specializes in the oil and gas sector and there are different activities being
performed by the company. However, for the current purpose the operations, servicing as well as
repair business processes is being taken into consideration. The company employs high level of
strategy in their operations and this has resulted in the growth of the UK’s oil and gas sector.
The company has a different department known as maintenance which conducts full variety of
containment vessel and water storage cleaning, maintenance and repair services (Mirvis, 2019).
1

There are different resources which are available to this department such as works
coping, general and dimension survey, project management, job pack preparation, procurement
planning, procurement of project materials, repair, cleaning and maintenance. The main aim of
this business process of the company is to offer higher value through leveraging the extensive
service and expertise abilities. The main mission of this department is making improvement,
extension and adding value to their services for the purpose of making sure continuous success
and evolution and at the same time fostering sustainability in the activities of the business by the
combination of social, health and safety and economic considerations (Glykas, 2013).
All these services are being offered by the department for making sure that the business
carries out its operations smoothly and effectively in the context of time and without any
damages and injuries. Other than this, the operations and the maintenance team also make sure
that the each and everything is in order and under power. Further, the department also makes
planning related to procurement and obtains materials from assortment of suppliers and firms
that specializes in manufacturing products being designed particularly for the oil and gas
industry operation and maintenance services (Liu and Heer, 2018).
2
S h ell
M an u fact
urin g
O p eration
&
M ainten a
nace
S to rag e an d
cleanin g
R ep air,
up ke ep in g an d
pro cu rem en t
plan nin gG en eral
m ain ten an ce,
insp ection and
m o n itorin g
M arketin g

1.2 Key business decision
There are variety of key decisions which are being taken in this process for the purpose
of maximizing the efficiency as well as usefulness of the firm such as tactical as well as strategic
decisions. Talking first in relation with the tactical decisions, they are generally short-term
decisions such as scheduling of maintenance activities, logistics planning, inventory planning
etc. On the other hand, strategic decisions have a longer-term influence on the operations and
growth of the company. Some of these decisions in the operation and maintenance business
process of Shell includes allocation of the capital, procurement of equipment related to cleaning,
repair and maintenance, maintaining the expenses in the maintenance budget, stocking of the
spare parts. Further, a strategic decision is being taken in relation with the health and safety of
the workers (Prat, 2019).
The operation and maintenance department of Shell focusses on the significance of the
healthy work practices and in this regard, they have developed certain established guidelines that
needs to be complied by each and every one on the basis of the situation. Further, the company
has also ban smoking in the premises of the company as it is related with the oil and gas sector,
further the walls of the offices are also piled up with pack papers. In addition to this, it has been
also ensured that while repairing, upholding and conducting other maintenance work, the
employees must always wear Personal Protective Equipment (PPE). All these strategic decisions
have a crucial influence on the present maintenance activities or on the performance indicators
like, cost, reliability and availability (Mirvis, 2019).
1.3 Business digital transformation
There is a requirement of digitalization in almost every sector as it supports in
augmenting the level of performance and also assists in reducing the total costs being incurred in
the business. Therefore, it is important that Shell should also make use of advanced and digital
technologies in their operation and maintenance business process so that it can prove
advantageous for them to sustain as well as survive for longer period of time in comparison to its
competitors which are also operating in the similar sector. In this regard, it is important for the
company to make use of artificial intelligence such as industrial robots, which are now
becoming a progressively choice in assortment of industries for varied applications (Seddon and
Currie, 2017). Robotic infrastructure can be used by Shell which are highly versatile as well as
3

programmable. Floor activities, quality control, assembling of spare parts, stocking and so froth
can be done by these robots effectively.
The business process will become highly effective and it will also support in reducing the
overall cost and budget of the maintenance department through less appointment of workers,
saving of time, reduced injuries and wastage. Other than this, the company can also make use of
wireless communication for communicating effectively within department and across the
organization. They can use Wireless Local Area Network (WLAN), Global Positioning System
(GPS) and Mobile Telephone Communication System. Further, for the purpose of attendance of
the workers, the company can also make use of electronic finger-based system of attendance
with a view to effectively calculate and monitor the exact working hours of each and every
worker (Chaffey, Hemphill and Edmundson-Bird, 2019). With this system in place, the company
will be able have a fair analysis of all the aspects which are related with the activities of the firm
in longer period of time.
TASK – 2 (DATA MANAGEMENT SYSTEMS)
2.1 Information or data management system
There are varied systems of data and information management which supports the firm in
growing and achieving prosperity in the present market condition in which it is operating as it is
very competitive and dynamic in nature. However, two information systems such as sales and
human resource is being taken into consideration for running the business process that have been
analysed in task 1. Both sales along with human resource helps in adding value to the business
and also proves quite beneficial for augmenting and improving the total conditioning along with
positioning in the enduring time (Denić and et.al., 2015). Talking in relation with the sales
department, it is one of the most crucial factors as it supports in making improvement in the
performance of the company through augmenting the volume of output which the firm is
creating in the present sector. The management of the sales includes all the facets which are
closely connected with it such as quality, quantity of the merchandise and services which the
firm is creating in the marketing for maximizing the customer’s experience. This again supports
in augmenting the market value of the firm in the competitive working environment.
On the other hand, the human resource management system supports in getting a perfect
candidate for conducting the activities so that the capabilities and knowledge of that candidate
4

can be utilized in the firm for earning more profits in long run and efficiency in maintenance and
repair services (Liu and Heer, 201). The company makes use of effective selection approaches in
the recruitment and selection processes for getting the desired and deserved applicant for the
chosen job role. Through this, the overall value of the maintenance and operation business
processes of Shell is being enhanced. Therefore, from the above evaluation, it can be said that all
the factors are being regarded as crucial for the operations regardless of the sector in which the
firm operates. Nevertheless, the information system such as sales and human resource are the
most crucial and necessary because they are the backbone of the organization.
2.2 Database management system
There are different types of database management system which can be attached to and
can be utilized for supporting the information system being determined in earlier task that is
sales and human resource such as centralized, relational, network etc. However, the most
important and relevant among them is centralized database management system. Since, human
resource department supports the operations and maintenance business process of Shell by
providing right candidate and the right job, they can make use of Applicant tracking systems
(ATSs) which is a centralized database management system for managing all recruitment and
hiring efforts of the company (Chiu, Lin and Jou, 2019). In addition to this, for the purpose of
storing the information in regards with the sales and human resource, the company can also
make use of cloud computing which is being referred as the cloud database for data storage and
computing power.
In order to be successful in the industry, Shell can pay attention on using the SQL which
is standardized programming language that is used to manage relational database and perform
various operation on data. There are distinct purposes for which having the successful operating
via collecting, storing and analyzing the data in most precise manner can become possible.
Cloud computing as being one of the advanced technique for managing data management
system can help in accomplishing benefits such as improved h data sharing & security effective
integration, possessing reliable data so that better decision-making for inclined productivity can
be done. This helps in having compliance with the trends of markets so that consumer can be
satisfied. It helps in gaining the precise formulation of production plan, etc for maintaining
highly effective processing based on available information in higher effective manner.
5

2.3 Big data for business
Big data is related with having the combination of structured, semi and unstructured
data collected by organization that can be mined for having the effective execution of processing
(Srivastava and Venkataraman, 2022). In the Shell organization there are various types of the
processes which are exerted for meeting the market forces that involves having right candidate,
possessing effective production marketing, financial planning, etc. optimum utilization of
resources by ensuring significant application of the strategic decision that can give assurance of
highly productive results. Microsoft big data is one of the crucial tool that is helpful in storing
the large data in turn application of significant storing, analyzing and meeting the organizational
objective of having reliable insights about the existing circumstances in turn accomplishing goal
of highly efficient processes for execution of processes of reducing the legal liabilities of tax,
optimum utilization of resource, etc (Big Data Tools. 2022). On the basis of this it can be
interpreted that Shell with help of the big data tool can obtain the significant information which
can allow taking strategic decision in tun higher profitability by eliminating irrelevant aspects in
turn higher profitability & stability in the industry can be derived.
The big data analytical tools are helpful in receiving the significant processing in Shell
by permitting to gather, store, and manage the insights regarding various factors such as
employees, customers, products, etc. so that taking competitive decision can become possible
(Sharma and et.al., 2021). On the basis of this, it can be mentioned that the big data is helpful in
gaining competitiveness by developing higher efficiency in the overall processing so that greater
effectiveness to deal with higher competition in market. Big data tools in Shell can get the better
approach of growth & development in turn higher compliance with operational, financial, legal.,
etc compliance can become possible.
TASK 3: (BUSINESS INTELLIGENT (BI) TOOLS)
3.1 Opportunities for Intelligent Tools and Systems
There are different forms of the business intelligent tools that are basically taken into the
procedure by the company in turn accomplishing the goal of having effectual processing can
become possible (Edge, Larson and White, 2018). Shell is one of the international organizations
that focuses on having application of effective tools in turn attaining good ability to coordinate
with the prevailing circumstances by having effectual processing through taking corrective
execution of the activities can exert in effective manner. The main reason behind the application
6

of oil and gas tool reserve checking so that appropriate manner of maintenance can be done for
this purpose there are different form of the Microsoft power BI, looker, clear analytics, tableau,
oracle BI, IBM Cognos analytics, SAS, data pine, Micro strategy, etc.
There are different types of the BI tools which can be taken into the procedure for
having collecting data, analyzing, etc. These are the different form of the tools that can be easily
employed by Shell as it is one of international organization that has good availability of
resources in turn highly effective so that collecting and processing unstructured data in turn good
ability to formulate decision-making can become possible (Ratia, 2018). Currently the firm is
using AI for the purpose of having the insights to identify possible oil and gas reserve so that
number crunching & statistical analysis to predict future events. On the basis of this, it can be
mentioned that AI is helpful in accomplishing the goal of having precise information for gaining
the rapid growth via taking accurate decision. This can help in accomplishing objective of
maintaining process in most fair functioning by possessing by application of business
intelligence tool in the most reliable manner. This can allow firm to develop effective
functioning by attaining corrective details so that meeting market demand in the most effective
manner can be done.
3.2 Business Intelligent (BI) Support
There are various form of the benefits by application of the business tool in turn
achieving ability to coordinate with complex processes. With help of the application of BI tools
that includes Microsoft power, looker, clear analytics, tableau, oracle, etc can allow Shell to
obtain competitive edge. This can permit the firm to get fast & accurate planning, valuable
business insights, effective data quality availability, improved operational efficiency, significant
& strategic decision-making, grabbing opportunities of growth, etc in the instant manner
(Business Intelligence Tools, 2022).
Shell as being an international organization require developing effective maintenance
process so that better functioning to have smarter & faster reporting for recognizing trends &
pattern. It can be helpful in maintaining good level of assurance in maintaining quality in
particular procedure so that maximum efficiency in declining challenges of time consumption,
inappropriate decision formulation, inability to cope up with trends, etc. as being an international
organization having effective maintenance and support process can become possible in turn
7

higher profitability & sustainability in functioning can become possible (Taipalus and
Seppänen, 2020).
There are various stakeholders of the company which involves both internal and
external. The internal stakeholders involve employees, owner and managers. In addition to this,
it comprises external stakeholders such as lenders financial intuitions, suppliers, investors, etc.
BI basically have the positive form of impact on both internal & external stakeholders that
ensure that good level of performance by offering data set about competitiveness such as
strategic decision formulation, quality maintaining, etc (Boehm, Kumar and Yang, 2019).
Customers are the crucial stakeholder whom information regarding trusted processes via having
improved operational efficiency can be provided (Václav and et.al., 2021). It helps in reducing
the risks so that customers can understand that the proper quality of products and services can be
maintained. Business intelligence can help in gaining the competitiveness to the organization to
have higher profitability via achieving effective processing in firm by ensuring quality
operational processes in turn higher productive outcomes can be offered to customers.
3.3 Reflecting on the BI tools
From the evaluation it can be mentioned that there are different forms of the benefits
which can be derived by the organization through the application of business intelligence tools
which can be helpful in receiving aspects such as higher efficiency and effectiveness in
operational activities. In my opinion business intelligence tool is helpful in accomplishing the
goal of taking strategic decision-making by considering the various aspects such as gathering
data, analyzing it, etc. On the other, in my opinion there are certain limitations which is required
to be taken into the process which involves security issues and ethical considerations. In my
views a having application of these tools can hamper the security & privacy issue which include
poor access control for sensitive data, flaws with APIs, lack of the data source security, etc.
There is availability of the distinct business intelligence features which can impact the
functioning of firm which involves protecting data pipeline and setting up rules for controlling
information, etc. (Tavera Romero and et.al., 2021). It can be mentioned that shell as being the
one of the international organization can pay attention data masking, encrypting, AWS security,
Limited operating system access, compliant with regulations, etc (Shakil and et.al., 2020) .
There is threat of the ethical consideration as business intelligence is application of
computers that does not involve higher focus on regulating the employee conduct for the
8

involuntary release of the personal information, threat of theft and misusing of insights, etc
(Putra, 2020). In addition to this, it can be mentioned that these are the ethical issues which are
required to be deal as in the policy, strategy and structure formulation on the basis of the
business intelligence tools can be bias and improper application of decision can hamper its
ability to coordinate with industrial rules and regulations. Business intelligence possesses the
significant features which ensure that effective cope up with requirement of organization by
ensuring favorable impact on the society can be implemented.
CONCLUSION
From the above report it can be concluded that data analysis is helpful in accomplishing
the organizational objective of higher profitability & stability by taking strategic decision. The
current study has given focus on having reliable key business decisions regarding allocation of
capital, procurement of equipment, etc. This study has given focus data management system
such as Applicant tracking systems, could computing, etc. that helps in taking the strategic
decision which support firm to have reliable procession. In addition to this, it has involved tools
of BI which comprises Microsoft power BI, looker, clear analytics, tableau, oracles, etc. that
helps in having successful processing.
9

REFERENCES
Books and Journals
Boehm, M., Kumar, A. and Yang, J., 2019. Data management in machine learning
systems. Synthesis Lectures on Data Management. 11(1). pp.1-173.
Chaffey, D., Hemphill, T. and Edmundson-Bird, D., 2019. Digital business and e-commerce
management. UK: Pearson.
Chiu, Y.C., Lin, H.H. and Jou, Y.T., 2019. A Model Selection Method for Machine Learning by
Differential Evolution. In Proceedings of the 2019 4th International Conference on Big
Data and Computing (pp. 135-139).
Denić, N., Stevanović, V., Milićević, V. and Goran, R., 2015. Possible business aspects of
application of intelligent systems in small and medium enterprises in Serbia. International
Multidisciplinary Scientific GeoConference Surveying Geology and Mining Ecology
Management. SGEM. 1(2). pp.257–264.
Edge, D., Larson, J. and White, C., 2018, April. Bringing AI to BI: enabling visual analytics of
unstructured data in a modern Business Intelligence platform. In Extended abstracts
of the 2018 CHI conference on human factors in computing systems (pp. 1-9).
Glykas, M., 2013. Business Process Management: Theory and Applications. Berlin: Springer.
Liu, Y. and Heer, J., 2018. Somewhere over the rainbow: An empirical assessment of
quantitative colormaps. In Proceedings of the 2018 CHI Conference on Human Factors in
Computing Systems (pp. 1-12).
Mirvis, P.H., 2019. Transformation at Shell: commerce and citizenship. Business and Society
Review. 105(1). pp.63-84.
Prat, L., 2019. Link: How decision intelligence connects data, actions, and outcomes for a better
world. UK: Emerald Publishing Limited.
Putra, J., 2020, June. Data Management System for Thesis Monitoring at STMIK IBBI Using B-
Model. In 2020 3rd International Conference on Mechanical, Electronics,
Computer, and Industrial Technology (MECnIT) (pp. 365-369). IEEE.
Ratia, M., 2018. Intellectual Capital and BI-tools in Private Healthcare Value
Creation. Electronic Journal of Knowledge Management.16(2). pp.pp143-154.
Seddon, J.J., and Currie, W.L., 2017. A model for unpacking big data analytics in high
frequency trading. Journal of Business Research. 70. pp.300-307.
10

Shakil, K. A. and et.al., 2020. BAMHealthCloud: A biometric authentication and data
management system for healthcare data in cloud. Journal of King Saud University-
Computer and Information Sciences. 32(1). pp.57-64.
Sharma, K and et.al., 2021, January. A Comparative Analysis on Various Business Intelligence
(BI), Data Science and Data Analytics Tools. In 2021 International Conference on
Computer Communication and Informatics (ICCCI) (pp. 1-11). IEEE.
Srivastava, G. and Venkataraman, R., 2022. A review of the state of the art in business
intelligence software. Enterprise Information Systems. 16(1). pp.1-28.
Taipalus, T. and Seppänen, V., 2020. SQL education: A systematic mapping study and future
research agenda. ACM Transactions on Computing Education (TOCE). 20(3). pp.1-
33.
Tavera Romero, C.A and et.al., 2021. Business intelligence: business evolution after industry
4.0. Sustainability. 13(18). p.10026.
Václav, C. and et.al., 2021. Utilization of business intelligence tools in cargo
control. Transportation Research Procedia. 53. pp.212-223.
Online
Big Data Tools. 2022. [Online]. Available through: <https://www.guru99.com/big-data-
tools.html>
Business Intelligence Tools. 2022. [Online]. Available through:<https://mopinion.com/business-
intelligence-bi-tools-overview/>
11