My Business Intelligence Framework (4 simple steps on how to get there)

by Albert Anthony D. Gavino

These days, everyone seems to be an expert at business intelligence, but what is business intelligence all about? its just not about data analytics and some graphs and some more pie charts, Business Intelligence involves a meticulous process that starts from the craft of a business strategy. 

Business Strategy

This business strategy comes from the company's vision mission statement aligned with its objectives, there are several ways to attack business strategy, you can use the Michael Porter's model or analyze your competition through market niche or market segmentation.

B.I. framework by Albert Anthony D. Gavino

Performance Management
Performance management is the field that discusses the nitty gritty stuff that involves the dreaded Balanced Scorecard where every organization unit is defined by a perfomance metric such as sales performance or sales quota or number of calls made per day, these metrics are defined by upper management that will in turn drive customer value and share holder value, somewhat taken from the Japanese qualitative methodology that we don't want to read like Six Sigma Belters that exemplify utmost quality by reducing the number of defects almost close to zero.

Data Warehousing
Of course you can't analyze your data if you dont have a good data warehouse, a good data warehouse involves flat files and cubes that are interconnected by a snowflake schema or a starflake schema. These are queried through your SQL server, your MySQL if your on a budget and in some other cases you would be needing your stored procedures that have scripts and subscripts nested within each other, talk about five pages of code with your database administrator (goodluck with that)

and Lastly...

Advance Statistics
your Company Statistician is best consulted with what kind of data you will be handling, no he doesn't care where you put your string fields in, he only has three kinds of variables and that are nominal, ordinal and scale. for in each there is a specific t-test, z-test, chi-square test, for elementary statistics and then there is the advance statistics from linear regression, logistic regression, time series analysis, cluster analysis, CHAID, C5  trees and Neural Networks which involve complex statistical models vastly computed through business intelligence software such as IBM-SPSS data modeler or your other competitor models that you would want to use.