Analyzing customer behavior

📄 Context

We are freelance data analysts and we are hired for the following project:

• E-commerce of electronic products wants to expand its product portfolio, so it would like to know better its customers and their respective consumption patterns, but it has only one year of operation and does not have a large database about them, however, that does not limit us because we can take advantage of the data provided.

💼 Business problem

We wish to expand the product catalog offered based on the sales obtained during the last year.

🚀 Goal

• Generate a visualization and analysis tool that allows us to know our customers better.

📝 Requirements

• An easy-to-use and easy-to-understand visualization tool
• Give insights on customer profiles and their respective consumption patterns
• Which products are the most purchased?
• What are the most popular brands
• What was the best month for sales? How much was earned that month?
• What City had the highest number of sales?
• What products are most often sold together?
• Average time of day when purchases are made

💡Conclusions

Which products are the most purchased?

The three best-selling products fall into the smart tv category, the first is XBR-X50E Sony brand, second one LG B7A Series, and Samsung QF7 Series

What are the most popular brands?

Samsung, LG, Acer, HP

What was the best month for sales? How much was earned that month?

The best month was december, 15.4M dollars of revenue

What City had the highest number of sales?

The best city is San Francisco, 31M dollars of revenue

What products are most often sold together?

Apple Iphone 11 Pro Max and Lenovo Ideapad Slim are one of the most commonly purchased products

Average time of day when purchases are made

Customers prefer to shop between 11 a.m. and 12 a.m. and between 6 p.m. and 8 p.m.

If you would like to download the database I use visit my Github repository