How do Brazilian shoppers pay, and does paying in installments change anything?
View as table
| Payment type | Sales (BRL) | Share of ~15M |
|---|---|---|
| Credit card | ~12M | ~80% |
| Boleto | ~2.8M | ~19% |
| Vouchers and other | Small remainder | ~1% |
I analyzed the Olist Brazilian e-commerce dataset from Kaggle to understand how customers pay, and whether paying in installments relates to order value and satisfaction.
Just over half of delivered orders were paid in installments. Boleto, a Brazilian bank-slip payment, came second to credit cards at about 2.8M, and vouchers were small. Monthly sales grew steadily from late 2016 into 2018.
Role: Analyst
Power BI, Power Query, DAX and data modeling, from raw tables to the finished report.
Clean first.
I cleaned and typed the data in Power Query, and fixed the headers of the category translation table.
Date and plan.
I created a custom Date table and a calculated "Payment Plan" column that labels each order as Installments or Paid in full.
DAX measures.
Total Sales, Total Orders, % Installment Orders, Avg Order Value, Avg Installments and Avg Review Score.
One clean filter.
A report-level filter keeps delivered orders only, so every number on the page counts the same thing.