Founded in 1879, Lechler is Europe’s leading spray technology manufacturer. The company engineers high-quality, precision nozzles and nozzle systems used by companies worldwide. They maintain offices on 5 continents that serve agricultural, environmental, and manufacturing demands in over 50 countries. It insists on superior engineering and performance in its operations to deliver the highest quality experience to customers.
C H A L L E N G E
A thought leader in their own industry, Lechler sought to bring their high engineering and production standards to internal Sales Forecasting. As with other long-lived enterprises, their legacy planning system was built and expanded in Excel. It depended on data manually tabulated from more than 50 spreadsheets, many of which contained complex formulas and macros that performed inconsistently as rows were inserted or links inadvertently broken. The annual sales forecasting process required more than two dedicated head office FTE just over four weeks to collect, cross-check, and consolidate the data and validation files. Because of the manual Excel-based challenges Sales Forecasting was undertaken only once a year.
Executives and Sales Managers needed more timely insight into what happened and anticipate what needed to happen in order to achieve changing targets of the modern global economy and to support the changing needs of their customers.
S O L U T I O N
Lechler envisioned a solution which could integrate with the organization’s recent investment in and choice for company-wide Business Intelligence: Microsoft’s Power BI. A quick “Google” for “planning and forecasting in Power BI” led them to Power ON BI’s Visual Planner. With planning and write-back within Power BI, the demo looked promising, and within days a working prototype proved to be successful.
Within weeks a new and fully operational Sales and Order Intake Forecast was launched across the Sales organization, using Visual Planner from Power ON. Employees and managers immediately accepted the new solution. Staff training took only one hour. The new process allowed front line managers to contribute to the process without compromising security or adding workload and eliminated the manual data preparation and spreadsheet distribution process, clearly demonstrating that how Lechler uses Power ON could have dramatic impacts on sales planning productivity.
R E S U L T
With connected planning within Power BI everyone, from the salesperson to division and regional executives, can review and input data which is immediately visible to all stakeholders using just their web browser. They also appreciate the opportunity to both contribute more value to the process, while simultaneously freeing up more time for higher value work.
With Visual Planner, the company now sees opportunity to be more accurate in scheduling notices sent to customers. How Lechler uses Power ON includes gradually expanding the usage of Visual Planner for Power BI for other Enterprise Performance disciplines like Cost Controlling, Strategy Planning and Profitability Planning.
In a world predominated by uncertainty, being able to deliver advanced insight, and accuracy, is highly valued by all stakeholders: customers, employees, investors, and executives alike.
A B O U T P O M E R O L
Pomerol Partners creates and delivers meaningful data-driven business solutions and services. We’ve been operating in Data Analytics and Intelligence Reporting for over 9 years and our Partners have a cumulative 100 years in global experience. In 2013, Pomerol spun out of Deutsche Bank after a range of successful BI projects were delivered saving the bank over $3m. Ever since then we’ve been partnering with our clients (executives, managers, analysts, etc.) across all business verticals to optimize the intersect between changing business demands, technological progress and sustainable business growth.
Our consultants have helped hundreds of organizations, of all sizes and in all industries worldwide, make money. How do we do this? Leveraging your data to increase revenue, automate processes, decrease costs and understand your insights. Pomerol delivers value that helps you grow and change with better data-driven decisions and solutions that empower you as an Elite Qlik Partner as well as a Gold Data Platform Microsoft Partner.
Our professional consultants, that reside in three countries (United States, United Kingdom and Portugal), are experts that will partner with you for the technical as well as business-oriented solutions. Working with the same team in all capacities ensures you always know where we stand with our work and commitment to you.
Pomerol offers a comprehensive range of Power BI training options. For those new to Power BI, Dashboard-in-aDay will provide give you the knowledge and confidence to build your own dashboards. For those looking to take their Power BI skills to the next level our advanced DAX and M courses will teach you the fundamentals of these two languages and to how to use them to build complex solutions. We also offer bespoke training workshops that can be tailored to your specific training needs.