LE5456, Batch 51, BI, Dewmi New

Internal verification of assessment decisions – BTEC (RQF)
INTERNAL VERIFICATION – ASSESSMENT DECISIONS

Programme title High national diploma in computing
Mr.Selvam
Assessor Internal Verifier
Unit 14: Business Intelligence
Unit(s)
Business Process Support Mechanisms
Assignment title
Dewmi Sandunika Heenatigala
Student’s name
List which assessment criteria Pass Merit Distinction
the Assessor has awarded.
INTERNAL VERIFIER CHECKLIST
Do the assessment criteria awarded match

those shown in the assignment brief? Y/N
Is the Pass/Merit/Distinction grade awarded
justified by the assessor’s comments on the Y/N
student work?
Has the work been assessed

accurately? Y/N
Is the feedback to the student:

Give details:
• Constructive?
Y/N
• Linked to relevant assessment criteria?
Y/N
• Identifying opportunities for Y/N
improved performance?
• Agreeing actions?
Y/N
Does the assessment decision need
amending? Y/N
Assessor signature Date
Internal Verifier signature Date

Programme Leader signature (if required)
Date
Confirm action completed
Remedial action taken
Give details:
1|Page
Dewmi Sandunika Heenatigala Unit14
Internal Verifier
signature Date
Programme Leader
signature (if required) Date
2|Page
Dewmi Sandunika Heenatigala Unit14
Higher Nationals - Summative Assignment Feedback Form
Student Name/ID Dewmi Sandunika Heenatigala/ LE05456
Unit Title
Assignment Number Assessor
Date Received
Submission Date 1st submission
Date Received 2nd
Re-submission Date submission
Assessor Feedback:
LO1 Demonstrate a range of interpersonal and transferable communication skills to a target audience
Pass, Merit & Distinction P1 P2 M1 D1
Descripts
LO2 Apply critical reasoning and thinking to a range of problem-solving scenarios

Pass, Merit & Distinction P3 P4 M2 M3 D2
Descripts
LO3 Discuss the importance and dynamics of working within a team and the impact of team working in
different environments
Descripts
LO4 Examine the need for Continuing Professional Development (CPD) and its role within the workplace
and for higher level learning
Descripts
Grade: Assessor Signature: Date:

Resubmission Feedback:
Grade: Assessor Signature: Date:

Internal Verifier’s Comments:
Signature & Date:
* Please note that grade decisions are provisional. They are only confirmed once internal and external moderation has taken place and grades
decisions have been agreed at the assessment board.
3|Page
Dewmi Sandunika Heenatigala Business Intelligence Batch51
Assignment Feedback
Formative Feedback: Assessor to Student
Action Plan
Summative feedback
Feedback: Student to Assessor
4|Page
Student signature Date
Pearson Higher Nationals in

Computing
Assignment 01
5|Page
6|Page
General Guidelines
1. A cover page or title page should be attached to your assignment. Use page 1 of this assignment
brief as your cover page and make sure all details are accurately filled.
2. The entire assignment brief should be attached as the first section of your assignment.
3. The assignment should be prepared using a word processing software.
4. The assignment should be word processing in an A4 sized paper.
5. Allow 1” margin on top, bottom and right sides of the paper and 1.25” on the left side (for
binding).
Word Processing Rules
1. The font size should be 12 point, and should be in the style of Time New Roman.
2. Set line spacing to 1.5. Justify all paragraphs.
3. Ensure that all headings are consistent in terms of size and font style.
4. Use footer function on the word processor to insert your name, unit, assignment no, and page
number on each page. This is useful if individual sheets get detached from the submission.
5. Use the spell check and grammar check function of the word processing application to review
the use of language on your assignment.
7|Page
Important Points:
1. Carefully check carefully the hand in date and the instructions given with the assignment. Late
submissions will not be accepted.
2. Ensure that sufficient time is spent to complete the assignment by the due date.
3. Do not wait till the last minute to get feedback on the assignment. Such excuses will not be
accepted for late submissions.
4. You must be responsible for efficient management of your time.
5. If you are unable to hand in your assignment on time and have valid reasons such as illness, you
may apply (in writing) for an extension.
6. Failure to achieve at least a PASS grade will result in a REFERRAL grade.
7. Non-submission of work without valid reasons will lead to an automatic REFERRAL. You will
then be asked to complete an alternative assignment.
8. If you use other people’s work or ideas in your assignment, it must be properly referenced, using
the HARVARD referencing system, in your text or any bibliography. Otherwise, you’ll be found
guilty of committing plagiarism.
9. If you are caught plagiarising, your grade will be reduced to a REFERRAL or at worst, you could
be excluded from the course.
8|Page
Student Declaration
I hereby, declare that I know what plagiarism entails, namely to use another’s work and to present it as
my own without attributing the sources in the correct form. I further understand what it means to copy
another’s work.
1. I know that plagiarism is a punishable offence because it constitutes theft.

2. I understand the plagiarism and copying policy of Edexcel UK.
3. I know what the consequences will be if I plagiarise or copy another’s work in any of the
assignments for this program.
4. I declare therefore that all work presented by me for every aspect of my program, will be my
own, and where I have made use of another’s work, I will attribute the source in the correct
way.
5. I acknowledge that the attachment of this document signed or not, constitutes a binding
agreement between myself and Edexcel UK.
6. I understand that my assignment will not be considered as submitted if this document is not
attached to the assignment.
[email protected]
Student’s Signature: Date: 10.05.2021
(Provide E-mail ID) (Provide Submission Date)
9|Page
10 | P a g e
Higher National Diploma in Business
Assignment Brief
Student Name /ID Number Dewmi Sandunika Heenatigala/LE05456
Unit Number and Title Unit 14 : Business Intelligence
Academic Year
Unit Tutor
Assignment Title Business Process Support Mechanisms
Issue Date
Submission Date
IV Name & Date
Submission format
Submission to include:
Part 1: The submission is in the form of an individual written report. This should be written in a
concise, formal business style using single spacing and font size 12. You are required to make use
of headings, paragraphs and subsections as appropriate, and all work must be supported with
research and referenced using the Harvard referencing system. Please also provide a bibliography
using the Harvard referencing system. The recommended word limit is 2,000–2,500 words, although
you will not be penalised for exceeding the total word limit.
Part 2: Comprehensive table
Part 3: The submission is in the form of a ten-minute Microsoft® PowerPoint® style presentation.
The presentation can include links to performance data with additional speaker notes and a
bibliography using the Harvard referencing system. The presentation slides for the findings should be
submitted with speaker notes as one copy. You are required to make effective use of headings, bullet
points and subsections, as appropriate. Your research should be referenced using the Harvard
11 | P a g e
referencing system. The recommended word limit is 500 words, including speaker notes, although
you will not be penalised for exceeding the total word limit.
Unit Learning Outcomes:
LO1 Discuss business processes and the mechanisms used to support business decision-making.
LO2 Compare the tools and technologies associated with business intelligence functionality
LO3 Demonstrate the use of business intelligence tools and technologies
LO4 Discuss the impact of business intelligence tools and technologies for effective decision-
making purposes and the legal/regulatory context in which they are used
12 | P a g e
Assignment Brief and Guidance:
Business processes are pivotal to the operation, functionality and accomplishment of

organisational goals. As a collection or set of tasks/activities, business processes ensure that the
end goal of delivering a service or product to a customer is accomplished successfully.
Scenario:
Data and information is core to any organization and business process. The necessity of having
meaningful information is the key driver for effective decision making and problem-solving.
Business intelligence has evolved from technologies such as decision support systems (DSS) to
include tools and methods associated with data mining, data integration, data quality and data
warehousing in conjunction with other information management systems and applications.
Suppose you are recently recruited as a Business Analyst to a leading Sri Lankan
Organisation. As your initial project, you are required to prepare a management report to
the Board of Directors including the following details.
Part 1
Background details of the organisation
Identify and explain different business processes, supporting processes and the mechanisms used
at the selected organisation with examples which support for decision making
Identify data that have been used by the organisation in different levels and processes
Discuss on business intelligence functionalities and the tools and techniques associated with them
using specific examples chosen from the selected organisation
Part 2
13 | P a g e
Produce a comprehensive table of comparison that includes the below details
Differentiation between data classification based on the selected organisation in terms of

structured, semi structured and unstructured
Compare the tools and technologies associated with the business intelligence functionalities and
support available for business decision making at various levels within the organisation
Part 3
Conduct a small study on organisations that have used business intelligence tools to enhance or
improve operations
Design a business intelligence tool, application or interface that can perform a specific task to
support decision making at the selected organisation
Discuss the importance and the impact of business intelligence tools and technologies that can be
used by the organization for effective decision making within the legal/ regulatory context of the
organisation
Identify new Business Intelligence trends and technologies that can be further enhance in the
selected organisational context
As the Business analyst, present your finding to the board of directors of the selected organisation
14 | P a g e
ACKNOWLEDGEMENT
I would like to express my special thanks to my module lecturer for his guidance, constant supervision as
well as for providing me the excellent opportunity to do this assignment. Also for providing necessary
information regarding the assignment and for his support in completing the assignment.
15 | P a g e
Table of content
Part 1........................................................................................................................................................18
1.1 Background details..................................................................................................................18
1.2 Company Departments.................................................................................................................20
1.3 Decision making for this company...............................................................................................23
16 | P a g e
1.4 Business intelligence Functionality...............................................................................................24
Part 2........................................................................................................................................................26
Software using in Sri Lankan airlines................................................................................................26
P1 Examine, using examples, the terms ‘Business Process’ and ‘Supporting Processes’...........28
P2. Compare the types of support available for business decision-making at varying levels
within an organization.....................................................................................................................32
P3. Determine, with examples, what business intelligence is and the tools and techniques
associated with it..............................................................................................................................34
P4. Design a business intelligence tool, application or interface that can perform a specific task
to support problem-solving or decision-making at an advanced level.........................................36
P5. Discuss how business intelligence tools can contribute to effective decision-making...........37
P6. Explore the legal issues involved in the secure exploitation of business intelligence tools.. .38
References.................................................................................................................................................39
Table of Figures
Figure 1 :Logo............................................................................................................................................18
Figure 2:Frame work..................................................................................................................................19
Figure 3:HR................................................................................................................................................20
Figure 4:Medical Department....................................................................................................................22
Figure 5:PROS............................................................................................................................................26
Figure 6:SITA..............................................................................................................................................26
Figure 7:IBS................................................................................................................................................27
Figure 8Business process management life cycle......................................................................................28
Figure 9 Operational business process......................................................................................................30
Figure 10:BI...............................................................................................................................................35
Figure 11DMP............................................................................................................................................37
Part 1
1.1 Background details
Sri Lankan Airlines
17 | P a g e
Air Lanka was built up as the banner transporter of Sri Lanka once the Sri Lankan
government shut down the bankrupt Air Ceylon.[8] Air Lanka's underlying armada
comprised of two Boeing 707, rented from Singapore Airlines. One Boeing 737 was rented
from Maersk Air and kept up Air Tara. On 24 April 1980, the rent finished; Air Lanka got a
substitution Boeing 737 rented from Royal Brunei. On 1 November 1980, Air Lanka started
wide-body activities with a rented Lockheed L1011-1 Tristar from Air Canada.
Air Lanka, which was state-claimed, was incompletely privatized in 1998, with
venture by Dubai-based Emirates Group, when Emirates and the Sri Lankan government
consented to an arrangement for a ten-year key organization. This arrangement included
select rights for all airplane ground taking care of and carrier cooking at Colombo-
Bandaranaike air terminal for a very long time. Emirates purchased a 40% stake worth
US$70 million (which it later expanded to 43.6%) in Air Lanka and looked to revamp the
aircraft's picture and armada. The legislature held a greater part stake in the aircraft however
gave full control to Emirates for speculation and the board choices. In 1998, the Air Lanka
re-marked to Sri Lankan Airlines.
Figure 1 :Logo
In 2008 when Emirates pulled out, the collected benefit of Sri Lankan was Rs.
9.288 billion in that money related year. From 2008 to 2015, when the administration
organization ran it, the misfortune for the seven years was Rs. 128.238 billion. (Srilankan
Airline, No date)
Sri Lankan Airlines mission:

18 | P a g e
To delight our customers with a reliable and pleasant travel experience with
warmth and hospitality, the Sri Lankan way. We strive to meet our stakeholder expectations
as a competent, proactive and diligent organization which is financially viable.
Sri Lankan Airlines vision:
To be Asia’s most customer-centric airline.
Sri Lankan Catering is a completely claimed auxiliary of Sri Lankan Airlines,

giving flight cooking administrations to all aircrafts serving the Bandaranaike International
Airport. (Srilankan Airline, No date)
Figure 2:Frame work
1.2 Company Departments

 Human Resources Department
19 | P a g e
This department is a one of most important department in a company. HR is
utilized to portray both the individuals who work for an organization or association and
the division liable for overseeing assets identified with representatives.
Human asset organizations have a significant impact of creating and making an

organization or association toward the start or making a triumph toward the end, because
of the work gave by representatives. HR is expected to tell the best way to have better
business relations in the workforce. Likewise, to draw out the best hard-working attitude
of the representatives and in this way making a transition to a superior workplace.
Duties of human resources department
 Human resource planning

 Advice for Employees
 Handling Compensation
 Provide Employees with Career Assistance
 Find and Recruit Employees That Advance Company Objectives
Figure 3:HR
 Accounts Department
20 | P a g e
An accounting department provides accounting services and support to the
organization it belongs to. The department records account payable and receivable,
inventory, payroll, fixed assets and every one other financial element. The department's
accountants review the records of every department to work out the company's financial
position and any changes required to run the organization cost-effectively.
Duties of accounts department

 Accounts receivable
 Accounts payable
 Payroll
 Financial controls
 Financial reporting
 Airport Medical Center
In the event that you feel unwell or harm yourself, a clinical focus is accessible.
Area: Arrivals Hall, Baggage Area. Hours: open 24 hours.
 Passenger medical assessment for communicable diseases

 Maintaining communicable disease surveillance system
 Dead body clearance
 Monitoring of disinfection and disinfection of aircraft
 Routine monitoring and supervision of premises for sanitation
 Inspection of food establishment
 Public health emergency management
 Training of public health staff and students
21 | P a g e
 Legal Department
Sri Lankan Airlines may collect and store your data whilst you are accessing our
websites or availing any of their services from us directly or through our agents. As an
airline, Sri Lankan Airlines is committed to respecting our privacy and protecting our
personal information. The details of their policies and procedures in collecting and storing
your data can be found in their Privacy Policy, Legal Notice, Conditions of Carriage &
Cookie Policy on their website . They invite us to read through these policies and
procedures prior to availing their services.
Services in Sri Lankan airlines
 Car parking
 Medical care
 Shop and café
 Luggage packing
 Information service
 Mother and child room
22 | P a g e
1.3 Decision making for this company
Businesses make complex decisions all the time. Managers decide whether to rent
or fire staff, sales managers determine the foremost lucrative sales leads, senior IT
administrators choose the simplest software for his or her purposes. All of those people make
choices before finding an answer to a drag.
Members of Sri Lankan airlines
 Chairman
Mr. Ranjith Fenandoo
 Board of Directors
Mr. Ashok Pathirage - Chairman
Mr. Malik Fernando - Director
Mr. Ashroff Omar - Director
Mr. Samantha Ratwatte PC - Director
Mr. Manohara De Silva PC - Director
Dr. Hans Wijayasuriya - Director
Mr. Sanjaya Mohottala - Director
 Chief Executive Officer
Mr. Vipula Gunatilleka
The company body, including the general director or (CEO), has characterized
jobs and obligations inside the business. Basically, it's the function of the governing body to
lease the CEO or top of the business and survey the overall course and system of the
business. The CEO or head is subject for recruiting the entirety of the contrary
representatives and directing the everyday activity of the business. Issues generally emerge
when these rules aren't followed. Strife happens when the overseers start to interfere inside
the everyday activity of the business. Alternately, the board isn't at risk for the overall
strategy choices of the business.
23 | P a g e
Duties of director board
 Determine the company's vision and mission and purpose to guide and set the pace
for its current operations and future development.
 Determine the values to be promoted throughout the corporate .
 Determine and review company goals.
 Determine company policies
From a business cycle the board viewpoint, there are frequently hardly any
frameworks as intricate as a contemporary global air terminal. For a certain something,
there's the sheer scale regarding physical size and number of planes and travelers. aside
from another, there are various cycles as work. Each has its own partners and directors, and
its own sources of info and yields, however there likewise are unobtrusive linkages that
combine every one of them.
For instance, traveler course through the air terminal, traffic light for the planes,
things dealing with, join and security, cleaning airplane and offices, even the very
demonstration of getting work force and flight team where they must be. Each might be an
exceptionally mind-boggling framework, and each one must occur during a packed climate
where wellbeing and security are principal.
1.4 Business intelligence Functionality

Business Intelligence concept was first proposed by Howard Dresner in 1989. BI
is trying to transfer the prevailing data into knowledge to assist companies make correct
business decisions. Operational systems will produce large amounts of knowledge , like
orders, customers, financial data, the way to use these data to reinforce the understanding of
customer behavior, supply chain partners, and business conditions, and may accurately
forecast the trend of corporate business development may be a business intelligence
questions got to be resolved. (Callminer, 2019)
24 | P a g e
Structures of airport business intelligence functions
 Market Analysis System: This module is especially wont to analyze the forecast demand
for airport products and services, analyze the supply of products in the market to
determine the size of the market, estimates the economic benefits. At an equivalent time, it
provides customer classification and data processing capabilities for marketing
department, including retail, based airlines, non-based airlines, business information,
freight and passenger information etc., which may improve market monitoring and sales
decision-making, and supply real-time aviation market information services.
 Financial Analysis System: Provide key financial information, reports, statistical data, like
profit, energy consumption for the relevant authorities; Provide financial operations,
financial policy analysis, management analysis, investment and financing management
analysis. Indicators include solvency capability (Current ratio, quick ratio), operational
capability (accounts receivable turnover, inventory turnover rate) and profitability (sales
margins, capital maintenance and increment ratio).
 Customer Management system: Including the management of the based airlines, non-
based airlines passenger information; Provide feature analysis on airlines and passengers
information, behavioral analysis, benefit analysis supported two aspects of aviation
business and non-aviation business; At the same time, provide a legitimate distinction
between potential and intention to customers and customers with feature clustering,
development trends, analysis of the spending power consumption characteristics.
 Decision Support System: This feature is especially for airport decision-making. Using
charts, table and other intuitive thanks to provide a report of management and decision-
making for the airport upper management; through the data warehouse to integrate and
analyze information from the operational systems and improve the prevailing statements
of efficiency and access to key performance indicators to realize a comprehensive
assessment and management.
 Data mining system: data processing capabilities provide the required data, environment
and tools for analysis. Analyst can conduct analysis and forecasting by making good use
of multivariate analysis , statistic models, neural network models, Bayesian methods,
25 | P a g e
seasonal models also as customer models, like customer classification model, business
data analysis and prediction models, risk management analysis model, etc.
Part 2
Software using in Sri Lankan airlines
This software operational help to carriers, air terminals, and FBOs (fixed-base
administrators) like taxi administrations, bistros, and other air terminal specialist
organizations. Furthermore, flying software underpins the administration of aircraft
armadas. Together this incorporates a decent scope of front work area and
deals/administration computerization, support, and air terminal staff the executives. Sellers
offering aeronautics software frequently focus on simply this vertical however spread all of
carrier deals, workforce, and upkeep operational help by means of their product. aside from
across the board arrangements some flying innovation merchants work in just a single
component of aircraft software. (Srilankan Airline, No date)
 PROS Airline Revenue
Figure 5:PROS
PROS Inc offers their Airline Revenue Management application and suite, a
cloud-based revenue management platform for airlines for optimizing passenger and
group ticket revenue with real-time dynamic pricing.
 SITA Airport
Figure 6:SITA
26 | P a g e
SITA, settled in Geneva, offers their air terminal administration set-up of
uses including Airport Central flight information the board, Airport Resource Manager
workforce and asset assignment application, Airport Vision flight data, and Airport
Voice public location device, among different applications.
 IBS iAirport
Figure 7:IBS
Indian company IBS Software offers iAirport operations management and

passenger relationship management suite of software.
27 | P a g e
P1 Examine, using examples, the terms ‘Business Process’ and ‘Supporting Processes’.
Business Process means a series of steps perform by a group of stakeholders to achieve
a concrete goal. Also, business process can be defines as a set of activities and tasks that, once
completed, will accomplish an organizational goal. Business process should have purposeful
goals, be as specific as possible and have consist outcomes. The process must involve clearly
defined inputs and a single output. (Beek, 2020)
Design
Optimization Modeling
BPM
Monitoring Execution
Figure 8Business process management life cycle

Business process management life cycle
28 | P a g e
 Design
Business analysts review current business rules, interview the various stakeholders, and
discuss desired outcomes with management. So, goal of the design process is to gain an
understanding of the business rules and ensure if the results are in alignment with the
organizational goals.
 Modeling
In this stage refers to identifying, defining, and making a representation of new process
to support the current business rules for various stakeholders. Also, this process helps to map
out a more efficient business process design so you can understand and make positive change.
 Execution
In here execute the business process by testing it live with a small group of users first
and then open it to all users.
 Monitoring
Collect meaningful and measurable data to determine the effectiveness of the process in
delivering the expected value and benefits.
 Optimization
This is the redesign of the business processes to streamline and improve process
efficiency and strengthen the alignment of individual business processes with a
comprehensive strategy.
There are three categories in the business process,
1. Operational process
2. Supporting process
3. Management process
Example for business process,
Think hiring process of the human resources department. Correct form posting the job
opening to onboarding the employee, there are multiple stages involved in the process. Although
this can vary from organization, following you can see the workflow of this:
o The HR executive posts the job update.
29 | P a g e
o Multiple candidates apply in a portal.
o Salary and policy negotiations take place.
o The right candidate is chosen at the last stage of the recruitment.
o Selected candidates are called for the next stages of the recruitments.
o The offer letter is sent and the candidates accept.
Operational process
Operational process refers to the essential business activities that deliver value to the
customer by providing services and products. This is a trickily procedure, since giving attention
and focusing on details is demanding. Define these processes by combining the inputs, outputs
sequential activity and an objective in order to manage and improve business process.
1.Evaluate 3.Make
2.Asking for 4.Analyze
inputs and process
feedback. the results.
outputs. analysis.
Figure 9 Operational business process
Operational business process
 Evaluate input and outputs
The difference between the inputs and outputs lies in the cost. In here inputs are the
all resources of the company such as materials, knowledge and human types. Outputs are
deployed to cut down on the extended use of your potential resources.
 Asking for feedback
Poll your employees to identify needs or procedures’ description or ask from
customers for their opinion.
 Make process analysis
Next check the potential risks, such as extra taxes or capital costs.
 Analyze the result
30 | P a g e
Finally, measure data before starting operational business process implementation
and analyze the results.
Supporting process
Supporting process accompany the “primary processes”, which do not typically

result in final products of the organization, but rather indirectly contributes to the value added.
Documentation, configuration, management, verification, training and audit process all are the
supporting process.
This process do not directly create products or services but are necessary to
facilities or assist the execution of operating or management processers. Support processes serve
internal ‘clients’ and do not generate income in themselves.
 Operational support
Ensuring that functional groups and supporting groups work together to orchestrate
an efficient and effective process.
 Strategic support
Champions at the top of the organization are able to articulate the business goals
and help link process to strategy.
 Cultural support
Where process improvement is a way of life, continual change is required.
Cultural support creates are sustains the required cultural shift.
Management process
Management process include require planning, coordination, monitoring and

control. Also, this process includes measuring overall results and dealing with opportunities and
treats that could help or harm to the business.
Management process do not directly generate income, they optimize income

generation and ensure the continued survival of the business as whole.
31 | P a g e
To be effective in maintaining quality and desired outcomes, management processes
need to be able to sense when outcomes are at risk, interpret options, decide, and then engage an
appropriate response. Doing this reliably requires forethought, agility, and structure. Industry
leaders prepare for this by distinguishing two types of management processes: decision-making
and control processes.
P2. Compare the types of support available for business decision-making at varying levels
within an organization.
Decision making defined as simply, an integral part of modern management. In
the management, rational and good decision-making take as primary function. Decision means a
course of action to achieve organizational or managerial objectives or goals.
Every level of the management makes decisions to ensure organizational and

business goals. We can define decision making process as check and balance system. It helps to
growth to linear and vertical directions of the company.
Sometimes consumed lot of time to get decisions. We can not get a decision rapidly
in management setting. Follow steps help to take good and correct decision.
1. Defining the problem

2. Collect information and data
3. Develop the option
4. Choose the better option
5. Plan
6. Take the action.
Following you can see types of decision making,
 Programmed decision
 Non programmed decision
 Operation decision
 Organizational design
 Personal decision
32 | P a g e
 Routine decision
 Strategic decision
There are some types of support for business decision-making,
 Communication driven support system

This type target at internal teams. Purpose of the communication driven type, help
conduct a meeting, users to collaborate. Web or client server is the most common technology
to this type.
Ex: Chats and instant messaging software.
 Data-driven support system
This type target at managers, staff and product/services suppliers. This type used to
database to seek specific answers.
Ex: To check the system used computer-based database
 Document driven support system
Document driven support system target at a board base of user group. We can brake
documents for three categories. They are known as oral, written and video. This type also
most popular system is client server system.
 Knowledge driven support system
This type covers the all category beard range of system within the organization.
This type used to provide management advice. Another purpose of this to choose product/
services.
 Model-driven support system
This type helps to analyze decision between different option. This type can use to
financial, algebraic, simulation and optimization models to get decision support.
(Johnson, 2019)
33 | P a g e
P3. Determine, with examples, what business intelligence is and the tools and techniques
associated with it.
Business intelligence means a collection of tools and strategic that analyze and
convert raw data into actionable and coherent information for use in business analyze to help in
decision making. Every major industry has powerful transaction-oriented systems.
Software elements support reporting, interactive “slice-and-dice” pivot-table

analyses, visualization, .and. statistical data mining. Applications tackle sales, production,
financial, and many other sources of business data for purposes that include.business
performance management.
Information.is.often.gathered.about.other.companies.in.the.same.industry.which.is
known as benchmarking. (Beek, 2020) (Al-ma'aitah, 2013)
Business intelligence techniques
 Predictive modeling
 Characterization and descriptive data mining.
 Classification
 Association
 Analytical processing
 Pattern analyzes
 Model visualization
 Clustering and outlier analyze
 Prescription analyzes
Importance of business intelligence

 It helps increase the quality of the data and it cause to make quality decision.
 This system, can use also to small and medium enterprises.
 To identify and set benchmarks for varied process.
 Can create key performance indicators based on historic data.
34 | P a g e
Figure 10:BI
Example for business intelligence
Tools in used business intelligence
 SAP business intelligence
 Micro Strategy
 Pentaho
 Yellowfin BI
 Sisence
 Clear analytics
 BIRT
 Dundas BI
35 | P a g e
P4. Design a business intelligence tool, application or interface that can perform a specific
task to support problem-solving or decision-making at an advanced level.
Seven steps of the decision-making process.
1. Identify the decision

2. Gather relevant info
3. Identify the alternative
4. Weigh the evidence
5. Choose among the alternative
6. Take action
7. Review your decision
 Identify the decision
First clearly identify the problem. It helps to make good decision.
 Gather relevant information
After identified your decision it is time to gather the information relevant to that
choice. Do a clear test, seeing where your organization fated in the decision.
 Identify the alternatives
After gather relevant information, identify the good solution for that problem.
In here more than one or two options to consider when trying to meet goal.
 Weigh the evidence
After identified multiple solutions, weigh the evidence for against said
solutions, which companies have done this take a good hard look at own organization wins
and losses.
 Choose among alternative
This is the part, make the decision in decision making process.
 Take action
After make the decision, act on it. Then develop a plan to related your decision
and then set the team loose. on their tasks. once the plan is in place.
 Review your decision
(Sharma, 2020)
36 | P a g e
P5. Discuss how business intelligence tools can contribute to effective decision-making.
There are many business intelligences tools to support the effective decision making
in business. Business system has developed since a long time and system is under the means of
developing that can help the means of developing that can help the customers to improve their
own skills by adding.
Strategy driven
process driven Information
NO Problem solved ?
analysis
executed?
Dashboard Evaluation
Intelligence Problem
YES
Data Reporting
driven
Reporting
Design and
analyze Visual Data
Recovery
Analytical What if fore
OLAP
models casting
Ad hoc query Figure 11DMP
Decision making process
Following you can see how business intelligence help your company;
 Create realistic target
 Foreseeing trends
 Take advantages of transparent data
 Making save data is clean
 Focus on business objective.
37 | P a g e
P6. Explore the legal issues involved in the secure exploitation of business intelligence tools.
Security and legal issues the biggest challengers for large and mid-size organization.
In any organization, data is an advantage and a risk. Business intelligence has evolved from
technologies such as decision support system to include tools and method associated with data
mining. Use business intelligence software, we can enter to a large database of information;
 Market patterns
 Department overviews
 Analytic and presentation tool
 Business insights
Business intelligence can solve many problems. Following you can see some of them.
 Performance management is far from perfection.
 Access to the data is limited.
 Creating multiple systems take too much time.
 Your clients prefer your competitors.
Business intelligence strives to eliminate guessing and ignorance in organizations by
leveraging masses. of quantitative data. collected and captured every day in a variety of
corporate applications. It is the most strategic component of information. management for
improving business decisions based on better information. According.to the Butler Group,
business intelligence is a set of activities. supported by concepts, techniques. and technologies
for improving. business decisions based on better information. Ultimately, it aims at improving
the ability of an organization to respond. to events and changes in customers, markets or the
environment. Business intelligence is being driven by the pace of technological. development,
but also the need to service. customers in. a more personal and. individual way. The business
intelligence imperative insists that business intelligence is considered for elevation to a strategic
initiative.
(Killen, No date)
38 | P a g e
References
Al-ma'aitah, M. A., 2013. The Role of Business Intelligence Tools in Decision. In: Unknown, ed.
International Journal of Computer Applications. Unknown: Unknown, pp. 24-32.
Beek, D. V., 2020. BI tools linked to the decision making process. [Online]
Available at: https://www.passionned.com/business-intelligence-tools-and-the-desicion-making-
process/
[Accessed 06 February 2021].
Callminer, 2019. Callminer. [Online]

Available at: https://callminer.com/blog/what-is-business-intelligence-definition-techniques-tools-and-
tips-from-experts/
[Accessed 23 January 2021].
Johnson, S., 2019. Levels of Management Decision Making. [Online]

Available at: https://smallbusiness.chron.com/levels-management-decision-making-58222.html
[Accessed 15 February 2021].
Killen, D., No date. BUSINESS INTELLIGENCE (BI) IN THE LEGAL SECTOR. [Online]
Available at: https://www.sproutit.co.uk/legalitblog/business-intelligence-bi-in-the-legal-sector
[Accessed 26 March 2021].
Lee, R. & Dale, B., 1998. Emerald Publishing Limited. [Online]

Available at: https://www.emerald.com/insight/content/doi/10.1108/14637159810224322/full/html
[Accessed 20 August 2020].
Sharma, M., 2020. Decision-Making: Levels and Types | Management. [Online]

Available at: https://www.businessmanagementideas.com/management/decision-making-
management/decision-making-levels-and-types-management/7578
[Accessed 26 March 2021].
Srilankan Airline, No date. Srilankan airlines. [Online]

Available at: https://m.srilankan.com/en/index.html
Tyagi, N., 2020. medium.com. [Online]

Available at: https://medium.com/analytics-steps/top-business-intelligence-tools-and-techniques-in-
2020-9e7948eafd02
Unknown, 2015. Business process incubator. [Online]

Available at: https://www.businessprocessincubator.com/content/what-are-support-processes/
Unknown, 2016. Management mania. [Online]

Available at: https://managementmania.com/en/support-processes
39 | P a g e
Unknown, 2020. Appian. [Online]
Available at: https://www.appian.com/bpm/definition-of-a-business-process/#:~:text=A%20business
%20process%20is%20a,will%20accomplish%20an%20organizational%20goal.
Gant Chart
40 | P a g e
LO Month 01 Month 02 Month 03 Month 04 Month 05
LO1
LO2
LO3
LO4
Finalizing
41 | P a g e
Grading Rubric
Grading Criteria Achieved Feedback
LO1 Discuss business processes and the mechanisms

used to support business decision-making.
P1 Examine, using examples, the terms ‘Business Process’

and ‘Supporting Processes’.
M1 Differentiate between unstructured and semi-
structured data within an organisation.
D1 Evaluate the benefits and drawbacks of using
application software as a mechanism for business
processing.
LO2 Compare the tools and technologies associated with
business intelligence functionality
P2 Compare the types of support available for business

decision-making at varying levels within an organization.
M2 Justify, with specific examples, the key features of
42 | P a g e
business intelligence functionality.
D2 Compare and contrast a range of information systems
and technologies that can be used to support
organisations at operational, tactical and strategic levels.
LO3 Demonstrate the use of business intelligence tools
and technologies
P3 Determine, with examples, what business intelligence
is and the tools and techniques associated with it.
P4 Design a business intelligence tool, application or

interface that can perform a specific task to support
problem-solving or decision-making at an advanced
level.
M3 Customise the design to ensure that it is user

friendly and has a functional interface.
D3 Provide a critical review of the design in terms of how
it meets
a specific user or business requirement and identify what
customisation has been integrated into the design.
43 | P a g e
LO4 Discuss the impact of business intelligence tools
and technologies for effective decision-making
purposes and the legal/regulatory context in which
they are used
P5 Discuss how business intelligence tools can contribute
to effective decision-making.
P6 Explore the legal issues involved in the secure

exploitation of business intelligence tools.
M4 Conduct research to identify specific examples of

organisations that have used business intelligence tools
to enhance or improve operations
D4 Evaluate how organisations could use business
intelligence to extend their target audience and make
them more competitive within the market, taking
security legislation into consideration.
44 | P a g e
45 | P a g e

LE5456, Batch 51, BI, Dewmi New

Uploaded by

Copyright:

Available Formats

LE5456, Batch 51, BI, Dewmi New

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

LE5456, Batch 51, BI, Dewmi New

Uploaded by

Copyright:

Available Formats

Internal verification of assessment decisions – BTEC (RQF)

INTERNAL VERIFICATION – ASSESSMENT DECISIONS

INTERNAL VERIFIER CHECKLIST

Do the assessment criteria awarded match

Has the work been assessed

Is the feedback to the student:

Assessor signature Date

Internal Verifier signature Date

Assessor signature Date

LO2 Apply critical reasoning and thinking to a range of problem-solving scenarios

Grade: Assessor Signature: Date:

Grade: Assessor Signature: Date:

Signature & Date:

Feedback: Student to Assessor

Student signature Date

Pearson Higher Nationals in

Word Processing Rules

1. I know that plagiarism is a punishable offence because it constitutes theft.

Unit Number and Title Unit 14 : Business Intelligence

Assignment Title Business Process Support Mechanisms

IV Name & Date

Part 2: Comprehensive table

Unit Learning Outcomes:

Business processes are pivotal to the operation, functionality and accomplishment of

Background details of the organisation

Differentiation between data classification based on the selected organisation in terms of

Sri Lankan Airlines mission:

Sri Lankan Airlines vision:

To be Asia’s most customer-centric airline.

Sri Lankan Catering is a completely claimed auxiliary of Sri Lankan Airlines,

Figure 2:Frame work

1.2 Company Departments

Human asset organizations have a significant impact of creating and making an

Duties of human resources department

 Human resource planning

Duties of accounts department

 Airport Medical Center

 Passenger medical assessment for communicable diseases

Services in Sri Lankan airlines

Members of Sri Lankan airlines

Mr. Ashok Pathirage - Chairman

Mr. Malik Fernando - Director

Mr. Ashroff Omar - Director

Mr. Samantha Ratwatte PC - Director

Mr. Manohara De Silva PC - Director

Dr. Hans Wijayasuriya - Director

Mr. Sanjaya Mohottala - Director

 Chief Executive Officer

Mr. Vipula Gunatilleka

1.4 Business intelligence Functionality

 PROS Airline Revenue

Indian company IBS Software offers iAirport operations management and

Figure 8Business process management life cycle

There are three categories in the business process,

Example for business process,

o The HR executive posts the job update.

Supporting process accompany the “primary processes”, which do not typically

Management process include require planning, coordination, monitoring and

Management process do not directly generate income, they optimize income