Powered by
Codebasics DA Bootcamp

Neha Pravin Sharma

Data Analyst

+91 9011816257 [email protected]

Resume

Hello, I am

Neha Pravin Sharma.

2

Excel Projects

2

PowerBI Projects

About Me

I am Neha Sharma, a Data Analyst intern with a strong passion for turning data into actionable insights. I specialize in Power BI, SQL, Excel, and Python, leveraging these tools to analyse complex datasets and build visualizations that support business decision-making. My expertise in Power BI allows me to create interactive dashboards, while my proficiency in SQL helps me efficiently manage and query large databases.

In Excel, I work with advanced formulas and Pivot Tables to automate tasks and deliver comprehensive reports. Additionally, Python enables me to automate workflows, perform statistical analysis, and develop predictive models that reveal key trends.

During my internship, I’ve applied my skills across diverse projects, helping businesses improve performance and make data-driven decisions. My goal is to continue growing as a data analyst and contribute to impactful projects that drive innovation and growth.

Key Skills

Effective Communication

Stake Holder Management

Power BI

MySQL

Problem Solving

My Projects

My Experience

BEACON, Delhi – Data Analyst

May 2024 - Present

Worked as a Data Analyst intern at Beacon, focusing on daily sentiment analysis for internet posts related to upcoming elections.
Analysed public sentiment from online platforms to track shifts in voter opinion across different parliamentary constituencies.
Created detailed reports for each constituency using historical and current election results, identifying trends and voter behaviour.
Leveraged previous election outcomes and real-time data to deliver valuable insights for electoral strategy and decision-making.
Synthesized data from various sources to develop reports that supported election-related decision-making and strategic planning.

Awards & Certificate

Excel: Mother of Business Intelligence

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

Code Basics Resume Project Challenge

Code Basics Resume Project Challenge

Data Analytics & Data Engineering

Data Analytics & Data Engineering

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.

[email protected]

https://www.linkedin.com/in/nehasharma2103/

+ 91 9011816257

https://github.com/neha-p-sharma

Excel Project

Customer Performance Analysis

Domain/Function: FMCG

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

View Project
Engagement

View Project
on GitHUB

Customer Performance Analysis

Customer Performance Report: Provides net sales performance of each customer across years

Customer Performance Analysis

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I developed a comprehensive sales report using Excel pivot tables to help businesses make data-driven decisions. The report enables companies to evaluate customer discount effectiveness, supports negotiation strategies, and uncovers potential expansion opportunities in high-growth countries. By analyzing sales data, businesses can gain actionable insights to optimize their sales approach, boost customer satisfaction, and maximize revenue potential.

Through this project, I honed several key skills:
1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

This project empowers businesses to monitor and enhance their sales performance, identify new opportunities, and make strategic decisions that drive growth and maintain market competitiveness. Through effective sales data analysis, businesses can achieve sustainable revenue growth in an evolving marketplace.

PowerBI Project

Business Insight 360

Domain/Function: Bricks & Mortar & E-commerce

AtliQ Hardware, a consumer electronics company, is growing fast but struggles to keep up with competitors who use data effectively. Most of their reports are still in Excel. My aim is to set up a smart analytics system using Power BI. This will help the company in making smarter decisions.

View Project
Engagement

View Project
on GitHUB

Business Insight 360

Executive View : Provides a 360-degree overview of key metrics, offering drillable insights and real-time data for informed decision-making.

Business Insight 360

Data Model: Incorporating 10+ Tables.

Project Details

In this project, the goal was to develop a comprehensive report usable by stakeholders across sales, marketing, finance, and the executive team. The focus was on robust data modeling, a user-empathetic report design, and delivering drillable insights for deeper analysis.

Key learnings from this project include:

• Mastering Power Query for both basic and advanced data operations.
• Applying DAX formulas to solve complex analytical challenges.
• Building data models with over 10 tables, ensuring accuracy and performance.
• Selecting the right visuals and formatting for clarity and impact.
• Implementing dashboard design principles for intuitive user experience.
• Utilizing bookmarks to enhance report navigation.
• Deploying reports in Power BI Service.
• Integrating stakeholder feedback for continuous improvements.
• Analyzing sales, marketing, finance, and supply chain metrics to provide actionable insights.

Project video

Live Interactive Dashboard

Excel Project

Road Accident Dashboard

Domain/Function: Transportation Or Public Safety

The Road Accident Dashboard offers insights into traffic incidents, analyzing factors like location, time, severity, and causes. It helps stakeholders identify accident hotspots, monitor trends, and improve road safety by enabling data-driven decision-making.

View Project
Engagement

View Project
on Excel

Road Accident Dashboard

The Road Accident Dashboard highlights key data on traffic incidents, helping to identify accident hotspots, analyze trends, and improve road safety.

Road Accident Dashboard

The dataset contains road accident data with details on date, location, severity, vehicles, casualties, road and weather conditions for safety analyse

Project Details

This project aims to analyze and visualize road accident data to enhance public safety and inform policy decisions. Using a dataset that includes Accident Index, Date, Severity, Location, Weather Conditions, and more, the dashboard focuses on several key objectives:
• Trend Analysis: Identify patterns in accident frequency by month, day, and time.
• Severity Insights: Examine how factors like weather and road types influence accident severity.
• Geospatial Visualization: Map accident hotspots to help allocate resources effectively.
• Casualty Statistics: Analyze the number of casualties and vehicles involved to understand the impact on public safety.
• Interactive Features: Allow users to filter data by date range, location, and severity for targeted insights.
This dashboard serves as a valuable tool for authorities and policymakers to make informed, data-driven decisions aimed at improving road safety and reducing accidents.

PowerBI Project

IPL Analysis

Domain/Function: Sports Analytics

This project analyzes IPL performance metrics over three years, highlighting top batsmen and bowlers, predicting key tournament outcomes, and using Power BI for visual insights.

View Project
Engagement

View Project
on GitHUB

Batsman data features total runs, averages, strike rates, and boundaries hit, enabling a detailed analysis of IPL performance over three years.

The Best 11 players are selected based on consistent performance metrics, including runs scored, wickets taken, and overall contributions in IPL match

Project Details

Embark on a data-driven journey through IPL history to uncover trends and performance metrics for Sports Basics Magazine.

Key Insights:

• Top 10 batsmen based on total runs, batting averages, and strike rates over the past three years.
• Top 10 bowlers based on total wickets, bowling averages, and economy rates.
• Performance metrics of top teams based on winning percentages and their success in chasing targets.

Projections:
• Forecasts for Orange and Purple Cap winners.
• Anticipated top four teams, standout players, and Best 11.

Tools Used:
• Power Query for data cleansing and transformation.
• Power BI for dynamic visualizations and predictive analysis.

This project enhances skills in data analysis, visualization, and storytelling, providing a comprehensive view of the IPL landscape and fostering informed discussions in the sports community.

Live Interactive Dashboard