Ayan Khan

Ayan Khan Email and Phone Number

Data Analyst • Excel | SQL | Python | Power BI | AWS • I smoke Data joints and tell insightful stories @ Urban Space
Ayan Khan's Location
Ahmedabad, Gujarat, India, India
About Ayan Khan

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.

Ayan Khan's Current Company Details
Urban Space

Urban Space

View
Data Analyst • Excel | SQL | Python | Power BI | AWS • I smoke Data joints and tell insightful stories
Ayan Khan Work Experience Details
  • Urban Space
    Data Analyst
    Urban Space Jun 2024 - Present
    Ahmedabad, Gujarat, India
    ● Developed a Python automation script that streamlined a daily task of two employees, saving 24 hours a month and 288 hours annually with 100% accuracy.● Implemented Power BI dynamic dashboards for five E-commerce marketplaces, tracking 80% of topline metrics to help founders monitor business health and make data-driven decisions.
  • Vibranium™
    Talent Manager
    Vibranium™ Jul 2020 - Jan 2021
    Bengaluru, Karnataka, India
    ● Attracted and managed over 2000 new artists within the first week using effective and persuasive communication, at the young age of 19.● Identified that 74.3% of artists were Indians by precisely analyzing data in Excel, providing valuable insights into the composition of our customer base.● Simplified complex blockchain technology to over 80% of new audience, guiding them to sell their first NFT in cryptocurrency.● Propelled the marketplace into the Top 50 Indian Startups of 2020, using strategic initiatives that solidified our position.(I worked here after completing my high school)

Ayan Khan Education Details

Frequently Asked Questions about Ayan Khan

What company does Ayan Khan work for?

Ayan Khan works for Urban Space

What is Ayan Khan's role at the current company?

Ayan Khan's current role is Data Analyst • Excel | SQL | Python | Power BI | AWS • I smoke Data joints and tell insightful stories.

What schools did Ayan Khan attend?

Ayan Khan attended Lj University.

Not the Ayan Khan you were looking for?

  • Ayan Khan

    Talent Acquisition Professional | Team Leader | Passionate About Managing And Building Strong, Effective Teams .
    Lucknow
  • AYAN KHAN

    Student At Anjuman College Of Engineering & Technology
    Nagpur
  • Ayan Khan

    Building Tripaway Journey
    New Delhi
  • Ayan Khan

    Software Engineer @Vericapreact | Next.Js | Node.Js | Typescript
    Bengaluru

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.