#2 Complete SQL Project - Sales Data Analysis - SQL Project | @drnimishadavis ​

Task: 1. How many unique cities are present in the dataset? 2. What is the city associated with each branch? 3. How many different product lines are included in the dataset? 4. Which payment method is used most often by customers? 5. Which product line has sold the most units? 6. What is the total revenue generated in each month? 7. During which month was the cost of goods sold at its highest? 8. Which product line earned the most revenue overall? 9. Which city recorded the highest total revenue? 10. Which product line had the highest amount of VAT applied? 11. For every product line, is its revenue above or below average? 12. Which branch sold more products than the average across all branches? 13. For each gender, which product line is purchased most frequently? 14. What is the average customer rating for each product line? 15. How many sales transactions occur during each part of the day across all weekdays? 16. Which customer type generates the most revenue? 17. Which city has the highest VAT percentage applied? 18. Which customer type pays the highest VAT on purchases? 19. How many distinct customer types are represented in the dataset? 20. How many different payment methods are used by customers? 21. Which customer type appears most frequently in the dataset? 22. Which customer type makes purchases most frequently based on total spending? 23. Which gender appears most often among the customers? 24. How is gender distributed within each branch? 25. At what time of day do customers leave the most ratings? 26. For each branch, during which time of day are the highest ratings given? 27. Which day of the week receives the highest average ratings from customers? 28. For every branch, which day of the week has the best average customer rating? 👍 Like this video if you learned something new 📢 Share it with your friends or study group 💬 Comment below your thoughts or questions 🔔 Don’t forget to **Subscribe** and hit the bell icon for more real-world SQL & Data Analytics projects! amazon sales analysis, sql projects, data analytics projects, sql for beginners, sql data analysis, portfolio project, data analyst resume project, ecommerce analysis, amazon dataset sql, data analytics career, business analysis with sql, power bi project, tableau analytics, real world sql project, sql internship project, kaggle dataset tutorial, beginner data analyst, end to end data project, data analyst job preparation, sql project demo #drnimishadavis #AmazonSalesAnalysis #SQLProject #DataAnalytics #SQLForBeginners #SQLTutorial #RealWorldSQL #DataAnalysisProject #AmazonData #SQLWithAmazon #EcommerceAnalytics #SQLPortfolio #DataAnalystProject #SQLCaseStudy #SQLStepByStep #BeginnerSQLProject #AmazonDataset #SQLInsights #SQLDashboard #DataScienceProject #SQLResumeProject #SQLWalkthrough #RetailAnalytics #PowerBIProject #TableauProject #MySQLProject #PostgreSQL #SQLQueries #CTEinSQL #GroupBySQL #JoinsInSQL #SQLCapstone #BusinessAnalysis #DataVisualization #SQLExplained #LearnSQL #AnalyticsProject #KaggleDataset #AmazonSQLTutorial #DataDriven #SQLBeginners #DataEngineer #EcommerceData #SalesDataAnalysis #SQLYouTube #SQLJobPrep #SQLLearning #SQLAnalytics #DataPortfolio #SQLVideo #SQLClass #SQLCareer