Abhishek Yadav

Data Analyst · SQL · Excel · Power BI · Python

Faridabad, Haryana, India

@abhishekkyadavvvv

GitHub LinkedIn

0 followers

🎓 Bachelor of Computer Applications (BCA) at Maharshi Dayanand University (MDU)

Follow Message

About

BCA graduate and aspiring Data Analyst with hands-on portfolio experience in SQL, Excel, Power BI, and Python. Skilled in data cleaning, relational analysis, dashboarding, and using AI-assisted tools to support research, SQL debugging, and documentation while validating outputs independently.

Education

Bachelor of Computer Applications

Maharshi Dayanand University (MDU)

Computer Applications

Computer Applications

Skills

<3 months

SQL Python Pandas Subqueries Aggregation Dashboarding Data Analysis Data Cleaning Data profiling Data validation Microsoft Excel Data Interpretation Relational Databases

Tools / apps / platforms

<3 months

Git GitHub SQLite PostgreSQL Power Query Microsoft Excel Microsoft Power BI

Projects

Student Performance Analysis

Microsoft Excel

Cleaned and validated demographic, education, and score data using PivotTables, formulas, filtering, and summary statistics to compare scores and identify patterns.
Retail Sales Dashboard

Power BI

Built an interactive dashboard tracking sales, item-count, and average-rating KPIs with filters for outlet location, outlet size, and item type.
Customer Churn Analysis

Python, SQL, SQLite

Worked with customer, subscription, and support data to practice cleaning, standardization, missing-value handling, churn-flag creation, and table merges.
E-commerce Sales Dashboard

Microsoft Excel

Built a dashboard with PivotTables, PivotCharts, and slicers to analyze revenue, average discount, regional sales, and revenue by product category.
Advanced SQL Business Analysis

SQL, GitHub

Analyzed sales records using joins, aggregations, subqueries, CTE/window-function concepts, rankings, and trend analysis to answer business questions.
E-commerce Refund & Risk Analysis

PostgreSQL, SQL, Power BI

Built an analytics workflow using 7 related tables and imported raw CSV data into PostgreSQL for profiling and analysis of customer, order, product, seller, return, and refund behavior.

Explore the Broxer community

💬 Q&A Ask about roles, salaries and interviews — and help others. 👥 Circles Join discussions on skills, companies and industries. 📰 Feed Follow updates and insights from the community.