← All projects

TripleTen Data Analyst Bootcamp · Business Performance Analysis · Jan–Jun 2025 · Rodrigo Garza García

RappiPlus — Business Performance Analysis

Data Quality, Profitability, Funnel, Retention and Checkout Testing

Combined data-quality review, product-level profitability, conversion-funnel and cohort-retention analysis, and checkout A/B test evaluation using Python, SQL, statistical testing and Tableau.

Business questions

Adjusted operating view

The raw dataset reported $51.99M in revenue. A small number of extreme-quantity records had a disproportionate effect, accounting for 81.45% of reported revenue and 91.12% of known product cost. The dashboard therefore presents an adjusted view that excludes extreme and invalid quantities to better represent typical operating performance.

$9.64MAdjusted revenue
$3.83MKnown product cost
$5.78MProduct-level profit before marketing
$385.97Average order value
1.50Average items per order
6,284Units of top-selling product

The top-selling product by units was Vacuum-Pro-Black. Product-level profit is before marketing and other operating expenses and only includes orders with known product costs.

Customer behavior and checkout experiment

AreaResultBusiness interpretation
Conversion funnelLargest relative drop: begin_checkout → add_payment_info; stage conversion 86.71%.The checkout-to-payment-information step is the clearest point for further review.
RetentionWeek-3 retention was approximately 40%–44%; February cohort was highest at 43.98%.February provides a useful comparison point, without establishing why its result was higher.
Checkout A/B testControl 15.69%; treatment 16.29%; p-value 0.4161.No statistically significant evidence that the tested checkout UI change improved conversion.

Data quality and preparation

Dashboard deliverables

RappiPlus executive overview dashboard
Executive Overview — adjusted revenue, cost, profit, average order value, monthly performance and category results.
RappiPlus order and product detail dashboard
Order & Product Detail — units sold, product quantity, cost, revenue and profit with filters.

Business recommendations

Tools and analytical methods

Python: pandas, data cleaning, validation and exploratory analysis. SQL: funnel analysis, cohort retention and conditional aggregation. Statistics: two-proportion z-test and hypothesis testing. Tableau: KPI dashboards, filters, interactive views and business storytelling.

The SQL queries are included in the public notebook, but execution requires access to the original TripleTen training tables and a PostgreSQL connection. Credentials and the original course database are not included. The checkout experiment is not statistically significant; recommendations are proposed actions, and their business impact was not measured. Funnel event counts do not prove that every user followed a strictly sequential path.

Project deliverables

Project repository ↗ Tableau dashboard ↗ Jupyter notebook ↗