Sales Management Customer Relationship Human Resources Business Performance BI & Data Quality IT Tools & Vendors

Sign-in   Register
Establishing 'Making it Happen' as a 'Formal & Predictable' Discipline
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.

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
 
Relevant links to this page
Entry criteria to start DW project
Prime Purpose of a Data Warehouse
Data Warehouse- Big Bang or Incremental
Dimensional model vs Relational model
Interview sequence for DW business requirements
Pre-configured reports- Do they work?
Business Intelligence vs Business Performance
Data Warehouse vs Business Intelligence
Refresh frequency of a Data Warehouse
EAI vs Data Warehouse
Excel export to Data Warehouse
Captive ERP reporting capability
CRM and Data Warehouse
Source system re-writing in parallel to Data Warehouse
Simultaneous launch of source system and Data Warehouse
Security Matrix of a Data Warehouse
ETL phase taking too long
Should Data Warehouse wait for Meta-Data initiative
Mismatch in Source vs Data Warehouse reporting.
Data Warehouse vs Data Mart vs Data Mining
Additional Channels
Principles & Rules
Free Templates
Glossary
Key Performance Indicators

Most Popular Zones with list of pages crossing 25000 hits  →→→ 
Maximising Sales Performance
Sales Compensation Structure Decision
Sales Channel Mix Profitability
Sales Compensation Analysis
Sales Compensation Management
Sales Compensation System
Read more...
  Customer Relationship Management
Customer Satisfaction & Retention- Data Management
Customer Service and Support - Strategic Role
Customer Value and Profitability-Overview
Customer-Centric product-service management
What is Customer Segmentation?
Read more...
  Human Resources & Leadership
Give feedback closer to the observation
Setting Strategic Intent and Alignment
Deliver Results
Roles and Level based Competency Segregation
Customer Focus
Read more...
 
 
Business Performance & Planning
Individual goal Sheet
Never design performance systems for specific KPI
Review Session should stay focused
Stakeholder test for Scorecard
strategy blueprint Rationalize Align and Publish
Read more...
  Business Intelligence & Data Quality
Data Warehouse Information Systems Assessment
Dimensional Model Schemas- Star, Snow-Flake
Normalization in Dimensional modeling
Data Monitoring Checklist
Data Warehouse Project Definition
Read more...
  IT Vendors & Tools Management
Metadata Tool Change Management
Vendor Evaluation Matrix
Technical Evaluation- Interoperability
OLAP Sever Database Tuning
Vendor Quality Evaluation
Read more...