Download PDF
Kullenbergs analyzes its way into the future with QlikView
Technology Category
- Analytics & Modeling - Real Time Analytics
Applicable Industries
- Agriculture
- Retail
Applicable Functions
- Sales & Marketing
Use Cases
- Supply Chain Visibility
- Inventory Management
Services
- Data Science Services
The Challenge
Kullenbergs Maskiner AB, one of Sweden’s largest distributors within the agricultural business, was struggling with a manual information reporting process. The company was unable to efficiently analyze the large volume of data from its warehouse, which contained almost 100,000 different articles. This was a significant challenge as the organization was not capable of analyzing all the reports manually. The company was also reliant on outside vendors for system maintenance and modifications, which was not ideal. The company needed a solution that could automate the data analysis process, increase operational efficiency, and reduce reliance on outside vendors.
About The Customer
Kullenbergs Maskiner AB is one of Sweden’s largest trading companies within the agricultural business with a market share of close to 35%. The company has been in operation for over 135 years. It has 120 employees and grosses around €37 - €43 million from its six facilities in the south Swedish province of Skåne. Each facility consists of a center for spare part sales and a large sales and service area. The company's warehouse contains a huge volume of almost 100,000 different articles, which is more than twice the size of General Motors’ warehouse.
The Solution
Kullenbergs deployed QlikView to 10 employees plus various customers. With QlikView across 5 functional areas, Kullenbergs now analyzes customer segmentation, profitability, customer needs, parts availability, and service performance - all focused on driving a more efficient and effective operation. With the QlikView Server, Kullenbergs easily handles the large data volume of more than 100,000 warehouse articles. The company was so impressed by its new business intelligence system that it adopted QlikView as its new information system for the enterprise. The company also plans to allow customers to see product availability and make purchases online.
Operational Impact
Quantitative Benefit
Related Case Studies.
Case Study
Intelligent Farming with ThingWorx Analytics
Z Farms was facing three challenges: costly irrigation systems with water as a limited resource, narrow optimal ranges of soil moisture for growth with difficult maintenance and farm operators could not simply turn on irrigation systems like a faucet.
Case Study
Greenhouse Intelligent Monitoring and Control Solution
Farming Orchids is the most successful form of precision farming in Taiwan, and also the most exported flower. Orchids need a specific temperature and humidity conditions to grow and bloom, and its flowering time may not be in line with market demands, so the price collapses when there is overproduction. Therefore, some farmers began to import automated greenhouse control systems for breeding and forcing, which not only improves quality, but also effectively controls the production period and yield to ensure revenue. In 2012, an orchid farmer built a Forcing Greenhouse of about 200 pings (approximately 661 Square Meters) in Tainan, Taiwan. The system integrator adopted Advantech’s APAX-5000 series programmable automation controllers to build the control platform, coupled with Advantech WebAccess HMI/SCADA software, to achieve cloud monitoring. The staff of the orchid field can monitor important data anytime via smart phone, iPad, and other handheld devices, and control the growth and flowering conditions. System requirements: In the past, most environmental control systems of orchid greenhouses in Taiwan used PLCs (Programmable Logic Controller) with poorscalability and control, and could not be connected to the Internet formonitoring from the cloud. For advanced database analysis and networking capability, the PC platform must be adopted. Therefore, PAC Systems (Programmable Automation Controller) with both PLC programming capabilities andPC functions is a better choice.The environmental control of the Orchid greenhouse switches on and off devices like fan, shade net, cooling/heat pump, liquid flow control, water-cooling wall etc. It is controlled by a control panel of electric controllers, and is driven by a motor, to adjust the greenhouse temperature, humidity, and other environmental conditions to the set parameters.
Case Study
Improving Production Line Efficiency with Ethernet Micro RTU Controller
Moxa was asked to provide a connectivity solution for one of the world's leading cosmetics companies. This multinational corporation, with retail presence in 130 countries, 23 global braches, and over 66,000 employees, sought to improve the efficiency of their production process by migrating from manual monitoring to an automatic productivity monitoring system. The production line was being monitored by ABB Real-TPI, a factory information system that offers data collection and analysis to improve plant efficiency. Due to software limitations, the customer needed an OPC server and a corresponding I/O solution to collect data from additional sensor devices for the Real-TPI system. The goal is to enable the factory information system to more thoroughly collect data from every corner of the production line. This will improve its ability to measure Overall Equipment Effectiveness (OEE) and translate into increased production efficiencies. System Requirements • Instant status updates while still consuming minimal bandwidth to relieve strain on limited factory networks • Interoperable with ABB Real-TPI • Small form factor appropriate for deployment where space is scarce • Remote software management and configuration to simplify operations
Case Study
Enabling Internet of Things Innovation in Agriculture
DigiBale, wanted to apply technology know-how and IP from implementations successfully to more agriculture sectors including cotton, forestry, sugarcane and cattle. However, farmers and growers still have worries about the connected technology.