8/17/2021
Assignment 1
Business Intelligence
Assessor name: Đặng Thái Đoàn
Learner’s name: Huỳnh Thanh Dương
Class: GCS0804_NX
Learner’s ID: GCS190756
Subject’s ID: 1641
Assignment due: July 2021
Assignment submitted: August 2021
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Guidelines and tips
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Business Intelligence - Part 1, Study Guides, Projects, Research of Economic Analysis
Data and information is core to any organisation 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.
Typology: Study Guides, Projects, Research
2020/2021
1 / 51
This page cannot be seen from the preview
Don't miss anything!
Related documents
Partial preview of the text
Download Business Intelligence - Part 1 and more Study Guides, Projects, Research Economic Analysis in PDF only on Docsity!
8/17/2021 Assignment 1
Business Intelligence
Assessor name: Đặng Thái Đoàn Learner’s name: Huỳnh Thanh Dương Class: GCS0804_NX Learner’s ID: GCS Subject’s ID: 1641 Assignment due: July 2021 Assignment submitted: August 2021
Assessment Brief
Student Name/ID Number Huỳnh Thanh Dương – GCS Unit Number and Title 14: Business Intelligence Academic Year 2021 - 2022 Unit Tutor Assignment Number & Title Assignment 1 : Discover business process and BI technologies Issue Date 12 /07/ Submission Date 20 / 08 / IV Name & Date Submission Format The submission is in the form of a 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.
Learning Outcomes and Assessment Criteria Pass Merit Distinction LO1 Discuss business processes and the mechanisms used to support business decision-making D1 Evaluate the benefits and drawbacks of using application software as a mechanism for business processing. P1 Examine, using examples, the terms ‘Business Process’ and ‘Supporting Processes’. M1 Differentiate between unstructured and semi-structured data within an organisation. LO2 Compare the tools and technologies associated with 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. P2 Compare the types of support available for business decision-making at varying levels within an organisation. M2 Justify, with specific examples, the key features of business intelligence functionality.
ASSIGNMENT 1 FRONT SHEET Qualification BTEC Level 5 HND Diploma in Computing Unit number and title Unit 14: Business Intelligence Submission date 20/08/ Date Received 1st submission
Re-submission Date Date Received 2nd submission Student Name Huỳnh Thanh Dương Student ID GCS Class GCS0804_NX Assessor name Đặng Thái Đoàn 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 Dương Grading grid P1 P2 M1 M2 D1 D
Contents
Assessment Brief ............................................................................................ 2
INTRODUCTION .............................................................................................. 5
I. PART 1. The business processes and the mechanisms used tosupport
business decision-making ............................................................................... 7
- The terms ‘Business Process’ and ‘Supporting Processes’ (P1) .................................................. 7
- Differentiate between unstructured and semi-structured data within an organization (M1). 13
- The benefits and drawbacks of using application software as a mechanism for business processing (D1).................................................................................................................................. 17
II. Part 2. The tools and technologies associated with business intelligence
functionality ................................................................................................. 22
- Compare the types of support available for business decision-making at varying levels within an organization (P2) .......................................................................................................................... 22
- The key features of business intelligence functionality (M2) ................................................... 32
- The range of information systems and technologies that can be used to support organizations at operational, tactical and strategic levels (D2) .............................................................................. 39
CONCLUSION ................................................................................................ 43
CRITICAL EVALUATION ................................................................................. 44
REFERENCE ................................................................................................... 45
Figures
INTRODUCTION
Assignment introduction Business intelligence concepts refer to the usage of digital computing technologies in the form of data warehouses, analytics and visualization with the aim of identifying and analyzing essential business based data to generate new, actionable corporate insights. A host of business intelligence concepts are executed through intuitive, interactive tools and dashboards – a centralized space that provides the ability to drill down into data with ease. Put simply: Business intelligence is the process of discovering valuable trends or patterns in data to make more efficient, accurate decisions related to business goals, aims, and strategies. BI technologies offer present (real-time), historical, and predictive views of internally structured data relating to all departments within an organization, which exponentially enhances operational insight and improves the decision- making process. It emerged in the latter part of the 20th century and has become an integral aspect of the decision-making processes for prudent companies looking to make use of a host of data relating to customer service, inventory, pricing, and so much more. It has evolved from generating rudimentary reports and tools used for the historical query, to include a host of components such as forecasting, online analytical processing, predictive modelling, data management, data mining, and optimization. My scenario: In a time of raging covid, having too many cases is one of the fears of the Vietnamese people. We have collected information and
tracked infected and treated patients to provide oxygen tanks to the frontline areas of the epidemic area. Dataset introduction My dataset is the entire data of patients across the country and this number is up to date ➢ Id - The id number corresponds to the patient's order ➢ Bệnh Nhân - Which patient is that patient? ➢ Tuổi - Patient's age ➢ Giới tính- Patient's sex ➢ Địa điểm - Where is this person sick? ➢ Tình trạng- So far, the patient's condition has been cured ➢ Quốc tịch - Hometown of the sick person ➢ Tài chính- Expenses for 1 case Group members ID Full Name GCS190065 Vũ Dương Quỳnh Anh (Leader) GCS200117 Nguyễn Thị Ngọc Hà GCS190756 Huỳnh Thanh Dương GBS190645 Võ Văn Tín GCS190405 Hoàng Đình Văn
supporting processes handle/help the backside of the core processes and functions within an organization. Example: A bank will have some Security processes (such as employee ID checks), which represents a Supporting process, helping the core processes of the bank and the workplace to become more secure. Management processes: Management processes measure, monitor and control the activities related to business procedures and systems. As well as supporting processes, management processes do not provide value directly to customers. Example: A bank will have some internal processes such as internal communication process, strategic planning process, etc. Figure 1 Business process Some of the key reasons to have well-defined business processes in place are to:
➢ Identify what tasks are important to the larger business goals ➢ Improve efficiency ➢ Streamline communication between people/functions/departments ➢ Set approvals to ensure accountability and optimum use of resources ➢ Keep chaos from creeping into the day to day operations ➢ Standardize a set of procedures to complete tasks that really matter to business The 7 steps of the business process: ➢ Step 1: Define the goals ➢ Step 2: Plan and map the process ➢ Step 3: Set actions and assign stakeholders ➢ Step 4: Test the process ➢ Step 5: Implement the process ➢ Step 6: Monitor the results ➢ Step 7: Repeat Supporting Processes Support processes are all processes whose sole purpose is to ensure the functioning of core processes and running the company itself, which coordinates the development and life cycle of the activities contained in the main Operational processes. These are processes that coordinate the development and life cycle of the activities contained in the main processes, ie organizational and business processes. The activities are in support processes, aimed at achieving objectives that support other processes that perform a specialized function. These objectives can point to: (businessprocessincubator) [2] ➢ Define necessary to record all the information produced by the process of life cycle activities. ➢ Incorporate activities to identify, control, and statistical evaluation of configurations as well as of version management.
Figure 2 Business process categories For instance, support processes include: ➢ Human Resource Management ➢ Financial Management processes ➢ Building and property management, cleaning and maintenance, Facility management ➢ IT processes ➢ Procurement and sourcing processes (supplier selection processes, purchasing services, ➢ purchasing materials, sourcing human and financial resources, etc.) ➢ Vendor Management processes ➢ Operational processes and routine operation and organization management ➢ Risk Management processes ➢ Security Management processes ➢ Corporate Governance processes ➢ Quality Management processes
information is typically text-heavy but may contain data such as dates, numbers, and facts [3]. An example is optimized to store documents. Apache Giraph, as an opposite example, is optimized for storing relationships between nodes. Figure 5 Unstructured data types The ability to extract value from unstructured data is one of the main drivers behind the quick growth of Big Data. 80% of all data being created by organizations is not analyzed properly. By understanding the "why" behind the "what," organizations are able to meet customer needs and expectations more effectively while also making strategic decisions[3].
Figure 6 What's hiding in your Unstructured Data? Semi-structured data Semi-structured data is a form of structured data that does not conform with the formal structure of data models associated with relational databases or other forms of data tables. Semi structured data contains semantic tags and metadata to make it easier to organize, but there’s still fluidity in the data. Many Big Data solutions and tools have the ability to read‟ and process either JSON or XML. This reduces the complexity to analyze structured data, compared to unstructured [4] Sources of semi-structured Data: (geeksforgeeks) ➢ Emails ➢ XML and other markup languages ➢ Binary executables ➢ TCP/IP packets ➢ Zipped files ➢ Integration of data from different sources ➢ Web pages The Different between unstructured data and semi-structured data Sr. No. Key Semi-Structured Data Unstructured Data