Alexander is working as a Business Intelligence Consultant at IT-Logix AG. IT-Logix is a Swiss Business Intelligence, Data Warehouse and Big Data expert.
Alexander is a Master of Business Informatics who studied at the Management Center in Innsbruck, Austria. After a couple of stopovers in the areas of IT support, IT project management and consulting services for test-automation he started his career at IT-Logix in Bern, Switzerland in 2013. Within the company he is working as a Business Intelligence Consultant for SAP Business Objects Frontend-Tools, SAP Business Objects Platform and since June 2015 he is head of the testing division. Very early he got in touch with the SUCCESS formula of IBCS® and could use this knowledge in a couple of customer projects and also to support his colleagues.
Today he focuses on IBCS® notation concepts, report development, data visualization, configuration and optimization of the SAP Business Objects BI Platform, and migrations with the SAP Business Objects BI Platform.
IBCS® Certified Consultant
Alexander Pröm has successfully completed the IBCS® certification for successful design of reports and presentations at the HICHERT+FAISST IBCS Institute in April 2015.
This example is a redesign of a traffic accident statistic with the standard features of SAP Business Objects Web Intelligence BI 4.1. Find the original document here.
A message was not included because it is not a report but a statistic. The title has been removed from the table, placed, according to IBCS®, on the top left and was adjusted with all required measures and dimensions. Unnecessary lines and colors have been removed and for better recognizability of the previous and actual year values semantic lines were added. The total line has been moved to the bottom and has been renamed from “Total” to “Alle Zustände”. To correctly display all of the variance values, plus-signs were added to the positive numbers. The illustration of accidents in % of the total with a pie chart is not very meaningful. As the information about accidents can easily be read directly out of the table, there is no need for a redundant chart. The space of the pie charts can be useful used to show relative variances. To show these values, 3 Pin-Charts were added and aligned to the table segments.
... and after
This example is a redesign of page 10 and 11 from the annual report 2013 from HG Commerciale with the standard features of SAP Business Objects Web Intelligence BI 4.1. Find the original document here.
Basically the whole report had potential for a redesign with IBCS® – for simplification a small extract has been taken. The two pages contain an collection of partial data wrapped in continuous text. In cases where measures were mentioned there is often the comparison (e.g. to previous year) missing or they are not exhaustive (e.g. economic growth of countries). In the text itself, many mundane phrases like “cautious”, “weakened”, “positive contribution”, “strong increase” and “loss of dynamic” were used without giving evidence about facts or numbers. The two charts are hardly readable and do not have the same time horizon. Because of the vertical lines in the charts it is not clear where the timeline for the years start (e.g. 2002). The grey background color makes it difficult to see the lines (e.g. grey line on grey background!). At the beginning of the text there is a title which was obviously meant to explain the content – it doesn’t.
The redesign started by giving the report a message and highlight the mentioned facts. The various numbers from the text have been consolidated in tables to make them structured and clearly readable – because of many missing values further research has been necessary. The tables were designed without vertical lines and semantic horizontal lines – according to the IBCS® Standards. For the redesign of the charts, stacked column-charts have been chosen as the proper visualization and labels were added. The legend has been removed and has been replaced by labels at the edge of the charts. The scaling of both charts has been adapted to be equal and as there is a total sum (“Bauausgaben”) but no measure for the rest on the chart “Bauinvestitionen”, the chart has been renamed to “Bauausgaben” and the measure “sonstiges” has been added. (Despite researching, there was no label found which makes more sense).
... and after