Make Me Ideas
Interactive Business Intelligence dashboard for the agricultural sector that combines production, crime, demographic, and weather data to optimize strategic decisions
For Make Me Ideas, I developed the 'AgroBI' web app for one of their clients, Verqor—a company focused on implementing technology, innovation, and strategies that accelerate agricultural production. The dashboard combines historical agricultural production data, crime statistics, demographic, and climate data with the client's internal information. One of my key skills is developing interactive, intuitively interpreted dashboards that prioritize information so that insights emerge at a glance.
Verqor is an agricultural business company that provides financing and markets fertilizers and agrochemicals. Their goal is to implement technology, innovation, and strategies to accelerate agricultural production, digitalizing the field and evolving alongside it.
The challenge was to develop a tool that could consolidate multiple critical business information sources and present them in a clear, interactive, and actionable way for strategic decision-making.
I developed an interactive online dashboard combining historical agricultural production data across Mexico, broken down by region, state, municipality, and crop type.
The system integrates: Production Value, Production Volume, Planted Area, Harvested Area, Yield, and Average Rural Price. It includes Market Share analysis and Production Cycles that help identify business opportunities and optimize commercial strategies.
The platform combines agricultural production info with monthly-updated crime statistics, establishing trends with the same geographical breakdown: National, Regional, State, Municipal, and Crop-specific.
This information is vital for Verqor's business as it allows for assessing risks and opportunities across different areas of the country.
Additionally, I integrated demographic data, weather patterns, and Verqor’s internal information—including prospects, granted credits, loan amounts, and renewals—creating a comprehensive data ecosystem for decision-making.
One of my key skills is developing dashboards that are interactive and intuitive, prioritizing information and applying strategies to ensure conclusions are apparent at a glance.
I use color schemes, comparative charts, and relational indices. For example, comparing regional performance against state and municipal performance to analyze deviations: 'Municipality X performed 10% above the regional average, and its crime index places it in the lowest incidence segment.'
I prioritize presenting information that facilitates interpretation and aligns with client goals. I believe every user should be able to interpret the data, thereby enriching insights from different perspectives.
Based on the data, I also developed a view that translates results into text through pre-established criteria, making it easier to communicate complex insights clearly and directly.
Quarterly, I produce an advanced report on the generated information, tailored to the client's specific needs, allowing for strategic business monitoring and early identification of trends and opportunities.
Hablemos sobre cómo puedo ayudarte a alcanzar tus objetivos
Iniciar Conversación
