An e-commerce company called Benvindo, located in Brazil has shared their data with you. General Management is interested in learning more about your business operations. They want to know more about your products and your customers so they can make decisions about your product lines. ๐ง
๐ค They are not sure which products are the most valuable to their customers and it seems to them that they can optimize their inventories by better selecting their offer to the public.
- What are the product categories that have the most sales?
- Which categories have the highest shipping costs?
- Which of these categories, taking only the shipping cost, has the highest profit margin?
- We believe that the products with the best reviews are the ones with the most sales. It really is that?
- What is the type of payment preferred by customers? And does it coincide with the type of payment with the highest flow of money?
Carry out an analysis of this data to find any insight that seems relevant to the company. Explain the process you carried out, if you developed any cleaning and preparation process for your data, the conclusions you reached, and the limitations or improvements that the analysis has.
Explore the information provided to you to arrive at your results. Graph or present in tables the information that seems most relevant to you. Present recommendations based on your discoveries.
- olist_order_items_dataset.csv
- olist_order_payments_dataset.csv
- olist_order_reviews_dataset.csv
- olist_orders_dataset.csv
- olist_products_dataset.csv
- product_category_name_translation.csv
The first step to solve the case was to understand the data and create the respective database using PostgreSQL to read and store the different .csv files creation database and his respective entity-relationship diagram.
In the file queries.sql were created the respective queries to answer the different questions proposed.
In the Python notebook challenge1.ipynb the queries were used to create different data frames and then create different graphs to present the results in a visual format.
- What are the product categories that have the most sales?
- Which categories have the highest shipping costs?
- Which of these categories, taking only the shipping cost, has the highest profit margin?
- We believe that the products with the best reviews are the ones with the most sales. It really is that?
- What is the type of payment preferred by customers? And does it coincide with the type of payment with the highest flow of money?
- How are the sales in the time for the products wich have the higgest sales?
Top five products
Bed bath table
Health beauty
Sports leisure
Furniture decor
Computers accesories
- There are any relationship between the volume of the products, the profits and the freight value
All the categories
Top five categories in sales