Here is a fantastic Data Analyst case study to check SQL knowledge.
An online bookstore that wants to maximize sales and customer pleasure is the subject of our case study. Your job as a data analyst is to examine sales data and provide conclusions to enhance company performance. You can find patterns, client preferences, and growth prospects by examining data from your books, customers, orders, and sales. In order to increase sales and strengthen the position of the online bookshop in the marketplace, your analysis will help guide decisions about inventory management, marketing initiatives, and customer engagement.
Get the case study from te following link: https://d-i-motion.com/lessons/sql-case-study-3-book-store-sales/
π― Project Objective: The main objective of this case study is to apply various SQL concepts and techniques to answer insightful questions about Book store Sales. Some of the key objectives include:
- Retrieve all books with a price greater than $10.
- Find the total amount spent by each customer in descending order
- Retrieve the top 3 best-selling books based on the total quantity sold.
- Find the average price of books in the Fiction genre.
- Retrieve the names of customers who have placed orders.
- Find the total revenue generated from book sales.
- Retrieve the books with titles containing the word βandβ (case-insensitive).
- Find the customers who have placed orders worth more than $50.
- Retrieve the book titles and their corresponding authors sorted in alphabetical order by author.
- Find the customers who have not placed any orders.
Working on this case study has been an amazing experience, allowing me to dive deep into analyzing book store sales. By leveraging SQL I was able to extract valuable insights and draw meaningful conclusions.