Brazilian E - Commerce Olist Store​

Olist is the largest department store in the market Place in Brazil.It connects small businesses from all the country to be able to channel orders without having any difficulties with transactions​

Data Source: by Quantum Analytics NG

Visualization Tool : Power BI

The data contains information of orders from the year 2016 to 2018 made at multiple market sections in Brazil.

Insights Generated

Total Order : 99K

Number of Customer : 99k

Total Seller : 3,095

Total Seller City : 611

Total Product Category: 72

Average Review Score : 4

Payment Type : 4

Sum of Payment Value by Payment type : The credit card was used the most for transactions having a proportion of 78.3% and the least debit card

Price Trend by year : There is a progressive increase in price from 2016 with a peak in 2018 corresponding to 61k

Price by Seller City (Top 5)

The city Votorantim had the highest price of

goods with the least city Xaxim

NoOrdered Delivered by Customer State ( Top 5): SP has the highest ordered Delivered and the least state of order is TO

Recommendations:

1. More campaigns should be made to encourage transactions of payment to be done other than credit card especially by using Voucher and Debit card

2. More adverts should be encouraged in other cities so as to increase revenue and sales of goods