What do you have in DWH? This is political question, because everything can be set up to be available through DWH but others allocate resources and schedule priorities. This is not question for DWH but for management and most of all for CMO, CFO and CSO who are main pushers toward DWH resources.
Continue reading What Do You Have in DWH? [...]
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 [...]
Google Effect is attention deficit problem where facts can be easily found but not understood. Our brains are physically changing due to data accessibilty. Companies have similar problem due to information hyper production.
Continue reading Google Effect vs. Knowledge Integration [...]
Marketing Analyst: What is the correct figure asks marketing data warehousing team? IT developer: Both figures are ok. Marketing Analyst: We know that both figures are ok but which one is correct for our KPI?
Continue reading Defining Key Performance Indicators [...]
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 [...]
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 [...]
It’s Time To Panic, I Don’t Want to be Part of Reporting Definition Process
When management washes hands and says that they want pure figures and does not want to participate responsibly together in large and complex project, then it is TIME TO PANICK!
If management does not want to participate in data definition,
Continue reading Not Part of Reporting Definition Process [...]
Spoiled and Lazy Data Warehouse and Business Intelligence Reporting Users
There was no life before Data Warehousing System! Once it is installed and operative many users simply forget how to gather data.
It is far easier to order all reporting through Data Warehousing and Business Intelligence system instead to dig on own data from
Continue reading Data Warehouse and Business Intelligence Reporting Users [...]
What Is A Decision? What is a business intelligence based decision?
Decision is a made choice between options, alternatives.
“Decide – to arrive at a solution that ends uncertainty or dispute”
A high quality decision should come with guarantee but not of certain outcome but with a warranty that the used porocesses to arrive to
Continue reading What Is A Decision? [...]
If performance management harmonization of finance and business is made through Business Intelligence modules with just more specialized functionalities it is than really Holy Grail, pure Utopia. If approach is different, made from decision making side and with involvement of basic rules for dealing and interpreting vast numbers of figures then
Continue reading Holy Grail [...]