Ayan Khan's Linkedin Analytics

Innovative Data Analyst with experience in analyzing data to extract profitable and insightful stories. I can help companies unlock hidden patterns, reveal valuable trends, and uncover critical business insights that drive informed decision-making. Key Insights from my portfolio projects: ● Detected the Electronics Category's highest ₹21,88,716 discount using Pivot Tables, signaling strong demand. Bundling methods could boost customer satisfaction. ● Predicted total sales for the next 15 days using forecasting techniques, resulting in an average expected sales figure of approximately $5,304 at a 95% confidence interval. ● Pinpointed Flipkart as the highest-volume purchaser with a 0.308% average pre-invoice discount in FY 2021, leading to negotiations for sustainable pricing and boosting profitability. ● Evaluated customer churn rate (30.7%) and transition from free trial to annual plan, finding an average duration of 105 days for 1000 customers using SQL queries. ● Identified Quarter Q4 as the most successful quarter regarding sales volume in 2021 by analyzing sales data, which revealed a record-high quantity sold of 17,447,125 units.