← All projects

TripleTen Data Analyst Bootcamp · Commercial Performance Analysis · 2024–2025 · Rodrigo Garza García

Andes Retail — Commercial Performance Analysis

Commercial Performance Across 2024–2025

Compared Andes Retail Group's 2024 and 2025 performance across revenue, margin, orders, customer segments, product categories, geography and seasonality using Tableau dashboards.

Business objective

Understand how commercial performance changed between 2024 and 2025 and identify the product, customer, geographic and seasonal patterns associated with those changes. The work is presented through an executive overview and a detailed dashboard.

−6.8%Revenue change
−6.9%Margin amount change
−3.9%Orders change
−3.0%Average order value change (approx.)
Metric20242025Change
Revenue2,863,3842,668,610−6.8%
Margin1,005,811.62935,937.71−6.9%
Orders2,5502,450−3.9%
Average Order Value1,122.901,089.23Decreased

Across both years, the dataset records 5.53M in revenue, 1.94M in margin and 5,000 orders.

Dashboard — Overview

Andes Retail commercial performance dashboard overview
Executive view of KPIs, monthly trends, customer segments and product categories.

Dashboard — Detail

Andes Retail commercial performance dashboard detail
Geographic, seasonal and product performance, including order-level detail.

Key findings

Recommendations based on the findings

Tools and methods

Tableau Public · Business Analysis · Data visualization · KPI analysis · Dashboard design · SCQA business communication.

Margin is a monetary amount, not a percentage or net profit. Lower segment totals do not by themselves establish lower customer value. Monthly results and the dataset's Season labels are separate views; Summer is not assumed to mean June–August. The observed patterns do not establish the causes of the decline. Recommendations are proposed next steps; their business impact was not measured.

Project deliverables

Project repository ↗ Tableau dashboard ↗ Jupyter notebook ↗