Back to search

University of Nevada - Reno

Business Intelligence for U.S. Agricultural Trade: Design and Implementation of an Interactive Power BI Dashboard

Abstract

dc:description.abstract

Reliable agricultural trade information is essential for guiding production, policy,and market decisions, yet these datasets are often scattered, inconsistently formatted, and difficult for non-specialists to interpret. This thesis presents an interactive vi- sualization system that integrates multiple U.S. Department of Agriculture (USDA) datasets including the Foreign Agricultural Trade of the United States (FATUS) and state-level trade summaries into a unified analytical dashboard built in Microsoft Power BI. The dashboard allows users to explore trade patterns across products, states, and years using interactive maps, bar charts, and key performance indicators. Distinct color schemes clearly separate exports and imports, helping users follow trade flows and compare major commodities such as corn, soybeans, and cotton. Filters support flexible analysis, making it possible to observe how trade relationships shift over time and across regions. Validation included technical checks and a usability study with graduate students and researchers at the University of Nevada, Reno. Participants completed a set of analytical tasks and rated the dashboard's navigation, filters, and visual clarity. Most tasks were answered accurately, with only minor confusion on questions involving geographic interpretation. Questionnaire ratings were consistently positive. ANOVA results showed no significant effects of computer proficiency or frequency of data-tool use, but familiarity with visualization tools did have a significant impact, with more experienced users reporting smoother navigation and clearer filter interactions. Overall, the dashboard effectively transforms fragmented agricultural trade data into clear, interactive insights. It supports accessible exploration of U.S. trade pat- terns for users with diverse experience levels and offers a practical, scalable model for developing analytical dashboards in other domains requiring transparency, usability, and data-driven understanding.

Degree

thesis:*
Level thesis:degree_level
Master's Degree
Department thesis:degree_department
Computer Science
Year dc:date.issued
2025

Author and committee

dc:creator, dc:contributor.*
Author dc:creator
  • Ghaed, Maryam
Advisor dc:contributor.advisor
  • Dascalu, Sergiu
Committee members dc:contributor.committeemember
  • Edberg, Dana
  • Harris, Fred

Rights

Language dc:language.iso
en_US, English

Identifiers

dc:identifier.*
Repository record dc:identifier.uri
https://scholarwolf.unr.edu/handle/11714/11743

Chain of custody

source
Harvested from
University of Nevada - Reno
Base URL
scholarwolf.unr.edu/server/oai/request
Last updated
2026-11-19
Source record
OAI-PMH GetRecord
related terms
citation

Ghaed, Maryam. Business Intelligence for U.S. Agricultural Trade: Design and Implementation of an Interactive Power BI Dashboard. Master's Degree thesis, 2025. https://scholarwolf.unr.edu/handle/11714/11743