SQL Data Analytics Project: Apple iTunes Music Store Analysis with Tableau Dashboard

🚀 Apple iTunes Music Analysis | End-to-End SQL Data Analytics Project In this project, I analyze the Apple iTunes relational database using SQL to uncover actionable business insights related to customer behavior, revenue performance, genre popularity, and operational efficiency. 🔍 Project Highlights: • Customer Lifetime Value (CLV) Analysis • Repeat vs One-Time Customer Segmentation • Inactive Customer Identification (Retention Analysis) • Revenue Trends & Monthly Performance • Media Type Revenue Breakdown (MPEG vs AAC) • Genre & Artist Performance Ranking • Employee Revenue Contribution • Interactive Tableau Dashboard 🛠 Tools Used: • SQL (SQLite) • Tableau Public • CSV Data Files • GitHub for Documentation 📊 Key Insights: • 27% customers inactive in last 6 months • 90% revenue from MPEG audio files • Rock genre generates highest revenue • Revenue concentrated among top customers 📁 GitHub Repository: [Paste your GitHub link here] 📈 Tableau Dashboard: [Paste your Tableau Public link here] If you found this helpful, like 👍 and subscribe for more data analytics projects! #SQL #DataAnalytics #Tableau #DataAnalystProject #BusinessAnalytics #PortfolioProject