1
Higher Nationals in Computing
Business Intelligence
ASSIGNMENT
No.1
Learner’s name: CAO MINH HOANG
Assessor name: NGUYEN XUAN SAM
Class: GCS0804B
Learner’s ID: GCS190814
Subject’s ID: 1641
Assignment due: Assignment submitted:
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Guidelines and tips
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
business intelligence, Essays (university) of Interface between Computer Science and Economics
assignment 1 business intelligence
Typology: Essays (university)
2020/2021
1 / 23
This page cannot be seen from the preview
Don't miss anything!
Related documents
Partial preview of the text
Download business intelligence and more Essays (university) Interface between Computer Science and Economics in PDF only on Docsity!
Higher Nationals in Computing
Business Intelligence
ASSIGNMENT
No. 1
Learner’s name: CAO MINH HOANG
Assessor name: NGUYEN XUAN SAM
Class: GCS080 4 B
Learner’s ID: GCS
Subject’s ID: 1641
Assignment due: Assignment submitted:
ASSIGNMENT 1 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 Student ID Class Assessor name 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 P1 P2 M1 M2 D1 D
Assessment Brief
Student Name/ID Number Unit Number and Title 14: Business Intelligence Academic Year 2019- Unit Tutor Assignment Number & Title Assignment 1 : Discover business process and BI technologies Issue Date Submission Date IV Name & Date Submission Format The submission is in the form of a Microsoft® PowerPoint® style presentation to be presented to your colleagues. The presentation can include links to performance data with additional speaker notes and a bibliography using the Harvard referencing system. The presentation slides for the findings should be submitted with speaker notes as one copy. You are required to make effective use of headings, bullet points and subsections, as appropriate. Your research should be referenced using the Harvard referencing system. The recommended word limit is 500 words, including speaker notes, although you will not be penalised for exceeding the total word limit.
Unit Learning Outcomes LO1 Discuss business processes and the mechanisms used to support business decision-making. LO2 Compare the tools and technologies associated with business intelligence functionality Assignment Brief Your company is currently working in [Assumed Domain] for 2 years. For a new, young company, the competition in the market is very high. Therefore, the Board of Director has decided to apply Business Intelligence to improve the company business process by making better decisions. The Board of Directors assigns a small group including you in Research & Development Department to study business intelligence to apply for the company in the coming years. You need to research about business processes and decision support processes in the company and identify the types of data (unstructured, semi-structured or structured) generated by these processes with examples. You also need to research about current software used in the business process or decision support process and evaluate these usages (benefits and drawbacks). Next you need to understand the types of support for decision-making at different levels (operational, tactical and strategic) within the company and study which business intelligence features can help on that types of support. Study the information systems or technologies (of BI) can be used in this case, compare and contrast them to conclude which should be used. Your group needs to present the research results to the board in a presentation of 30 minutes.
Table Of Content
- Introduction................................................................................................................................................
- Business processes and the mechanisms used to support business decision-making...............................
- 2.1. Examine, using examples, the terms ‘Business Process’ and ‘Supporting Processes’.....................
- 2.2. Differentiate between unstructured and semi-structured data within an organisation..............
- Compare the tools and technologies associated with business intelligence functionality......................
- 3.1. The tools and technologies associated with business intelligence functionality..........................
- 3.2. Levels of Management Decision Making.......................................................................................
- organization.......................................................................................................................................... 3.3. Compare the types of support available for business decision-making at varying levels within an
- 3.4. Justify, with specific examples, the key features of business intelligence functionality...............
- Conclusion.................................................................................................................................................
- References.................................................................................................................................................
- Figure 1 Business process(source : reshcodeit)..................................................................................... List Of Figure
- Figure 2 Oracle BI (source : mopinion)................................................................................................
- Figure 3 Microsoft Power BI (source : mopinion)................................................................................
- Figure 4 Tableau (source : mopinion)..................................................................................................
- Figure 5 Domo (source : mopinion).....................................................................................................
- Figure 6 Levels of Management Decision Making (source : researchgate).........................................
- Table 1 Difference between structured, unstructured and semi-structured data............................. List Of Table
1. Introduction This report focuses on business terms: 'Business Process' and 'Supporting Processes'. Give definitions and comparisons between unstructured and semi-structured data. Introduction to some of the tools and technologies related to business intelligence functions.Compare the types of support available for business decision-making at varying levels within an organization.Justify, with specific examples, the key features of business intelligence functionality. The report divided into two main points, includes: -Business processes and the mechanisms used to support business decision-making -Compare the tools and technologies associated with business intelligence functionality 2. Business processes and the mechanisms used to support business decision-making 2.1.Examine, using examples, the terms ‘Business Process’ and ‘Supporting Processes’.
2.1.1. Business process
A business process is a series of steps performed by a group of stakeholders to achieve a concrete goal. Each step in a business process denotes a task that is assigned to a participant. It is the fundamental building block for several related ideas such as business process management, process automation, etc (Kissflow , 2021 ). A business process includes at least one of, but not limited to, the following elements: -Task/ Activity -System -Employee(s) -Workflow
Step 5: Implement the process Start running the process in a live environment. Properly communicate and train all stakeholders (Kissflow. 2021 ). Step 6: Monitor the results Review the process and analyze its patterns. Document the process history (Kissflow. 2021 ). Step 7: Repeat If the process is able to achieve the goals set for it, replicate it for future processes (Kissflow. 2021 ). Examples of Business Processes Processes vary depending upon the type, industry, location, etc., of a business, but there are a few processes that are practiced across all these segments of businesses around the globe. To make this easy to understand, we will look at examples of such processes (Gaikwad, M , 2021 ). Sales process Making a sale is a fundamental business process across various industries, offerings, and other segments. The common process observed by most businesses involves the following steps: -Sharing the sales proposal -Sending quotes -Negotiations -Receiving orders for product/service -Updating records of sales -Delivery of product/service -Billing -Payment These are repetitive steps and the workflow and structure of the process are flexible based on the business. Customer service Customer service is another important process that is a part of global business operations. It involves the following steps: -Receive customer complaints/issues through CRM
-Acknowledge the customer concern -Login details of the issue in the CRM system -Resolve the issue -Communicate status to customer A few more examples of business processes are: -Recruitment process -Invoicing process -Order processing -Customer onboarding process -Accounting process -Market research process -Product development process
2.1.2. Supporting process
Supporting processes are those processes that support the core processes. In the manufacturing example, a supporting process might be to recruit production staff. There may also be sub processes, decisions and activities(Wilmington, 2019 ). For instance, support processes include: -Human Resource Management -Financial Management processes -Building and property management, cleaning and maintenance, Facility management -IT processes -Procurement and sourcing processes (supplier selection processes, purchasing services, purchasing materials, sourcing human and financial resources, etc.) -Vendor Management processes
The relational model of structured data utilizes memory since it minimizes data redundancy. However, this also means that structured data is more inter-dependent and less flexible. Now let’s look at more examples of structured data.Example: Relational data(Marr, B., 2019 ).
2.2.2. Unstructured Data
Unstructured data is defined as data present in absolute raw form. This data is difficult to process due to its complex arrangement and formatting. Unstructured data management may take data from many forms, including social media posts, chats, satellite imagery, IoT sensor data, emails, and presentations, to organize it in a logical, predefined manner. In contrast, the meaning of structured data is data that follows pre-defined data models and is easy to analyze. Structured data examples would include alphabetically arranged names of customers and properly organized credit card numbers. After understanding the definition of unstructured data, let’s look at some examples.Example: Word, PDF, Text, Media logs(Marr, B., 2019 ).
2.2.3. Semi-structured data
Semi-structured data is information that does not reside in a relational database but that has some organizational properties that make it easier to analyze. With some processes, you can store them in the relation database (it could be very hard for some kind of semi-structured data), but Semi-structured exist to ease space. Example: XML data(Marr, B., 2019 ).
2.2.4. Difference between structured, unstructured and semi-structured data
Table 1 Difference between structured, unstructured and semi-structured data Properties Structured data Semi-structured data Unstructured data Technology It is based on Relational database table It is based on XML/RDF(Resource Description Framework). It is based on character and binary data Transaction management Matured transaction and various concurrency techniques Transaction is adapted from DBMS not matured No transaction management and no concurrency Version management Versioning over tuples,row,tables Versioning over tuples or graph is possible Versioned as a whole
Properties Structured data Semi-structured data Unstructured data Flexibility It is schema dependent and less flexible It is more flexible than structured data but less flexible than unstructured data It is more flexible and there is absence of schema Scalability It is very difficult to scale DB schema It’s scaling is simpler than structured data It is more scalable. Robustness Very robust New technology, not very spread
Query performance Structured query allow complex joining Queries over anonymous nodes are possible Only textual queries are possible
3. Compare the tools and technologies associated with business intelligence functionality 3.1.The tools and technologies associated with business intelligence functionality
3.1.1. Why use business intelligence tools?
For starters, data discovery, which used to be limited to the expertise of advanced analytics specialists, is now something everyone can do using these tools. And not only that, these tools give you the insights you need to achieve things like growth, resolve issues that are urgent, collect all your data in one place, forecast future outcomes and so much more (Haije, E. and Haije, E., 2021 ).
Figure 3 Microsoft Power BI (source : mopinion) Microsoft Power BI is a web-based business analytics tool suite which excels in data visualisation. It allows users to identify trends in real-time and has brand new connectors that allow you to up your game in campaigns. Because it’s web-based, Microsoft Power BI can be accessed from pretty much anywhere. This software also allows users to integrate their apps and deliver reports and real-time dashboards (Haije, E. and Haije, E., 2021.). Website: www.powerbi.microsoft.com Tableau
Figure 4 Tableau (source : mopinion) Tableau is a Business Intelligence tool specialised in data discovery and data visualisation. With the software you can easily analyse, visualise and share data, without IT having to intervene. Tableau supports multiple data sources such as MS Excel, Oracle, MS SQL, Google Analytics and SalesForce. Users will gain access to well-designed dashboards that are very easy to use. Additionally Tableau also offers several standalone products including Tableau Desktop (for anyone) and Tableau Server (analytics for organisations), which can be run locally, Tableau Online (hosted analytics for organisations) and many more (Haije, E. and Haije, E., 2021.). Website: www.tableau.com Domo Figure 5 Domo (source : mopinion) Domo is a completely cloud-based business intelligence platform that integrates multiple data sources, including spreadsheets, databases and social media. Domo is used by both small companies and large multinationals. The platform offers micro and macro level visibility and analyses (including predictive analysis powerd with Mr. Roboto, their AI engine). From cash balances and listings of your best selling products by region to calculations of the marketing return on investment (ROI) for each channel. The only setbacks with Domo are the difficulty in downloading analyses from the cloud for personal use and the steep learning curve (Haije, E. and Haije, E., 2021.). Website: www.domo.com
Figure 6 Levels of Management Decision Making (source : researchgate) 3.3.Compare the types of support available for business decision- making at varying levels within an organization.
3.3.1. Strategic Decisions
Strategic decision making is about choosing the best path to success. For instance, if you’re starting a new business, you need to consider factors like cost, time and the target market. How do you classify decisions to reach the ideal solution? Strategic decision making will help you formulate a plan of action and align your small-term goals with the big picture. From a management perspective, strategic decision-making is different from the routine choices you make every day. As a manager, for instance, you have to delegate roles, communicate goals to your teammates or external stakeholders and account for uncertainties. The decisions you make not only affect you but the organization as a whole. It’s a good practice to cultivate objective decision-making abilities, free from bias and prejudice (Chand, S., 2021 ).
3.3.2. Tactical Decisions
Tactical decision making is a business strategy where decisions are made with the end result of ensuring a company is as successful as possible, according to Blue Collar University. This means the company makes decisions that will contribute to the longevity, profitability, and continued improvement of all areas of operation (Chand, S., 2021 ). Tactical decision making focuses on the big picture and the here and now. When making tactical decisions, the company as a whole is involved, according to Chron.com Small Business. Tactical decision making allows a company to evaluate its infrastructure and how it operates and make adjustments accordingly. To make a tactical decision, a board analyzes information it is presented, and determines an immediate course of action with the intention of achieving a specific goal that will directly and immediately benefit the most people. A study by npower suggests that although they do involve many people and departments, tactical decisions tend to have a limited impact in the case of their failure because they can be adjusted and changed relatively quickly, according to Business Case Studies (Chand, S., 2021 ).
3.3.3. Operational Decisions
A type of short term decision by a company in lieu of long term strategies at the time of acquisition of company assets. These involve the day-to-day operations of the company, and therefore need to be addressed before any grand scheme issues.
Operational decisions are often very specific and highly certain. Although single operational decisions have no lasting or material impact on the company, they guide the execution of strategic and tactical plans. The operations manager must respond to company officials about the operational decisions made by the operations manager (Chand, S., 2021 ). 3.4.Justify, with specific examples, the key features of business intelligence functionality.
3.4.1. Key Business Intelligence Features
Ranking Reports Ranking reports let you easily view the best- and worst-performing facets of your business, from products to marketing campaigns to salespeople. You can view rankings across multiple dimensions and specify various criteria to focus your results (Selecthub.com. 2021 ). What-If Analysis If you’re curious about how a future decision will affect your business, you can run a “what-if” analysis using past data to predict the potential impacts. Tools for what-if analyses give you an objective view of the risks and rewards involved in each potential decision, and allow you to plan better for the future (Selecthub.com. 2021 ). Executive Dashboards Executive dashboards give your organization’s leaders a real-time overview of your business in the form of graphs, charts, summaries and other information reports. They allow your company’s executives to make smarter, faster and better decisions (Selecthub.com. 2021 ). Interactive Reports Interactive reports allow users to condense the massive amounts of collected data into a wide variety of possible views. Users can take advantages of features like statistical analysis and regression to identify trends, anomalies and outliers in the data (Selecthub.com. 2021 ). Geospatial Mapping Applications using location intelligence can take your information and transform it into graphical and cartographic representations, simplifying your geographical data. At a glance, judging which regions are performing better than others — and which ones need particular attention — becomes much easier (Selecthub.com. 2021 ). Operational Reports