Ashutosh pathak

Data Analayst

[email protected] +91 6392579889

Resume

Hello, I am

Ashutosh pathak.

1

Python
Project

2

PowerBI
Projects

About Me

Hi, I’m Ashutosh Pathak, a Data Analyst with a strong foundation in Python, SQL, Excel, Power BI, and Tableau, passionate about turning complex data into clear, actionable insights.

I come from a programming and analytical background, and over the past year, I’ve worked on real-world projects including YouTube Data Analysis, Lok Sabha Election Dashboard (Power BI), and Sales & Customer Segmentation. I love solving data problems and creating visual stories that drive smarter decisions.

Key Skills

python

Sql

power bi

tabelau

excel

pandas

data visualizations

Dax studio

My Projects

Carbon impact analysis

Domain/Function: Sustainability Analytics

HR Analytics Dashboard

Domain/Function: Human Resources / HR Analytics

Lok sabha Elections Analysis

Domain/Function: Election Analysis

Health Insurance Dashboard

Domain/Function: Insurance

My Experience

Data Analyst Intern – UDM, Remote/Mumbai

Jul 2024 – Jun 2025
• Collected, cleaned, and organized data using Excel, SQL, and Python.
• Created interactive dashboards in Power BI and Tableau to show key business insights.
• Helped the team in analyzing sales and customer data to find useful trends and patterns.
• Wrote basic SQL queries to extract data and prepare reports for daily use.
• Supported the team in making data-driven decisions by presenting clear visual reports.
• Learned how to work with large datasets and improved understanding of real business problems.

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

Deloitte Data Analyst Internship Certificate

Data visualization: Empowering business with effective insights

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

https://www.linkedin.com/in/ashutosh-pathak-13337033a/

Call Me

+91 6392579889

GitHub

https://github.com/Ashutos6392/Lok-sabha-election-analysis

Python Project

Carbon impact analysis

Domain/Function: Sustainability Analytics

This project involved analyzing the relationship between carbon dioxide (CO₂) emissions and global temperature anomalies using Python. Leveraging Pandas, I conducted time-series analysis, clustering, and predictive modeling on historical datasets.

View Project
Engagement

View Project
on GitHUB

Lagged Effects Analysis: To evaluate delayed impacts, lag variables for CO₂ concentration (1, 2, and 3 years) are created.

time series analysis to examine the relationship between CO₂ concentrations and global temperature anomalies over several decades.

Project Details

In this project, I performed time-series analysis to study the relationship between CO₂ emissions and global temperature anomalies using Python. I used Pandas for data cleaning and transformation, and applied statistical techniques like correlation and lag variable modeling to assess delayed impacts. The analysis reveals a strong positive correlation between rising CO₂ levels and temperature changes, highlighting the increasing influence of human activities. It also identifies consistent emission trends and the growing burden on natural carbon sinks like forests and oceans.

HR Analytics Dashboard

Domain/Function: Human Resources / HR Analytics

Analyzed employee data to uncover insights on attrition, job satisfaction, and workforce demographics. Created an interactive Tableau dashboard for data-driven HR decisions.

View Project
Engagement

View Project
on GitHUB

This visualization highlights how employee attrition varies across departments. It shows that certain departments, such as Sales and R&D.

This chart displays how emp.loyees rate their job satisfaction on a scale. It helps identify whether most employees are satisfied or dissatisfied

Project Details

In this project, I worked with a CSV dataset containing detailed HR data such as department, job role, age, marital status, overtime, education field, and more. Using Tableau, I transformed this raw data into an interactive HR Analytics Dashboard. The dashboard provides insights into key metrics like attrition rate and count, active employee count, average age, department-wise attrition, employee distribution by age group, education field-wise attrition, gender-based trends, and job satisfaction ratings. This project helped me improve my data cleaning and visualization skills while understanding how analytics can support strategic HR decisions.

PowerBI Project

Lok sabha Elections Analysis

Domain/Function: Election Analysis

Voter turnout trends Top/Bottom constituencies Vote share comparison Impact of bifurcation (AP–Telangana) Correlation with GDP & literacy rate Interactive Power BI dashboard included for dynamic exploration.

View Project
on GitHUB

This visual dashboard highlights the Top 5 and Bottom 5 Lok Sabha constituencies in India for 2014 and 2019 based on voter turnout ratio.

This scatter plot visualization explores the correlation between postal vote percentage and overall voter turnout across Indian constituencies.

Project Details

This project presents a comprehensive analysis of the 2014 and 2019 Lok Sabha election results using Python, Excel, and Power BI. The analysis began with data cleaning in Python using Pandas, including text normalization and resolving constituency mismatches caused by the bifurcation of Andhra Pradesh (handling Telangana constituencies like Hyderabad and Warangal).

Voter turnout ratios were calculated in Excel, and additional datasets like State GDP and 2011 Census literacy rates were integrated to analyze their correlation with voter turnout. The final Power BI dashboard visualizes:

Voter turnout comparison between 2014 and 2019

Party-wise vote share and top gaining constituencies

Correlation between voter turnout and state-level literacy/GDP

Regional insights into party dominance and political shifts.

Live Interactive Dashboard

PowerBI Project

Health Insurance Dashboard

Domain/Function: Insurance

Developed an interactive and dynamic Power BI dashboard to analyze health insurance claim data. The dashboard provides key performance indicators (KPIs) such as total claims, approved/rejected claims, average claim amount, and claim turnaround time.

visualizes healthcare claim data by status, type, age group, and provider specialty. It includes a geographic distribution of claims and a yearly.

So this contain Slicer for Gender and Age to use Slice use CTRL+ Click on icon.