Introducing 

Prezi AI.

Your new presentation assistant.

Refine, enhance, and tailor your content, source relevant images, and edit visuals quicker than ever before.

Loading…
Transcript

Olist

Name Thavethini MURUGATHAS

Department Data analyst

Institution Simplon.co

Introduction

Brazilian E-Commerce Public Dataset by Olist

Introduction

What is the olist?

  • Olist is an e-commerce company based in Curitiba, Brazil
  • Founder Tiago Dalvi created Olist in 2015 with the goal of helping shopkeepers reach larger and the best marketplaces nationally and internationally.
  • Olist is among the Top 3 largest department store inside Brazil’s largest marketplaces and has generated $1.8 Million in revenue annually.
  • Olist is the largest department store in Brazilian marketplaces. Allows merchants from small businesses throughout Brazil to sell their products and ship them directly to the customers through Olist’s logistics partners.

Databases

Database

The dataset has information of 100k orders from 2016 to 2018 made at multiple marketplaces in Brazil. Its features allows viewing an order from multiple dimensions: from order status, price, payment and freight performance to customer location, product attributes and finally reviews written by customers. We also released a geolocation dataset that relates Brazilian zip codes to lat/lng coordinates.

we have 9 Tables with dataset

https://www.kaggle.com/olistbr/brazilian-ecommerce#olist_products_dataset.csv

Analysis

1. ANALYSIS OF THE CUSTOMERS DATABASE

2. PAYMENTS METHODS

3. DELIVERED STATUS

4. PRODUCT CATEGORY CUSTOMER RATINGS

5. WHEN ARE CUSTOMERS ORDERING?

Analysis

Conclusion

  • Need to be competitive with pricing in the market
  • Shipping – reduce delivery times and provide accurate estimations of delivery time
  • Low brand awareness

Thank you

THANK YOU

Learn more about creating dynamic, engaging presentations with Prezi