Portfolio Details
Agricultural Supply Chain Dashboard
Project information
- Category: Agricultural Supply Chain Analytics
- Client: AgroFruits (International Agricultural Company)
- Tools Used:Power BI, DAX, Excel, Geographic Analytics, Seasonal Analysis, Transportation Logistics, Farm Management Systems
- Key Features: Revenue tracking ($234M), volume analysis (75M units), seasonal crop monitoring, multi-farm profitability analysis (Moonlight Farm $59M, Green Haven $33M), global import/export mapping, transportation optimization (Truck 44.91%, Airplane 34.91%, Ship 15.05%), monthly crop seasonality tracking with fruit-specific analytics.
- Project date: December 2023
- Project URL: Report Link
Agricultural Supply Chain Dashboard
Developed a comprehensive agricultural dashboard for AgroFruits providing complete visibility into revenue ($234M) and production volumes (75M units) across multiple farms and international markets. The system tracks seasonal crop patterns with detailed monthly analysis, monitors farm-level profitability across 7 major farms including Moonlight Farm ($59M) and Green Haven ($33M), and provides global import/export visualization. Features advanced transportation logistics optimization showing distribution across truck (44.91%), airplane (34.91%), and ship (15.05%) methods, enabling data-driven decisions for seasonal trends, logistics optimization, and international agricultural trade operations.