Is it possible to implement required reporting for new rolling marketing product? There is a huge chasm between implementing marketing product and required reporting. Before technical solution and technical implementation of new product it is not possible to foresee level in every detail of possibility to have reporting or not. If even slightest detail does not exist, report will not be created and additional information structure needs to be generated.
Continue reading Marketing Products and Business Intelligence Reporting [...]
Occurrence of production error data for reports is very often since production systems are more process oriented then process-reporting oriented. Productions systems are customized for processes and for plain and simple reports mostly for users in divisions that are owners of system. What is usually forgotten and perhaps is not so obvious is that very aggregated reports are not included into debate during project analysis and later in deployment and implementation. Result is that aggregated KPIs from one source or from several sources are not “consolidated”. This is a financial term but fits in this perfectly. KPI A combined with KPI B and KPI C should give logical result, zero. For example if X number of subscribers deactivate subscription, Y number of subscribers purchase subscription, Z number of subscribers are deactivated do to many reasons (nonpayment, technical reasons and
Continue reading Production data errors [...]
Its a challenging task to include existing ERP reports into independent solution for reporting and planning purposes like DWH/BI or even Financial Business Intelligence. Challenge raises as reports are more complex and are very customized. There are more reasons to place data from ERP to DWH like: reports need to support combination of financial and non financial kpis; faster reporting better data analysis functionalities and similar…
Continue reading Business Intelligence Reporting Risks [...]
There are 3 basic ways of report deployment in Data Warehouse. Each has benefits and risks. Here is the list of facts to be aware before choosing how to deploy reports.
Continue reading ABC reporting deployment options [...]
Decision was to process and gather all financial data through ERP system and to deliver information to Management Information System in bulk. Further, other part of decision was to process all non financial data in separate systems like data warehouse, business intelligence solutions and deliver information to Management Information System separately through other information flow. Intention was to process financial and non-financial data independently and then to gather them for Reporting purposes in Management Information Systems and then to publish performance indicators toward all relevant participants like Bord, Supervisory, Audit and similar.
Continue reading Management Reporting Mind Crime [...]
Gather all production systems experts at one project
Importance of Master Data Management systems are growing during time. Their value is especially important during current explosion of demands toward company information. Gather all experts exactly like hen gathers at one place all eggs during nesting time. Join all experts from production/transaction systems together, lock them in a room and give them
Continue reading Gather all production systems eggs together [...]
Current situation with business management reporting is similar to situation in the airplane cockpit. Each pilot (Board member or Chief of Business unit) looks into panel with instruments and sees only static data with two or several options prepared by their stuff.
Continue reading Management reporting problems – conversation in the cockpit [...]
Extremely long implementations are treated as normal Long business intelligence report implementation is usual
What happens very often becomes usual and what is very long during time became usual and normal. For example implementation of new module, software or business intelligence reports regular is to plan implementation in several years. It is weird to say data are
Continue reading Long long business intelligence journey [...]
Making specification of how report should look like with all combinations of content and functionalities can be mighty frustrating job for requesting side. If specification is not detailed enough it is always a grey zone for misunderstanding between developer and those who asked reports. It is a tough job and there were cases where IT experts felt how hard it is to make requirement toward other IT developers.
Continue reading How to Make Specifications for Business Intelligence Reports [...]
It is weird to see list of RfCs with action points for business who initiated RfC and to see it constantly in same status. For example business needs to make additional specification or to make prioritization of own requests. So, business ordered change but does not actively participate in its implementation like it is not interested.
Continue reading Waiting for storm [...]