ASSIGNMENT 1 FRONT SHEET

Qualification BTEC Level 5 HND Diploma in Computing

Unit number and title Unit 14: Business Intelligence

Submission date Date Received 1st submission

Re-submission Date Date Received 2nd submission

Student Name Ha Tran Hoang Hieu Student ID GCC18195

Class GCC0701 Assessor name Nguyen Thai Nghe

Student declaration
I certify that the assignment submission is entirely my own work and I fully understand the consequences of plagiarism. I understand
that making a false declaration is a form of malpractice.

Student’s signature hieu

Grading grid
P1 P2 M1 M2 D1 D2
❒ Summative Feedback: ❒ Resubmission Feedback:

Grade: Assessor Signature: Date:

IV Signature:

`Assessment Brief
Student Name/ID Number
Unit Number and Title 14: Business Intelligence
Academic Year 2018
Unit Tutor
Assignment Number & Title Assignment 1: Discover business process and BI technologies
Issue Date
Submission Date
IV Name & Date
Submission Format
The submission is in the form of a 15-minutes Microsoft® PowerPoint® style presentation to be presented
to your colleagues. 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
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
Assignment Brief

Your company is currently working in [Assumed Domain] for 2 years. For a new, young company, the
competition in the market is very high. Therefore, the Board of Director has decided to apply Business
Intelligence to improve the company business process by making better decisions.
The Board of Directors assigns a small group including you in Research & Development Department to
study business intelligence to apply for the company in the coming years.
You need to research about business processes and decision support processes in the company and
identify the types of data (unstructured, semi-structured or structured) generated by these processes
with examples. You also need to research about current software used in the business process or decision
support process and evaluate these usages (benefits and drawbacks).
Next you need to understand the types of support for decision-making at different levels (operational,
tactical and strategic) within the company and study which business intelligence features can help on that
types of support. Study the information systems or technologies (of BI) can be used in this case, compare
and contrast them to conclude which should be used.
Your group needs to present the research results to the board in a presentation of 15 minutes.
 Learning Outcomes and Assessment Criteria

Pass Merit Distinction

LO1 Discuss business processes and the mechanisms used to support

business decision-making

P1 Examine, using examples, the M1 Differentiate between D1 Evaluate the benefits and
terms ‘Business Process’ and unstructured and semi-structured drawbacks of using
‘Supporting Processes’. data within an organisation. application software as a
mechanism for business
processing.

LO2 Compare the tools and technologies associated with business D2 Compare and contrast a
intelligence functionality range of information systems
and technologies that can be
P2 Compare the types of support M2 Justify, with specific examples, used to support
available for business decision- the key features of business organisations at operational,
making at varying levels within an intelligence functionality. tactical and strategic levels.
organisation.
Contents

P1 Examine, using examples, the terms ‘Business Process’ and ‘Supporting Processes’. ............................................................................................. 7
1.Business Process ..................................................................................................................................................................................................... 7
2.Supporting Processes ............................................................................................................................................................................................ 11
P2.Compare the types of support available for business decision-making at varying levels within an organisation. ................................................ 11
1.Type of control ...................................................................................................................................................................................................... 11
2.Type of decision .................................................................................................................................................................................................... 11
References ................................................................................................................................................................................................................... 12
P1 Examine, using examples, the terms ‘Business Process’ and ‘Supporting Process
1.Business Process
- A business process has been designated as a business venture, it will accomplish the organization's mission. The process must
include a clear set of inputs and a single output. These inputs are made up of all the factors that contribute to the added value of a
service or product (directly or indirectly). These factors are addressed in the management process. Managing the operations of a
particular organizational system of management processes operations. Operations form the main business. Support processes such
as human resources and statistics are in place to support key business processes. (kissflow, n.d.)
- Dataset: My data is used to discuss pizza sales. The data consists of tables: a table that stores complete data with the names of
cities, zip codes, addresses of stores; the second table saves the menu, the price of money; The final table stores the transaction, order
date, date received, and price of each cake
Delivery process
Report process
Strategy\ report process
 2.Supporting Processes
- Is performed to maintain the integrity of the product or service developed by “primary processes” as well as ensures that products
and processes comply with predefined provisions and plans. Supporting processes 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 are all supporting processes
P2.Compare the types of support available for business decision-making at varying levels within an organisation.
1.Type of control
- Operational control : Operational business controlling is used to regulate the internal processes necessary to monitor and direct
the company in the short term. It allows making business decisions related to ongoing business operations. The main tasks of
operational controlling include
+ Controlling the results
+ liquidity planning
+ Monitoring of profitability
+ Improving the effectiveness of the use of existing resources.
- Manage control : Control is a function of management which helps to check errors in order to take corrective actions. This is done
to minimize deviation from standards and ensure that the stated goals of the organization are achieved in the desired manner.
- Strategic planning : In terms of the overall long-term goals or desires of a company, strategic planning is the art of creating specific
business strategies, implementing them, and evaluating the results of executing the plan. It is a concept that focuses on integrating
different departments within a company (such as accounting and finance, marketing, and human resources) to achieve its strategic
objectives. Essentially, the term strategic planning is synonymous with strategic management.
2.Type of decision
- Structured data : Structured data exists in a format created to be captured, stored, organized, and analyzed. It’s neatly organized
for easy access. If structured data was an office it would contain many file cabinets that are efficiently set up, clearly labeled, and easy
to access. For that reason, structured data brings inherent benefits when dealing with high volumes of information.
- Semi-structured data : semi-structured data as a type of data that contains semantic tags, but does not conform to the structure
associated with typical relational databases. While semi-structured entities belong in the same class, they may have different
attributes.
- Unstructured data : Unstructured data is not organized in any discernable manner and has no associated data model. This type of
information is usually text-heavy and often includes multiple types of data. Examples of file types commonly considered as
unstructured data are: books, some health records, satellite imagery.
 Type of decision Types of Control

Operational control Management control Strategic planning

Structured Order enter Analysis: Economic management

Delivery enter 1. Budget Delivery management
Pay enter 2. Area Supplier
3. Report Distribution
Semi-structured Delivery services Financial review Budget Making a new plan
Project schedule
preparation

Unstructured Buying Software Buying hardware Development planning.

Recruiting

References
kissflow, n.d. business process. [Online]
Available at: https://kissflow.com/bpm/business-process/
[Accessed 10 October 2020].