Building Making It Happen
Building Making It Happen
  Sign-in         Register
    
Ask a question Listing Page
Online data feed to Data Warehouse.
Is there a valid business need for feeding data on online basis to a data warehouse? Many vendors have starting placing it as a differentiated offering?
 
This page of 'Ask a question' is linked to:  Data Warehousing, BI business intelligence end-to-end view, Data Analysis/OLAP, BI platform Tools Evaluation,


'Real Time Business Intelligence or Real Time decisioning is a big discussion item. Our recommendations are:

  • Assume that real time Business Intelligence is not needed, unless proven: As real-time or online feed into a data warehouse is a complex subject, and one should have highly quantified business case to go ahead with it.
  • Avoid non-operational needs for real-time BI: We don't think that a decision maker needs current real-time data for taking managerial or strategic decisions. Most of the operations related decisions do not require real time Business Intelligence.
  • Focus on select operational needs: Some examples of real time BI are:
    • financial reporting near period end close, whereby you need to keep track on almost hourly basis on the orders booked and invoices raised.
    • Managing your infrastructure: For telecommunication companies, keeping a track of the network usage therefore fine-tuning the network band-width allocation to various channels.
    • Risk Management: When you are authorizing a major spending on a credit card, the real time view of what customer has spent in the day helps. This is a typical case with stolen credit cards.

Tips to structure your real-time BI

  • Use real-time BI for very special cases. Avoid as much as you can.
  • Avoid using data federation tools as your enterprise BI solution
  • Execution-MiH recommendation will be that in spite of a data set being loaded real-time, it should also be made part of the end of the day ETL routines for the traditional data warehouse. This ensures that nothing gets missed out.
   Access more details on this page   

Quick Feedback- Was this information helpful ?
Relevant Links to this page
Expert's Answers → Entry criteria to start DW project → Expert's Answers → Prime Purpose of a Data Warehouse → Expert's Answers → Data Warehouse- Big Bang or Incremental → Expert's Answers → Dimensional model vs Relational model → Expert's Answers → Interview sequence for DW business requirements → Expert's Answers → Pre-configured reports- Do they work? → Expert's Answers → Business Intelligence vs Business Performance → Expert's Answers → Data Warehouse vs Business Intelligence → Expert's Answers → Refresh frequency of a Data Warehouse → Expert's Answers → EAI vs Data Warehouse → Expert's Answers → Excel export to Data Warehouse → Expert's Answers → Captive ERP reporting capability → Expert's Answers → CRM and Data Warehouse → Expert's Answers → Source system re-writing in parallel to Data Warehouse → Expert's Answers → Simultaneous launch of source system and Data Warehouse → Expert's Answers → Security Matrix of a Data Warehouse → Expert's Answers → ETL phase taking too long → Expert's Answers → Should Data Warehouse wait for Meta-Data initiative → Expert's Answers → Mismatch in Source vs Data Warehouse reporting. → Expert's Answers → Data Warehouse vs Data Mart vs Data Mining → 
 
Back
Featured Pages
Master-Data-Management CDI Usage pattern
Derived Facts table in DW
Exception Analysis
Data Model Entity Relationship Controls

Make 'Executable' Strategy
Maximize Results
Maximize People
Manage Execution

Featured Pages
Business Intelligence Vendor Evaluation
Avoid Pure MOLAP
BI Competency Centre Setup- Overview
Data Quality Proposal & Agreement