← All projects

TripleTen Data Analyst Bootcamp · Real Estate Commercial Analysis · 2023–2024 · Rodrigo Garza García

Andes Capital — Real Estate Sales Analysis

Revenue, Property, Channel and Customer Cohort Analysis

Analyzed real estate sales across 2023–2024 through executive KPIs, property and channel performance, geographic and monthly patterns, and customer cohort views in Tableau.

Business objective

Evaluate commercial performance and identify the sales, channel, customer, property and time patterns associated with the results. The project presents three complementary views: Executive Overview, Commercial Analysis and Customer Cohort Analysis.

$6.01BTotal revenue
8,500Sales
$707.4KAverage ticket
$200.63MTotal commission
11.14%Year-over-year growth

Executive overview

Andes Capital executive overview Tableau dashboard
Executive view of total revenue, sales, average ticket, commission, monthly trends, city performance and year-over-year growth.

Commercial performance

Andes Capital commercial analysis Tableau dashboard
Property types, sales channels, customer segments and commercial performance.
DimensionObserved result
Property typesHouses led total revenue; Commercial properties led average ticket; Apartments led sales volume.
Sales channelBroker channel generated approximately 73% of total revenue.
Customer segmentFirst-Time Buyers accounted for approximately 63% of revenue.
GeographyMexico City generated more revenue than Bogotá.
Time patternRevenue peaks appeared around March–April and September–November.

Customer cohort analysis

Andes Capital customer cohort analysis dashboard
Initial cohort sales declined from 224 in January 2023 to 26 in December 2024. Repeat purchases remained visible across cohorts, with rebounds around March–April and September–November.

Recommendations based on the findings

Tools and methods

Tableau Public · KPI analysis · LOD expressions · Cohort analysis · Dashboard design · Data visualization · Data storytelling.

Revenue share and average ticket do not establish profitability. Cohort sales counts do not by themselves measure retention. The monthly patterns describe the two years analyzed and should not be treated as guaranteed future demand. Recommendations are proposed actions; their business impact was not measured. The raw course dataset is not included in the repository.

Project deliverables

Project repository ↗ Tableau dashboard ↗ Jupyter notebook ↗