Data quality can not secure correct report publishing. Provided data can be of highest quality but if administrator that publishes reports or business analytic that publishes analysis misinterprets data, result will be poor information quality for decision makers.
Continue reading Data Quality vs. Information Quality [...]
Reporting is treated as a boring process that can be once set up and then consummated with press the button. In current situation where more and more markets are becoming very dynamic and flooded with complex products and services, reporting environment has become extremely challenging. There is the solution how confront chaotic reporting environment.
Continue reading Reporting Parts [...]
Playing Political Games
If organization does not fit into current IT requirements with its structure and undefined processes, and nobody wants to take responsibility nor lead in defining requirements toward IT implementation… What can be done in such environment? If nothing is done then Business Intelligence reporting can soon collapse! Business Intelligence reporting represent common work
Continue reading Shadow Business Intelligence Games [...]
Information Systems are not stabile systems because of too many components that might influence final non-financial figures. All that can be done is to give most accurate figures from current definitions and with given resources from unstable systems.
Continue reading Accuracy of Figures for Stock Exchange [...]
Sharing Key Performance Indicators
I was just passing by in restaurant, buying a coffee and then I’ve heard one very interesting conversation of two colleagues. They were commenting how corporation gathers thousands of KPI’s from daughter companies in controlling departments but none of the board management members except CFO can see more then 5 Key Performance
Continue reading Sharing Key Performance Indicators [...]
Business Intelligence Reporting Trap
It is not always wise to recreate reports from source systems in Data Warehouse. Chances are that you’ll make much more efforts and engage more resources to create report in DWH instead to make it in source system.
In order to recreate required report in Data Warehouse all data need to imported.
Continue reading Replacing Reports from Source Systems [...]
Data Warehouse is not imune to changes on source systems, actually it is very vulnarable to them. If source systems have duplicate figures, Data Warehouse will also report duplicates. Here is an example from practice where guys made patch on CRM system to handle “urgent” marketing product without making any kind of communication toward reporting – DWH and Business Intelligence. Duplicated figures were in official reports for three months and caused significant deviations of core Key Performance Indicators. Unfortunatelly, reporting mistake was presented to the board members as Data Warehouse error.
Continue reading Business Intelligence Example of Reporting Errors – Duplication of Figures [...]
At the beginning of the project many reports are required by users. They prepare specifications, list of wishes, explanations, descriptions, even business cases to justify their influence on company profitability. It is almost always huge amount of requests. All the business intelligence requests are made from users perspective and from what they know best, from the perspective of functionalities of table calculators. Those requests are very rarely checked and consolidated from decision or business intelligence experts. It is more like un-structured bunch of reporting requirements.
Continue reading Redundant and Over Customized Reporting [...]
Corporate information environment is full of reporting solutions – reporting universes. It is tempting thing to make parallel reporting solutions that have most of the information base same but not complete. Building parallel reporting solutions is easier but also makes huge information and knowledge problems in the future.
Continue reading Building Parallel Business Intelligence Reports [...]
From time to time reports need to be pushed for using. Sounds weird, but it is true. It is hard to force users to use new reporting platforms. Sometimes it looks like invisible wall between exploitation of reports and users. It is very common event that reports are ordered and not being used. Reasons might be following…
Continue reading Enforcement of Reports [...]