Unit-14 Business Intelligence assignment 1, Assignments of Business Informatics

Download Unit-14 Business Intelligence assignment 1 and more Assignments Business Informatics in PDF only on Docsity!

Assignment On Business Intelligence

Submitted By: Shantanu Adhikary

Submitted To: Sabrina Hossain Mou

Program: HND in CSD

ID: 2019141004

Date: 17/12/

Contents

Introduction: ................................................................................................................................................. 3 P1: Examine, using examples, the terms ‘Business Process’ and ‘Supporting Processes’. ........................... 4 P2: Compare the types of support available for business decision-making at varying levels within an organization. ................................................................................................................................................. 8 P3: Determine with examples what business intelligence is and the tools and techniques associated with it. ................................................................................................................................................................. 11 P4: Design a business intelligence tool, application or interface that can perform a specific task to support problem-solving or decision making at an advance level. ............................................................ 14 P5: Discuss how business Intelligence tools can contribute to effective decision making. ....................... 18 P6: Explore the legal issues involved in the secure exploitation of business intelligence tools. ................ 20 Referencing: ................................................................................................................................................ 23

P1: Examine, using examples, the terms ‘Business Process’ and

‘Supporting Processes’.

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 processing (OLAP), Digital dashboards, Data mining etc. A business process is a system in which certain set of rules are defined and a method to run a business is to be followed in order to achieve the defined goals. A business process is an operation or collection of activities that can accomplish a particular organizational objective. Business process management refers to a specialized business process improvement information system by measuring, tracking and analyzing process performance against strategic objectives. Business process management is an application of business intelligence. Examples of Business processes are: Invoicing, Shipping products, receiving orders, Updating personnel data, determining marketing and other budgets.

The business process can be described in three categories: • Operational Process • Process Supporting • Management Process.  Operational Process: This process can also be defined as a primary process. The process that make up the organization's core business and build the primary value flow. Example: One example for operational process in “SAP SE” multinational software and IT Corporation is this process carries out the tasks of sales, purchasing, marketing department of this company. Evaluate Inputs and Outputs Data and resources used by humans to manufacture specific products that are designed to meet customer’s needs. Input elements are the raw materials such as work items, energy, human labor etc. And the outputs elements are finished goods which have been manufactured from the factory and the product that the customer needs. This production or conversion is called the input output device transformation. Asking for Feedback Feedback is important for operational process. It can come from internal as well as from external sources. External sources include monitoring assessment and continuous improvement of goods and services and external sources include those offering end- customer products or services as well as customer feedback. Feedback information is used to control the operational process by adjusting the inputs and processes used to obtain desired outputs. Make our process analysis Analysis of business processes is a method of analysis that helps to increase system efficiency and effectiveness. This determines how well the end goal of the operational process is accomplished. Business process analysis identifies and examines every part of the structure including the process itself the participating parties the information exchange and others. Analyze the Results Analyzing the results is carried out with the purpose of understanding and improving organizational processes. Using different mathematical models quantitative analyzes and logical reasoning techniques organizational analysis attempts to assess whether each part of the organization is effectively contributing to overall success and company strategy growth.

Organizing Organizing involves deciding how to organize and manage tasks and services. The organization can also be characterized as a deliberately formalized position structure or positions for individuals to fill in an organization. Organizing creates a relationship structure in an organization, and future plans are followed through these organized relationships. Directing The ability to influence people for a specific purpose and intention is directing. Directing is considered by all managerial practices to be the most critical and demanding. Directing drives or encourages the organization's leader to work with the organization's interest. Directing is to create a positive attitude towards the work and goals among the organization's employees by changing their behavior. Controlling Controlling is called tracking the progress of the company towards achieving the goal. To ensure the achievement of the organizational goal, monitoring progress is important. Controlling is evaluating, and correcting the organizational practices that are carried out to achieve the goals or targets. Control tasks usually relate to calculating success or consequences of actions taken to achieve the goal.

P2: Compare the types of support available for business decision-making

at varying levels within an organization.

To be successful in business today companies need to be able to support their managers and business professionals varied knowledge and decision-making needs. Web, internets and other web-enabled information systems have been instrumental in promoting the role that is played in supporting the decision-making activities of all managers and knowledge workers in industry. Organizational decision-making process is essential to high quality and transparent decisions otherwise a business will not run smoothly. Business decision making is very important and it is also very complex. In an organization employees at all levels across all departments make decisions. In an organization various decisions are taken some decision relate to the evaluation of investments the allocation of resources or the evaluation of fusions and acquisition proposals while others relate to the introduction of new products the study of their shelf-life or the improvement of production efficiency. For an organization the decisions can be classified into three types they are:

**- Strategic Decisions

• Tactical Decisions
• Operational Decisions**  Strategic Decision: Strategic decisions involve careful analysis of the situation and consequences. Generally it is taken by the top level employees. Strategic decisions are not related to an organization's general operation they are non-repetitive in nature and require a great deal of time to be made. Strategic decision for “SAP SE” multinational software and IT corporation includes include priorities, goals setting and forecasting for the future, global diversification.  Tactical Decisions: Tactical decisions are taken more frequently. Tactical decision for “SAP SE” multinational software and IT Corporation includes Change product pricing, Reschedule work, Reorganize a department. It helps the company to gain competitive advantage. The impact of these types of decisions on the organization is of a medium risk nature.

Figure: Decision taking pyramid

P3: Determine with examples what business intelligence is and the tools and

techniques associated with it.

The process and technical infrastructure that gathers stores and analyzes the data generated by the activities of an organization is called the business intelligence. Business Intelligence is broad term covering data mining, system analysis, benchmarking of results, and descriptive analytics. Business Intelligence analyzes all the data generated by an organization and provides easy-to- digest reports, quality metrics and trends that guide management decisions. Business Intelligence helps in the fields of consumer identification, customer support, market research, market segmentation, brand productivity, statistical analysis, and stock and distribution analysis. For the transformation of raw data into meaningful and actionable information for Business analysis some tools and techniques are used in business intelligence. Business Intelligence Tools:  SAP Business Intelligence: SAP Business Intelligence provides many advanced analytics tools including predictive analytics for real-time BI, machine learning, and planning and evaluation. SAP is a versatile application for all functions and provides lots of functionality in one system. Example: SAP SE uses SAP Business Intelligence tools for predictive analysis and also planning and evaluation for their company.  MicroStartegy: MicroStrategy is a business intelligence platform that provides powerful dash boarding and data analysis that help track trends, identify new opportunities, improve productivity, and more. Whether the incoming data is from a spreadsheet, cloud-based or business information technology, users may connect to one or several sources. Example: SAP SE uses MicroStrategy business intelligence platform to provides powerful dash boarding and data analysis for their company.

 OLAP: Online analytical processing is a technique for solving various dimensional analytical problems. OLAP's most important value is its multidimensional nature, which allows users to identify issues from various perspectives. OLAP can be used to complete tasks such as budgeting, analysis of CRM data and financial forecasting. Example: SAP SE uses online analytical processing for solving various dimensional analytical problems for their company.  Data Mining: Data mining is a technique to find patterns in huge datasets and often incorporates database systems, statistics, and machine learning to find patterns. Data mining is an essential data management system as well as data pre-processing since it ensures sufficient data structuring. Data mining could also be used by end users to create models that expose these patterns. Example: SAP SE uses data mining technique to find patterns from huge datasets of their company.  Model Visualization: The model visualization technique is used to turn the discovered facts into histograms, maps, graphs and other visuals that allow the insights to be properly interpreted. Example: SAP SE uses model visualization technique to turn the discovered facts of their company into histograms, maps, graphs and other visuals.

P4: Design a business intelligence tool, application or interface that can

perform a specific task to support problem-solving or decision making at

an advance level.

I have created an e-commerce website for Daily Bazaar. Here I have converted the data into visual information using charts. I also customize the design to ensure that it is user-friendly and has a functional interface. On the left hand side it is the logo of my website Daily Bazaar. On the right hand side it is the banner of my website Daily Bazaar. And in the down below it is the toolbar of Daily Bazaar website.

Bar Chart The figure on the above is a bar chart. A bar chart presents categorical information with heights or lengths of rectangular bars equal to the values they represent. Using bars of various heights or lengths a bar chart is used to visually represent data. Data is either horizontally or vertically graphed enabling viewers to quickly and easily compare different values and draw conclusions. From the bar chart we can see the most produced product of Daily Bazaar in a year is Potato and Minicate rice. 0 2 4 6 8 10 12 14 16 18

Yearly Production of Products

Line Chart The figure on the above shows the line chart. Line chart is also called line graph. A line chart is a graphical representation of the data with a sequence of lines. This is a graph which connects individual data points using lines that represent quantitative values over a specified time interval. Line charts show lines running horizontally across the chart with the values axis shown on the chart's left side. From the line chart we can see that the most sold products of Daily Bazaar per year. It can be seen that potato and minicate rice is the most sold product in a year. Broo ke Bond Taaza Tea Bag… Pepsi Diet Pet ( ml) Aaro ng UHT Low Fat Mil… ACI Pure Prem ium Katar ibh… Aaro ng Dairy Sprea d Che… Lave nder Brea d (600g ) Ahm ed Corn Flour Powd er… Aaro ng Dairy Laba n( 0ml) Deshi Mosh ur Dal(P remi um… Moo gh Dal Prem ium Bul… Najir Rice Prem ium 5kg Pack Minic ate Rice Prem ium (1kg) Begu n Brinj al Gree n… Potat o Seas onal (1kg) Hilsh a Fish( 700g +) Broil er Chick en with Ski… Sales 5 12 8 2 5 4 2 4 5 5 4 14 5 16 3 6 0 2 4 6 8 10 12 14 16 18 Yearly Sales of Products

Sales