Dinesh Murugan
- Bangalore, Karnataka, India
- dineshmsn5@gmail.com
- +91 87781-10525
Motivated Entry-Level Data Analyst proficient in Microsoft Excel, Python, SQL, and Tableau. Skilled in data visualization and exploratory data analysis, with a passion for leveraging insights to drive decision-making. Eager to excel in data-driven environments.
Projects
EDA on US Accidents (2019-2023)
- python
- exploratory data analysis
- data visualization
Work:
- Performed Exploratory Data Analysis (EDA) on the US Accidents dataset from 2019-2023.
- Extracted key insights on accident locations, severe weather conditions, and relevant details.
- Utilized various statistical techniques and visualization methods to analyze the dataset.
- Focused on the geographical distribution of accidents and examined the severity level of accidents.
- Identified areas with the highest accident rates and analyzed the impact of different weather conditions on accident frequency.
- Examined
## Impact
- Valuable information for traffic safety improvement initiatives: By analyzing and curating the US Accidents dataset, the project provided valuable insights into accident locations, severe weather conditions, and other relevant details. This information can be used to identify areas with high accident rates and prioritize traffic safety improvement initiatives in those areas.
- Insights into the geographical distribution of accidents: The project leveraged statistical techniques and visualization methods to examine the geographical distribution of accidents. This analysis helped identify areas with the highest
provides insights to the marketing team in food & beverage industry
- tableau
- data visualization
Work Description:
- Utilized Tableau's visualization capabilities to create interactive and visually appealing visualizations.
- Created visualizations that effectively communicated key marketing metrices and trends.
- Provided insights on marketing trends, competitor analysis, and consumer preference.
- Informed marketing strategy and decision making.
- Analyzed the survey results from 10k respondents in 10 cities.
- Identified brand awareness, market share, and product development opportunities.
- Used Tableau to present the survey data in a clear
Impact:
- The utilization of Tableau's visualization capabilities helped in creating interactive and visually appealing visualizations.
- The visualizations effectively communicated key marketing metrics and trends.
- The insights provided on marketing trends, competitor analysis, and consumer preferences informed the marketing strategy and decision-making.
- The survey was conducted in 10 cities and received results from 10k respondents, allowing for a comprehensive analysis.
- The increased brand awareness and market share can be attributed to the informed marketing strategy based on the insights
Pizza Sales Analysis
- microsoft excel
- mysql
- data visualization
## Work Description
- Collected and analyzed pizza sales data to gain insights into sales performance, customer preferences, and trends.
- Developed SQL queries to extract key metrics, including total sales by pizza type, monthly, daily, and hourly sales trends, and top-selling pizzas.
- Leveraged Excel features such as pivot tables, charts, and formulas to create a comprehensive dashboard.
- Presented the dashboard to stakeholders, enabling data-driven decision-making in optimizing pizza sales strategies.
- Provided insightful commentary and recommendations based
Impact:
- Collected and analyzed the pizza sales data to gain insights into sales performance, customer preference, and trends for business requirements.
- Provided insightful commentary and recommendations based on the analysis of sales data.
- Developed SQL queries to extract key metrics, including total sales by pizza type, monthly, daily, and hourly sales trends, and top-selling.
- Leveraged Excel features such as pivot tables, charts, and formulas to create a comprehensive dashboard.
- Presented the dashboard to stakeholders, enabling
Publications
A Machine Learning Based Approach for Road Traffic Accidents Prediction
Apr 2021
Utilizing data analysis and machine learning, this paper addresses road safety concerns by predicting accident types and offering safety
recommendations, aiding both authorities and citizens.