Data Analyst | SQL | Python | Power BI
About Me
I'm Nikhil Yadav, a BCA 2nd year student and an aspiring Data Analyst. I work with SQL, Python, and Power BI to understand data and find useful insights.
I enjoy solving problems using data and creating simple dashboards that make information easy to understand. I'm currently focused on building my skills through practice and real-world projects.
I'm looking for opportunities to learn, grow, and gain hands-on experience in data analytics.
Projects
Blinkit Sales Analysis
Performed end-to-end analysis of Blinkit sales data using Python to uncover trends in product performance, pricing, and outlet impact.
Key Insights:
- • Tier 1 & 2 outlets outperform Tier 3 in average sales
- • Pricing has a stronger impact on sales than item visibility
- • Supermarket Type 1 contributes highest sales volume
GitHubCustomer Analytics Project
End-to-end customer behavior analysis using Python, SQL, and Power BI to identify trends and improve business decision-making.
Key Insights:
- • Identified high-value customer segments
- • Analyzed purchasing patterns across categories
- • Built interactive dashboard for business insights
Zepto SQL Data Analysis
Analyzed e-commerce inventory dataset using SQL to extract business insights related to pricing, stock, and product performance.
Key Insights:
- • Identified top discounted and high-demand products
- • Found high-value items that are out of stock
- • Analyzed revenue contribution by category
Spam Detection Using Naive Bayes
Built a spam classification system from scratch using pure Python without any machine learning libraries.
Key Insights:
- • Implemented Naive Bayes with Laplace smoothing
- • Used log-space computation for numerical stability
- • Classifies messages with probability-based scoring
Technical Skills
Data Analysis
Python
Visualization
Cloud
AWS (basic)Tools
Git & GitHubAI & Automation
ClaudeCertifications
Data Analysis with Python
IBM (Cognitive Class)
Intro to Data Analytics
Simplilearn SkillUp
SQL Foundation
Skill Course (Learn More Pro)
