__STYLES__
📄 Context
We are freelance data analysts and we are hired for the following project:
💼 Business problem
We wish to expand the product catalog offered based on the sales obtained during the last year.
🚀 Goal
📝 Requirements
💡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