ANSHUL CHAHAR
Gurgaon
Summary
Results-driven Data Analyst skilled in sales analytics, business intelligence, KPI reporting, and dashboard development. Expertise in SQL, Excel, Power BI, Python, Tableau, DAX, and Power Query. Transforms complex datasets into actionable insights, enhances reporting accuracy, automates reports, and drives data-informed decisions through effective cross-functional collaboration.
Overview
1
1
Certification
1
1
year of professional experience
Work History
Data Analyst
V2 Retail
05.2025 - Current
- Developed KPI dashboards and MIS reports for management and business stakeholders, enhancing data-driven decision-making.
- Build interactive Power BI dashboards and visualizations that simplify complex data for management review.
- Conduct trend analysis, forecasting, and performance analytics to support business planning and operational decisions.
- Analyzed sales, inventory, store performance, and operational data using SQL, Power BI, and Advanced Excel to uncover trends and performance gaps.
- Perform data cleaning, transformation, validation, and recurring-report automation to improve data accuracy and reporting efficiency.
- Monitored sales, PSF, inventory turnover, and stock availability to pinpoint opportunities for performance improvement.
- Collaborate with cross-functional teams to understand business requirements and improve operational efficiency and reporting accuracy.
Education
Bachelor of Arts -
Dr. Bhimrao Ambedkar University
Agra01-2023
Skills
- Power BI
- Dashboard Development
- Data Analysis
- Trend Analysis
- Forecasting
- Performance Analysis
- SQL
- Advanced Excel
- Power Query
- Power Pivot
- DAX
- Statistical Analysis
- EDA
- Python
- Tableau
- Stakeholder Collaboration
Certification
- Data Science, Machine Learning, Deep Learning & Generative AI - Ducat Institute
- SQL for Data Analysis
- Advanced Excel for Data Analytics
- Power BI Data Analytics
Projects
- IPL Analytics Dashboard, Power BI, Developed an interactive Power BI and DAX dashboard to analyze team performance, player statistics, and KPI metrics across 1,500+ matches and 250+ player statistics; enabled 40% faster analysis.
- HR Analytics Dashboard, Power BI, Created workforce analytics dashboards for attrition monitoring, employee demographics, and performance analysis across 1,400+ employees; automated reporting and reduced manual effort by 60%.
- Olympic Analytics Dashboard, Power BI, Analyzed 100+ years of Olympic data covering 50+ countries and 1,000+ athletes to visualize medal trends, participation metrics, and country performance.
- Banking Management System, Python, SQLite, Tkinter, Developed a desktop banking application with account management, transaction processing, and database integration.
Timeline
Data Analyst
V2 Retail
05.2025 - Current
Bachelor of Arts -
Dr. Bhimrao Ambedkar University