Open to opportunities

Abhishek Upadhyay

@abhishekupadhyay2

Message

Skilled data analyst proficient in Excel, SQL, and Python.

India

Message

What I'm looking for

I seek a role that fosters growth, encourages collaboration, and values data-driven insights.

I am a passionate data analyst with a Bachelor of Technology in Information Technology, graduating in May 2024. My expertise lies in transforming complex datasets into actionable insights through effective storytelling and problem-solving. I have hands-on experience in data cleaning, analysis, visualization, and dashboard development, utilizing tools such as Excel, SQL, Power BI, and Tableau.

Throughout my academic journey, I have successfully completed several projects, including a dynamic Power BI dashboard for mobile sales analysis and an HR analytics dashboard in Tableau. My projects have not only honed my technical skills but also enhanced my ability to communicate insights effectively. I am committed to supporting data-driven decision-making and continuously improving my analytical skills to deliver impactful results.

Experience

Work history, roles, and key accomplishments

Mobile Sales Data Analyst

Personal Project

Extracted and transformed raw sales data using Power Query, cleaning missing values and utilizing DAX for calculated columns and measures. Developed a dynamic Power BI dashboard showcasing mobile sales with slicers, KPIs, and visuals, building insightful MTD and YoY reports.

Power BI DAX Power Query ETL Data Cleaning Data Visualization KPIs

HR Data Analyst

Personal Project

Visualized HR data in Tableau to analyze attrition trends by gender, department, education, and job role. Created an interactive dashboard showing attrition rate, job satisfaction, and age group trends, revealing a 16.12% attrition rate, highest in Sales.

Tableau Data Cleaning Data Visualization HR Analytics Dashboard Development

Customer Churn Analyst

Personal Project

Performed exploratory data analysis on a telecom customer dataset to identify key drivers of churn. Transformed data using Pandas, handled missing values, and created visuals using Seaborn and Matplotlib, identifying churn trends by contract type, payment method, tenure, and demographics.

Python Pandas Matplotlib SeaBorn Data Visualization

SQL Data Analyst

Personal Project

Analyzed a pizza sales dataset using SQL to extract insights on revenue, sales volume, and peak sales hours. Performed data cleaning and aggregation to identify top-selling pizzas and high-revenue categories, creating reports on daily/monthly trends and average order value.

MySQL SQL Queries Data Cleaning Sales Analysis

Excel Data Analyst

Personal Project

Cleaned raw sales data and utilized pivot tables to calculate revenue, quantity sold, and profit metrics. Built an interactive Excel dashboard with slicers and charts to visualize product-wise, region-wise, and monthly sales, enabling quick insights into high-performing products and seasonal patterns.

MS Excel Pivot Tables Data Cleaning Dashboarding Sales Analysis Data Visualization

Education

Degrees, certifications, and relevant coursework

Chandigarh Group of Colleges, Mohali

Bachelor of Technology, Information Technology

Grade: 7.87 SGPA

Achieved a strong academic performance with a score of 7.87 SGPA. Focused on Information Technology, gaining foundational knowledge and practical skills in the field.