Gaining Insights – Part I - By Sanjay Jotwani

Introduction

We live in a digital world!! Every interaction is a “transaction”, and recorded into the computer’s storage.

So, what is the primary need of capturing this transactional data?

· Proof of Interaction

· Grain for Business Analysis

· Case for Predictive Analysis

As we have digitized every piece into a bit, the challenge faced today is more in terms of

· Volume of Data and,

· The disparate forms of Data in a Domain.

As mentioned, data has a purpose to serve; the major is that of participating in analysis, leading to the intelligence required by the business to make informed decisions.

In this multi part blog series, we will try to cover the need, along with the design & implementation practices for a Business Intelligence Application.

The Framework for Business Intelligence

A Business Intelligence Application, from a layered architecture perspective would be represented as shown in Figure 1.

This framework is conceptual, and technology agnostic.



















Figure 1.

1. The Data Integration will result in the Consolidated Data Storage

2. Data Analysis and Rich Visualization such as decomposition trees will use this Consolidated Data

3. The Consolidated Data can be termed as Data Warehouse OR Data Mart.

In the next blog, we will explore the Application Data Layer.

Until then; Cheers!!

Synergetics is Awarded as the "Best. NET Training Service Provider" by Microsoft.