Ashutosh pathak

Data Analayst

[email protected] +91 6392579889

Resume

Hello, I am

Ashutosh pathak.

1

Python
Project

4

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

Lok sabha Elections Analysis

Domain/Function: Election Analysis

Health Insurance Dashboard

Domain/Function: Insurance

Spotify Dashboard

Domain/Function: Spotify

Hospital Management Dashboard

Domain/Function: Hospital Management Dashboard

My Experience

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.

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.

Project Details

Live Interactive Dashboard

PowerBI Project

Spotify Dashboard

Domain/Function: Spotify

Analyzed user listening trends, top artists, genres, and streaming patterns using power bi and Excel to uncover insights and visualize data for better music recommendation strategies.

Other Tools

Excel

SQL

Albums Dashboard This dashboard visualizes album listening trends on Spotify. It shows total albums played over time (7,905 plays).

Artists and Tracks Dashboard This dashboard tracks Spotify listening by artist and track. On the left, it shows 4,112 artists played, highlighting.

Project Details

Built an interactive Power BI dashboard to visualize Spotify listening patterns over time. Tracked albums, artists, and tracks with metrics like yearly comparison, top 5 rankings, and total plays. Included donut charts, time series graphs, and category-wise analysis to identify user preferences and engagement trends.

Live Interactive Dashboard

PowerBI Project

Hospital Management Dashboard

Domain/Function: Hospital Management Dashboard

I created an interactive hospital dashboard using Power BI to track patient information, doctor details, appointments, billing, and medicine sales. The first dashboard shows the doctor’s profile, appointment schedule, patient admission/discharge status, and total billing summary.

Other Tools

SQL

Excel

This Power BI dashboard displays patient appointment details, doctor profile (cardiologist), and key metrics such as total bill amount.

This dashboard presents a single-patient case overview, including diagnosis (acne), treatment duration, patient ratings, and medicine usage tracked.

Project Details

The first dashboard shows the doctor’s profile, appointment schedule, patient admission/discharge status, and total billing summary. It includes charts showing the types of patient charges and a detailed table of patient billing data.

The second dashboard focuses on individual patient insights such as diagnosis, treatment dates, medicine tracking (by month/day), and sales quantity. It also includes patient ratings and feedback.

This project helped visualize hospital operations clearly, making it easier to analyze charges, monitor doctor availability, and track medicine usage. It demonstrates my ability to create dashboards for real-world applications using Power BI.