Business Intelligence: A Comprehensive Overview (BUS201)

Desklib provides past papers and solved assignments for students. This report explores business intelligence.

Business Intelligence

Table of Contents
Introduction......................................................................................................................................1
LO1..................................................................................................................................................2
P1 Examine, using examples, the terms ‘Business Process’ and ‘Supporting Processes’..........2
M1 Differentiate between unstructured and semi-structured data within an organisation..........6
D1 Evaluate the benefits and drawbacks of using application software as a mechanism for
business processing......................................................................................................................9
LO2................................................................................................................................................10
P2 Compare the types of support available for business decision-making at varying levels
within an organisation................................................................................................................10
M2 Justify, with specific examples, the key features of business intelligence functionality....11
D2 Compare and contrast a range of information systems and technologies that can be used to
support organisations at operational, tactical and strategic levels.............................................12
LO3................................................................................................................................................15
P3 Determine, with examples, what business intelligence is and the tools and techniques
associated with it........................................................................................................................15
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] [D3]....................17
LO4................................................................................................................................................24
P5 Discuss how business intelligence tools can contribute to effective decision-making........24
P6 Explore the legal issues involved in the secure exploitation of business intelligence tools.25
M4 Conduct research to identify specific examples of organisations that have used business
intelligence tools to enhance or improve operations.................................................................25
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..............................................................................................................................26

Conclusion.....................................................................................................................................27
References......................................................................................................................................27

List of Figures
Figure 1: Microsoft Power BI........................................................................................................16
Figure 2: New system Architecture...............................................................................................17
Figure 3: Detailed architecture......................................................................................................18
Figure 4: BI system for Survey......................................................................................................18
Figure 5: Database schema............................................................................................................19
Figure 6: Survey form from user section.......................................................................................19
Figure 7: Form layout....................................................................................................................20
Figure 8: Survey Form for user.....................................................................................................20
Figure 9: Survey result...................................................................................................................20
Figure 10: Survey report................................................................................................................21
Figure 11: Module Architecture for Statistic................................................................................21
Figure 12: Financial report............................................................................................................22
Figure 13: Human resource report.................................................................................................22
Figure 14: Overview of project......................................................................................................23
Figure 15: Overview of the organization.......................................................................................23

Introduction
Business intelligence is the broad sense in related on focusing on data files and then processing
them to generate products that are beneficial for the organisational business. The key capabilities
of business intelligence commonly include various technologies including online analytical
running, exposure, process mining, data mining, analytics, benchmarking, complex event
processing, textual content mining etc. BI or Business intelligence, in general, is a combination
of various tools and strategies that a business organisation apply for transforming all the natural,
unstructured, semi-structured data to useful and meaningful information that are effective for
conducting business research.
1

LO1
P1 Examine, using examples, the terms ‘Business Process’ and ‘Supporting Processes’.
2

For an organisation like Tesco, a business process is referred to extensive collection of various
structured but chained, tasks and activities which are performed or functions that are conducted
in the organisation through equipment or by people for producing particular products and
services for specific consumers or users (Chen et al. 2012). In an organisation, the main purposes
of implementing business processes for accomplishing the goal of the organisation that has been
predetermined. In the present organisation business process can be classified as Operating
process, supporting process and management process.
Operating process: In Tesco, Operating process are those that are performed by the organisation
and the employees for adding, creating and delivering values to the associated customers that are
paying for product and services. Tesco is a supermarket that sells and provides different services
and products to customers according to the strategies applied. In Tesco, some of the operating
processes include sale order processing, customers services, warranty services, supply
management etc.
3

Supporting process: These processes in Tesco are mainly to proper support execution of
operational procedures of the organisation for delivering the best and useful product and
services. However, these processes are not directly related to profit or customer services, but the
primary purpose of these processes is to assist the organisation to run other functions and
operates seamlessly. This function includes HR management, information security, customer
services, sales and marketing etc. For instance, For example, for offering the proper functioning
of the employees to provide effective customer services it is expected that the HR department
needs to hire good employees.
4

Management process: The management process in the organisation is performed for
controlling and measuring the product and service quality for achieving high performance. These
processes are mainly for resolving various issues, making a decision and for controlling variance
while performing multiple activities for offering services to the customers.
5

M1 Differentiate between unstructured and semi-structured data within an organisation
6

7

Table 1: Differentiate between unstructured and semi-structured
Parameter Unstructured data semi-structured data
Definition Unstructured data for an organization is
considered as information stored in different
forms like sounds, images shapes and sounds
that do not support or fall into conventional
data mode creating issues for mainstream
relational database used in the organization
(George et al 2015).
Data collected in an organisation in ad-
hoc manner without proper defined way
for managing and storing. Although the
data has some structure but not all the
collected data will have similar or
identical structure
Managing  Visual Storage Intelligence  Ignore it
 Forcing the unstructured data to
transform into structured
relational form
 Adopting different mechanism
for storage
Types Database, data ware house, enterprise system XML, EDI, email
8