Problem solve Get help with specific problems with your technologies, process and projects.

How to transition to real-time business intelligence and data warehousing

Learn how real-time business intelligence (BI) impacts a data warehouse and get expert tips for making the transition to real-time BI.

What's the best (and smoothest!) way to switch to real-time business intelligence (BI)? Do you have any best practices/advice?

There are several ways to make the transition to real-time business intelligence (BI).

One approach to switch to real-time business intelligence is to make the data warehouse real-time, loading it in concert with operational structures and minimizing operational business intelligence. This is simple in concept. However, making data warehouses real-time can be an extremely complex challenge. Operational systems need to cooperate with this vision by not being so fragile that they break with intra-day extracts. The data warehouse environment needs to be efficient to the point where the requested extracts are kept to a minimum. This is not always the case, so real-time remains a challenge. Service-oriented architecture has increasingly helped allow operational queries, but extracts remain a challenge.

Sometimes, however, the simplicity and value-add of a real-time data warehouse can prove to be so enormous that a company can choose to actually replace its operational system with one that is more "real-time data warehouse friendly." That's the second approach. Generally, these are systems that can tolerate extracts while also performing real-time operations. The irony is that many of these modern enterprise resource planning (ERP) systems provide much more analytics than previous ones and also control many of the functions that previously were the domain of the data warehouse. Consequently, some companies have found themselves in the enviable position -- but still at an intersection -- of having analytical abilities both in operations as well as in a real-time enabled data warehouse.

Putting that aside for the moment, most shops need to choose generally where analytics and business intelligence will prevail, and give the appropriate attention to operational BI as a result. I do not believe a shop can ignore operational business intelligence any longer. However, the emphasis of where the majority of BI occurs is in question -- in the data warehouse or in the operational arena.

More about real-time business intelligence

•  Experts predict growing real-time business intelligence trend in 2008

•  Real-time business intelligence case study: Gartner lauds police for crime-fighting BI

More about operational business intelligence

•  Operational data store vs. operational business intelligence

•  Operational business intelligence making its way in the enterprise .

More about active data warehousing

•  Active data warehousing explained and examined

•  Business intelligence and data warehousing top trends: A two-part series by Dr. Mark Whitehorn

Dig Deeper on Business intelligence best practices

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.