Tilo Sommerwerk is Senior Business Intelligence Architect at New Yorker, a German fashion company.
Dipl. Ing. Tilo Sommerwerk studied computer engineering at the TU Berlin. Since 2004, he is a highly sought-after IT consultant, successfully designing and developing state-of-the-art reporting solutions. He has particular expertise in Microsoft SQL Server Reporting Services (especially in connection with IBCS® notation) and corporate information design, which he consistently proves to his customers. Particularly the subject of corporate information design continues to excite him because customers want important company data relevant to the decision-making process visualized optimally at the push of a button. Moreover, his expertise in MDX (query language for multi-dimensional databanks) must be pointed out
IBCS® Certified Consultant
Tilo Sommerwerk has successfully completed the IBCS® certification for successful design of reports and presentations at the HICHERT+FAISST IBCS Institute in October 2010.
The ‘Fruit Trade Report’ is a dashboard that conveys a general overview of the fruit trade. This clearly illustrates where the problems are to be found. Displaying numerous key data over the course of the year including identification of problems presented a special challenge. The concept was implemented with Crystal Reports in the customer’s reporting system.
Upper left: Shipments are shown in green for the course of the year. In addition, the values for the previous year appear in light gray slightly offset in the background. Relative deviations are displayed above.
Lower left: The main target countries for the fruits are shown. Adjacent to this is the respective rate for punctual deliveries.
Center: Return shipments were made when fruit was either not purchased or had defects. This shows the numbers and relative deviations, as well as the percentage of the original deliveries.
Right: Service quality is a list of the main key performance indicators, shown over the course of the year. In order to detect problems instantly, the points at which thresholds are exceeded are highlighted.
Fruit dealer compensation
The dashboard shown appears extremely unusual at first glance. In fact, it is a neutral dashboard taken from a current project, in which an interactive dashboard was designed and implemented for a well-established logistics company using Microsoft Reporting Services 2008 R2.
Through the strict application of the IBCS® reporting notation, the dashboard shown here provides an immediate overview of the company’s general trend in costs. It is important to be able to analyze partners, on one hand, and the profitability of the logistics company is visualized, on the other. Integration of the narrow range of tolerance into both the positive and negative direction presented a particular challenge.
Upper left: Deviation in compensation between setpoint and actual in absolute and relative values. Moreover, the deviation is cumulative to show how strong the deviation over a period is. This can be compensated or lead to substantial cumulative values.
Lower left: The compensation is displayed over the course of the year. In addition, the values for the previous year appear in light gray slightly offset in the background.
Upper right: This shows fruit dealers who have either received too much (Flop) or too little (Top) compensation. In addition, every row shows the main key performance indicators of a dealer in order to be able to quickly classify the effect of the figures on the business.
Below: The quality of the fruit plays a decisive role in sales. The main indicators are summarized here.