Download Business Intelligence: Leveraging Data for Informed Decision-Making and more Lecture notes Software Development in PDF only on Docsity!
Higher Nationals Internal Verification of Assessment Decisions – BTEC (RQF) Program title HND in Computing Assessor MR.Thilina Wansathilaka Internal Verifier Unit(s) Unit 14: Business Intelligence Assignment title Applying BI solutions to enhance and improve business operations Student’s name W.M.Supun Anjana Jayasinghe List which assessment criteria the Assessor has awarded. Pass Merit Distinction 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 student work? Y/N Has the work been assessed accurately? Y/N Is the feedback to the student: Give details: Y/N Constructive? Y/N Linked to relevant assessment criteria? Y/N Identifying opportunities for improved performance? Y/N Agreeing actions? Y/N Assessor signature Date Internal Verifier signature Date Programme Leader signature (if required) (^) Date W.M. Supun Anjana Unit-14 Business Intelligence
Confirm action completed Remedial action taken Give details: Assessor signature Date Internal Verifier Date signature Date Program Leader Date signature (if required) Date W.M. Supun Anjana Unit-14 Business Intelligence
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.
Assignment Feedback
Formative Feedback: Assessor to Student Action Plan Summative feedback Feedback: Student to Assessor Assessor signature Date Student signature Date W.M. Supun Anjana Unit-14 Business Intelligence
Pearson Higher Nationals
in Computing
Unit 14: Business Intelligence
Assignment 01
W.M. Supun Anjana Unit-14 Business Intelligence
Important Points:
- It is strictly prohibited to use textboxes to add texts in the assignments, except for the compulsory information. e.g.: Figures, tables of comparison etc. Adding text boxes in the body except for the before mentioned compulsory information will result in rejection of your work.
- Avoid using page borders in your assignment body.
- Carefully check the hand in date and the instructions given in the assignment. Late submissions will not be accepted.
- Ensure that you give yourself enough time to complete the assignment by the due date.
- Excuses of any nature will not be accepted for failure to hand in the work on time.
- You must take responsibility for managing your own time effectively.
- 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.
- Failure to achieve at least PASS criteria will result in a REFERRAL grade.
- Non-submission of work without valid reasons will lead to an automatic RE FERRAL. You will then be asked to complete an alternative assignment.
- If you use other people’s work or ideas in your assignment, reference them properly using HARVARD referencing system to avoid plagiarism. You have to provide both in-text citation and a reference list.
- If you are proven to be guilty of plagiarism or any academic misconduct, your grade could be reduced to A REFERRAL or at worst you could be expelled from the course. W.M. Supun Anjana Unit-14 Business Intelligence
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. I know that plagiarism is a punishable offence because it constitutes theft. I understand the plagiarism and copying policy of Edexcel UK. I know what the consequences will be if I plagiarize or copy another’s work in any of the assignments for this program. 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. I acknowledge that the attachment of this document signed or not, constitutes a binding agreement between myself and Pearson UK. I understand that my assignment will not be considered as submitted if this document is not attached to the assignment. Student’s Signature: Date: ( Provide E-mail ID ) ( Provide Submission Date )
Higher National Diploma in Business
Assignment Brief
Student Name /ID Number Unit Number and Title Unit 14: Business Intelligence W.M. Supun Anjana Unit-14 Business Intelligence
(DSS) to a number of tools, technologies, architectures and methods which involves data cleaning, data integration, data mining, data evaluation and data representation. Hence BI can be identified as a software suite of software and services to transform data into actionable intelligence and knowledge. Scenario Yard of Ale is a large-scale brewery in Sri Lanka and well establish company control 20% market share of beer market which is the 2nd biggest market share from entire beer market. The company have automated production line include mills, Brewhouse and bottling plant and each control by separate embedded software system not allowed to access operational data stores but can be configured to generate CSV or excel operational data file at the end of each batch. The company consists of multiple departments responsible for each operations of the organization such as Production, Engineering, HR/Legal, finance, Sales and marketing, Procurement, Administration, Quality control, Research and development, IT and each and every department have its own operational systems to record keeping purposes and each operational application software developed by professionally. Each department manages by a department manager. For an example, production department manages by the production manager, and he is responsible for manage all production related operations in sub departments. Mills, Brewhouse, Bottling plant, raw material and finish products stores and each sub department managed by operational manager. This hierarchical configuration replicates throughout most of the department. Upper management of brewery required to consolidate all these data in to one data warehouse with the data contain in the legacy system as well. Other than that upper management required to incorporate every external data about company and products from various data collection and research agencies to the business intelligent system. Those external data available as JSON/XML data files, plain text reports, social media comments/posts and all negative and positive online comments about organization and products. Upper management of company believe more you know about organization and the external environment you have better completive advantage. Have potential to control bigger market share and effectively become number 1 beer in Sri Lanka Task 1 W.M. Supun Anjana Unit-14 Business Intelligence
Analyse the business processes and the supporting processes of the organization given in the scenario and differentiate between semi structured and unstructured data. Evaluate the benefits and drawbacks of using application software to handle the business processes in Yard of Ale. Task 2 Compare how strategic, tactical and operational decisions are supported within the organization for business decision making process. You have to furthermore compare and contrast how various information systems (TPS, MIS, DSS) could be utilized to enhance those decisions with related to key features of BI framework. Justify your answer with relevant to the functionalities of business intelligence. Task 3 Chief Engineer is the tactical manager of engineering department who oversees all repairs and maintenance of the total eight sectors of the factory that include water purification plant, Mill, Brewhouse, bottling plant, waste treatment plant, factory maintenance and repair/ fabrication shop. Each sector consists of two or more sub sectors and each subsector have 4- 10 of machines. Chief engineer requires to track the maintenance and repair all the machineries with minimal disruption to production and he must maintain healthy inventory of spare parts which consist of over 5000s items, track the progress of every job, identify problematic arias, Track engineers and mechanics work logs and efficiency and monitor system downtime. 3.1. Explain what business intelligence is and the tools and technologies associated with it by taking relevant examples to the organization given in the scenario. 3.2. Design a Managerial dashboard for chief engineer using various data visualizations methodologies that includes 6-8 widgets to present required information. Apply appropriate customizations that can utilize to improve the managerial dashboard designed above. Critically evaluate how your Dashboard design and the suggested enhancement could optimize chief engineer’s performance by delivering accurate and reliable information to increase his effectiveness. Task 4 W.M. Supun Anjana Unit-14 Business Intelligence
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 organization.
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 business intelligence functionality.
W.M. Supun Anjana Unit-14 Business Intelligence
D2 Compare and contrast a range of information systems and technologies that can be used to support organization 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 Customize 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 specific user or business requirement and identify what customization has been integrated into the design
W.M. Supun Anjana Unit-14 Business Intelligence
Tale of Contents Task 01.......................................................................................................................................................................... 17 1.1 Examine, using examples, the terms ‘Business Process’ and ‘Supporting Processes’................................ 17 1.1.1 What is Business process........................................................................................................................ 17 1.1.2 The importance of business processes........................................................................................................ 17 1.1.2 Management process............................................................................................................................. 19 1.2 Differentiate between unstructured and semi structured data within an organization.................................... 24 1.2.1 Structured Data............................................................................................................................................ 24 1.2.2 What is unstructured data?......................................................................................................................... 25 1.2.3 Semi structured Data................................................................................................................................... 27 1.2.4 What are the key differences between structured and unstructured data?.............................................. 27 1.2.5 Differentiate between unstructured and semi structured data.................................................................. 28 1.3 Evaluate the benefits and drawbacks of using application software as a mechanism for business Processing 29 Task 02.......................................................................................................................................................................... 34 2.1 Decision making is central to all or any the managerial activities, be it planning, organizing, staffing, directing, or controlling............................................................................................................................................................. 34 2.1.1 Compare how strategic, tactical, and operational decision are supported within the organization for business deciding process..................................................................................................................................... 40 2.1.2 Good Decision Making................................................................................................................................. 41 2.2 Justify the key features of Business Intelligence................................................................................................ 41 2.3 Compare the range of information systems and technologies that can be used to assist organizations at the operational, strategic and strategic levels................................................................................................................ 43 2.3.1 Transaction processing System (TPS).......................................................................................................... 43 2.3.2 Management information system (MIS)..................................................................................................... 44 2.3.3 Decision support System (DSS).................................................................................................................... 45 2.3.4 Artificial intelligence techniques in business............................................................................................... 45 2.3.5 Online Analytical processing (OLAP)....................................................................................................... 47 Task 03.......................................................................................................................................................................... 50 Demonstrate the use of business intelligence tools and technologies........................................................................ 50 3.1 Determine, with examples, what business intelligence is and the tools and techniques associated with it 50 3.2 Create a managerial dashboard for the chief engineer utilizing multiple data visualization approaches, with 6-8 widgets to display essential information. Apply the essential adjustments to improve the above- mentioned management dashboard........................................................................................................................ 65 W.M. Supun Anjana Unit-14 Business Intelligence
3.3 Critically evaluate how your Dashboard design and therefore the suggested enhancement could optimize chief engineer’s performance by delivering accurate and reliable information to extend his effectiveness............................................................................................................................................................. 69 Task 04.......................................................................................................................................................................... 71 4.1 Discuss how organizational decision-making process can be improved by implementing business intelligence tools.......................................................................................................................................................................... 71 4.1.1 Conduct a research to identify the organizations that have utilized new business intelligent innovations and trends to improve their performance and to extend BI systems to target audience, provide better competitive advantage within the market........................................................................................................... 74 4.2 Explore the legal issues involved in the secure exploitation of business intelligence tools.............................. 86 4.3 Conduct research to spot specific samples of organizations that have used business intelligence tools to reinforce or improve operations............................................................................................................................. 92 4.3.1 What is business intelligence....................................................................................................................... 92 4.3.2 business intelligence achieved in organization........................................................................................... 94 4.3.3 which type of Business intelligence tools using by organization................................................................ 98 4.4 Evaluate how organizations could use business intelligence to increase their audience and make them more competitive within the market, taking security legislation into consideration...................................................... 117 4.4.1 Provide strong security.............................................................................................................................. 118 4.4.2 To power up productivity.......................................................................................................................... 121 4.4.3 Swift Decision Making................................................................................................................................ 124 4.4.4 Timely recognition trends.......................................................................................................................... 126 References.................................................................................................................................................................. 134 W.M. Supun Anjana Unit-14 Business Intelligence
Task 01 1.1 Examine, using examples, the terms ‘Business Process’ and ‘Supporting Processes’. 1.1.1 What is Business process A business process is a set of procedures taken by a group of people to accomplish a specific goal. A task is allocated to each participant at each step in a business process. It serves as the foundation for other related concepts such as business process management, process automation, and so on. While there is a lot written and spoken about business process management, it's critical to understand why it's so critical to your company. 1.1.2 The importance of business processes W.M. Supun Anjana Unit-14 Business Intelligence
The need for and advantages of a business process are quite apparent in large organizations. A process forms the lifeline for any business and helps it streamline individual activities, making sure that resources are put to optimal use. Figure 1 business process (Source: https://kissflow.com/workflow/bpm/business-process/ Date: February 20,2022) Key reasons to have well-defined business processes
- Identify what tasks are important to your larger business goals
- Improve efficiency
- Streamline communication between people/functions/departments
- Set approvals to ensure accountability and an optimum use of resources
- Prevent chaos from creeping into your day-to-day operations
- Standardize a set of procedures to complete tasks that really matter to your business W.M. Supun Anjana Unit-14 Business Intelligence
