Data Analyst with 1+ years in Power BI, SQL, and Advanced Excel for data-driven insights.
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Ayush Sambhare is an aspiring Data Analyst with strong skills in data manipulation, visualization, and analytical problem-solving. Through various projects, including building dashboards for EV sales and public transport management, he has demonstrated proficiency in Power BI, SQL, Advanced Excel, Python, and other data analysis tools. His certifications further highlight a solid foundation in data science and analytics with AI.
Sant Gadge Baba Amravati University
Bachelor of Engineering · Electronics and Telecommunication Engineering
August 1, 2021 – June 30, 2025
EV Sales Dashboard
September 1, 2025 – June 1, 2026
Constructed an interactive Power BI dashboard tracking Electric Vehicle (EV) sales in regions, manufacturers, and vehicle categories, analyzing records. Processed and transformed raw EV sales records using Power Query, applying data type corrections, column splits, filters, and merges, strengthening reporting consistency by 30%. Developed visualizations including bar charts, line charts, donut charts, KPI cards, and maps, highlighting trends in total sales, year-over-year growth, and model outcomes. Created DAX measures to calculate total sales, 12% growth, 18% market share, and YoY comparison for products, enabling data-driven business insight. Visualized EV adoption trends across 28 states and 10 categories, pinpointing high-growth regions and low performing areas to guide targeted marketing strategies.
Public Transport Management
August 1, 2025 – June 1, 2026
Constructed a complete relational database system for a Public Transport Management project using MySQL, creating tables for stations, routes, buses, passengers, and trips. Executed complex SQL queries with joins, subqueries, grouping, HAVING filters, and aggregate functions, analyzing system usage and passenger demand patterns, enhancing data insight reliability by 35%. Generated analytical SQL queries and identified capacity constraints, route delays, high-demand lines, and passenger trends, supporting data-driven transport planning for urban routes. Analyzed 50 bus routes, 50 buses, and 50+ trips, assessing operational patterns, identifying trends, and supporting recommendations, improving public transportation planning and scheduling. Assessed overcrowded trips by comparing passenger counts against bus capacities, detecting high-demand gaps, enabling corrective measures for optimized transport resource allocation and service planning.
HR Analytics Dashboard
July 1, 2025 – June 1, 2026
Implemented an HR Analytics Dashboard in Microsoft Excel, tracking workforce metrics such as Attrition Rate, Active Employees, Employee Count, Average Age, and Department-wise attrition for employees. Applied advanced Excel features, including Slicers, PivotTable filters, VLOOKUP/XLOOKUP, and formulas to automate calculations, improving reporting accuracy by 32% and reducing manual efforts. Analyzed attrition trends, employee demographics, and performance metrics using Pivot Tables/Charts, identifying high-risk departments and supporting 20% improvement in workforce retention strategies. Designed a management-ready HR dashboard visualizing key metrics, enabling 25% faster insights, improving workforce planning, and strategic insights.
Python Essentials for Data Science
IT Vedant
November 1, 2025 – Present
Power BI Essentials
IT Vedant
September 1, 2025 – Present
Advanced Excel
IT Vedant
August 1, 2025 – Present
SQL Mastery
IT Vedant
August 1, 2025 – Present
Master's in Data Science and Analytics with AI
Unknown
July 1, 2025 – Present
Cultural Fit Analysis
The candidate's academic projects demonstrate a breadth of skills relevant to data analysis, including data visualization, database management, and HR analytics. The certifications further reinforce a commitment to learning and skill development in key areas. The projects are diverse enough to suggest adaptability to different data domains. However, all projects are academic, which limits the assessment of real-world collaboration and problem-solving within a professional team setting.
Soft Skills & Operational Fit
The candidate's project descriptions indicate an ability to analyze complex data, identify patterns, and present findings clearly, which are crucial for a Data Analyst role. The focus on improving reporting consistency and accuracy suggests an attention to detail and a results-oriented approach. However, without direct work experience or psychometric test results, it's difficult to fully assess stress handling, team collaboration, or broader work attitude.