Business Intelligence Hariprit Padam Ramakanth Gajjela Agenda Introduction

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 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 34 th 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, 16 th International Workshop on Database and Expert Systems Applications (DEXA'05), 2005. • “Adding Semantics to Business Intelligence”, 16 th 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