By implementing advanced Business Intelligence practices, Natural One has achieved an estimated savings of R$1,400,000 over the past 6 years.
With consulting from Grupo IN, the company evolved from decentralized bases, lack of governance and a structure supported by spreadsheets to an intelligent and collaborative structure based on Data Science and Qlik platforms.
THE Natural One, a pioneer and leader in the natural juice segment and second in the Brazilian ready-to-drink juice market, is solidifying its position as a data-driven companyThe company has transformed its management and optimized processes, from sales to the organizational climate. All of this is driven by the implementation of solutions Qlik and strategic consulting of the IN Group, in addition to a robust data architecture accelerated by the creation of its Data Science in 2023.
By implementing advanced Business Intelligence practices, Natural One has achieved an estimated savings of R$3.3 million over the past six years. These figures represent significant gains resulting from greater operational efficiency and data-driven decision-making.
Data Lake and Qlik: the basis of evolution
Natural One's journey towards a data-driven culture had as a relevant milestone the implementation of its data lake, with the use of the Snowflake platform. This centralized data repository not only improved communication between the company's databases but also ensured greater storage security and eliminated downtime in the ERP system, which was previously occasionally overloaded by the simultaneous use of on-premises systems.
“The data lake has enabled Natural One to advance its data roadmap. It offers scalability, flexibility, and centralization of data, reduces costs, and drives innovation. With simplified access and support for advanced analytics, it enables fast and accurate decisions, making it essential for data-driven companies.“, states Ana Laura Rui Oliveira, Data Science Leader at Natural One. “The low-code Snowflake platform makes day-to-day administration easier, even without an in-house team of data engineers. Having the support of Grupo IN to assist with adjustments and changes ensures smooth and efficient lake management.“, adds Ana Laura.
Currently, the Qlik extracts data directly from the raw layer of the data lake. Dedicated extractors transform this raw data into tables, applying business rules to generate QVDs (QlikView Data). These optimized files feed the 90 dashboards available for use and others 25 administrative dashboardsThe most accessed dashboards are those that provide information on revenue, inventory, and portfolio, totaling about 20 that are essential for monitoring volume and order goals. To achieve this, Natural One uses solutions Qlik Talend for data integration, orchestration and monitoring, and Qlik Cloud for viewing.
“The IN Group helped us structure, organize, and implement the company's main data projects, such as the data lake, data architecture, and support with Qlik and Snowflake, with extreme efficiency and professionalism. We count on them to continue evolving.”, highlights the executive.
“Natural One's transformation is a concrete example of how data intelligence can directly impact a company's strategy and results. From the structuring of the data lake to the implementation of Qlik dashboards, we've closely followed the company's evolution toward a truly data-driven culture. It's gratifying to see an innovative Brazilian company with a global presence use cutting-edge technology to transform processes, empower people, and make decisions with greater agility and security. For us at Grupo IN, it's an honor to be part of this journey.”, explains Bruno Guerra, CEO of the IN Group
The number of Qlik platform users at Natural One has grown exponentially. Since 2019, when the company took its first steps into business intelligence, there has been a increase of 70% in the scope of accesses. At the moment, 80% from the administrative team from Natural One has access to Qlik, demonstrating the dissemination of the data culture within the organization.We have earned the trust of employees and senior management by delivering reliable data in real time and demonstrating results.“, explains Ana Laura.
The executive highlights two projects recently delivered to the areas as current milestones in Natural One's trajectory as a data-driven company: PED+, for the commercial area, and the G&G Project – People and Management, for the HR sector.
PED+ Project: Business Data in the Palm of Your Hand
O PED+ Project is a clear example of how data intelligence empowers Natural One's sales team. Through a mobile app, salespeople have access to Essential KPIs such as revenue versus target and inventory. This data is tracked individually and personalized, allowing each salesperson to view their performance against the target, broken down by channel, customer, line (refrigerated or ambient), category (package size), and flavor, down to the minimum SKU granularity.
The goal has been to provide updated data several times a day to field salespeople, enabling them to be more assertive in their strategies with each customer and knowing what the company has in stock, guided by the sales targets for each SKU.
Data for people management and improving the organizational climate
O People & Management Project (G&G) Qlik arose from the need to decentralize and streamline people management indicators. Before implementation, data such as turnover, absenteeism, overtime, time bank, and costs were made available monthly via Excel reports, a time-consuming and department-specific process.
“We studied the end-to-end processes and developed an API that, in partnership with the payroll company, brings monthly data directly to the Data Lake. From this repository, the information is consumed and visualized in Qlik.“, explains Ana Laura.
One of the great differences of this project is the security in the circulation of sensitive data, such as payroll costs, which come directly from the bucket from the partner to the data lake and from there to Qlik, automatically and securely. Furthermore, G&G was the first project with section access lock, providing a fully customized data visualization per manager.
“This empowers managers to independently monitor their teams' metrics, enabling them to navigate with greater efficiency and purpose. The project also brought greater awareness of team well-being (absences, hours worked, sick leave, overtime) and tighter control of costs per employee, resulting in better budget management and allocation.“, adds Ana Laura.
Natural One remains committed to becoming an increasingly data-driven company, leveraging the intelligence it generates to drive growth, optimize operations, and ensure employee and customer satisfaction. With a solid foundation and strategic partnerships, the company is ready for the challenges ahead and to explore the full potential of data intelligence.
In short, the company embarked on a digital transformation journey marked by significant challenges: decentralized foundations, a lack of governance, and a structure supported by Excel spreadsheets hosted on physical servers. But the obstacles went beyond technology, also involving organizational culture, agility, and a vision for the future. What was once fragmented is now part of an intelligent, collaborative, and scalable structure. With the implementation of Qlik and the creation of a dedicated data science area, the company restructured its entire data architecture, migrated to the cloud, and centralized its sources in a robust data lake.
Natural One's key figures as a data-driven company
- 90 dashboards available for use;
- 25 dashboards administrative (extractors and transformers);
- 70% growth in the scope of access to the data platform since 2019;
- 80% from the administrative team from Natural One has access to Qlik.
About Natural One:
Natural One is a Brazilian company born from the desire to offer a product unlike anything else people have ever experienced. To develop its technological development in the production and packaging of juices and functional beverages, the company has worked with technology partners in Germany. Today, Brazilians and people around the world are already enjoying the benefits of green cap juice. Besides Brazil, the company operates in Chile, Canada, Mexico, China, Indonesia, Malaysia, Angola, and other countries.
About Grupo IN
With 20 years of experience in the market, Grupo IN's purpose is to continue to be a trusted partner for organizations seeking innovative data solutions in business intelligence. Over these two decades, Grupo IN has expertise in data analysis and advanced technology, empowering companies and governments to make strategic decisions with confidence, optimizing processes and driving growth and maturity in the Data Journey. In 2023, Grupo IN was acquired by NowVertical, expanding its operations to a global level and further strengthening its ability to be a trusted partner for organizations seeking innovative data solutions.
EN 
PT 
