Homesh Kolhe profile photo 1 on Tal

Homesh Kolhe

Entry-Level Data Analyst | Turning Data Into Actionable Insights | Proficient in Power Bi, SQL, Excel, Python

Pune District

< 1 year of work experience

SevenMentor Pvt Ltd
Mar 20247 mosSep 2024

Pune District, Maharashtra, India

Conducted Retail Sales Analysis Project, extracting, cleaning, and analyzing datasets using SQL, Python, Excel, and Power BI, improving data accuracy and reporting efficiency. Built interactive dashboards in Power BI using DAX functions, enabling stakeholders to visualize sales trends and make data-driven business decisions. Applied data cleaning and transformation techniques in SQL and Excel (pivot tables, VLOOKUP, advanced formulas), reducing data inconsistencies by 20%+. Designed and presented data visualizations to showcase KPIs such as sales growth, regional performance, and customer trends, supporting business strategy discussions. Data Analyst Projects Experience Retail Sales Analysis Report Tools: SQL, Excel, Python, Power BI Analyzed retail sales data to identify sales trends, customer behavior, and product performance. Built interactive dashboards to visualize revenue growth, category-wise insights, and key business KPIs for better decision-making. Personal Finance Dashboard Tools: Power BI Developed an interactive dashboard to track income, expenses, savings, and budget performance. Cleaned and transformed raw data using Power Query and created DAX measures for insightful financial analysis and reporting. Walmart Sales Data Analysis Tools: MySQL Performed SQL-based sales analysis to identify top-performing products, customer purchasing patterns, and revenue trends. Used queries, joins, and aggregations to generate business insights from large datasets. Weather Forecasting System Tools: Python Built a predictive weather forecasting model using historical weather datasets and statistical analysis. Applied data preprocessing and Python libraries to improve forecasting accuracy and understand weather patterns.

Education

Kavayitri Bahinabai Chaudhari North Maharashtra University, Jalgaon

Master of Computer Applications - MCA

Kavayitri Bahinabai Chaudhari North Maharashtra University, Jalgaon

20232 yrs2025
Yashwantrao Chavan Maharashtra Open University (YCMOU), Nashik

Master of Business Administration - MBA

Yashwantrao Chavan Maharashtra Open University (YCMOU), Nashik

20232 yrs2025

Join Homesh and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Homesh Kolhe on Tal

Headline

Entry-Level Data Analyst | Turning Data Into Actionable Insights | Proficient in Power Bi, SQL, Excel, Python

About

I am a detail-oriented Data Analyst with a passion for transforming raw data into meaningful insights that support smarter business decisions. With a strong academic foundation (BCA + MCA + MBA) and practical internship experience, I specialize in data cleaning, analysis, visualization, and reporting using modern analytics tools. During my internship as a Data Analyst, I worked on diverse projects including Retail Sales Analysis, HR Analytics Dashboard, Wheather Forecasting Report, and Walmart Sales Data Analysis. These experiences helped me develop a strong ability to identify trends, summarize large datasets, and present findings through interactive dashboards that drive real value for decision-makers. My technical toolkit includes: SQL – database management, queries, and reporting Excel (Advanced) – pivot tables, formulas, and data summarization Python – data manipulation and analysis Power BI – building dashboards and interactive visualizations I have also earned certifications in MySQL, Advanced Excel, Python, and Power BI from Seven Mentor Training Institute, strengthening both my technical expertise and problem-solving mindset. I am now eager to apply my skills to real-world business challenges where I can contribute to data-driven decision-making, process improvements, and actionable insights. My goal is to grow as a Data Analytics professional while continuously learning and adding value to forward-thinking organizations.

Location

Pune District

Work experience

Data Analyst Intern at SevenMentor Pvt Ltd, Mar 2024 - Sep 2024 · 7 mos, Pune District, Maharashtra, India, Conducted Retail Sales Analysis Project, extracting, cleaning, and analyzing datasets using SQL, Python, Excel, and Power BI, improving data accuracy and reporting efficiency. Built interactive dashboards in Power BI using DAX functions, enabling stakeholders to visualize sales trends and make data-driven business decisions. Applied data cleaning and transformation techniques in SQL and Excel (pivot tables, VLOOKUP, advanced formulas), reducing data inconsistencies by 20%+. Designed and presented data visualizations to showcase KPIs such as sales growth, regional performance, and customer trends, supporting business strategy discussions. Data Analyst Projects Experience Retail Sales Analysis Report Tools: SQL, Excel, Python, Power BI Analyzed retail sales data to identify sales trends, customer behavior, and product performance. Built interactive dashboards to visualize revenue growth, category-wise insights, and key business KPIs for better decision-making. Personal Finance Dashboard Tools: Power BI Developed an interactive dashboard to track income, expenses, savings, and budget performance. Cleaned and transformed raw data using Power Query and created DAX measures for insightful financial analysis and reporting. Walmart Sales Data Analysis Tools: MySQL Performed SQL-based sales analysis to identify top-performing products, customer purchasing patterns, and revenue trends. Used queries, joins, and aggregations to generate business insights from large datasets. Weather Forecasting System Tools: Python Built a predictive weather forecasting model using historical weather datasets and statistical analysis. Applied data preprocessing and Python libraries to improve forecasting accuracy and understand weather patterns.

Education

Master of Computer Applications - MCA, Kavayitri Bahinabai Chaudhari North Maharashtra University, Jalgaon

Master of Business Administration - MBA, Yashwantrao Chavan Maharashtra Open University (YCMOU), Nashik

Homesh Kolhe - Data Analyst Intern in Pune District | Tal