Avocado Demand & Pricing Analysis

An Excel based analysis using pivot tables and dashboards to explore demand trends, regional differences and price sensitivity.

Context

This project analyses US avocado sales data to understand how demand varies over time, region, and price. The analysis was completed as part of the Generation UK Data Analyst programme that focuses on applying Excel-based analytical techniques to a real-world retail dataset.

Aim

The aim of the analysis was to identify key demand patterns, regional differences, and pricing relationships in avocado sales, supporting more informed forecasting, pricing, and inventory decisions.

Approach

📂Data preparation

Cleaned and structured raw sales data to ensure accuracy
Applied conditional formatting to highlight price variation and outliers
Prepared data for flexible aggregation across time, region, and product type

📊Staging & Pivot Tables

Built a dedicated staging area to support analysis
Created pivot tables by year, region, avocado type, and price
Enabled dynamic exploration of trends using slicers and filters

📈Visualisations

Developed charts directly from pivot tables to maintain data integrity
Selected chart types based on comparison and trend analysis goals
Annotated visuals to highlight key patterns and business implications

Summarises key demand, pricing and regional patterns identified during the analysis, allowing using to explore trends interactively.

Key Insights

Regional concentration

A small number of regions account for a large share of total avocado sales, while many other regions only slightly contribute.

Product type performance

Conventional avocados dominate overall sales, with organic representing a significantly smaller proportion of total demand.

Price sensitivity

Higher avocado prices are generally associated with lower demand, suggesting that pricing plays a key role in influencing sales volume,

Recommendations

Based on the analysis of avocado sales, the following actions could support overall performance.

🥑Plan Seasonal promotions

Review demand trends across seasons and align promotions and offers with low-demand periods. Accounting for seasonal fluctuations can help stabilise sales performance.

📍Focus on High Demand Regions

Since a small number of regions account for a large proportion of total demand, prioritising product availability for these regions could deliver the greatest impact on overall sales.

💲Use Pricing to Support Demand

Higher prices are associated with lower demand, suggesting that pricing decisions influence sales volume. Monitoring price demand patterns can support more informed pricing adjustments during slower periods.

Reflections

This was the first project I completed as part of my Generation training. It strengthened my ability to use Excel pivot tables to explore sales data, identify commercial patterns and translate trends into actionable recommendations.

Back to Projects

Page updated

Google Sites

Report abuse