BI project tasks

Define: Project template elements from here. Most importantly: ┬áThe goal, the reports required, the data points and their sources and business names, the benchmark report or query (the current status). Make a brainstorming session for requirements and include all stakeholders! document requirements and get all approved by all, otherwise it will make conflicts and reduce[…]

Data Integration Architecture Options

When choosing between different data integration architecture Options: At least two axes to consider: Timing (real time is becoming necessary) and Volume. Main integration patterns are: A. Enterprise Information Integration (EII): direct data pull from sources into the report, using usual APIs (ODBC, ADO, etc). B. Enterprise Application Integration (EAI): Row level data push into[…]