Download business intelligence assignment btec hnd diploma and more Study Guides, Projects, Research Business Informatics in PDF only on Docsity!
Assignment of business intelligence
LO The definition of the term ‘Business Process’ and ‘Supporting Processes’ A business process is a set of linked tasks that find their end in providing services or products to customers. A business process has also been identified as a set of activities and tasks that, once completed, will accomplish the organization's goals. The process must involve clearly defined inputs and a single output. These inputs are made up of all factors that contribute (directly or indirectly) to the added value of the service or product. These factors can be categorized into management processes, operational processes and business process support. The management processes govern the activities of a specific organization. The operational processes form the core business. Supporting processes such as human resources and accounting are in place to support core business processes. There are three main types of business process as the following listed: Management processes – governing the operation of a system. Typical management processes include corporate governance and strategic management. Operational processes- forming the core business and create the main value stream. Typical operating processes are purchasing (invoice process, payment process, risk management process), production (product assembly process, quality assurance process, guarantee process maintenance / prevention.), marketing and sales. Supporting process- supporting the core processes. Examples include accounting, hiring (start-up process, release process, leave request) and technical support. examples for the term”business processes” and “supporting processes”: example of term business process
Figure 1 The example for the term 'Business Processes'- Hospital Management flow chart
- Step 1: Start the system.
- Step 2: The patient enters the ID and requests to enter the system.
- Step 3: The system will check the ID with the available database. Step 4: If the ID does not match, a message will be required to re-enter the ID or end the session. Step 5: End of the session.
- Step 3: If the ID matches, skip steps 4 and 5 and go to step 6.
- Step 6: Confirm that you have entered the correct ID, categorize the request and send it to the person responsible.
- Step 7: Who is responsible for multiplying system requests.
- Step 8: Check if the problem can be solved.
- Step 10: If possible, proceed and return the report. Then skip to step 11.
- Step 11: End the session example for the term 'supporting process'
customers larger companies, have more participants, and have a high organizational structure. A process diagram or work in logical linked steps The process can be manual or automated (with the help of the technology to help make it more accurate) Does not help decision making. Help make money decision and create the value for the customer It provides a clear and in- depth understanding of task positions that can be improved The basic components: 1.Database. 2.Models: •Behavioral model •Management science model. •Operation research model. All new employees to quickly speed up or find a level that’s suits their activity throughout the process Goal Help make decisions. Support border workers to make money. Generate cash and output value for customers. Ensure business resources in terms of quality and quantity. Improve customer satisfaction, agility to respond to market changes quickly. From raw materials like personal and business knowledge, => report making => help identity and solve problems. Provide a lot of information. => Help make optimal choices. Increase productivity, efficiency, with an optimal choice of technology, processes and investment planning or logistics segment. Figure 3 The key attribute and goal of the term ‘Business Process’ and ‘Supporting
Differentiate between unstructured and semi- structured data within
An organization there are three types of data structure that can be used in any organization and they are structure data, semi-structure and unstructured data type. Structure data type Structured data is the data that conforms to a data model, has a well-defined structure, follows a standard order, and a human or a computer program can easily access and use it. Generally structured data is stored in well-defined schemes like databases. Typically defining the attributes is tabular with columns and rows. Unstructured Data Unstructured data is the data that does not stick to a data model and does not have an easily identifiable structure, because of which a computer program cannot easily use it. Unstructured data is not predefined or has no predefined data model, so it is not a good fit for a traditional relational database. Characteristics of unstructured data The data does not belong to a data model nor does it have any structure. As in Databases, data cannot be contained in rows and columns. The data does not follow any logical rule. Data lacks any particular format or series. Sources of unstructured data Web pages Images (JPEG, GIF, PNG, etc.) Videos Memos Reports Word documents and PowerPoint presentations Surveys Advantages of unstructured data It supports data that does not have a correct format or sequence. Data are not limited by a set structure Data is portable. It is very scalable Disadvantages of unstructured data Due to lack of schema and structure, it is difficult to store and handle unstructured data. It is difficult to index the data and prone to error due to ambiguous structure and not having predefined attributes. So search results aren't very reliable. It is a difficult task to ensure data security Semi-Structured data type
3 Transaction Management In Semi Structured Data transaction is not by default but is get adapted from DBMS but data concurrency is not present. While in Unstructured Data no transaction management and no concurrency are present. 4 Versioning On other hand in case of Semi Structured Data versioning is done only where tuples or graph is possible as partial database is supported in case of Semi Structured Data. Versioning in case of Unstructured Data is possible only as on whole data as no support of database at all. 5 Flexible and Scalable While in case Semi Structured Data data is more flexible than Structured Data but less flexible and scalable as compare to Unstructured Data. As there is no dependency on any database so Unstructured Data is more flexible and scalable as compare to Structured and Semi Structured Data. 6 Performance On other hand in case of Semi Structured Data only queries over anonymous nodes are possible so its performance is lower than Structured Data but more than that of Unstructured Data While in case of Unstructured Data only textual query are possible so performance is lower than both Structured and Semi Structured Data.
LO
Figure Pyramid Diagram of Organizational levels and information requirements. (99, n.d.) The Figure 4, shown the various levels of a typical organization, basic on this pyramid diagram to compare the difference (includes: factor, task, type of decision, support) of three main levels of business organization, we collected the results shown as the following table: Operational management Tactical management: Strategic management Factor employee cashiers at a point of sale ,bank tellers ,nurses in a hospital ,custome r care staff,etc middle-level managers heads of departments supervisors etc most senior level in an organization,director Task conduct daily business transactions Control the operation of the operating level Long-term planning for organizations
transactions of the organization current performance status problems that are unique and change frequently techniques to solve common problems make decisions Decision Structured data, highly structured and routine Semi- structured decision Support of semi structured and unstructured decisions (structured decisions can be automated) There is no substitute effect, only nature supports professionals Support information and decision- making process Handlin g Manage operations using information and process them Routine algorithms (aggregate, compare and summarizes the results) Sophisticated mathematical models, statistical techniques (probability, predictive modelling, etc.) Human- controlled computer systems or programs Encapsulate company data and provide sales performance or statistics tables Input Information about daily transactions Information from output of TPS Internal systems (transaction processing systems, management information systems), external systems. Rules and data from an expert or through open questions Company data, sales performance, market research statistics Output The information is very detailed. (Input of MIS) Report (information) for tactical managers use to monitor, control and predict future performance (make the structured decision) Solutions are interactive Format to display in computers to be used (support for humans) Information inside and outside the company meets the organization's strategic objectives From the definitions and characteristics of the positions in a company above, we have drawn three main points:
Firstly, the action determines the highest employee frequency but only the decisions of activities that do not completely affect the project as well as the company (limited by the wrong decision leads to serious impacts on project and company). Next, the component decides the frequency of Staff Management is lower but their decision is based on the recommendations that have been selected by the employee and they need to make a decision based on their own capacity and take responsibility for Work results. The decision of the manager is bigger and more important, it can affect the project's performance and calculate the success or failure of the current project. In the end, the frequency components can at least make decisions but also the biggest influence that the Director. They were given the company's strategic plan based on efficiency and data from the lower divisions. Their decisions are often at the micro-level and have a decisive influence on the future direction of the company and the success or failure of a company. Based on three main point that we mentioned, we set out a chart to shown the frequency and influence of decision- making within the organization level. Figure 6 The frequency and influence of decision-making within the organization level. Conclusion To sum up, throughout the report we had a lot of in-depth knowledge within business intelligence fields. The different of the term Business Processes and Supporting Processes, as well as, the differences of the types of support available for business decision-making at varying levels within an organization. Conduct a small study on organizations that have used business intelligence tools to enhance or improve operations
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) 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.
- 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.
- 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.
- 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.
- 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.
- Text mining - involves extracting relevant patterns and deriving high quality information from text sources, which are then analysed by a BI program.
- 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.
- 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. 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). BI Tools used at Company 1.SAP Business Intelligence: Figure: SAP BI Tool 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.
Machine Learning: Maximize the impact of your business applications and drive your Intelligent Enterprise with powerful, advanced, and predictive analytics. MicroStrategy provides an extensive library of native analytical functions and scoring algorithms, along with an SDK to integrate with third-party and open source statistical and data mining products 3-Datapine: Datapine is an all-in-one BI platform that facilitates the complex process of data analytics even for non-technical users. Thanks to a comprehensive self-service analytics approach, datapine’s solution enables data analysts and business users alike to easily integrate different data sources, perform advanced data analysis, build interactive business dashboards and generate actionable business insights Figure: Datapine Features: Intuitive drag-and-drop interface: Simply drag your KPIs into the interface and see how your charts and graphs transform into a professional dashboard without any IT involvement or advanced coding. Easy-to-use predictive analytics: Advanced analytics features, including predictive analysis based on a forecast engine, where you simply select the KPI, determine the number of data points you want to forecast, specify the previous data points for the calculation, and finally define the model quality by appointing the desired confidence interval. Many interactive dashboard features: Dig deep into each part of the dashboard with numerous options and filters such as drill-downs, chart zooms, widget linking, hierarchical filters, among others, that will ensure a detailed data discovery process. 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- Excel Excel-based BI tools empower users with existing knowledge of Excel to view their data as dashboards and reports in spreadsheet format, just as in Excel, and share it with others while pulling data from multiple sources in real-time. These tools help them explore, visualize and analyze trends based on historical and current proprietary information to make data-driven decisions. The familiar Excel-based interface makes it easier to scale up in creating and editing reports. Organizations can save a tidy sum otherwise spent in training employees for a more complex BI tool. With a low-programming approach, these tools are made for swift user adoption and boost revenue by generating insights quicker Figure: excel pros and cons Data Connectivity: BI tools come with built-in data connectors to pull from a multitude of disparate data sources, from relational databases to files, to on premise and cloud-based data warehouses and business apps for 360-degree analysis. Data Visualization: With rich libraries that include charts, graphs and tables, and tool kits to interact with and manipulate data as necessary, BI tools empower users to visualize and analyse their data as they generate it. Faster Decision-Making: Users can share insight with others and collaborate on reports through comments and annotations within their business applications, which improves productivity and speeds up decision-making. They can also set real-time alerts when specific KPI values change beyond pre-defined specific values and quickly take action. Data Security: BI tools ensure data integrity and security through encryption, versioning, role-based permissions and granular access control at the row and column levels. Let’s face it – with data drawn from a multitude of disparate sources, data security isn’t exactly one of Excel’s strong points.
open up dashboards just about anywhere (thanks to this tool’s flexibility in accessibility (mobile, webpage, etc.) Figure: Yellowfin BI 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. 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. Figure: QlikSense 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. Develop any analytics users can imagine with a complete set of open APIs and bring them into any app, project, or process with powerful embedded analytics support. Easily combine SaaS, hybrid multi-cloud, and on premise deployment options with the industry’s only true multi-cloud architecture. BI tool BI Functionalities SAP BI Tool Analytics : The SAP BI tool presents the data that has been collected from various sources in a relevant graphs and chart formats. This will help the organization in analyzing the pattern and forecast the future trends. 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
