RappiPlus Performance Dashboard
RappiPlus Performance Dashboard
An interactive Power BI report turning cleaned e-commerce data into a live view of revenue, profit, and product performance.
An interactive Power BI report turning cleaned e-commerce data into a live view of revenue, profit, and product performance.
Once the underlying RappiPlus data had been cleaned and analyzed, the results were sitting in a Jupyter notebook, useful for the analysis itself, but not something a business stakeholder could open and explore on their own. The goal was to turn those numbers into an interactive report anyone could filter by month or country, drill from a category-level overview down into a single product's performance, and check without needing to read code.
This dashboard is built on a deeper analysis: data cleaning, cohort retention, and A/B testing in Python and SQL.
Connected the cleaned datasets (orders, product catalog, and marketing spend) as the data source for the report.
Built DAX measures for total revenue, profit, and profit margin, calculated so they stay accurate at every filter level — whole business, one category, or one product.
Designed a 3-page report: a Performance Overview with KPI cards and trend charts, a Product & Order Details page with a full order-level table, and a drill-through page that opens a dedicated view for any single product.
Added Month and Country slicers across every page, so the whole report re-filters live to any time period or market.
Published the report to Power BI Service as a shareable, interactive link.
Over the 6-month period analyzed, the dashboard shows $9.61M in total revenue and $2.91M in profit, a 30.27% overall margin. Revenue holds steady month to month (between $1.44M and $1.66M), while profit trends upward, from $0.49M in January to $0.51M by May and June. Revenue splits almost evenly across the three product categories: Home, Electronics, and Fashion each bring in roughly $3.2M. But Home is the most profitable category ($2.0M profit vs. ~$1.9M for the other two).
Vacuum-Pro-Black, Blender-XL-Red, and Jacket-Winter-M are the best-selling products by units (~6.3K each), notably ahead of electronics like Laptop-Gaming-16GB (4.2K). Drilling into Blender-XL-Red specifically shows Mexico as its top market (2.2K units), ahead of Colombia (2.1K) and Argentina (1.9K), at a 31.18% margin.