Portfolio - Akash Kumar

Akash Kumar

Data Analyst

Resume

1

Excel Project

About Me

Welcome to my data-driven world!
I am Akash Kumar , a passionate and results-driven aspiring Data Analyst with a flair for transforming raw data into actionable insights. Armed with a postgraduate degree, I bring a unique blend of academic rigor and practical experience garnered from both the corporate and education sectors. In my journey, I have mastered the art of data analysis using tools like Excel, PowerBI, SQL, and Python, turning complex datasets into meaningful narratives.

While my formal experience might be in the making, my portfolio showcases diverse business projects that highlight my analytical prowess. Whether it's deciphering complex data sets or crafting valuable solutions, my commitment to excellence and insatiable curiosity drive me forward.

Join me on this exploration of unlocking the potential of data. Let's connect and dive into a world of endless possibilities together!

Key Skills

data visiualization

CTL

SQL

python

data mining

My Projects

Road Accidental Analysis

Domain/Function: Data Analytics

My Experience

Data Analytics Internship : IBM

• Leveraged Power BI, MySQL, and MS Excel to perform data analysis

• Gained expertise in data visualization, analysis and aggregation techniques.

• Developed decision-making skills by utilizing statistical analysis and data visualization

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.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/akash-kumar-3a9395287/

Call Me

+91 8434590454

GitHub

https://github.com/Akashkumar1844

Excel Project

Road Accidental Analysis

Domain/Function: Data Analytics

Developed key performance indicators (KPIs) to track and measure accident trends.– Created detailed reports on casualties categorized by rural vs. urban areas, vehicle type, road type, and accident severity (fatal, serious, slight).– Use of Hyperlink for easy navigation and drop email as require

View Project
Engagement

View Project
on GitHUB

He analysis focuses on various casualty types—fatal, serious, and slight—while comparing current year casualties with the previous year.

The analysis covers the following key areas, all filtered by month, year (2021), and area type (rural or urban):

Project Details

Road accident analysis involves collecting, analyzing, and interpreting data related to traffic accidents to identify patterns and improve road safety.
Key aspects include:

Data Collection: Sources like police reports, traffic cameras, and emergency services data provide details on accidents.

Types of Analysis:

Casualty Analysis: Breaks down the number of fatalities, serious injuries, and minor injuries.
Location-based Analysis: Compares accidents in urban vs. rural areas and specific road types.
Vehicle Type Analysis: Examines the types of vehicles involved in accidents.
Accident Conditions: Studies factors like weather, lighting, and road surface conditions that contribute to accidents.
KPI Comparison: Focuses on key metrics, such as casualty rates, accident severity, and year-over-year trends, often using charts and dashboards to identify improvement areas.