DataViz - Agribusiness
How I helped centralize the consultation and analysis of strategic and operational data for a large agribusiness company, facilitating processes and decisions.
Client
Timac Agro
Methodology
Branding Data Visualization Immersion with stakeholders Prototyping Validation
Sector
Agribusiness
Data
September 2023
The Challenge of Improving Data Access for Strategic and Operational Teams
The initial need was to improve the experience of the strategic and operational areas of the company in accessing analytical and strategic information. Until then, data was mostly consulted through Excel reports, which made the process time-consuming, less interactive, and non-collaborative. The goal was to develop dashboards in Power BI that centralized and facilitated access to this information for different levels of users, from the strategic committee to the operational teams.
Designing a management platform using dashboards
The challenge was to identify the real needs of the users, analyze the limitations of the current dashboards, and design a new structure that was intuitive and capable of providing quick and relevant insights. This new structure, called Management Platform, was organized into six main dashboards: Portfolio Management, Team Management, CTC Management, SRV Management, and Results Analysis. These dashboards needed to encompass a series of specific metrics and functionalities to support daily monitoring and strategic decision-making.
Structuring dashboards to meet needs and expectations
During the deepening process, conducted over three days, we carried out interviews and detailed analyses of the current dashboards with stakeholders to identify the main pain points and expectations.
Exploration of Current Limitations: We understood the limitations, such as navigation difficulties, lack of customization, and gaps in functionalities.
Mapping of Expectations: We defined ideal functionalities and metrics for each dashboard.
Development of the Dashboards: We structured the six main dashboards with the identified priority functionalities, such as viewing by market/product hierarchy, period comparisons (MTD, YTD, FY), and team performance views.
