AU
Open to opportunities

Abhishek Upadhyay

@abhishekupadhyay2

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

India

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

PP

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.

PP

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.

PP

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.

PP

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.

PP

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.

Education

Degrees, certifications, and relevant coursework

CM

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.

DS

Dolphin Public School

Intermediate (CBSE), General Studies

Grade: 87.8%

Completed Intermediate education with a strong academic record, achieving 87.8%. Focused on a comprehensive curriculum as per CBSE standards.

Tech stack

Software and tools used professionally

Interested in hiring Abhishek?

You can contact Abhishek and 90k+ other talented remote workers on Himalayas.

Message Abhishek

People also viewed

View all talent

Find your dream job

Sign up now and join over 85,000 remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan
Abhishek Upadhyay - Mobile Sales Data Analyst - Personal Project | Himalayas