Customer Churn Analysis Dashboard
Analyzed 7,043 records and found that 88% of churned customers were on Month-to-Month contracts. Developed KPIs including Total Customers (7,043), Churn Rate (26.54%), and Churned Customers (1,869). Built an interactive Power BI dashboard with filters across contract type, tenure band, and risk category. Identified 52.94% churn among customers with 0–6 month tenure versus 17.13% for 12+ months. Technologies: Python, SQL, Power BI. Duration: Dec 2024 – Jan 2025.
Sales Performance Dashboard
Wrote 30+ SQL queries using joins to extract revenue, customer, and sales insights. Identified Pune as the top revenue city and Tea as the highest-selling product with 427 units across 1,000 orders. Developed KPIs including Total Revenue (INR 16.45L), Average Order Value (INR 1,645), and Total Quantity (3,067). Built a Power BI dashboard with dynamic slicers. Technologies: SQL, Power BI, Excel. Duration: Feb 2025 – Mar 2025.
Amazon Prime Video Content Analysis
Analyzed 9,655 titles from 1920–2021 across 25 content ratings, 519 genres, and 5,771 directors. Cleaned and transformed data using Power Query. Found that Movies represented 80.82% of titles and TV Shows 19.18%. Identified Drama and Comedy as the most popular genres and 13+ as the most common rating. Built an interactive Power BI dashboard featuring country-wise distribution, release trends, genre filters, and content rating analysis. Technologies: Excel, Power BI. Duration: Mar 2025 – Apr 2025.