Yash Pohekar

Aspiring Business Analyst | Data Analyst
Pune, IN.

About

Highly motivated and analytical Business Analyst and Data Analyst with a strong academic foundation in statistical analysis, data visualization, and practical application. Proficient in leveraging Excel, SQL, Power BI, and Python to clean, analyze, and translate complex datasets into actionable insights. Proven ability to identify critical trends, build interactive dashboards, and drive data-informed decision-making and business growth, as demonstrated through a 5-month internship and impactful academic projects.

Work

NMD Infotech PVT.LTD
|

Data Analyst - Internship

Pune, Maharashtra, India

→

Summary

As a Data Analyst Intern, I specialized in data analysis and dashboard creation, delivering actionable insights for real-time business operations.

Highlights

Spearheaded data analysis and dashboard creation initiatives over a 5-month internship, delivering actionable insights for real-time business operations.

Leveraged expertise in Excel, SQL, Power BI, and Python to process and analyze real-time business data, supporting critical decision-making processes.

Applied robust analytical and problem-solving methodologies to optimize data workflows, contributing to enhanced data integrity and reporting accuracy.

Education

Chandigarh University
Chandigarh, Punjab, India

→

Master of Computer Application (MCA)

Data Analytics

Dhayan Bharti College
Pune, Maharashtra, India

→

Bachelor of Science

Science

Certificates

Data Analysis Internship Certification

Issued By

NMD Infotech pvt.ltd

Data Analysis Essentials

Issued By

Microsoft and LinkedIn

Data Analytics Essential

Issued By

Cisco Networking Academy Program

Skills

Data Analysis & Visualization

Data Analysis, Business Analysis, Data Cleaning, Data Management, Data Visualization, ELT, Statistical Analysis, Trend Identification, Actionable Insights, Interactive Dashboard Design, Problem Solving, Reporting, KPI Tracking.

Tools & Technologies

Excel, MySQL, Power BI, Python, MS Office Suite, Jupyter Notebook, SQL, DAX.

AI/ML Concepts

AI Prompt Engineering.

Interests

Hobbies

Organizing, Travel, Culinary Exploration, Driving.

Projects

Fashion Store Data Analysis

→

Summary

Developed comprehensive data analysis and dashboard solutions for a simulated fashion store, focusing on sales performance and marketing strategies.

Adventure Work's Bike Shop Data Visualization

→

Summary

Developed a robust Power BI solution for Adventure Works Bike Shop, focusing on visualizing key business metrics to drive sales and profitability.

Telco Customer Churn Prediction

→

Summary

Executed a Python-based project to analyze telecommunications customer data, identify churn patterns, and inform business retention strategies.

OLA Ride-Sharing Data Analysis with MySQL & Power BI

→

Summary

Performed data cleaning and analysis on OLA ride-sharing data using MySQL, integrating with Power BI to visualize key operational and customer metrics.