Business Intelligence: Enhancing Organizational Decision-Making, Assignments of Business Informatics

Download Business Intelligence: Enhancing Organizational Decision-Making and more Assignments Business Informatics in PDF only on Docsity!

Higher Nationals

Internal verification of assessment decisions – BTEC (RQF)

INTERNAL VERIFICATION – ASSESSMENT DECISIONS Programme title HND in Computing Assessor T.Menan^ Internal Verifier Unit(s) Unit 14:^ Business Intelligence Assignment title Applyi operationsng BI solutions to enhance and improve business

Student’s name ITHREES MOHAMED ISHRAK 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:

• Constructive?
• Linked to relevant assessment criteria?
• Identifying opportunities for improved performance?
• Agreeing actions?

Y/N Y/N Y/N Y/N

Does the assessment decision need amending? Y/N Assessor signature Date

Internal Verifier signature Date Programme Leader signature (if required) Date

Confirm action completed

Remedial action taken Give details:

Assessor signature Date Internal Verifier signature

Date

Programme Leader signature (if required)

Date

Assignment Feedback

Formative Feedback: Assessor to Student

Action Plan

Summative feedback

Feedback: Student to Assessor

Assessor Date signature Student signature Date

Pearson Higher Nationals in

Computing

Unit 14: Business

Intelligence Assignment 01

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.

Isfaqrock300@gmail.com Student’s Signature:

Date: ( Provide E-mail ID ) ( Provide Submission Date )

Higher National Diploma in Business

Assignment Brief

Student Name /ID Number ITHREES MOHAMED ISHRAK/ TRI/ Unit Number and Title Unit 14 : Business Intelligence Academic Year 2021/ Unit Tutor Assignment Title Business Process Support Mechanisms Issue Date Submission Date IV Name & Date

Submission format

The submission should be in the form of an individual written report. This should be written in a concise, formal business style using single spacing and font size 12. You are required to make use of headings, paragraphs and subsections as appropriate, and all work must be supported with research and referenced. Follow Harvard referencing system for in-text citations, reference list and the bibliography.. The recommended word limit is 4,000–4, words, although you will not be penalised for exceeding the total word limit.

Assignment Brief and Guidance:

Data and information are core to any organizational business process. Meaningful information is a necessity to drive profitable business actions. The concept of Business Intelligence (BI) has evolved through technologies such as Decision Support Systems (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 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 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 jobs, Identify problematic arias, Track engineers and mechanics work logs and efficiency and monitor system downtime.

Grading Rubric

Grading Criteria (^) Achieve d

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 organisation. 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.

D2 Compare and contrast a range of information systems and technologies that can be used to support organisations 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 Customise 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 a specific user or business requirement and identify what customisation has been integrated into the design.

Acknowledgement

In preparation for my assignment, I had to take the help and guidance of some respected persons, who deserve my deepest gratitude. As the completion of this assignment gave me much pleasure, I would like to show my gratitude Mr. T. Menan giving me a good guideline for assignment throughout numerous consultations. I would also like to expand my gratitude to all those who have directly and indirectly guided me in writing this assignment. Thank you… I.M.ISHRAK.

Table of Contents

ACKNOWLEDGEMENT ------------------------------------------------------------------------------------------------------------------ 16 TASK 01 ------------------------------------------------------------------------------------------------------------------------------------------ 19 1.1 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. ---------------------------------------------------------------------------------------------------------------------------------------- 19 Background details of the organization ------------------------------------------------------------------------------------------ 19 Business process ------------------------------------------------------------------------------------------------------------------------ 20 Operational processes ----------------------------------------------------------------------------------------------------------------- 21 Supporting processes ------------------------------------------------------------------------------------------------------------------- 22 Management processes ---------------------------------------------------------------------------------------------------------------- 23 Important Of Business Intelligent ---------------------------------------------------------------------------------------------------------- 24 Semi structured and unstructured data -------------------------------------------------------------------------------------------------- 26 Application software ------------------------------------------------------------------------------------------------------------------- 26 Functions of Application Software --------------------------------------------------------------------------------------------------------- 27 Examples of Application Software --------------------------------------------------------------------------------------------------------- 27 Business Application software ------------------------------------------------------------------------------------------------------ 27 Popular Application Software Add-Ons ------------------------------------------------------------------------------------------------- 28 TASK 02 ------------------------------------------------------------------------------------------------------------------------------------------ 30 2.1 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. ------------------------------------------------------------------------ 31

1. OPERATIONAL DECISIONS ------------------------------------------------------------------------------------------------------- 31 Operational Decisions ----------------------------------------------------------------------------------------------------------------- 31 Tactical Decisions ---------------------------------------------------------------------------------------------------------------------- 32 Strategic Decision ----------------------------------------------------------------------------------------------------------------------- 32 Transaction Processing System (TPS) -------------------------------------------------------------------------------------------- 34 Management Information Systems (MIS) --------------------------------------------------------------------------------------- 34 Decision Support System (DSS) ---------------------------------------------------------------------------------------------------- 35 Key features of Business Intelligence functionality ----------------------------------------------------------------------------------- 36 TASK 03 ------------------------------------------------------------------------------------------------------------------------------------------ 38 2.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. --------------------------------- 38 Business Intelligence Tools ---------------------------------------------------------------------------------------------------------- 38 Business Intelligence Techniques -------------------------------------------------------------------------------------------------- 40 Inventory Plan ------------------------------------------------------------------------------------------------------------------------------------ 42 3.2. DESIGN A MANAGERIAL DASH BOARD 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. --------------------------------------------------------------------------------------------------------- 44 Busines intelligence dashboard ----------------------------------------------------------------------------------------------------- 44 BI dashboard features and components -------------------------------------------------------------------------------------------------- 44 Managerial dash board --------------------------------------------------------------------------------------------------------------- 46

Table of Figures

Figure 1 Yard of Ale Profile Image ........................................................................................... 20 Figure 2 Semi structured and unstructured data .................................................................... 26 Figure 3 Word process sample picture ..................................................................................... 29 Figure 4 Scheduling software sample picture ........................................................................... 30 Figure 5 Spreadsheet sample picture ........................................................................................ 30 Figure 6 Decisions Concerns for comparison ........................................................................... 33 Figure 7 Decision taking pyramid ............................................................................................. 33

Task 01

1.1 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.

Background details of the organization

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.

Figure 1 Yard of Ale Profile Image

Business process

A set of processes architectures and technologies that transform raw data into meaningful information that drives profitable business actions are called Business Intelligence. Business Intelligence was derived from the idea that managers with inaccurate or incomplete information tend to make worse decisions on average than if they had better information. Transforming data into actionable intelligence and knowledge is a suite of software and services. Business intelligence impacts directly on the strategic, tactical and operational business decisions of the organization.

A wide range of applications and methodologies enable companies to collect data from internal systems and external sources to prepare data for analysis, create and conduct knowledge queries, and produce reports, dashboards and data visualizations to make analytical results available to corporate decision-makers and administrative staff are included in Business Intelligence. The different kinds of application that are used in BI are: Spreadsheets, Reporting and querying software: applications that extract, sort, summarize, and present selected data, online analytical