From the category archives:

Business Intelligence

Let me reiterate – Big Data is the ‘New Normal’ in Business Intelligence. Now, What is this Big Data?
Before that let me take a dig at this fashionable phrase called the ‘New Normal’ – Mr Mohammed El-Erian, CIO of Pimco, first introduced the phrase New Normal and it has since been used by many people [...]

Because Non-linear nature of business is the root cause for the gap between analytics delivered by IT and positive impact of such analytics on business decisions. Let me try to substantiate that statement in this blog post.

Ease of data handling has been a vital reason for the statistical software platforms like SAS, SPSS to be very popular with the business analyst community. Manipulating data and inferring information is done in a much easier way on these platforms.

I have been encountering ‘this’ situation in BI consulting engagements with increasing regularity and thought that it merits a blog post. ‘This’ situation mentioned above is a scenario where enterprises are utilizing a combination of On-Demand cloud applications (CRM functionality) with On-Premise systems (Traditional BIG ERP’s like SAP, Oracle Apps etc.) with exchange of data [...]

In a typical data warehouse setup, we would first extract, cleanse and bring the required base data into the data warehouse. We would then transform or aggregate the base data into additional derived tables for easier reporting; these are processes that are optional but are done to get the data ‘report friendly’.

My inspiration for this post is the wonderful book titled “Innumeracy” authored by John Allen Paulos. In this book, the author hypothesizes that many of us are unable to deal with numbers in the real world and that by understanding the concepts in this book, we can get a clearer, more quantitative way of looking [...]

In the process of Data Mart Consolidation, the third area to focus after Data Integration Consolidation is the Information Delivery process. Let us define the following

Parent Data Mart (PDM) – The Data Mart which is to get extended with the elements from another ( Child ) Data Mart
Child Data Mart (CDM)– The Data Mart which [...]

Recently, I happened to read a couple of books with the “Obvious” word in the title and thought of writing a post around some of those obvious things in BI that we all know but typically forget during the thick of action.

And if you can onboard a Picasso, Salvatore Dali, Vincent Van Gogh or Claude Monet, go for it! Business Intelligence needs Artists more than ever!
My biggest learning from consulting assignments during 2009 is the increasing emphasis on the artistic elements of Business Intelligence. The first question asked by senior executives across organizations was, “So, how [...]

In the process of Data Mart Consolidation, the second area to focus after Data Model Consolidation is Data Integration (DI) Process. Let us define the following 

Parent Data Mart (PDM) – The Data Mart which is to get extended with the elements from another ( Child ) Data Mart
Child Data Mart (CDM)– The Data Mart which [...]