Brazilian E - Commerce Olist Store
About this project
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:
- More campaigns should be made to encourage transactions of payment to be done other than credit card especially by using Voucher and Debit card
- More adverts should be encouraged in other cities so as to increase revenue and sales of goods
More projects by Olanipekun
