Download Assignment 2 for Business Intelligence - 1641 and more Assignments Business Informatics in PDF only on Docsity!
ASSIGNMENT 2 FRONT SHEET
Qualification BTEC Level 5 HND Diploma in Computing Unit number and title Unit 14: Business Intelligence Submission date Date Received 1st submission Re-submission Date Date Received 2nd submission Student Name Phan Minh Tri Student ID GCD Class GCD0904 Assessor name Phyo Min Tun Student declaration I certify that the assignment submission is entirely my own work and I fully understand the consequences of plagiarism. I understand that making a false declaration is a form of malpractice. Student’s signature Grading grid P 3 P 4 P5 P6 M3 M4 D3 D
Summative Feedback: Resubmission Feedback:
Grade: Assessor Signature: Date: IV Signature:
Table of Contents
- Chapter 1 – Present about Business Intelligence (P3)
- I. Business Intelligence (BI)
- Definition
- Examples of Business Intelligence on business
- II. Business Intelligence techniques.......................................................................................................................
- III. Business Intelligence tools
- problem-solving or decision-making at an advanced level (P4).................................................................................... Chapter 2 – Design a business intelligence tool, application or interface that can perform a specific task to support
- I. Scenario and application will be used
- II. Tableau for problem – solving
- III. Tableau for decision-making at advanced level
- Chapter 3 - Discuss how business intelligence tools can contribute to effective decision-making (P5)
- I. Business Intelligence tools can contribute to effective decision-making in our organization
- II. Examples of Business Intelligence tools’ contribution to effective decision-making in our organization
- Chapter 4 – Explore the legal issues involved in the secure exploitation of business intelligence tools (P6)
- References
- Figure 1: Tableau Table of Figures
- Figure 2: Oracle BI
- Figure 3: Microsoft Power BI
- Figure 4: Sales by car prices and manufacturer
- Figure 5: Sales by horsepower and manufacturer
- Figure 6: Sales by fuel capacity, fuel efficiency, and manufacturer
- Figure 7: Sales by average car price of manufacturer
- Figure 8: Sales by latest launch
- Figure 9: Sales by vehicle types
- Figure 10: Sales by car models
Chapter 1 – Present about Business Intelligence (P3)
I. Business Intelligence (BI)
1. Definition
❖ Business intelligence (BI) refers to the technology that allows firms to organize, analyze, and interpret business data from throughout the organization. BI encompasses a variety of tools and approaches for transforming raw data into useful and usable information. Business intelligence delivers data that enables businesses to make timely and educated choices. ❖ Business intelligence systems are composed of four major components:
- A data warehouse consolidates and makes available firm information from several sources.
- In a data warehouse, business analytics or data management technologies harvest and analyze data.
- Business Performance Management (BPM) tools track and assess progress toward corporate objectives.
- A user interface (often an interactive dashboard with data visualization and reporting features) allows users to quickly access information.
2. Examples of Business Intelligence on business
Many businesses utilize business intelligence (BI) to improve the effectiveness of quick, data-informed decision-making. Business intelligence is shown by using data to provide targeted adverts based on surfing behavior and providing relevant KPI data access to all workers. Here are some case studies that demonstrate how BI is helping businesses throughout the globe. ❖ Univision (An American Spanish-language, free-to-air television network.): BI Increases Market Spend Efficiency
- Challenge – Univision desired more access into company data to unify and concentrate on targeted advertising initiatives.
- Solution – Programmatic TV is a data-driven, automated technique to purchasing and delivering advertising against video content on television. Companies may get additional value from their programmatic advertising by using BI and data from apps like Facebook, Google Analytics, and Adobe Analytics. It comprises advertisements provided on the web, mobile devices, and linked televisions.
- Results – After using business intelligence, Univision increased its yield by 80% in the first quarter. ❖ New York Shipping Exchange (NYSHEX is a shipping-technology business that is striving to enhance the shipping process.): BI Reduces IT Dependency
- Solution – Management saw the necessity for a business intelligence system to act as a single source of accurate information. Maintaining the system is simpler than having to handle everything using Excel, and staff no longer must depend on obsolete spreadsheets and can access simple-to-understand data and dashboards.
- Results – SFK was able to swiftly communicate data and analytics across departments by centralizing data assets into a single system, including sales, manufacturing planning, application engineering, business development, and management. SKF has enhanced the planning process by combining demand projections from many divisions. II. Business Intelligence techniques ❖ Data Visualization – Data represented as a set or matrix of numbers is accurate but difficult to read. For example, are revenues increasing, decreasing, or remaining constant? This gets significantly more difficult when considering more than one dimension of the data. As a result, visualizing data in charts is a quick approach to grasp how to interpret the data. ❖ Data Mining – Data mining is a computer-aided process for discovering previously undiscovered or undetected relationships between data elements. From shopping basket analysis to fraud detection, data mining methods are employed in a variety of applications. Analyzing complications and/or frequent illnesses in medicine and health may assist to limit the danger of cross infection. ❖ Reporting – BI tools aid business users in the design, scheduling, and creation of performance, sales, reconciliation, and savings reports. BI tool reports effectively collect and show information to aid management, planning, and decision making. Once built, the report may be automatically delivered to a predetermined distribution list in the format requested, providing daily/weekly/monthly data. ❖ Time-series Analysis Including (Predictive Techniques) – Business intelligence solutions let users plan, schedule, and create performance, sales, reconciliation, and savings reports. BI tool reports efficiently gather and display data to help in management, planning, and decision making. Once created, the report may be provided automatically to a predefined distribution list in the format chosen, delivering daily/weekly/monthly statistics. ❖ On-Line Analytical Processing (OLAP) – Drill-up, drill-down, and drill-across functionalities allow users to move across OLAP cubes. The drill-up feature allows the user to effortlessly zoom out to finer-grained information. Drilling down, on the other hand, reveals the information in more depth. Every feature is available in real time. ❖ Statistical Analysis – Statistical analysis use mathematical underpinnings to assess the importance and reliability of observed relationships. The most intriguing aspects are distribution analysis and confidence intervals (for example for changes in user behaviors, etc.). Statistical analysis is used to create and analyze data mining findings.
III. Business Intelligence tools ❖ Tableau – A Business Intelligence application that specializes in data discovery and visualization. Tableau allows you to effortlessly analyze, visualize, and share data without requiring IT intervention. Tableau works with a variety of data sources, including Microsoft Excel, Oracle, MS SQL, Google Analytics, and Salesforce. Figure 1 : Tableau ❖ Oracle BI – A business intelligence technology and application suite. This technology provides customers with almost all business intelligence features, including dashboards, proactive intelligence, ad hoc reporting, and more. Oracle is also ideal for businesses that need to analyze enormous amounts of data (from both Oracle and non-Oracle sources), since it is a highly resilient solution. Other major features include data archiving, versioning, a self-service portal, and alerts/notifications. Figure 2 : Oracle BI
II. Tableau for problem – solving ❖ Democratize data insights with dashboards – The dashboard is a well-known BI application in which data is gathered from many sources and graphically displayed in charts and graphs. Tableau has a plethora of workbook capabilities that allow users to quickly construct well-designed interactive dashboards. It may also link to several data sources (e.g., Excel spreadsheets, Amazon Redshift etc.). ❖ Tell data stories with advanced data visualization – Tableau users may create a visual narrative by connecting a sequence of visuals (including dashboards). Tableau distinguishes itself from competing programs like Excel by its ability to integrate complex graphics into a cohesive data story. These data tales are very successful in framing a compelling case for communicating actionable insights to decision-makers. ❖ Extract data insights with no coding skills required – Tableau is a data management program that enables both technical and non-technical analysts to rapidly create data visuals and analysis. The drag-and-drop interface makes it simple to answer complicated data-related issues without programming knowledge. Tableau also provides a series of certifications to help analysts evaluate and demonstrate their product knowledge and data visualization abilities. III. Tableau for decision-making at advanced level ❖ Because our Car Auto company is still small, there is no data department, and our team lacks the technical skills required to utilize Python for data visualization, thus we rely on Tableau for such jobs. We may change a dull sales data sheet into live charts in the following example by using drag and drop. Furthermore, based on sales data combined with models, manufacturers, and car specifications to design live charts to assist our Board of Directors (Strategic level) in providing efficient strategy such as promoting car inventory management department to import popular car models, car manufacturer, and car specifications or assigning tasks to our marketing department (including tactical and operational level) to find potential customer sets who are able to purchase car based on characteristics of car.
Figure 4 : Sales by car prices and manufacturer Figure 5 : Sales by horsepower and manufacturer
Figure 8 : Sales by latest launch Figure 9 : Sales by vehicle types
Figure 10 : Sales by car models
Chapter 3 - Discuss how business intelligence tools can contribute to
effective decision-making (P5)
I. Business Intelligence tools can contribute to effective decision-making in our organization ❖ Data is accessible across fundamental company activities, including industry trends, consumer behavior, productivity, inventory, and extensive financial analysis. Executives, CFOs, branch managers, and our sales staff have instant access to critical information, allowing them to make informed choices quickly. Business intelligence software gathers information and translates it into actionable and strategic insights, allowing our organization to easily accomplish its objectives.
- Better financial decision – Phocas' Financial Statements will enable our company to dig down to individual transactions and obtain fast answers to revenue potential and cost problems. Our firm may make judgments based on the company's future financial situation by analyzing incoming and outgoing cash from the present and past. Customizing the dashboard enables executives to monitor key performance indicators (KPIs) for better financial supervision and management.
comprehensible data, making it considerably more useful to hackers. Those that use the BI technique in their operations are more aware of their data.
- Mobile Malware – Security specialists have identified mobile device security concerns in the early phases of internet access. The minimal unfair play of mobile phones has bothered customers considerably less than it should have. Given our dependency on mobile phones and the few focused crooks, this offers a severe danger.
- Third-party Entry – Cybercriminals seek the route of least resistance. The target is the poster child for a large network attack from third-party access points.
- Social Engineering – Cybercriminals are aware that shelf-life intrusion methods have shifted to dependable non-technical spoof social engineering approaches that rely on social contact and psychological manipulation to get sensitive data. This kind of incursion is both unexpected and effective.
- Corporate Data on Personal Devices – Whether or whether a corporation distributes corporate phones, confidential information is always available on mobile PCs. Mobile management technologies exist to limit functionality, but many enterprises do not prioritize securing the gaps.
- Neglecting Proper Configuration – Big data technologies can be adapted to an organization's requirements. Companies continue to disregard the need of correctly establishing security settings.
- Lack of Encryption – Few firms have considered protecting secret business data in transit and at rest, despite its effectiveness.
- Outdated Security Software – Updating security software is an important practice in technology management and a necessary step in securing huge data. The software is intended to defend against known risks. This guarantees that no new harmful code enters an outdated version of the security application.
- Inadequate Security Technology – Investing in software that monitors network security is a growing trend in the business sector. When an intrusion attempt is detected, the application is set to send out alerts. However, alerts are only useful if someone is willing to analyze them. When technology is designed to be a regulated tool, businesses depend on it much too much to adequately protect themselves against threats.
- Technology with Weak Security – Every day, new technology is launched. Most new devices have some type of Internet connectivity, but no security strategy. This creates a significant risk: each unprotected link suggests vulnerability.
- Social Media Attacks – Cybercriminals utilize social media to distribute a dynamic geographical attack dubbed "water holing" as a platform. The attackers identify and infect a website cluster that they believe targeted organization members would visit.
- Data Security Issues Involved in the Organization – The author investigates the legal and security issues that may be involved in the business's facilities. The damage to information security might vary from minor losses to the entire destruction of the information system. Organizations are still striving to spot risks to their data assets and develop methods to combat them. ❖ Security stores a large amount of data, including firewall logs, IDS events, and policy exceptions. Historically, most security choices were based on intuition; they were rough estimates of how much it would cost to secure the firm. One method for developing a security BI is to establish a "criticality panel" that prioritizes the dangers you must manage. To get the intended outcomes, a substantial amount of fat in the elbow is necessary. ❖ For numerous years, several types of legal concerns have been considered. The following are some of the legal issues that arise while using business intelligence technologies safely.
- Confidentiality – Outsourcing deals might contain BI specifics and private data context knowledge. It should also be determined who owns the secret information.
- Software Rights Management – To utilize BI / BA solutions, both specialists and consumers must ensure that they have the permitted alternative. This comprises a product permit analysis at whichever stage seller control software and BI / BA devices are employed for the two meetings.
- Trade secrets – Security and survival. As competitive advancements, BI / BA research experiences and procedural enhancements should be preserved. To end the non-revelation period by sharing privileged insights, non-divulgence agreements should separate private data from the exchange of insider knowledge.
- Knowing what is going on with members allows all authorities and directors to effectively manage and grow a firm. Rotting dissatisfaction and multiple difficulties will result in insecurity, high turnover, and substantial, both immediate and indirect, expenses. Furthermore, ignoring representation concerns will lead to legal issues soon.
- Legal departments have recovered from handling legal matters via their law offices. Goal information is essential to organize prices as they coordinate more inventive alternative expenditure game plans to estimate and manage costs. Law firms may also use notable BI to evaluate elements like as changes in their documented charge rates, hours worked, and so on.
- A digital security viewpoint that includes both the leaders' digital security and Business Intelligence allows bosses and owners to see the InfoSec issue in real time. It may also aid cybersecurity specialists in acquiring the assets required to provide genuine protection to the firm. It is almost impossible for directors and owners to ignore the admonitions supplied by displaying icy, harsh information without looking indiscreet.
