Transcript Business Intelligence - School of Information Technology

Business Intelligence
Hariprit Padam
Ramakanth Gajjela
Agenda
•
•
•
•
•
•
•
Introduction
BI process
Past proposal
Current proposal
Enhancement in BI architecture
Conclusion
Questions
Introduction
• A typical BI architecture contains a
Data Warehouse (DW), an Extraction,
Transformation and Loading tool (ETL)
and a set of analytical tools.
• DW is an integrated repository of data
consolidated from different data
sources through ETL tools.
Business Intelligence Process
•
•
•
•
Understand and define the process
Perform data collection and extraction
Perform Data Cleaning and Exploration
Data Engineering
– select attributes of interest
– select records of interest
– map attributes to suit DM algorithms
Business Intelligence Process
• Algorithm Engineering
– which algorithm to use
– ability to deal with
• quality of input
• quality of output
• performance
•
•
•
•
Run the data mining algorithm
Preliminary evaluation of the results
Refine the data and the problem
Use the results to implement a business strategy
Past proposal
The data warehouse
does not have to be
implemented as a single,
centralized system, but
can also be partially or
entirely implemented in a decentralized or even
virtual way.
Proposed Architecture
Enhancement in BI architecture
• Information integration infrastructure:
– This infrastructure is mainly responsible for
managing and analysis of data required by the
business intelligence.
• Business integration infrastructure:
– The central component of this infrastructure
is the Sense and Respond system which
interact with the internal and external
environments via hubs.
Claims of Enhance Business
Intelligence Architecture: 1
• Minimizing Data latency:
– A major portion of time is consumed in the
extraction, transformation and uploading of the data
in the data warehouse database.
• Minimizing Analysis latency:
– Analysis latency is mainly determined by the time it
takes to inform the person in charge of data analysis
that new data has to be analyzed, the time needed to
choose appropriate analysis models and the time to
process the data and present the results
Claims of Enhance Business
Intelligence Architecture: 2
• Minimizing Decision latency:
– This is one aspect of BI which does not involve
much technology because it is manual process and
the decisions are taken by specialized human
resources and hence it consumes lot of time.
• Minimizing Response latency:
– Response latency is the time consumed from
initiating an action till its execution.
Conclusion
• Traditional business intelligence architecture
does not support real time decision making.
• The author emphasizes on the latencies that
occur in various stages of the traditional
architecture and presents a sense and response
system clubbed with analytical services to
enhance the BI system.
References
•
A Current and Future Role of Data Warehousing in Corporate
Application Architecture, By R. Winter
Date: January 2001. IEEE, Proceedings of the 34th Hawaii
International Conference on System Sciences – 2001
• Andreas Seufert, Josef Schiefer, "Enhanced Business Intelligence Supporting Business Processes with Real-Time Business Analytics," dexa,
pp. 919-925, 16th International Workshop on Database and
Expert Systems Applications (DEXA'05), 2005.
• “Adding Semantics to Business Intelligence”, 16th International
Workshop on Database and Expert Systems Applications
(DEXA'05), By Denilson Sell, Liliana Cabral, Enrico Motta, John
Domingue, Roberto Pacheco, Publication Date: August 2005.
Questions?
Thank you