Ashish Chauhan

As a passionate and motivated data analyst with strong passion for deriving valuable insights from complex datasets. With a solid foundation in data analysis, Statistical methodologies, and programming languages. I am eager to leverage my skills to contribute to data driven decision-making and solve real-world problems.

Road Accident Analysis | Power BI

This project provides a depth analysis and visualization to identify Road Casualties data for the year 2021 and 2022. 

• Worked on developing KPIs & Monthly Trends showing the comparison of current & previous year casualties.
• Casualties by severity and vehicle types
• Analyzed YoY Casualties rate reduced by 7-11.9%.
• Applied various charts and graphs to identify casualties by vehicle types, Road types, and daytime.

Walmart Sales Data Analysis | SQL

The project aims to explore the sales data to understand the top-performing branches and products.

• Deployed SQL to examine the most selling product electronic accessories and branches A, B&C are the topmost
  branches that sold most products.
• Performed Data Wrangling, EDA, Joins, Subqueries & generated new columns as per the requirement.

Diwali Sales Analysis | Python

This project was to improve customer experience by analyzing sales data & increase revenue.

• Performed exploratory data analysis (EDA) using NumPy, Pandas, Matplotlib & Seaborn libraries.
• Performed data cleaning and manipulation by using Pandas.

Store Sales Analysis | Excel

The project was to improve sales with targeted customers and implement new ideas by
analyzing annual sales data and increase revenue.

• Data Cleaning & Data Processing
• Pivot Table Analysis
• Created a wide range of charts & graphs to get meaningful insights.

Scam Awareness Course