Back to Developers
Nikhil Pandey

Nikhil Pandey

Data Analyst | Power BI Developer

Indore, MP 452001 85 ยท Excellent

About

Results-driven Data Analyst and Power BI Developer with hands-on experience in Power BI, SQL, DAX, Power Query, Excel, and dashboard development. Proficient in data cleaning, ETL processes, data transformation, visualization, and KPI reporting. Designed and delivered interactive dashboards to analyze sales trends, customer behavior, and business performance. Adept at translating complex data into actionable business insights to support data-driven decision-making.

Skills & Expertise (26)

Microsoft Excel Advanced
8.5/10
5
Years Exp
Power BI Advanced
8.0/10
5
Years Exp
Advanced Excel Advanced
8.0/10
5
Years Exp
Pivot Tables Advanced
8.0/10
5
Years Exp
Dashboard Development Advanced
8.0/10
5
Years Exp
DAX Advanced
7.5/10
4
Years Exp
SQL Advanced
7.0/10
4
Years Exp
Business Insights Advanced
7.0/10
4
Years Exp
Data Modeling Advanced
7.0/10
4
Years Exp
Charts Advanced
7.0/10
4
Years Exp
KPI Reporting Advanced
7.0/10
4
Years Exp
Data Transformation Advanced
7.0/10
4
Years Exp
Data Cleaning Advanced
7.0/10
4
Years Exp
Power Query Intermediate
6.5/10
3
Years Exp
ETL Intermediate
6.5/10
3
Years Exp
Python Intermediate
6.5/10
3
Years Exp
Statistical Analysis Intermediate
6.0/10
3
Years Exp
Pandas Intermediate
6.0/10
3
Years Exp
Google Sheets Intermediate
6.0/10
3
Years Exp
Macros Intermediate
6.0/10
3
Years Exp
MySql Intermediate
6.0/10
3
Years Exp
VBA Intermediate
5.5/10
2
Years Exp
Risk Assessment Intermediate
5.0/10
2
Years Exp
ChatGPT Beginner
4.0/10
1
Years Exp
Claude Beginner
4.0/10
1
Years Exp
Gemini Beginner
4.0/10
1
Years Exp

Work Experience

Data Analyst

Adidas

Present - Present

Built an interactive Power BI dashboard to analyze $163M in sales, $60.56M profit, and 407K units sold, enabling stakeholders to identify trends across regions and time periods. Identified September as the top-performing month and the Southeast region as the highest-revenue area through time-series and geospatial analysis. Analyzed product and retailer performance using DAX measures; Men's Street Footwear ($36M) and Foot Locker ($60M) emerged as top performers, informing inventory and marketing strategy.

Data Analyst

Coffee Trends

Present - Present

Developed DAX measures and KPIs for Total Spend, Average Spend, and Peak Hour Sales, enabling granular spend pattern analysis. Discovered 8 PM as the peak sales hour and identified weekdays as contributing 80% of total revenue, providing actionable scheduling and staffing recommendations. Built an interactive Power BI dashboard to analyze coffee sales, spending trends, and product performance, reducing manual reporting time significantly.

Education

Bachelor of Technology in Computer Science and Engineering - RGPV University, Bhopal

2021 - 2025 ยท Afghanistan

Certifications

Deloitte Data Analytics Job Simulation

Forage ยท 2026

KPMG Career Catalyst: Audit Job Simulation

Forage ยท 2026

Interested in this developer?

Profile Score Breakdown

๐Ÿ“ท Photo 10/10
๐Ÿ“„ Resume 10/10
๐Ÿ’ผ Job Title 10/10
โœ๏ธ Bio 10/10
๐Ÿ› ๏ธ Skills 20/20
๐ŸŽ“ Education 10/10
โฑ๏ธ Experience 5/15
๐Ÿ’ฐ Rate 0/5
๐Ÿ† Certs 5/5
โœ… Verified 5/5
Total Score 85/100

Profile Overview

Member sinceJul 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation