Higher Nationals in Computing
Unit 14: BUSINESS INTELLIGENCE
ASSIGNMENT 1
Assessor name: PHAN MINH TAM
Learner’s name: NGUYỄNMINHĐẠO
ID: GCS210351
Class: GCS1003B
Subject code: 1641
Assignment due: Assignment submitted:
1
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
Community
Ask the community
Ask the community for help and clear up your study doubts
University Rankings
Discover the best universities in your country according to Docsity users
Free resources
Our save-the-student-ebooks!
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
Business Intelligence: Assignment 1 Brief and Answers, Assignments of Computer Science
sagaanvkoueniaibejrnvknirafeea
Typology: Assignments
2020/2021
1 / 24
This page cannot be seen from the preview
Don't miss anything!
Related documents
Partial preview of the text
Download Business Intelligence: Assignment 1 Brief and Answers and more Assignments Computer Science in PDF only on Docsity!
Higher Nationals in Computing
Unit 14: BUSINESS INTELLIGENCE
ASSIGNMENT 1
Assessor name: PHAN MINH TAM
Learner’s name: NGUYỄNMINHĐẠO
ID: GCS
Class: GCS1003B
Subject code: 1641
Assignment due: Assignment submitted:
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 Nguyen Minh Dao Student ID GCS Class GCS1003B Assessor name Phan Minh Tam 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 DAO Grading grid
P1 P2 M1 M2 D1 D
The submission is in the form of a 15-minutes Microsoft® PowerPoint® style presentation to be presented to your co Submission Format ASSIGNMENT 1 BRIEF Student Name/ID Number Unit Number and Title 14: Business Intelligence Academic Year 2021 Unit Tutor Assignment Number & Title Assignment 1: Discover business process and BI technologies Issue Date Submission Date IV Name & Date
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. 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
Table of Contents
- Unit 14: BUSINESS INTELLIGENCEASSIGNMENT
- ASSIGNMENT 1 BRIEF
- Assignment 1 Answers
- I. Examine, using examples, the terms ‘Business Process’ and ‘Supporting Process’.
- Business process model. - 1.1. Definition. - 1.2. Example.
- Business process. - 2.1. Definition. - 2.2. Example. - 2.2.1. Online ordering process - 2.2.2. Order management
- Supporting processes (Decistion making process). - 3.1. Definition. - 3.2. Example.
- List the types of data generated by business process. - 4.1. Unstructured data. - 4.2. Semi-Structured data. - 4.3. Structured data.
- List software used in business process. - 5.1. Customer Relationship Management (CRM) Software.
- 5.2. Enterprise Resource Planning (ERP) Software
- 5.3. Business Process Management (BPM) Software.
- 5.4. Collaboration and Communication Tools. - 5.5. Analytics and Business Intelligence (BI) Tools.
- 5.2. Enterprise Resource Planning (ERP) Software
- List software used in business process. - 5.1. Customer Relationship Management (CRM) Software.
- organization. II. Compare the types of support available for business decision-making at varying levels within an
- Business decision making.
- Types of decision-making levels.
- 2.1. Operational decisions. - 2.2. Tactical decisions. - 2.3. Strategic decisions.
- List examples of decisions need to make for each level in the company.
- 3.1. Operational Decisions
- 3.2. Tactical Decisions
- 3.3. Strategic Decisions
- List examples of decisions need to make for each level in the company.
- REFERENCES
Figure 2: Flowchart example of BP model There are 2 shapes in the flowchart above:
- Rectangle: represent the process of task being performed
- Diamond: represent the decision point of process.
2. Business process. 2.1. Definition. A business process is a collection of interconnected operations carried out in an organization to accomplish a specified purpose, such as supplying a product or service to a client. A business process is often comprised of a sequence of activities, procedures, and actions carried out by people, technology, or a mix of the two. Depending on the nature of the company and the aim being pursued, business processes can be simple or complicated.
Figure 3: Business process 2.2. Example.
2.2.1. Online ordering process
Activities diagram Figure 4: online ordering process Explain:
3. Supporting processes (Decistion making process). 3.1. Definition. Supporting processes are business procedures that are required to support or facilitate an organization's main activities. While core processes directly contribute to the development of goods and services, supporting processes assist core processes by providing the resources, infrastructure, and services that allow core processes to function. Supporting processes are the activities, actions, and procedures that are required to support the fundamental business processes. Human resources, IT support, procurement, finance, quality management, and facilities management are examples of supporting processes. Figure 6: Supporting process 3.2. Example. Asset Management: Activities diagram
Figure 7: Asset Management Explain:
- The first activity in the process is to identify the categories of assets that need to be tracked and managed.
- The next activity is to add an asset to the system. This involves entering details about the asset such as the name, type, model, and serial number.
- After the asset details are entered, a unique code is assigned to the asset for identification purposes. This code is then saved to the asset database along with all other details of the asset.
- Next activity involves tracking the current location and condition of the asset to ensure that it remains in good working condition.
- Lastly, the asset information is updated regularly to reflect any changes such as repairs, maintenance, or disposal.
4.2. Semi-Structured data. Figure 9: Semi-structured data Semi-structured data is data that lacks a definite or preset data model or structure but yet has organizational qualities such as labels, tags, or other markers that offer some level of structure. While not as strictly defined as structured data, unstructured data is more ordered. Semi-structured data includes XML or JSON data, emails, social media postings, and other forms of textual data with some structure but no formal standard. Semi-structured data might be difficult to deal with since it may need the use of specialized tools to extract and analyze the information. 4.3. Structured data. Figure 10: Structured data
Structured data is data that has been structured and formatted in a precise manner, typically within a database or spreadsheet. It has a well-defined and consistent data model in which data is kept in tables with set columns and rows and each data piece is generally divided into distinct fields. Structured data, because of its uniform format, may be readily searched, sorted, analyzed, and processed using a variety of tools and technologies. Customer information, sales or transaction data, personnel records, financial statements, and most other sorts of data that are arranged in a predictable and consistent manner are examples of structured data.
5. List software used in business process. 5.1. Customer Relationship Management (CRM) Software. CRM software is a product or suite of tools that assists organizations in managing their customer interactions by providing a centralized database of client information that can be accessed and updated by various departments within the organization. It usually contains tools for sales automation, marketing automation, customer care and support, analytics and reporting, and so forth. Contact management, lead tracking, opportunity management, campaign management, ticket management, analytics, and reporting are some of the functions that may be included. Salesforce, HubSpot, Zoho, and Microsoft Dynamics are some major CRM software companies. Figure 11: CRM
Figure 13: BPM 5.4. Collaboration and Communication Tools. Collaboration and Communication tools and apps meant to improve communication and cooperation between teams and people inside organizations. These technologies allow teams to collaborate from many places, exchange documents and data, use instant chat, interact in real time, track progress, and give tasks to team members. Slack, Microsoft Teams, and Google Workspace are some examples of collaboration and communication solutions.
Figure 14: Collaboration and Communication Tools
5.5. Analytics and Business Intelligence (BI) Tools.
Analytics and Business Intelligence (BI) tools are software systems and apps that allow users to extract, display, and analyze data. Reporting, data visualization, predictive analytics, data mining, and self- service BI tools are among the numerous types of Analytics and Business Intelligence tools available. Tableau, Power BI, and Google Data Studio are examples of analytics and business intelligence software. Figure 15: BI tools
II. Compare the types of support available for business
decision-making at varying levels within an
organization.
1. Business decision making.
The process of determining the best effective course of action from multiple available choices to meet specified company objectives is referred to as business decision making. Effective decision making is critical for an organization's success and growth since it involves many factors such as resource allocation, risk management, performance improvement, and strategic planning. For example: A customer contacts a call center to resolve a billing dispute.