Tilo Sommerwerk, Dipl. Ing.

Tilo Sommerwerk studied computer engineering at the TU Berlin. Since 2004, he has worked as an IT consultant for the design and creation of state-of-the-art reporting solutions. His main professional focus is on Microsoft SQL Server Reporting Services in conjunction with the SUCCESS Notation. Particularly the subject of SUCCESS Notation continues to excite him because it enables him to provide customers with important company data in easily understood form at the push of a button.
Tilo Sommerwerk works for PTS Group AG and you can reach him This e-mail address is being protected from spambots. You need JavaScript enabled to view it .

HICHERT CERTIFIED CONSULTANT (HCC)
Mr. Sommerwerk has successfully completed training in the SUCCESS Rules on the Design of Reports and Presentations with HICHERT+PARTNER.

Work samples 
(The pictures will zoom automatically on mouse-over. Click to open an enlarged picture.)

The following work samples (in German) are from Tilo Sommerwerk

Example 1

Fruit Trade
The Fruit Trade Report is based on a concept for English-speaking customers. It 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.
Further reports that permit a detailed analysis are part of the design. 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.

Example 2

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 SUCCESS reporting notation from Hichert+Partner, 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.
Further reports were part of the scope of design, which ensured a more detailed analysis.
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.