Customer Bank Loan Analysis

Requirements:- Year-wise loan amount Stats Grade and sub-grade wise revol_bal Total Payment for Verified Status vs. Total Payment for Non-Verified Status State-wise and last_credit_pull_d wise loan status Homeownership Vs last payment date stats

HR Analytics Dashboard

Empower HR managers with real-time analytics. • Key Metrics: Attrition rates, employee satisfaction, diversity stats. • Interactive Features: Filter, drill down, and explore data in real-time. • Actionable Insights: Context-rich data for effective strategies.

Customer Churn Analysis

1. Power BI analysis: Segmented customer data by gender, activity, credit card, country, and products. 2. Advanced churn analysis: Discovered retention patterns based on age, credit score, and balance. 3. Interactive, clear data dashboards for informed decisions and customer-centric strategies.

FNP Sales Analysis

I recently worked on an FNP Sales Analysis Dashboard using Excel to uncover key insights about customer behavior, product performance, and sales trends.

UK Road Accident Dashboard

Total Casualties taken after the accident. total casualties & percentage of total with respect to accident severity and maximum casualties by type of vehicle. tal casualties with respect to vehicle type. Monthly Trend showing a comparison of casualties for the current & previous year.

Pizza sales Analysis

1. Total Revenue : The sum of the total price of all pizza orders. 2.Average Order Value : The average amount spend per order, calculated by dividing the total revenue by the total number of orders. 3.Total Pizzas Sold : The sum of the quantities of all pizzas sold. 4.Total Orders : The total number

Call Center Analysis

- Managed 33,000 weekly calls, with peak days on Thursdays and Fridays. - Achieved top call volumes in California and Washington. - Leveraged sentiment analysis on 11,100+ calls for enhanced decision-making. - Led the highest call volume center in Los Angeles, optimizing operations.

Investment Analysis Dashboard

*Developed a robust Gender and Investment Distribution Analysis. *Explored trends in Avenue Types, uncovering dominant investment categories. *Delved into Duration and Avenue correlations for strategic planning. *Examined Mutual Investment patterns, identifying key insights.

Top 1000 YouTubers Analysis

Entertainment dominates with 211 usernames, highlighting diverse content preferences. The US leads with 321 usernames, a 1,589.47% lead over TH, emphasizing global impact. MrBeast's 94.71% share of 5,300,000 likes showcases powerful engagement dynamics. Lifestyle_(sociology) sparks 422,856 comments

Car Dekho Analysis

Anticipated 2023 inventory projection. Detailed breakdown of cars in 2020, 2021, and 2022. Client-requested total cars per year. Fuel-specific insights - diesel and petrol cars in 2020. Comprehensive printout of all fuel-related cars (petrol, diesel, CNG). Identified years with car count exceeding.

Adidas Sales Analysis

I worked on an end-to-end Adidas Sales Analysis project, starting with cleaning and preparing raw data using Power Query