business intelligence, Assignments of Business

Download business intelligence and more Assignments Business in PDF only on Docsity! Pearson Higher Nationals in Computing Unit 14: Business Intelligence Assignment 01 General Guidelines 1 Business Intelligence 1. A cover page or title page should be attached to your assignment. Use page 1 of this assignment brief as your cover page and make sure all details are accurately filled. 2. The entire assignment brief should be attached as the first section of your assignment. 3. The assignment should be prepared using a word processing software. 4. The assignment should be word processing in an A4 sized paper. 5. Allow 1” margin on top, bottom and right sides of the paper and 1.25” on the left side (for binding). Word Processing Rules 1. The font size should be 12 point, and should be in the style of Time New Roman. 2. Set line spacing to 1.5. Justify all paragraphs. 3. Ensure that all headings are consistent in terms of size and font style. 4. Use footer function on the word processor to insert your name, unit, assignment no, and page number on each page. This is useful if individual sheets get detached from the submission. 5. Use the spell check and grammar check function of the word processing application to review the use of language on your assignment. 2 Business Intelligence making purposes and the legal/regulatory context in which they are used Assignment Brief and Guidance: Business processes are pivotal to the operation, functionality and accomplishment of organisational goals. As a collection or set of tasks/activities, business processes ensure that the end goal of delivering a service or product to a customer is accomplished successfully. Scenario: Data and information is core to any organization 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 5 Business Intelligence include tools and methods associated with data mining, data integration, data quality and data warehousing in conjunction with other information management systems and applications. Suppose you are recently recruited as a Business Analyst to a leading Sri Lankan Organisation. As your initial project, you are required to prepare a management report to the Board of Directors including the following details. Part 1 Background details of the organization Identify and explain different business processes, supporting processes and the mechanisms used at the selected organisation with examples which support for decision making Identify data that have been used by the organisation in different levels and processes Discuss on business intelligence functionalities and the tools and techniques associated with them using specific examples chosen from the selected organisation Part 2 Produce a comprehensive table of comparison that includes the below details Differentiation between data classification based on the selected organisation in terms of structured, semi structured and unstructured Compare the tools and technologies associated with the business intelligence functionalities and support available for business decision making at various levels within the organisation Part 3 Conduct a small study on organisations that have used business intelligence tools to enhance or improve operations 6 Business Intelligence Design a business intelligence tool, application or interface that can perform a specific task to support decision making at the selected organisation Discuss the importance and the impact of business intelligence tools and technologies that can be used by the organization for effective decision making within the legal/ regulatory context of the organisation Identify new Business Intelligence trends and technologies that can be further enhance in the selected organisational context As the Business analyst, present your finding to the board of directors of the selected organisation 7 Business Intelligence the legal/regulatory context in which they are used P5 Discuss how business intelligence tools can contribute to effective decision-making. P6 Explore the legal issues involved in the secure exploitation of business intelligence tools. M4 Conduct research to identify specific examples of organisations that have used business intelligence tools to enhance or improve operations D4 Evaluate how organisations could use business intelligence to extend their target audience and make them more competitive within the market, taking security legislation into consideration. 10 Business Intelligence Dilmah Plc 1 Business Intelligence Table of Contents Activity 1.................................................................................................................................6 1.1 Background of the Company........................................................................................................6 1.2 Identify and explain different business processes, supporting processes and the mechanisms used at the selected organization with examples which support for decision making........................7 1.2.1 Business Process Defined.............................................................................................................................7 1.2.2 Core Business Process..................................................................................................................................8 1.2.3 Supportive Business Process......................................................................................................................10 1.2.4 Management Process.................................................................................................................................13 1.3 Identify data that have been used by the organization in different levels and processes...........14 1.3.1 Data Used in Core Business Process...........................................................................................................15 1.3.2 Data Used in Supportive Business Process.................................................................................................16 1.3.3 Data used in Managerial Business Process................................................................................................17 1.4 Discuss on business intelligence functionalities and the tools and techniques associated with them using specific examples chosen from the selected organization..............................................19 1.4.1 BI Defined...................................................................................................................................................19 1.4.2 BI Functionalities........................................................................................................................................20 1.4.3 Business Intelligence Tools.........................................................................................................................21 1.4.4 BI Tools used at Dilmah Company..............................................................................................................22 1.4.5 BI Tools and their BI Functionalities...........................................................................................................28 Activity 2...............................................................................................................................30 2.1 Differentiation between data classification based on the selected organization in terms of structured, semi structured and unstructured..................................................................................30 2.1.1 Data Used in Core Business Process...........................................................................................................30 2.1.2 Data Used in Supportive Business Process.................................................................................................31 2.1.3 Data used in Managerial Business Process................................................................................................32 2.2 Compare the tools and technologies associated with the business intelligence functionalities and support available for business decision making at various levels within the organization.........34 Activity 3...............................................................................................................................35 2 Business Intelligence Table 1: Data Used in Core Business Process...............................................................................15 Table 2: Data Used in Supportive Business Process (HRM).........................................................16 Table 3: Data Used in Supportive Business Process (Production Planning).................................16 Table 4: Data used in Managerial Business Process......................................................................17 5 Business Intelligence Activity 1 1.1 Background of the Company Dilmah Ceylon Tea Company PLC is a world renowned Sri Lankan tea company with an unparalleled reputation for producing the highest quality authentic, natural and ethical Sri Lankan tea. The company pioneered the concept of single-origin tea in 1988 and offered tea that was "picked, perfected and packaged" at the origin. As the first global tea brand to be owned by a manufacturer, Dilmah Group is the only fully vertically integrated tea company with a presence along the entire value chain, including ownership of several of the best tea gardens, factories, printing and packaging facilities in Sri Lanka. Dilmah products are sold in over 100 countries and are supported by an extensive global sales network. The group has remained true to its founder's vision of growing business as a matter of human service. Significant investments are made each year in support of the humanitarian and environmental initiatives of Dilmah Conservation and the MJF Charitable Foundation. DCTC is 86% owned by the MJF group of companies - MJF Teas (Pvt) Ltd and MJF Exports (Pvt) Ltd. 6 Business Intelligence Figure 1: Dilmah Company The Dilmah Group has made a significant contribution to increasing the brand value of Ceylon Tea on a global basis. Significant investments have been made each year in global marketing efforts, research and development, communications and industry leadership. The group conducts international signature events and competitions including Dilmah Thé Culinaire, Dilmah Tea Sommelier, Chefs and Teamaker, School of Tea to inspire industry stakeholders for new tea experiences. Dilmah also publishes a number of tea-inspired publications aimed, among other things, at raising awareness of industry innovations, the health benefits of tea and tea dining, and mixology. On the occasion of the 150th anniversary of the tea industry in Sri Lanka, the group also launched its own website on the history of Ceylon tea, which contains numerous publications on the fascinating development of the industry. Dilmah products are sold in over 100 countries around the world through an extensive network of agents and distributors. These partners are a crucial element of our value chain. You will proactively engage with consumers, pursue new opportunities and identify emerging consumer preferences. 1.2 Identify and explain different business processes, supporting processes and the mechanisms used at the selected organization with examples which support for decision making. 1.2.1 Business Process Defined A business process consists of a series of steps that are carried out by a group of stakeholders in order to achieve a specific goal. Each step in a business process designates a task that is assigned to a participant. It is the basic building block for various related ideas like business process management, process automation, etc. (Kissflow Inc, 2021). Main reasons for having clearly defined business processes  Identify which tasks are important to achieve the larger business goals  Increase efficiency  Optimize communication between people / functions / departments  Establish approvals to ensure accountability and optimal use of resources  Prevent chaos from creeping into daily routines 7 Business Intelligence Step 6: Sort & Sort Once the burning and drying process is completed, the leaves are moved into large meshes that separate them by size, and this ultimately determines the quality of the tea, for example, dust, whole leaf, pekoe. Step 7: Tasting and evaluation This is the final stage in the whole process. Trying tea is really an art form; The taster has to judge the quality of the appearance of the tea leaf, the aroma, the cup color and the peculiarity of the tea. This traditional method of tea processing, which has taken many years to master; From the fine hand-picking of the tea leaves to the oxidation, sorting and sorting to tasting, everything was mastered by the Dilmah staff. The art of making Ceylon black tea is truly a love work, a love Dilmah is proud of. 1.2.3 Supportive Business Process 1.2.3.1 Human Resource Management Training and Development At Dilmah, company prides themselves to be a learning organization. Company is being committed to ensuring that all their employees have access to learning, development and training opportunities to gain the knowledge and skills needed to carry out their designated role within the Group. Company believes that through training and development, employees can sharpen their competencies in order to support the Group’s strategic objectives and future growth trajectory. The training and development of human resources is based on the strategic goals of the organization. During this year, the company conducted more than 170 individual trainings and 45 group plans for technical and soft skills development, and provided total beneficiaries for all employees. Develop personal development plans for employees based on the functional/technical capability gaps identified by HOD. After a rigorous evaluation process, a lineup of training and development plans will be provided to individuals. In addition to on-the-job training through 10 Business Intelligence mentoring and job rotation culture, we also conduct internal and external training programs for all categories of employees. In this year, well-known industry experts conducted 9 external team training programs, and the company's internal knowledge bank (composed of well-known personnel with rich industry experience) conducted 36 internal team training programs. In addition to training for specific positions, the company also promotes employee growth by investing in other training to enhance leadership skills, thereby transforming our management team to lead the next generation of workforce. HOD recommends 460 training programs for individuals and groups in 2019/20. According to business needs, all training is divided into 08 categories, 1. Business and Communication 2. Compliance and System Requirements 3. Finance and Accounting 4. Information Technology 5. Leadership and Management 6. Professional Trainings 7. Food Hygiene and Safety/OHS 8. On the job trainings/Technical Further, Cross Functional Training Programs are conducted to provide insights to the processes and the functions between departments. Engagement and Grievance Handling Through numerous mechanisms and engagement measures, Dilma has maintained a high level of employee engagement. These measures include development measures, sports and entertainment activities, and cultural activities. The team also benefited from a transparent and simplified grievance handling procedure, which resulted in a happy workforce. Performance Evaluation 11 Business Intelligence Rewards and compensation are based on a transparent and well-defined performance evaluation system to foster a performance-driven culture. Through the latest HRIS and capability assessment, the executive and non-executive staff will be evaluated for performance every six months. The Employee Performance Management System (EPMS) evaluates employees based on each key performance indicator (KPI), ability and Dilmah value during the evaluation period. EPMS facilitates a one-to-one discussion of the evaluation process and provides continuous feedback between evaluators and evaluators. 1.2.3.2 Planning and Scheduling The production planning department is responsible for planning and planning orders. This department is called the PPC department. They perform production and follow all production processes. Production plans and activity arrangements are essential for the procurement of raw materials on time, the completion of production activities on time, and the ability to deliver goods on time. The following activities are performed by the production planning and control department of the Dilmah tea factory  Job or Task Scheduling  Material Requirement Planning (Inventory)  Loading Production  Process selection & planning  Facility location  Estimating quantity and costs of production Capacity planning  Line planning  Production follow up and execution 12 Business Intelligence 1.3.1 Data Used in Core Business Process Table 1: Data Used in Core Business Process Business Process Data Used Getting Raw Materials • The details of the raw materials (tea leaves and other ingredients) such as their quality, colour and etc. (Structured Data). • The details of the suppliers of the raw materials such as their names, registration number (Structured Data). • Payment details of the raw materials purchased like the bill number, amount paid and payable (Semi-structured Data). • The details of the transportation facilities used (Structured Data). Production Process • Details of the equipment’s used such as drying machines, grinding machines and etc. regarding their working-conditions, repairing details and etc. (Structured Data). • The details of the employees who are working on the production process such as their employee id, name and etc. (Semi-structured Data). Quality Control • The details of the final products such as their quality, colour, taste and etc. (Structured Data). • The details of the standard measurements and the quality checking protocols and criteria (Semi- structured Data). Packaging and Delivery • The details of the packaging bags like the number of bags used and the packaging tags which consists of the product name, brand name and sizes (Structured Data). 15 Business Intelligence • The details of the delivery vehicles used like their vehicle number, their working- conditions and the details of the drivers of the vehicle (Structured Data). 1.3.2 Data Used in Supportive Business Process Table 2: Data Used in Supportive Business Process (HRM) Business Process (HRM) Data Used Recruitment and Selection Process • The Personal Details of the Employees such as their name, employee reg number, year of service their qualifications (Structured Data). Compensation • The details regarding the compensation packages for each type of jobs in the company along with other reward facilities (Structured Data). Training and Development • The details of the training and development programmes and the current status of employees (Structured Data). Performance Management • The performance management details of the employees with past data with inclusion of employees’ skills and competencies details (Structured Data). Occupational Health and Safety • The details of the medical history pf each employee along with the health and safety information regarding the accidents in the organization and their follow up details (Semi-structured Data). Table 3: Data Used in Supportive Business Process (Production Planning) Business Process Data Used Planning and Scheduling • Scheduling of production process (Semi-structured Data). • Material and Labour Cost Management (Semi- Structured Data). 16 Business Intelligence • Control standards to be measured (Semi-Structured Data). • Production Forecasting details (Un Structured Data). 1.3.3 Data used in Managerial Business Process Table 4: Data used in Managerial Business Process Business Process Data Used Policy Formulation • The policy scopes (Un Structured Data). • The purpose of the policy (Un Structured Data). • The impact of policy on organization and society (Un Structured Data). • The clauses and conditions of policies (Un Structured Data). • The operation status of the company (Un Structured Data). • The need and wants of employees (Semi- Structured Data). • The dissatisfaction factors at the company (Semi-Structured Data). • Need assessment details of the company (Semi-Structured Data). • The ways in which the policy is communicated [Publications, Annual Reports] (Un Structured Data). • The Meeting details with employees [time, venue] (Semi-Structured Data). • The opinion / messages to employees and stakeholders from top management on policy (Semi-Structured Data). 17 Business Intelligence of who is business intelligence. BI aims to provide business managers with a simple snapshot of the current state. Although the predictions and recommendations derived from business analysis require analysis and interpretation by data science professionals, one of the goals of BI is that relatively non- technical end users should be easy to understand and can even delve into the data and create new reports (Mary Pratt and Josh Fruhlinger, 2021). 1.4.2 BI Functionalities Analytics- BI is the discovery, interpretation, and communication of relevant and useful patterns in data. Analysis can use descriptive, descriptive and predictive methods, as well as statistical data, computer programming, and other methods to provide meaningful data that can be used to describe, predict, quantify, and improve business performance. 2. Reporting-One of the hallmarks of the BI program is to fully visualize the knowledge and reports generated after analysing the data. These reports can be charts, graphs, presentations, and infographics, and they provide users with important information that they can respond to or decide. 3. Complex event processing - combines data from multiple sources to identify important events or events across the organization. Regardless of whether it is a threat or an opportunity, CEP offers companies the opportunity to respond appropriately. 4. Data Mining - BI supports data mining techniques to convert raw data into useful information. BI programs often receive data from data warehouses that already contain consolidated information. BI focuses on analysing the data. 5. Process Mining - Special algorithms are applied to event logs that are recorded by an information system to identify trends and details and improve process efficiency. 6. Text mining - involves extracting relevant patterns and deriving high quality information from text sources, which are then analysed by a BI program. 7. Benchmarking - BI uses this method to measure business performance against a specific indicator (time, quality or cost). The result is a performance metric that is compared or compared with best practices from other companies or the standard level in a particular industry. 20 Business Intelligence 8. Business Performance Management - BPM activities, particularly in large companies and organizations, involve large amounts of data that require collection, analysis, and reporting. BI programs were developed for these areas. 1.4.3 Business Intelligence Tools Business Intelligence (BI) tools are types of application software that collect and process large A business intelligence (BI) tool is an application software that can collect and process large amounts of unstructured data from internal and external systems, including books, journals, documents, health records, images, files, emails, videos, and other business sources . BI tools are not as flexible as business analysis tools, but they provide a way to collect data, mainly to find information through queries. You can also use these tools to prepare the data for analysis so that you can create reports, dashboards, and data visualizations. The results provide employees and managers with opportunities to accelerate and improve decision-making, improve operational efficiency, identify new sales potential, identify market trends, report actual KPIs, and discover new business opportunities. Business intelligence tools are typically used for easier query and reporting of business data and can combine a wide range of data analysis applications, including ad hoc analysis and query, business reporting, online analysis processing (OLAP), mobile BI, real-time BI and operations BI, cloud and software as a service BI, open-source BI, collaborative BI and location information. It can also include data visualization software for chart design, as well as tools for creating BI dashboards and performance scorecards that display business metrics and KPIs to bring corporate data to life in easy-to-understand graphics (Microsoft Azure, 2021). 21 Business Intelligence 1.4.4 BI Tools used at Dilmah Company 1. SAP Business Intelligence SAP Business Intelligence offers several advanced analytics solutions including real-time BI predictive analytics, machine learning, and planning & analysis. The Business Intelligence platform in particular, offers reporting & analysis, data visualization & analytics applications, office integration and mobile analytics. SAP is a robust software intended for all roles (IT, end uses and management) and offers tons of functionalities in one platform. Features of SAP BI Tool  A BI enterprise reporting system: Reporting and analysis are done with ad hoc queries and a complex BI enterprise reporting system designed to guide your overall company strategy.  Self-service, role-based dashboards: Analytics applications and data visualization are focused on self-service capabilities, similar to other tools, where you can build your own role-based dashboards and applications to assess risks, for example.  Cross-enterprise sharing: You can create a cross-enterprise sharing functionality that will enable you to communicate your findings with other stakeholders and partners.  Connection with SAP Warehouse and HANA: Multidimensional data analysis enables you to filter and manipulate data with real-time analytics when you connect with SAP Business Information Warehouse (SAP BW) or SAP HANA. 22 Business Intelligence Figure 5: SAP BI Tool  Multiple reporting options: Create standard and customized reports by sharing via URL, enabling viewer access or sending an automated e-mail report which you can automate on specific time intervals. Additionally, you can embed datapine into your own application. 4. SAS BI Tool While SAS’ most popular offering is its advanced predictive analytics, it also provides a great business intelligence platform. It is self-service tool that allows to leverage data and metrics to make informed decisions about their business. Using their set of APIs, you are provided with lots of customization options, and SAS ensures high-level data integration and advanced analytics & reporting. Features  5 main subjects: SAS offers different BI products and technologies that are focused on visual data exploration and easy analytics, interactive reporting and dashboards, collaboration, and mobile apps.  Data exploration supported by machine learning: SAS’ data exploration offers automated analysis supported by machine learning compiled in interactive visualizations that answer business questions such as: “Where do my customers come from?”  Text analytics capabilities: Interesting features are text analytics that enables you to gain insights from text data such as social media and location analytics that combines data in a geographical context. 25 Business Intelligence Figure 8: SAS BI Tool  Reports and dashboards across devices: Dynamic visuals are organized into interactive reports and dashboards, similar to other tools in our lists, and you can access them also on mobile and tablet devices (both Android and iOS).  Integration with other applications: You can integrate SAS with Microsoft Office applications such as PowerPoint, Word, SharePoint or Excel with their Office Analytics solution which enables you to view your results directly in Microsoft Office Suite. 5. Yellowfin BI Yellowfin BI is a business intelligence tool and ‘end-to-end’ analytics platform that combines visualization, machine learning, and collaboration. You can also easily filter through tons of data with intuitive filtering (e.g. checkboxes and radio buttons) as well open up dashboards just about anywhere (thanks to this tool’s flexibility in accessibility (mobile, webpage, etc.). Features  5 main products: The Yellowfin BI suite combines 5 main products to connect, transform and understand your company data: Yellowfin signals, stories, dashboards, data discovery, and data prep.  3 areas of BI and analytics: They are specialized in 3 main areas of BI and analytics solutions: enterprise analytics, embedded analytics, and external analytical apps.  Yellowfin signals via smartphone: Benefit from the automated detection of trends and anomalies in your data thanks to the Yellowfin signals, which are based on powerful, AI- controlled algorithms and enable immediate, personalized notifications directly to your smartphone.  Persuasive data stories: Yellowfin stories enable users to combine data with a written narrative, video, and images to build trusted data reports, that put people first. 26 Business Intelligence Figure 9: Yellowfin BI  Smart tasks: They offer trigger-based smart tasks that are automatically sent to the relevant person if a KPI falls below a standard. This enables everyone within the company to take the right action at the right time. 6. QlikSenseQlikSense is a product of Qlik, a company also known for another business intelligence tool called QlikView. You can use QlikSense from any device at any time. The user interface of QlikSense is optimized for touchscreen, which makes it a very popular bi tool. A big difference with QlikView is the feature Storytelling. Users add their experience to the data and by using snapshots and highlights making the right analysis and decisions has become a lot easier. Features  Easily combine and load data, create smart visualizations, and drag and drop to build rich analytics apps accelerated by suggestions and automation from AI.  Augmented intelligence enhances human intuition throughout Qlik Sense with suggested insights, automated processes, and natural language interaction.  Stay productive online or offline with fully interactive mobile analytics. Make discoveries, easily collaborate, and take action with data — anywhere, anytime. 27 Business Intelligence Figure 10: QlikSense QlikSense Analytics: The QlikSense BI tool presents the data that has been collected from various sources in a relevant graphs and chart formats after analyzing and doing the forecasting experiments. Complex Event Processing: The BI Tool gather information from all the departments like HRM, Sales, Customer data, Finance and etc., and provide their analysis and forecasting on a whole considering the data collected from different sources. Activity 2 2.1 Differentiation between data classification based on the selected organization in terms of structured, semi structured and unstructured 2.1.1 Data Used in Core Business Process Business Process Data Used Getting Raw Materials • The details of the raw materials (tea leaves and other ingredients) such as their quality, colour and etc. (Structured Data). • The details of the suppliers of the raw materials such as their names, registration number (Structured Data). • Payment details of the raw materials purchased like the bill number, amount paid and payable (Semi-structured Data). • The details of the transportation facilities used (Structured Data). Production Process • Details of the equipment’s used such as drying machines, grinding machines and etc. regarding their working-conditions, 30 Business Intelligence repairing details and etc. (Structured Data). • The details of the employees who are working on the production process such as their employee id, name and etc. (Semi- structured Data). Quality Control • The details of the final products such as their quality, colour, taste and etc. (Structured Data). • The details of the standard measurements and the quality checking protocols and criteria (Semi-structured Data). Packaging and Delivery • The details of the packaging bags like the number of bags used and the packaging tags which consists of the product name, brand name and sizes (Structured Data). • The details of the delivery vehicles used like their vehicle number, their working- conditions and the details of the drivers of the vehicle (Structured Data). 2.1.2 Data Used in Supportive Business Process Business Process (HRM) Data Used Recruitment and Selection Process • The Personal Details of the Employees such as their name, employee reg number, year of service their qualifications (Structured Data). Compensation • The details regarding the compensation packages for each type of jobs in the 31 Business Intelligence company along with other reward facilities (Structured Data). Training and Development • The details of the training and development programmes and the current status of employees (Structured Data). Performance Management • The performance management details of the employees with past data with inclusion of employees’ skills and competencies details (Structured Data). Occupational Health and Safety • The details of the medical history pf each employee along with the health and safety information regarding the accidents in the organization and their follow up details (Semi-structured Data). Business Process Data Used Production Planning and Control • Scheduling of production process (Semi- structured Data). • Material and Labour Cost Management (Semi-Structured Data). • Control standards to be measured (Semi- Structured Data). • Production Forecasting details (Un Structured Data). 2.1.3 Data used in Managerial Business Process Business Process Data Used Policy Formulation • The policy scopes (Un Structured Data). • The purpose of the policy (Un Structured Data). 32 Business Intelligence Activity 3 3.1 Conduct a small study on organizations that have used business intelligence tools to enhance or improve operations  New York Shipping Exchange (NYSHEX) This is a shipping technology company working to improve the process of shipping overseas. The company has done really well lately, doubling their enrollment in 2019 using the business intelligence tool. NYSHEX has decided to give the entire company access to the data using the Chartio business intelligence tool. This was possible not only because all of this data is centralized in one system, but also because it is easy for someone with no programming knowledge to delve deep into the analysis. Chartio's drag and drop Visual SQL generator allows any NYSHEX employee to query, set up dashboards, and generate reports. Even if you have no idea what SQL (structured query language) stands for, you can get exactly what you need, when you need it. NYSHEX is now an incredibly efficient process as every employee can access and act on real-time data.  Amex One of the business areas where BI has been most effective is the financial industry. American Express was a pioneer of business intelligence in this sector and used the technology to develop new payment service products and market offerings for customers. The company's experiments in the Australian market have made it impressive to identify up to 24% of all Australian users who will close their accounts within four months. With this information, American Express can take effective measures to retain customers who would otherwise be lost. The BI software also helps the credit card company identify fraud more accurately, protecting customers whose card information may have been compromised.  CareLinx CareLinx is a nationwide home care network that connects families with over 300,000 home care workers. In recent years the company has sharpened its profile through partnerships with companies such as AARP and Aetna. The next step towards growth of the company required to adopt a compliant business intelligence solution so that the company can better serve their customers. After using the BI tool, any team in the company can securely query data, PHI, or 35 Business Intelligence other data to understand users on a deeper level. For example, Customer Success leverages Chartio to analyze data in real time and leverage those insights to better serve users. No matter how big CareLinx gets, they can give personal attention to every family who uses their product with the help of a HIPAA Compliant BI tool.  REI REI uses a business intelligence platform to analyze their co-op membership. Cooperative members contribute more than 90 percent of purchases from the retailer to the REI account. So it's important to track metrics like acquisition, retention, and reactivation. All of this information corresponds to over 90 terabytes of data. With the ability to analyze all of this data, operations teams can decide whether to invest more in brick-and-mortar retail or in digital experiences for their members. This leads to higher customer satisfaction and positive associations with the brand. The team also uses its BI platform to analyze customer segmentation to make decisions such as shipping methods, member lifecycle management, and assortments of product categories.  Starbucks Seattle-based Starbucks coffee chain is also a well-known user of BI technology. Through its popular loyalty card program, Starbucks can collect individual purchase data from millions of customers. With the help of this information and business intelligence software, the large coffee company can then predict which purchases and offers a single customer is likely to be interested in. The company informs customers of the offers that it believes they want to use on mobile devices. With this system, Starbucks can attract existing customers to its branches more often and increase sales volume. In this function, BI is used in a similar way to conventional CRM systems. In fact, many companies choose to combine BI and CRM systems to get the most out of their data.  SKF is a global manufacturer and supplier SKF is a global manufacturer and supplier of bearings, seals, mechatronics, and lubrication systems. Based in Sweden, the company is represented in more than 130 countries worldwide and has approximately 17,000 distributor locations. As SKF has such broad geographic coverage and product diversity, they need to constantly forecast market size and product demand to adjust their manufacturing. 36 Business Intelligence Traditionally, SKF analysts — like so many analysts — created and maintained those forecasts in complex Excel files. However, the overhead of maintaining and reconciling disparate analyses can be overwhelming. SKF often needed days to produce a simple demand forecast. By centralizing their data assets into a single system, SFK was quickly able to start sharing their data and analyses between a number of different departments within the organization — including sales, manufacturing planning, application engineering, business development, and management. As they produce a large number of product variants, they are now able to quickly aggregate demand forecasts, no longer needing to debate data integrity between departments. This allows management to efficiently plan their future manufacturing.  Amazon Last but not least, the online retail giant Amazon is one of the companies that use BI. Similar to Starbucks, Amazon uses business intelligence technology to personalize product recommendations and market products, but also uses its BI software tools for logistical business decisions. An in-depth data analysis enables the massive supply chain of Amazon to run smoothly. From optimizing shipping routes to distributing inventory to the warehouse, data and BI tools impact virtually every step of Amazon's delivery process. 3.2 Design a business intelligence tool, application or interface that can perform a specific task to support decision making at the selected organization 3.2.1 About the Tool Dilmah's customized BI tool combines BI, planning, forecasting and advanced analysis functions in a simple cloud environment. Based on AI technologies and an in-memory database, it is one of the most advanced analytics solutions currently available. This BI tool serves as a competitive advantage for the company. With this tool, the company may be able to:  To predictive analysis and forecast the future trends related to the particular functions.  Make end-to-end decisions with data management and analysis in one place  Scale to meet business and diverse user needs across all decision types (strategic, operational, and tactical). 37 Business Intelligence If the employee is new to the company, then he/she needs to fill the details in-order to sign-up for the system. Here the employees are needed to fill their personal data as required in the space provided and then by clicking the sign-up button can get their user’s name and password validate to enter into the system to continue their work. 40 Business Intelligence Figure 14: Account Registration - Interface This is the home page of the BI Tool. Here the short description of the Dilmah Company has been provided and in the top part interesting stories regarding Dilmah such as Family Passionate, We are, We believe and etc., has been provided in short boxes and by clicking each topic the employees will be directed to the particular page which explains the certain things. 41 Business Intelligence Figure 15: Home Page- Interface 3.2.2.2 Training and Development Process Once the employee gets into the Training and Development portal the dashboard will be displayed. In this dashboard the details related to the T&D functions will be displayed in widgets. In the widgets details like Gender analysis on training programmes, Training trends at the company will be displayed in graphs and charts format. Lower-Level Management 42 Business Intelligence Figure 16: Training and Development Dashboard Figure 17: Lower Management Interface - T&D 3.3 Discuss the importance and the impact of business intelligence tools and technologies that can be used by the organization for effective decision making within the legal/ regulatory context of the organization  Enhancing Inclusive Working Culture In 2021 company will focus on enhancing the capabilities of both the management and operational teams, with focus on leadership skills and operational excellence. Company will also conduct numerous engagement initiatives targeted towards embedding the Living Values to the organizational culture. Emphasis was also placed on strengthening the data analytical capabilities with the recruitment of several data scientists. The tool will help the HR management to keep the records of all the employees of the company including their needs and wants along with their qualifications as well. In addition, the BI tool of the company will also maintain the past record of the training held and their feedbacks as well. Also, the performance management records maintained in the tool will help the mangers to design the training programme to improve the human capital.  Widening the Network The company is planning to expand the network with suppliers. During the year the company has initiated valuing the social accountability through SMETA which is the SEDEX standards for labour standards, health and safety practices, environmental practices and business ethics. The BI tool will help the company in analysing the possible suppliers and scan the details of each suppliers and will choose the right supplier for the company and will prepare the code of ethics for the suppliers and will help to maintain the contracts and terms based on the yearly basis.  Introduction of New products The company is being spending around 40 million for the R&D to introduce new flavours of tea which will allow for a further reduction in prices given the cost advantage compared to relying on imported cones. The Dilmah can use their BI Tool to record the internal, external and customer requirement analysis done by their operative heads and then the BI Tool will produce the budget for the implementation of the new product with all the findings and record which will help the management to allocate the financial resources. The tool will assist the top management 45 Business Intelligence in devising the strategies for the development of product and will help in the promotional activities to introduce the new product to the market.  Attaining the SDG Goals for preserving the environment The Dilmah Company mainly concerns on sustainable production process rather than concerning more on profit making. In the sustainable production the company is more intended in concerning the Environment and making a carbon free production process. In this aspect the BI Tool help the company in analyzing their energy consumption and also the tool calculates the carbon dioxide emission of the Dilmah and help the company in reducing their wastages and help the company in maintain the eco-friendly practices at the workplace. 3.4 Identify new Business Intelligence trends and technologies that can be further enhance in the selected organizational context 1. Mobile BI The definition of mobile BI refers to the access and use of information about mobile devices. With the increasing use of mobile devices for business - not just in leadership positions - Mobile BI can bring business intelligence and analytics closer to the user if done properly. Whether during a train journey, in the departure hall of the airport or during a break in the meeting - with Mobile BI, information can be consumed almost anywhere and at any time. Mobile BI - driven by the success of mobile devices - was seen by many as a big wave in BI and analytics a few years ago. The market is disillusioned nowadays, and users attach much less importance to this trend (BI Survey, 2021). In the Dilmah Company the Mobile BI will help in the following ways: The first big advantage is the ability for end users to access information in their mobile BI system anytime, anywhere. This enables them to access data and analytics in “real time,” which improves their day-to-day operations and means they can respond more quickly to a wider range of events. The integration of mobile BI functions into operational business processes increases the penetration of BI within organizations and often brings advantages in the form of additional information. This speed up the decision-making process by expanding information and reducing the time spent searching for relevant information. This real-time access to data improves operational efficiency and enforces organizational collaboration. 46 Business Intelligence Overall, Mobile BI ensures a higher availability of information, a faster response speed and more efficient work, as well as an improvement in internal communication and a shortening of work processes. By providing suitable mobile applications for all users of mobile devices, information can be used by people who have not previously used BI systems. This in turn leads to a higher BI penetration rate within companies. 2. Artificial intelligence (AI) Artificial intelligence (AI) is the science aiming to make machines execute what is usually done by complex human intelligence (BI Survey, 2021). In Dilmah AI can be used as a BI solution with the upscaled insights capability. It basically fully analyzes company’s dataset automatically without needing an effort on employee end. Mangers simply choose the data source they want to analyze and the column/variable (for instance, revenue) that the algorithm should focus on. Then, calculations will be run and come back with growth/trends/forecast, value driver, key segments correlations, anomalies, and what-if analysis. That is an incredible time gain as what is usually handled by a data scientist will be performed by a tool, providing business users with access to high-quality insights and a better understanding of their information, even without a strong IT background. 3. Advanced and Predictive analytics Advanced analytics describes data analyses that go beyond simple mathematical calculations such as sums and averages or filtering and sorting. Advanced analysis uses mathematical and statistical formulas and algorithms to generate new information, recognize patterns, and predict results and their respective probabilities. Predictive Analytics is a subdivision of Advanced Analytics and focuses on the identification of future events and values with their respective probabilities. Advanced and predictive analytics can be applied to a variety of use cases, from classic customer value and success forecasts to preventing contract termination or price, sales and demand forecasts, to new tasks such as machine failure forecasting, social media monitoring and evaluation and proactive policing (BI Survey, 2021). Advanced analysis enables both "optimization" and "innovation". It can support the improvement of existing processes, for example in the form of more precise sales planning (and 47 Business Intelligence