{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/6e120bc8d89a49a4af28072214cc5db5\" frameborder=\"0\" width=\"1920\" height=\"1440\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1440,"width":1920,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1440,"thumbnail_width":1920,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/6e120bc8d89a49a4af28072214cc5db5-dbf9bd677a0e77c7.gif","duration":614.632,"title":"OLIST Business Performance and Key Insights","description":"I built an OLLIST e commerce performance report using Kaggle datasets released by OLLIST in Brazil. Overall we see 16 million total revenue, about 99.4k total orders, strong revenue growth after 2016, and fulfillment of 96.48k delivered, with 625 canceled orders worth almost 100k at the average order value. Revenue is concentrated in Sao Paulo at about 40 percent of GMV, payment installments average 2 to 3, and repeat rate is very low at around 3 percent. Delivery delays range up to about 21 days by state, freight to price ratios are as high as 53.99 percent in some categories, and this could drive cart abandonment. I did not ask viewers for specific action."}