Companies have many problems in defining and creating their own product/service portfolio. In addition, if product portfolio with many types of hierarchies is hard to define… why should be then implementation of product management be easy task for IT?
Continue reading What is the Product [...]
Definition of parameters in reports significantly determine business performance measurement. Definitions influence reports, personal goals and benchmarking quality. If the official reporting consistency is changed due to change in definition,
Continue reading Definition Influence [...]
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 [...]
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 [...]
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 [...]
Are you going to listen to experts who never delivered materials for the board or supervision in huge companies? Have they ever delivered plans, reports, budget, business cases, comments. Were they ever on conference or video calls with board members to explain to defend presented materials and to explain what is wrong with figures? Well, in those situations you’ll see how business intelligence explanations from consultants and IT are not enough and how different kind of business intelligence knowledge is very important.
Continue reading Afraid of Business Intelligence Experts [...]
Excel mappings systematic solution
There was a good question from colleagues, is there a systematic solution for manual maintenance of mapping and translation tables? Yes there is, Master Data Management (MDM).
Especially if many mappings from more production systems are made in Excel sheets.
Question was provoked with many process problems caused with usage of Excel
Continue reading Excel mappings systematic solution [...]
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 [...]
Life writes interesting stories. There was an urgent need to quickly redefine current OLAP cubes for official reporting purposes since old reporting system suffered from permanent instability. Term official reports means reporting toward board, owners, supervisory, agency and etc. Old business intelligence data cubes generated non trustable key performance indicators due to poor data and definition integration. For example marketing generated one figure and finance generated other figure for something that looked like same key performance indicator. Then management compare their reports and find out they can not trust to own reports. Usually it is always different performance indicator but with wrong and inadequate interpretation.
Continue reading No clear guidance from methodology [...]
Reporting architect has to take care about all current reporting dimensional requirements are built into company information systems. Has to take care about reporting world: management reporting, expert analysis, internal and official reporting and etc. In addition architect needs to also take care about future reporting scaling and development. In other words, shall current reporting business intelligence system function in future with new reporting features and requirements. Shall current reporting system adopt new requirement easily or with lot of money, human, time effort.
Continue reading Reporting Business Intelligence Architect [...]