Abhishek Upadhyay
@abhishekupadhyay2
Skilled data analyst proficient in Excel, SQL, and Python.
What I'm looking for
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.
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.
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.
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.
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
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.
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.
Availability
Location
Authorized to work in
Job categories
Interested in hiring Abhishek?
You can contact Abhishek and 90k+ other talented remote workers on Himalayas.
Message AbhishekFind 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!
