Transformative solution for growth of sustainable farming

Background

The leading irrigation company in the Limpopo Province, Bekmar Irrigation is dedicated to providing advanced drip and micro-irrigation solutions for sustainable, cost-effective farming. With a strong commitment to efficient resource use, Bekmar needed equally efficient systems for its own operations—starting with sales reporting. The company approached Keyrus with a critical need: streamline and enhance their existing manual, Excel-based sales reporting process.

Challenge

Bekmar’s sales reporting process involved multiple, interlinked Excel sheets that required daily manual updates. Not only was this process time-intensive, but it also limited the company’s ability to gain meaningful insights from their sales data. To address these challenges, Bekmar required to reduce manual effort, automate sales reporting and ensure comprehensive data capture.

Approach

To meet Bekmar’s expectations, Keyrus implemented a robust, hybrid-cloud-based reporting solution designed to optimise Bekmar’s existing data sources while providing scalability for the future. The solution leverages SQL Server, SQL Agent Jobs, T-SQL, and Tableau Cloud to automate data movement, transformation, and reporting. Automated merge statements in SQL Server ensure that the staging database is continuously updated with new and modified records from SAP through a Linked Server, ensuring accurate and current data availability. Keyrus transformed the data via output views from the staging area, merging it with a secure, relational Data Warehouse. The data is indexed and optimised for fast access and flexibility. Once processed, the data model is ready for visualisation in Tableau. The interactive reports include filters that allow Bekmar’s team to focus on specific sales insights, supporting targeted action.

Key results

Benefits

This fully automated solution has redefined Bekmar’s approach to sales data, enabling them to focus on analysis rather than maintenance. The customer transitioned from a manually ran analytics to a modern, efficient, and scalable automated solution. Through this transformative solution, Bekmar Irrigation eliminated manual work, improved reporting accuracy, and embraced data-driven insights for a future of strategic, data-led growth in sustainable farming.

What our clients say

By partnering with Keyrus, Bekmar has not only optimised our reporting processes but has also laid the foundation for a future of strategic, data-led growth in sustainable farming.

Paul van den Berg, Managing Director, Bekmar Irrigations

Share this key play