Music Store Analysis

This project aims to derive actionable insights from a music store database by answering a series of business-critical questions through SQL queries. The project focuses on customer behavior analysis, including identifying cities with the highest revenue for targeted promotions, evaluating the effectiveness of various marketing channels, and determining the most popular music genres by country. By leveraging customer lifetime value and spending patterns, the project seeks to inform strategic decisions on customer acquisition and retention, enhance marketing efforts, and optimize resource allocation. Overall, the project's goal is to utilize data-driven approaches to improve business outcomes and customer satisfaction in the music store context.