CIS7026 Business Process and Data Analysis: Schiphol Travel Project

This project analyzes Schiphol Travel International, a major travel company, focusing on the impact of COVID-19 and Brexit. It employs various business analysis tools, including PESTLE analysis to assess external factors, CATWOE analysis to understand stakeholder perspectives, and DFD diagrams to model data flow. The project also includes use case diagrams, context diagrams, and a resource audit to understand the company's internal capabilities. Furthermore, the project investigates the company's situation using rich pictures and considers the power grid interest. The project provides recommendations and a critical evaluation of the company's strategies and challenges, offering insights into business process improvements and data-driven decision-making. The analysis also includes business insights and conclusions. Finally, the project provides a comprehensive overview of the company's operations and the challenges it faces in a dynamic global environment.

CIS7026
Business Process and Data Analysis
Business Analysis Final Assignment
Student Name:
Student ID:
Lecturer Name:

Table of Contents
Part A...............................................................................................................................................3
Task 1...............................................................................................................................................3
Introduction..................................................................................................................................3
Task 2...............................................................................................................................................4
Justification..................................................................................................................................4
Task 3...............................................................................................................................................5
Strategy analysis..........................................................................................................................5
Resource for Audit.......................................................................................................................6
Investigation situation..................................................................................................................8
Rich picture..................................................................................................................................8
Context diagram...........................................................................................................................9
Consider Perspective.................................................................................................................10
CATWOE analysis....................................................................................................................10
Analyze needs............................................................................................................................11
Use case diagrams......................................................................................................................12
Define Requirement...................................................................................................................13
DFD level 0 & 1........................................................................................................................14
Task 4.............................................................................................................................................15
Recommendations and observations..........................................................................................15
Task 5.............................................................................................................................................17
Critical Evaluation.....................................................................................................................17
Part B.............................................................................................................................................19
Introduction....................................................................................................................................19
Business Insights...........................................................................................................................20
1

Conclusion.....................................................................................................................................25
Reference.......................................................................................................................................26
List of Figure
Figure 1: PESTEL Model................................................................................................................5
Figure 2: Process of resource audit..................................................................................................7
Figure 3: Human Resource for Audit..............................................................................................7
Figure 4: Rich Picture of Schiphol Travel International.................................................................8
Figure 5: Context diagram of Schiphol Travel International...........................................................9
Figure 6: Power grid interest of Schiphol Travel International.....................................................10
Figure 7: Use case of Schiphol Travel International.....................................................................11
Figure 8: Decision tree of Schiphol Travel International..............................................................12
Figure 9: DFD Level 0 Schiphol Travel International...................................................................13
Figure 10: DFD level 1 Schiphol Travel International..................................................................13
Figure 11: Class diagram of Schiphol Travel International...........................................................14
Figure 12: Sequence Diagram of Schiphol Travel International...................................................15
Figure 13: Example of flight reduction in Europe.........................................................................16
Figure 14: Overall Life Expectancy..............................................................................................20
Figure 15: Life Expectancy based on the year...............................................................................20
Figure 16: Animated Version of the Life Expectancy...................................................................21
Figure 17: Life Expectancy for the European Region...................................................................21
Figure 18: Animated Version of the Life Expectancy...................................................................22
2

Part A
Task 1
Introduction
Schiphol travel international is one of the largest types of business tours and travel companies or
organizations that was founded in the European country of Netherlands and also in the UK. This
company provides 5-star services to their customers and client. This is one of the most
comprehensive online tools that take guarantee to give the best services at the best and affordable
price. The income of this company in the year 2018 was around €285 million and total assets are
around €7.354 billion. This organization is owned by in partnership with the State of the
Netherlands is around (69.77%) the Government of Amsterdam that having partnership around
(20.03%), the Groupe of ADP is (8.0%) and the Government of Rotterdam having (2.2%
partnership. But due to the COVID-19 and the Brexit impact on this industry is quite disgraceful
(Schiphol travel international 2022).
Due to this global crisis of COVID-19 and Brexit, more than 100 million direct tourism jobs and
employments are at big risk, and also it has a long impact on the economy of this industry, their
livelihood, all the public services, and opportunity. Due to the COVID-19 effect, the supply
chain of Schiphol travel international company was also being affected. In some other countries,
the sudden fall in tourism cut off all the funding for biodiversity conservation. Some of 7% of the
entire world tourism were also being related to the wildlife’s, as the segments were kept growing
by the 3% per year. This result reveals that all the tourists and clients of the company cancelled
their trip and tours service and because of that company face high economic crisis. For 2 years’
all the hotels, public gardens, hills Station, flights, and all the transportation facilities were
stopped due to the COVID-19 and Brexit effects at a global level (Schiphol travel international
2022).
3

Task 2
Justification
To manage all the issues and challenges that were faced by the Schiphol travel international tours
and travel management company due to the COVID-19 and Brexit impact, the company thinks to
use the PESTLE analysis method to solve all the issues and challenges. A PESTLE analysis is
the strategic planning method that helps to minimize all the possible business risk and threats
This tool or method were used to gain small or macro pictures of an industry environment. The
term PESTLE stands for, political, economic, social, technological, legal, and environmental
factors. This tool allows the Schiphol travel international company to create a reputed impression
of all the factors that may impact their business or the new industry. In that, some of the factors
will be important that is according to the type of business and it also helps to identify and
mitigate all the possible risk factors of the SWOT analysis (Lib guides 2021).
This tool of strategic planning method has some benefits because this company uses this analysis
tool to solve all the threats and risks that were created by the COVID-19 and Brexit issue. These
benefits or advantages are cost-effective which means the implementation of this tool in any
organization take less cost, it also helps to provide or supply a deep and broad understanding of
business and how to increase the overall business performance and revenues or profits rates, this
method also has the capability to the alertness of attacks and threats on the business process and
the supply chain that help to decrease the probability of risk effective on travel and tour services
providing industry or organization. The last and most important and useful benefit of this tool or
method is, it can help to study all the external environments opportunities that can be found to
the strengthen business model (Frue 2017).
4

Task 3
Strategy analysis
PESTEL business analysis model is used by Schiphol Travel International to analyze the activity
of the travel business. This is the form of PEST analysis that consider 6 factors for crucial
business are:
 Political
 Economic
 Sociocultural
 Technological
 Environmental
 Legal
Figure 1: PESTEL Model
 Political: This factor affected the business of travel company which includes the policy of
trading, regulation of workforce and many legislations of government. If the company wants
to stay business along with the law-bound then these factors of political are important.
5
Schiphol
Travel
International
pestal analysis
Political
Economic
Sociocultural
Technological
Environmental
Legal

 Economic: this factor affects the economy of business in that it operates the factors
individually like Domestic product gross, rate of exchange, and inflation. The factor of
economic affect all business sorts but this is a most important factor for finance of the
company.
 Sociocultural: The factor of sociocultural is affected the business of travel company because
sometimes it also called the factor of sociality which is connected with the culture and
society at the available area.
 Technological: This factor affected the business of travel companies that involves the update
of new technology like robotics along with the infrastructure prevalence for slightly older
ones.
 Environmental: This factor of business is affected at a significant level ever of a travel
company which considers the tool that is taking on the earth planet. The various factor of the
environment is somehow is connected with global warming like the change in climate,
increment in pollution, and in the supply of resources which is natural.
 Legal: This factor affected the business of travel companies at very often overlap along with
the factor of political. It also makes the acronym of PESTEL which is easier to read and so it
is worth mentioning. This involves the consumer, copyright, and trade that is connected with
the decision of political.
The model of PESTEL provides Schiphol Travel International full insight into the factor of
business which can affect the given business, market, venture, and company. In actuality, the
model of PESTEL forces the company to think about the affected factor of business. This is
valuable because it allows the company to find out the decision before implementation and
optimization in the strategy of company business. This means is the wastage of money is less and
also able to earn more profit. This helps to analyze the complete market as it is an individual
business and the company also used this model for better understanding and planning of every
market individually.
Resource for Audit
An audit is conducted to get to know about the weakness and strengths of Schiphol Travel
International which is a resource-based company is called the audit resource. The capability can
be understood from the audit of the resource (Accountlearning 2016).
6

Figure 2: Process of resource audit
(Source: Freemanagementbooks 2015)
 This audit helps travel company to identify the resources for audit which is available for
business.
 Some it might be owned like machinery, the outlet of retail, and plant. Whereas others might
be obtained from suppliers, joint ventures, and partnerships.
 The resource of finance includes the Schiphol Travel International financial assets that
involve the raising ability by the credit of finance.
 The resource of physical includes the equipment and building that might be either leased or
owned.
 Resources of human are including both temporary and permanent staff.
Figure 3: Human Resource for Audit
(Source: Freemanagementbooks 2015)
7

 The reflection reputation includes how’s the company is perceived at the level of the market.
 Also, able to know how is intellectual property enables the functions of Schiphol Travel
International.
Investigation situation
Figure 4: Rich Picture of Schiphol Travel International
Rich picture
The Rich pictures are the type of pictorial representations of their environmental or the entire
social systems. This type of can helps the Schiphol travel international organize to take complex
situations and also able to identify all the possible underlying problems by counting all the
required relevant elements and also the possible stakeholders of their working or non-working
system. Any technique may be used in drawing a rich picture, and they may be used in any
situation, regardless of its complexity or the initial level of understanding of the problem. When
they were done as the part of a participating type of planning approach, the representation of the
rich pictures can also be a useful tool or method for encouraging discussion, the interaction, and
8

also for the attaining of a holistic sympathetic of their business system by involving the
stakeholder's interests. this risk picture also helps to describe the entire workings of the Schiphol
travel international systems into one picture (SSWM 2021).
Figure 5: Context diagram of Schiphol Travel International
Context diagram
This type of context diagram or picture try to help a Schiphol travel international organization to
find out or identify all the possible interfaces that they need to use an account for, it also helps an
organization or any system to identify their scope, to identify their potential stakeholders, and
also help to build a better or broad understanding of the context in which they want to work for.
This type of context diagram is also DFD or data flow diagram.
9

Consider Perspective
Figure 6: Power grid interest of Schiphol Travel International
CATWOE analysis
This analysis is used to find out and to solve the problem of business which often includes
conflicting and various interests. Considering every standpoint and perspective along with it this
also offers an ethical framework for the approach of problem-solving. As this analysis, Schiphol
Travel International can be done on existing process and system to analyze the COVID 19 and
Brexit effect.
Table 1: CATWOE Analysis
CATWOE Analysis
Customer This is the customer of Schiphol Travel International. Its Stakeholder and users of the
system. Customers of Schiphol Travel International are couples, families, and business
persons. This is the first process that is used to identify the customer and also
understand them as to how the system and process of the company influence them.
Actor This is the employee of the company who is responsible for the process of
transformation that is happening. This is the person in Schiphol Travel International are
administrator and travel agent. In this, the administrator has the responsibility to carry
10

out the work and is also involved in the system changes implementation.
Process of
transformation
The transformation is the updating in the process and system leads to. This is the
process in which the input is transformed from the Schiphol Travel International within
the output like the final solution of the problem.
World view This is completely dependent on the big picture and take it as the various interested
customer and also stakeholders by the surrounding of Schiphol Travel International and
influence as they can have. This is the most important step of CATWOE analysis. The
stakeholder has various approaches for the same issue along with another interest. This
analysis aims to make it various explicit viewpoints.
Owner This is reflected by the owner of Schiphol Travel Internationalis the one who will
provide events and deny permission to change the route approach or process of braking.
Environmenta
l Constraints
The constraint of the environment will significantly influence the new approach of
Schiphol Travel International that’s why need to think about the law which is made by
the government, the condition of weather, etc.(Toolshero 2017)
Analyze needs
Figure 7: Use case of Schiphol Travel International
11