1641 Business Intelligence Assignment 2 Pass, Assignments of Computer Science

Download 1641 Business Intelligence Assignment 2 Pass 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: GCS210351 Class: GCS1003B Subject code: 1641 Assignment due: Assignment submitted: 1 2 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 GCS210351 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 D2 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. 5 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 6 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. 7 Table of Contents Unit 14: BUSINESS INTELLIGENCEASSIGNMENT 1 1 ASSIGNMENT 1 BRIEF 4 Assignment 1 Answers 9 I. Examine, using examples, the terms ‘Business Process’ and ‘Supporting Process’. 9 1. Business process model. 9 1.1. Definition. 9 1.2. Example. 9 2. Business process. 10 2.1. Definition. 10 2.2. Example. 11 2.2.1. Online ordering process 11 2.2.2. Order management 12 3. Supporting processes (Decistion making process). 13 3.1. Definition. 13 3.2. Example. 13 4. List the types of data generated by business process. 15 4.1. Unstructured data. 15 4.2. Semi-Structured data. 16 4.3. Structured data. 16 5. List software used in business process. 17 5.1. Customer Relationship Management (CRM) Software. 17 5.2. Enterprise Resource Planning (ERP) Software 18 5.3. Business Process Management (BPM) Software. 18 5.4. Collaboration and Communication Tools. 19 5.5. Analytics and Business Intelligence (BI) Tools. 20 II. Compare the types of support available for business decision-making at varying levels within an organization. 20 1. Business decision making. 20 1 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. 1 Figure 3: Business process 2.2. Example. 2.2.1. Online ordering process Activities diagram Figure 4: online ordering process Explain: 1 + The process begin with the login of client + Client then choose the product they want to order among others + If that what they want, they can put it into their waiting cart for payment or return + After finish shopping, client will check again their cart and pay for it + In order to make it easy for shipping, client will have to give some necessary information + Client last confirm the order and exit the app 2.2.2. Order management Activities diagram Figure 5: Order management Explain: + Process start when system receive an order information + Employee then check and verify that information + They then put that order into to-do list on the app + Employees prepare all the goods that match with the order and packed them + Shipper will get the order packages and ship to client house + When shipping is finished, status of the order will be updated + End the process, system stop running 1 4. List the types of data generated by business process. 4.1. Unstructured data. Figure 8: Unstructured data Unstructured data is any data that lacks a pre-defined data model or organizational structure. Free text, photos, audio and video files, social media postings, emails, and any other sort of data that does not fit well into standard database structures are examples of this type of data. Unstructured data can be difficult to analyze using traditional approaches, and it frequently necessitates the use of sophisticated analytics tools and techniques to extract significant insights. Despite these obstacles, unstructured data is becoming increasingly relevant in today's data-driven world since it frequently offers significant insights and information that may assist companies in making better decisions. 1 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 1 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 2 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. 2 2. Types of decision-making levels. 2.1. Operational decisions. Operational decisions are made at the most basic level of the organization and are concerned with day-to-day operations. They are routine and repetitive in nature, with the goal of maintaining smooth operating operations and effective resource use. Front-line staff or supervisors with a thorough awareness of the individual activities and operational needs typically make these judgments. Figure 16: Operational Decisions 2.2. Tactical decisions. Tactical decisions are made at the organizational intermediate level to bridge the gap between operational and strategic decisions. When opposed to strategic judgments, tactical decisions are more organized and standardized. Resource allocation, budgeting, project planning, and personnel management are a few examples. Managers and department heads are accountable for making tactical decisions that link the operations of their departments with the larger company goals. Figure 17: Tactical Decisions 2.3. Strategic decisions. Strategic decisions are taken at the highest levels of an organization and have a substantial influence on the business's long-term direction and performance. These judgments are difficult, unstructured, and 2 fraught with ambiguity. Setting organizational goals, establishing strategies, entering new markets, mergers and acquisitions, substantial investments, and overall corporate positioning are all part of strategic decisions. Figure 18: Strategic Decisions 3. List examples of decisions need to make for each level in the company. 3.1. Operational Decisions Scenario: A restaurant manager needs to decide on menu items to offer and pricing for the upcoming quarter. Apply BI tools: Business intelligence may give insights into client preferences and spending habits, detect trending menu items and competition pricing, and estimate prospective demand changes. This information can help to influence choices and boost revenue and profitability. Solution: Create a Business Intelligence system that compares transaction data from other restaurants to help precisely price things and estimate client demand. 3.2. Tactical Decisions Scenario: A marketing department is deciding which advertising channels to allocate budgets to. Apply BI tools: Data from advertising campaigns may be evaluated to see which channels are most productive and which campaigns yield the greatest results. The marketing team may make better informed decisions with more predictable effects using business intelligence technologies.