Business Intelligence Assignment 2_1641, Assignments of Business Informatics

Download Business Intelligence Assignment 2_1641 and more Assignments Business Informatics in PDF only on Docsity!

Higher Nationals in Computing

Unit 14: BUSINESS INTELLIGENCE

ASSIGNMENT 2

Assessor name:

Learner’s name:

Class:

Subject code: 1641

Assignment due: Assignment submit

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 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

P3 P4 P5 P6 M3 M4 D3 D

audience and make them more competitive within the market. Unit Learning Outcomes LO3 Demonstrate the use of business intelligence tools and technologies Assignment Brief (Continued from previous scenario) Your next task is to demonstrate to the board of directors about the ability of applying business intelligence in the company's current business processes. To demonstrate BI, you need to prepare a presentation about BI and related tools & techniques and a demonstration on real company dataset. For the presentation, you need:

• Explain general concept of what is BI
• Introduction to some tools / techniques for BI and their application in general For the demonstration, you need:
• A (some) data set(s) extracted from the company's business processes. Explain the dataset.
• Show how you pre-process data for later analysis, explain each step and it purpose
• Design dashboards to show your analysis on pre-processed data. Explain clearly purpose of dashboards and charts. Suggestions should be made after analysis During the demonstration, you need collect feed-back and comments from users to review how well your dashboards design meet user or business requirement and what customization needed for future use. Team needs to present their point of view about how business intelligence tools can contribute to effective decision-making as well as the legal issues involved in exploiting user data for business intelligence. You may need to research for specific examples of organizations that use BI tools to enhance or improve their business and evaluate how they can use BI tools for extend their target audience and make them more competitive within the market. To summary, you need to submit a report in PDF includes 4 parts: your presentation, result of demonstration and review of user feedback, point of view on BI contribution and legal issues. 3

Learning Outcomes and Assessment Criteria Pass Merit Distinction LO3 Demonstrate the use of business intelligence tools and technologies D3 Provide a critical review of the design in terms of how it meets a specific user or business requirement and identify what customisation has been integrated into the design. P3 Determine, with examples, what business intelligence is and the tools and techniques associated with it. P4 Design a business intelligence tool, application or interface that can perform a specific task to support problem- solving or decision-making at an advanced level. M3 Customise the design to ensure that it is user friendly and has a functional interface. LO4 Discuss the impact of business intelligence tools and technologies for effective decision-making purposes and the legal/regulatory context in which they are used 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 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. Table of Contents Unit 14: BUSINESS INTELLIGENCE................................................................................................................... 1 4

P3 Determine, with examples, what business intelligence is and

the tools and techniques associated with it.

1. Business intelligence

Business intelligence (BI) is a set of strategies and technologies used by companies to analyze business

information and transform it into actionable information to make business decisions. strategic and

tactical business. BI tools access and analyze datasets and present analysis results in reports,

summaries, dashboards, graphs, charts, and maps to give users insights about status of the business.

Figure 1: Business Intelligence

Here are some examples of how different groups and companies use their business intelligence:

❖ Marketing and Sales: BI helps marketers determine which tactics work- Basically BI will analyze

all the tactics of marketers and customers and show you what works and doesn't work. fruit.

Based on that, strategists or managers can make appropriate adjustments to tactics and future

directions.

❖ Small business: Hotel owners use BI analytics applications to gather statistical information on

average occupancy and room rates. It helps to find aggregate revenue generated per room. In

addition, the owner also collects market share statistics and data from each hotel's customer

surveys to determine the hotel's competitive position in different markets. By analyzing these

trends year-to-year, month-by-month and day-to-day helps management reduce room rental

rates.

2. The tools of Business Intelligence (BI) 2.1. Tableau

Tableau is the fastest growing and powerful data visualization tool used in the Business Intelligence

Industry. It helps to simplify raw data in a very understandable format. Tableau helps create data

that professionals at every level of an organization can understand. It also allows non-technical

users to create custom dashboards.

Figure 3: Power BI

2.3. SAP Business Objects

SAP Business Objects is a business intelligence software that provides comprehensive reporting,

analysis, and interactive data visualization. The platform focuses heavily on categories like Customer

Experience (CX) and CRM, digital supply chain, ERP, and more. What's really cool about this platform

is the self-service, role-based dashboard it offers that allows users to build their own dashboards

and apps. SAP is a powerful piece of software for every role (IT, end use and management) and

offers a lot of functionality in one platform. However, the complexity of the product increases the

price, so be prepared for that.

Figure 4: SAP Business Object

2.4. Datapine

Datapine is an all-in-one business intelligence platform that facilitates complex data analysis even

for non-technical users. Thanks to its comprehensive self-service analytics approach, datapine's

solution enables data analysts as well as business users to easily integrate disparate data sources,

perform advanced data analytics, build Build interactive business dashboards and generate helpful

business insights.

Figure 5: Datapine

2.5. MicroStrategy

MicroStrategy is an enterprise business intelligence tool that offers powerful (and high speed)

dashboarding and data analytics, cloud solutions and hyperintelligence. With this solution, users can

identify trends, recognize new opportunities, improve productivity and more. Users can also

connect to one or various sources, whether the incoming data is from a spreadsheet, cloud-based or

enterprise data software. It can be accessed from your desktop or via mobile.

2.6. SAS Business Intelligence

While SAS's most popular service is advanced predictive analytics, it also provides a great business

intelligence platform. This seasoned self-service tool, founded in the 1970s, allows users to leverage

data and metrics to make informed decisions about their business. Using their set of APIs, users are

provided with many customization options, and SAS ensures high-level data integration as well as

advanced analytics and reporting. They also have great text analytics to give you more contextual

insights into your data.

Figure 7: SAS BI

2.7. Other Tool

✔ Yellowfin BI

✔ QlikSense

✔ Zoho Analytics

✔ Sisense

✔ Looker

✔ Clear Analytics

✔ Oracle BI

✔ IBM Cognos Analytics

3. Business Intelligence techniques 3.1. Collection techniques

This technique is used to discover patterns in small to large data sets, and often combines database,

statistical, and machine learning systems to find data that can be analyzed and cleaned.

This is an indispensable process for data management as well as data pre-processing because it

ensures proper data structure, and is also the top thing to do in Business Intelligence. End users can

also use the mining data to generate specific models and metrics and for analysis.

For example, a food business like the one we mentioned earlier who could mine data from

customers who bought it to predict which potential customers are more likely to buy or certain

products and which are not. which products are suitable for which customers.

4. Tool BI used

With the project of analyzing data and creating charts showing the correlation in a food company, we

have been using a tool called tableau to analyze the data in the following dataset:

Figure 8: Dataset

✔ I use tableau in my analysis and charting for a variety of reasons:

o It processes information very quickly but handles limited data volume

o Tableau software with access to multiple data sources and servers

o Tableau is more expensive

o Tableau also contains a variety of analytical functions

✔ In the next part of this report, I will implement and use tableau to represent and create

correlation charts in the dataset.

P4 Design a business intelligence tool, application or interface

that can perform a specific task to support problem-solving or

decision-making at an advanced level.

1. Dataset

Figure 9: Dataset

✔ This is a fairly detailed dataset that shows the basic information of customers as well as the total

product they have purchased after the company has surveyed 2240 different customers.

✔ The ID column is to represent the customer's identifier in our data

✔ Year_birth column, it is the date of birth of the customer

✔ The Income column shows the total income of each customer or the customer's family

✔ In addition to columns such as MntWines, MntFruits, MntMeat, MntSweets,...Mnt_, these are

all purchases of the respective products by the customer. Not only that, there are many other

columns of data such as the number of in-store purchases, online purchases on the company's

website, and the number of product complaints.