Business Intelligence for Agricultural Foreign Trade: Design and Application of Power BI Dashboard

Karen Guadalupe Sanabia-Lizarraga, Blanca Carballo-Mendívil (), Alejandro Arellano-González and Alfredo Bueno-Solano
Additional contact information
Karen Guadalupe Sanabia-Lizarraga: Campos Bórquez, Ciudad Obregon 85010, Mexico
Blanca Carballo-Mendívil: Industrial Engineering Department, Sonora Institute of Technology, Ciudad Obregon 85130, Mexico
Alejandro Arellano-González: Industrial Engineering Department, Sonora Institute of Technology, Ciudad Obregon 85130, Mexico
Alfredo Bueno-Solano: Industrial Engineering Department, Sonora Institute of Technology, Ciudad Obregon 85130, Mexico

Sustainability, 2024, vol. 16, issue 21, 1-25

Abstract: In today’s rapidly evolving business landscape, data analytics has become a critical tool for organizations striving to remain competitive and make informed decisions. Although technology facilitates data analysis, many decision-makers need more technical knowledge to use these tools. This project focuses on developing a business intelligence system in Power BI to analyze agricultural exports from Mexico as part of the Agro-logistics Observatory, aiming to bridge this gap and make data more accessible for non-technical users. The objective is to create an interactive panel that would allow users to visualize and compare export and import data, thereby supporting decision-making for both business and academic purposes. The methodology involved collecting and cleaning data from various sources, such as public institutions, and a modeling process that integrates geospatial data and economic classifications. Key performance indicators (KPIs), such as trade balance and the export share by-product, were designed and calculated to identify critical products and trade patterns. Although similar approaches have been presented in the literature, the novelty of this research lies in the detailed presentation of its methodology, which provides a step-by-step guide for its replication that is often lacking in other studies. In addition, it offers a dashboard that integrates data from various sources, presenting them through easy-to-interpret visualizations so that stakeholders can quickly and efficiently access valuable information beyond traditional data visualization. Furthermore, the project highlights opportunities for improvements in data visualization, including integrating more specific product data and enhancing the dashboard’s capabilities through predictive analysis.

Keywords: business intelligence; dashboard; foreign trade; agricultural sector (search for similar items in EconPapers)
JEL-codes: O13 Q Q0 Q2 Q3 Q5 Q56 (search for similar items in EconPapers)
Date: 2024
References: View references in EconPapers View complete reference list from CitEc
Citations:

Downloads: (external link)
https://www.mdpi.com/2071-1050/16/21/9576/pdf (application/pdf)
https://www.mdpi.com/2071-1050/16/21/9576/ (text/html)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:gam:jsusta:v:16:y:2024:i:21:p:9576-:d:1513187

Access Statistics for this article

Sustainability is currently edited by Ms. Alexandra Wu

More articles in Sustainability from MDPI
Bibliographic data for series maintained by MDPI Indexing Manager ().