Conmetall Meister: Sales reporting with DeltaMaster reports
Conmetall Meister, a system supplier for hardware stores, uses DeltaMaster to analyze data from SoftM and SAP. More than 100 users use the centrally provided reports. The main focus is on sales.
Conmetall Meister offers around 40,000 products. The result is a high degree of data complexity, as Mirco Lischka, controller at Conmetall Meister, explains: “Our various sales organizations mean we have more than 30 million data records in our sales system alone, including 22 million billing items. We also have around six million order items in Procurement, 420,000 product data records, over 30,000 profitability segments for customers, and around 6,500 for suppliers.”
Conmetall Meister was previously unable to fully harness the benefits of analyzing this diverse pool of data. “We were able to generate revenue and gross profit. Other important key figures, however, had to be calculated manually, which was a timeconsuming process,” Lischka explains. “This involved using vast and unwieldy walls of Excel spreadsheets to prepare analyses manually.”
In addition to more flexible analyses, Conmetall Meister wanted to be able to provide employees at departmental management level and senior managers with easily comprehensible reports in a simpler and more needs-oriented manner than was previously the case.
DeltaMaster impresses with variety and functions
When it came to selecting a suitable analysis and reporting tool, Conmetall Meister left nothing to chance: The IT department presented various OLAP-based solutions to a committee of employees from the specialist departments. These solutions were then evaluated in the form of a questionnaire.
The DeltaMaster business intelligence suite from Bissantz met with the best response among users. Decisive factors besides its intuitive operation were the variety of analysis options, its refined report distribution functions, and its ease of connection to the ERP systems.
Report distribution using DeltaMaster Repository
One particularly valuable component for Conmetall Meister is the DeltaMaster Repository, a central database for the provision of applications and reports. Conmetall Meister uses it to supply its employees with reports.
Role management is used to define exactly who gets to ‘see’ which reports. Unlike report distribution in file format, this ensures that reports are not reproduced and amended in an uncoordinated manner.
“DeltaMaster allows us to provide our managers with clearly visualized reports on a centralized basis. And we can control precisely what information and functions are offered to each user.”
Mirco Lischka, controller at Conmetall Meister
Key figures and comparisons
The ‘Daily Billing’ statistic is among the most important reports. It shows the revenue billed on a given day, the monthly projection and target, as well as a prior-period comparison between the average daily value for the same month of the previous year and the current value – all broken down by product range, customer group, etc.
The sales team uses the central statistics to obtain information on revenue, margins, and target-actual variances. Field sales employees are provided with analyses of actual and target revenue and the number and length of visits to a given customer.
Procurement receives key figures such as stock levels and turnover, purchasing advantages and disadvantages, purchase volumes, and purchase price development. The development of missing quantities in the individual product segments and the main product groups is also reported. As the parent of Conmetall Meister, the Würth Group is regularly provided with key figures such as the revenue, gross profit, as well as customer and product structure of the Conmetall Meister group. Analyses of delivery quotas, credit notes, and missing quantities are also provided.
Visualization with Graphical Tables
Graphical Tables from DeltaMaster ensure that information is not only available, but also understood: “Revenue variances are visualized using sparklines, bars, and colors. Red stands for negative developments, blue for positive ones. The development of margins is presented using line sparklines,” Lischka explains. “This allows patterns and trends to be identified at a glance, followed by a deeper analysis of the data in order to establish the precise relationships.
Now we can see what is happening more quickly and more accurately. To give an example: Previously, we were only able to examine the success of our customer business once a quarter. The necessary figures had to be painstakingly extracted from the transactional systems and processed in Excel. Now we can generate the information directly in DeltaMaster and see how successful our customer business has been for each product segment at the end of each month – at the touch of a button.”
Looking to the future: Analysis AND planning
Lischka adds that in the future the business intelligence solution will also be used for planning: “We are currently developing a DeltaMaster application that will allow us to plan all revenues and costs that are allocable to our customers and product segments. We also intend to run our P&L planning in DeltaMaster.”
- More than 100 DeltaMaster users
- Reports made available via central database
- Flexible analysis and simple report distribution
- System supplier for hardware and DIY stores both nationally and internationally
- 40,000 stock items: tools, ironware, garden, bathroom, power tools, electrical installation
- Part of the Würth Group
- 900 employees