user is expecting mind reading application that will prepare report that uses as a source unstructured data out of information systems…that was not specified and that is changing during deployment…
Continue reading Report Testing with Confused User [...]
Excel loves controlling and controllers (comptrollers) adore Excel mostly due to its superb functionalities. It is love in both way, pure chemical reaction. Therefore Excel is very often used in Controlling processes like planning, reporting and forecasting, budgeting and many more. Yes Excel and Controlling are tightly connected and often wrongly percepted by management and by IT.
Continue reading Excel in Controlling [...]
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 [...]
In controlling department Excel is used to prepare and customize reports, presentations and ad hoc analysis according to management guidelines. Excel provides great functionalities too controllers and is essential tool in everyday work without alternative. On the other side business intelligence software is great in reporting, planning, workflow, consolidation, analysis, masterdata management and similar processes in controlling. Lack of integration between Excel and Business Intelligence software causes many everyday problems.
Continue reading Integrating Excel and Business Intelligence Software [...]