University of Nevada - Reno
Business Intelligence for U.S. Agricultural Trade: Design and Implementation of an Interactive Power BI Dashboard
Abstract
dc:description.abstractReliable 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