Analyzing Business Intelligence Systems and Methodologies (SEM1, 2024)

Desklib provides past papers and solved assignments for students. This presentation explores Business Intelligence systems and their applications.

S E S S I O N 3 , S T O R Y 3 , TA S K 3
Business Intelligence/ Business
Analytics

Business Intelligence systems
It is used to define the business strategies and
technologies for the data analysis from the business
information.
It provides historical, current as well as futuristic aspect
of the business operations and so that supports business
decision making process.

Analytics life cycle

Example-Amazon
The organization uses BI to understand the purchasing
behavior of the customers on price, product and other
factors.
It is used to determine innovative strategies and products
to engage and satisfy the customers.

Steps in a BI methodology

Factors on evaluation and selection of BI platform
Platform integration & accessibility
Ease of use
User enablement
Deployment flexibility
Pricing and packaging

BI users

Extract, Transform, and Load process
Extract
 It can be defined as the process to read the desired data or records
from the database or other storage mechanisms.
Transform
 It is the conversion of the extracted data into new form to achieve
acceptance in business systems.
Load process
 It is the process to write the transform data into target database.

Is ETL pose problems?
Yes
 It needs unified data modeling and presentation to
achieve seamless integration.
 The transformation process is time consuming if there
is no direct acceptance of the data formats.
 The information system has to manage the atomicity
and transactional control to achieve the desired
security.