Real-time data marts and business intelligence solutions are no longer a novelty or luxury. These solutions are not in their infancy stage. They are becoming instrumental in delivering information crucial for organizations to remain competitive in their core businesses. Given the number of tools mushrooming over the past few years touting anything from ready-to-go solutions on day one to analytical ability on-the-fly and on-demand, real-time business intelligence solutions appear to be a piece-of-cake. However, the reality often reveals a different picture than one might imagine! What challenges can you face when you consider a Real-time Business Intelligence solution for your organization? The most obvious challenges may include the following: Ability to provide analytical information with superior performance while refreshing the data marts real-time. Justification of cost versus benefits for real-time business intelligence. Impact on performance of one or more source applications. Ability to perform all of the transformations in the ETL Extract, Transform Load- process in real-time. Well, these responses are not incorrect. However, they are only a small part of the total answer. During the implementation of a real-time business intelligence solution, we realize that the biggest challenges include more than just issues around tools or technologies. So what are the challenges, and, correspondingly, what rules should you follow?
- Be careful in defining ?real-time? Differentiate between ?must-be-real-time?, ?nice-to-have real-time? and ?not-at-all-real-time? Don?t build a bridge when a boat would do A picture is worth a thousand words especially when you are refreshing live- Placing the information right Can you please all the people all the time? What prevails in a real-time solution? Operational Intelligence or Analytical Intelligence? ol> Source and full article: