Pravesh Agarwal

Data Analyst

[email protected]

Hello, I am

Pravesh Agarwal.

1

Excel
Project

3

PowerBI
Projects

1

SQL
Project

1

Python
Project

About Me

Hello! 👋 I'm Pravesh Agarwal, a Marine Engineer transitioning into data analytics. With a strong engineering background, I offer a unique blend of technical expertise and analytical precision. My passion lies in using data to drive impactful decisions and optimize processes.

Why Choose Me?

📊 Analytical Mindset: My engineering experience enables me to tackle complex problems with clarity and precision.

🛠️ Data Tools Enthusiast: I am mastering tools like Excel, PowerBI, MySQL, and Python to stay ahead in data analytics.

🧮 Problem-Solver: I leverage data-driven insights to address real-world challenges and seek innovative solutions.

🔍 Detail-Oriented: My keen attention to detail ensures accurate data interpretation and reporting for confident decision-making.

🌟 Passion for Growth: I am committed to continuous learning, always seeking to expand my knowledge and skills in data analytics. I'm excited to apply my unique background and skills to the world of data analysis.

Key Skills

SQL

PYTHON

EFFECTIVE COMMUNICATION

ADVANCED EXCEL

POWER BI

PROBLEM SOLVING

My Projects

AtliQ Grands Hospitality Analysis

Domain/Function: Hospitality / Revenue

Consumer Goods Ad-Hoc Insights

Domain/Function: Consumer Goods / Executive Management

IPL Historical Data Analysis

Domain/Function: Sports Analytics

Sales & Finance Analytics

Domain/Function: Fast-Moving Consumer Goods (FMCG)

Shield Insurance Analysis

Domain/Function: Insurance

Goodcabs Operations Analysis

Domain/Function: Transportation & Mobility / Operations

My Experience

Data Analyst Intern | AtliQ Technologies, Remote

Jul 2024 - Aug 2024

Leveraged Power BI, MySQL and MS Excel to conduct comprehensive data analysis.
Gained expertise in data visualization, analysis and aggregation techniques.
Developed decision-making skills by utilizing statistical analysis and data visualization.

Marine Engineer | Anglo Eastern Ship Management, Mumbai

Mar 2019 - Apr 2021

Monitored and analyzed engine performance data to optimize operational efficiency.
Maintained detailed logs and records, ensuring accurate data tracking and reporting.
Collaborated with senior engineers to identify and resolve issues through data-driven insights.

Awards & Certificate

Excel: Mother of Business Intelligence

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

SQL Beginner to Advanced For Data Professionals

Python: Beginner to Advanced For Data Professionals

Data Analytics Bootcamp 4.0: With Practical Job Placement Support + AI for Data Analysts

Community Champion - March 2024

2nd Place – Codebasics Resume Project Challenge #10

HackerRank SQL Basic

HackerRank SQL Intermediate

HackerRank SQL Advanced

AtliQ Technlogies VIrtual Internship

1st Place – Codebasics Resume Project Challenge #13

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/pravesh-agarwal27

GitHub

https://github.com/Pravesh-Agarwal

Python Project

AtliQ Grands Hospitality Analysis

Domain/Function: Hospitality / Revenue

AtliQ Grands encountered tough competition and a decline in revenue. They sought to utilize data and strategic insights but lacked internal expertise. My aim is to conduct a comprehensive analysis using Python to empower AtliQ Grands with insights for customer retention and revenue growth.

View Project
Engagement

View Project
on GitHUB

bar chart showing average occupancy rate per city

pie chart of revenue realized per booking platform

Project Details

🎯𝗧𝗮𝘀𝗸:
Analyze AtliQ Grands' booking data to address declining revenue.

🛠️ 𝗔𝗽𝗽𝗿𝗼𝗮𝗰𝗵:
Cleaned and transformed data, created metrics, and generated insights.

📚 𝗞𝗲𝘆 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴𝘀:
✅ Pandas Library
✅ Handling Null Values
✅ Concatenation and Merging
✅ Plotting with Matplotlib
✅ Data Exploration & Understanding

🚀 𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀 & 𝗥𝗲𝘀𝘂𝗹𝘁𝘀:
"Presidential" rooms stand out with a 59.28% occupancy rate, while Delhi leads in overall occupancy at 61.51%. Weekends consistently outperform weekdays, suggesting potential for targeted marketing. June saw high occupancy in Delhi and Hyderabad. Mumbai takes the revenue lead, but monthly revenue varies, hitting ₹38,99,40,912 INR in July 2022 and ₹40,83,75,641 INR in May 2022.

SQL Project

Consumer Goods Ad-Hoc Insights

Domain/Function: Consumer Goods / Executive Management

Using SQL queries answered 10 ad-hoc requests, making data the compass for AtliQ's journey to success. SQL, Excel and PowerPoint tools are used. Key insights included a significant increase in unique products, a dominant 'Notebook' segment and seasonal sales trends.

View Project
Engagement

View Project
on GitHUB

Other Tools

Power BI

Power Point

Complete report of the Gross sales amount for the customer “AtliQ Exclusive” for each month.

This shows the highest and lowest manufacturing cost product.

Project Details

🎯 𝗧𝗮𝘀𝗸:
Crafting impactful reports to unveil AtliQ Hardware's performance insights.

🛠️ 𝗔𝗽𝗽𝗿𝗼𝗮𝗰𝗵:
Loaded data into MySQL Workbench, generated insightful reports, and exported them to CSV files. Formatted and visualized data using CSV files when needed.

📚 𝗞𝗲𝘆 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴𝘀:
✅𝑫𝒂𝒕𝒂 𝑹𝒆𝒕𝒓𝒊𝒆𝒗𝒂𝒍: SELECT, WHERE, DISTINCT, LIKE, BETWEEN
✅𝑺𝒐𝒓𝒕𝒊𝒏𝒈 & 𝑭𝒊𝒍𝒕𝒆𝒓𝒊𝒏𝒈: ORDER BY, LIMIT, OFFSET
✅𝑨𝒈𝒈𝒓𝒆𝒈𝒂𝒕𝒊𝒐𝒏 𝑭𝒖𝒏𝒄𝒕𝒊𝒐𝒏𝒔: SUM, MIN, MAX, AVG, GROUP BY, HAVING
✅𝑼𝒏𝒗𝒆𝒊𝒍𝒊𝒏𝒈 𝑹𝒆𝒍𝒂𝒕𝒊𝒐𝒏𝒔𝒉𝒊𝒑𝒔: JOINS, Subqueries, Correlated Subqueries
✅𝑨𝒅𝒗𝒂𝒏𝒄𝒆𝒅 𝑨𝒏𝒂𝒍𝒚𝒕𝒊𝒄𝒔: CASE, YEAR, CURYEAR, IF, CTEs, User Defined Functions, Windows Functions
✅𝑫𝒂𝒕𝒂𝒃𝒂𝒔𝒆 𝑴𝒂𝒏𝒂𝒈𝒆𝒎𝒆𝒏𝒕: DDL, DML, Data Types, Views.

🚀 𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀 & 𝗥𝗲𝘀𝘂𝗹𝘁𝘀:
Built 9 reports: Finance (sales overview, Market Badge), Sales (top markets/products/customers), Net Sales (global market share). Empowering stakeholders with actionable insights.

PowerBI Project

IPL Historical Data Analysis

Domain/Function: Sports Analytics

"Sports Basics" is a sports blog company that entered the space recently. They wanted to get more traffic to their website by releasing a special edition magazine on IPL 2024. This magazine aims to provide interesting insights and facts for fans, analysts and teams based on the last 3 years' data.

View Project
Engagement

View Project
on GitHUB

Other Tools

Power Query

Teamwise Matches for every year

IPL 2024 Latest Match

Project Details

🎯 𝗣𝗿𝗼𝗷𝗲𝗰𝘁 𝗜𝗻𝘁𝗿𝗼𝗱𝘂𝗰𝘁𝗶𝗼𝗻:
"Sports Basics" is a sports blog company that entered space recently. They wanted to get more traffic to their website by releasing a special edition magazine on IPL 2024. This magazine aims to provide interesting insights and facts for fans, analysts and teams based on the last 3 years' data.

🎯 𝗣𝗿𝗼𝗷𝗲𝗰𝘁 𝗢𝗯𝗷𝗲𝗰𝘁𝗶𝘃𝗲:
The objective is to craft a comprehensive dashboard analyzing IPL data for 2021 to 2023.

🔎 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗗𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱 𝗢𝘃𝗲𝗿𝘃𝗶𝗲𝘄:
✅ Home View: A landing page with icons to navigate to different views.
✅Player Type View: Includes Opener, Anchor, All Rounder, Finisher, Bowler.
✅Winner View: Orange Cap, Purple Cap and winner for last 3 year
✅TOP N View: Provides primary insights of TOP N players of different category
✅Prediction View: Includes live IPL 2024 top runs and top wicket takers data along with Table rankings.
✅Playing 11 View: People can select their playing XI and see the overall performance

Project video

Live Interactive Dashboard

Excel Project

Sales & Finance Analytics

Domain/Function: Fast-Moving Consumer Goods (FMCG)

The objective of this project is to offer in-depth analysis of the company's financial health and its standing in the market. It involves generating a range of reports such as "Customer Net Sales Performance" and "Market Performance vs. Target" using a combination of fundamental and advanced Excel.

View Project
Engagement

View Project
on GitHUB

Other Tools

Power Pivot

Pivot Table

Power Query

This report allows stakeholders to evaluate the country's performance over multiple years and compare it to the established targets.

The Customer Performance Report displays the yearly net sales performance for each customer.

Project Details

🎯𝗧𝗮𝘀𝗸:
Crafting Accessible Reports - Net Sales Performance, Market Analysis, Yearly & Monthly, Profit & Loss.

🛠️ 𝗔𝗽𝗽𝗿𝗼𝗮𝗰𝗵:
Harnessing Pivot Tables for insightful reports. Power Query for seamless data transformation. Power Pivot for robust data models.

📚 𝗞𝗲𝘆 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴𝘀:

✅ Functional Knowledge

✅ Data Transformation & Modeling

✅ Data Modeling

✅ DAX Measures

✅ Pivot Table Reports

✅ Fine-Tuning

✅ User Empathetic Report Generation

🚀 𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀 & 𝗥𝗲𝘀𝘂𝗹𝘁𝘀:
Empowered stakeholders with data-driven reports showing an overall of more than 300% increased net sales and a 36.4% of gross margin percentage.

PowerBI Project

Shield Insurance Analysis

Domain/Function: Insurance

Explored Shield Insurance customer behavior & sales trends using Power BI in a data analytics bootcamp by Codebasics. Completed an end-to-end project during my data analytics internship, analyzing provided CSV files.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

Power Query

The Overview Dashboard provides a snapshot of Revenue and Customer trends, enabling exploration of key insights.

The Age Group Dashboard offers monthly customer trends, sales mode distribution, policy preferences, settlement percentages & customer distribution.

Project Details

● Executed in-depth analysis using Power BI, revealing crucial insights into revenue, customer behavior trends,
city-specific trends, sales modes, and age groups.
● Produced 3 reports, leading to a substantial 10% surge in active users and a 15% profit increase, fortifying
market standing and financial results.

Project video

Live Interactive Dashboard

PowerBI Project

Goodcabs Operations Analysis

Domain/Function: Transportation & Mobility / Operations

Analyzed 6 months of operational data for Goodcabs in 10 tier-2 Indian cities. Used SQL for insights and built a Power BI dashboard to track key metrics, increase trip volumes, and enhance passenger satisfaction, enabling data-driven decisions.

View Project
Engagement

View Project
on GitHUB

Other Tools

MySQL

Excel

Provides a high-level overview of company-wide performance and progress toward key goals.

Offers detailed insights into city-specific metrics, trends, and growth opportunities.

Project Details

🎯 𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐎𝐛𝐣𝐞𝐜𝐭𝐢𝐯𝐞:
• Analyze dataset to address key Business Questions on City - Level Trip Performance, Passenger Trends, Revenue Patterns, and Target Achievement.
• Present findings in a clear and visually engaging manner to assist the Chief of Operations in making informed strategic decisions.

📋 𝗗𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱 𝗢𝘃𝗲𝗿𝘃𝗶𝗲𝘄:
• 🏡 𝙇𝙤𝙜𝙞𝙣 𝙋𝙖𝙜𝙚: Landing Page, from here one can navigate to different pages.
• 📊 𝙀𝙭𝙚𝙘𝙪𝙩𝙞𝙫𝙚 𝘿𝙖𝙨𝙝𝙗𝙤𝙖𝙧𝙙: Provides a high-level overview of company-wide performance and progress toward key goals.
• 🏙️ 𝘾𝙞𝙩𝙮 𝘿𝙖𝙨𝙝𝙗𝙤𝙖𝙧𝙙: Offers detailed insights into city-specific metrics, trends, and growth opportunities.
• 👨‍👩‍👧 𝙋𝙖𝙨𝙨𝙚𝙣𝙜𝙚𝙧 𝘿𝙖𝙨𝙝𝙗𝙤𝙖𝙧𝙙: Focuses on passenger behavior, satisfaction, and repeat rates to optimize customer retention strategies.