GreenFood – a holistic view on business
GreenFood is the largest independent fruit and vegetable operator in the Nordic region. When the company grew and introduced a new ERP system, GreenFood needed to structure and future-proof its business intelligence solution in a QlikView environment.
Enfo and GreenFood’s collaboration started with a preliminary study in which the different target groups and needs were structured to ensure future benefits and value. Enfo studied the underlying technical structure using QlikView Deployment Framework and made sure that relevant data was uploaded from the various companies and the different source systems. Initially, focus was on sales and the importance of providing correct data and information to management and sales reps.
"I’ve worked quite a lot in QlikView and have a good grasp of the tremendous possibilities that are available. Enfo has mainly helped me prioritize among all the ideas and focus on what is most business-critical. I have gotten good guidance and technical competence for a future-proof BI solution we can grow with," says Johan Wohlin. Today, QlikView is used for analyzing many areas, such as sales, purchasing and waste follow-up.
They’ve also recently started looking into quality processes and traceability possibilities. For sales analysis, the sales reps now have an improved outline and can see the whole transaction with a specific customer. Sales reps can also easily create customer-specific reports that are sent directly to the customer with information about what the customer has bought, average prices, etc.
BI grows with the organization
The BI solution has grown with the organization — introduced in Sweden on a small scale, and now used by all the organizations. When NAV was implemented in Finland, the BI solution was included for analysis of incoming deliveries, losses and sales. Enfo aided the introduction, which meant that most parts could be applied “as is” a solution which of course was both simpler and cheaper. “If Finland had chosen to introduce their own BI solution, it would have cost ten times more. Now we could basically ”copy-paste” it. There are also major benefits of working similarly throughout the group,” says Johan Wohlin.
Linked data provides effective performance management
By linking sales and purchasing data with business data, GreenFood controls its operations more efficiently. The sales reps get greater insight into the whole transaction with a specific customer, from purchasing and production to delivery. By quickly and simply presenting customer-specific reports, customer service is also improved. GreenFood also uses QlikView to visualize and monitor losses.
Now we can calculate losses based on business data and take preventative measures which is proof that business intelligence solutions create direct business value.
Linking data also means that traceability has increased significantly. For instance, when alerts of problems with a product or a commodity come in, it’s important to control the logistics chain in order to see where certain lots are, when something was produced, which raw materials were used, etc. This kind of information is available in accounting and business systems, yet thanks to the BI solution, GreenFood gains even higher insight, reduced response times and improved customer service.
"Being able to respond and take action quickly to alerts regarding our products increases safety and also the level of customer service. In tests, we have reduced the response time from two hours to a few minutes, which is fantastic," says Johan Wohlin.
The vision is fully comparable data
As GreenFood had different business systems, questions have been raised about comparability and which data is correct. The issue has not yet been solved entirely, but the vision is a Business Intelligence solution with completely comparable data resulting in a common vision and single truth.
Tips and lessons
Johan Wohlin is happy to share his three top tips for other companies on the verge of implementing a Business Intelligence solution.
1. Start small and grow with the solution.
Build a house rather than a castle. Keep in mind that ” less is more.” We’ve developed and so has the solution along with us. The key to success is to constantly check and validate.
2. The consultant should have industry and business insight.
Make sure the consultant helping you is well versed in the industry and understands your business.
3. Get to know and understand the origin of the data.
By having a good grasp of source data and systems, it’s easier to build a good Business Intelligence solution.