Powered by
Codebasics DA Bootcamp

Aman Verma

Data Aspirant

+91 9953523798 [email protected]

Resume

Hello, I am

Aman Verma.

1

Excel Project

1

PowerBI Project

About Me

Welcome to my portfolio!!
I am a mechanical engineering graduate with a strong interest in data analysis. I'm eager to leverage my technical skills and analytical mindset to contribute to a data driven organization. I've actively developed my data analysis capabilities through projects and coursework completed at Codebasics Bootcamp, gaining proficiency in tools like Python, Excel, and Power BI for data manipulation, visualization, and uncovering insights. My engineering background equips me to understand complex systems and translate data into actionable solutions. I'm a fast learner and highly motivated to contribute my skills and enthusiasm to your team.

Key Skills

ETL

Data Visualization

Data Manipulation

SQL

Python

Problem Solving

My Projects

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/aman-verma-ds/

+ 91 9953523798

https://github.com/aman1DS

Excel Project

Sales Analytics(FMCG)

Aced Sales Analytics in Excel! Analyzed customer performance, market trends, and profitability with insightful reports and visualizations. I learned advanced calculations, data organization, and storytelling with Excel.

View Project
Engagement

View Project
on GitHUB

Sales Analytics(FMCG)

"Market Performance vs Target" report compares actual performance to targets with region and division filters.

Sales Analytics(FMCG)

"P&L Statements for Markets" report uses filters (region, subzone, FY) with columns for net sales, COGS, gross margin, and GM% by market.

Project Details

My recent Codebasics bootcamp included a sales analytics project using Excel. I created key reports to understand customer performance, market trends, and profitability.

These reports analyzed individual customer performance against targets, compared market performance to goals, and broke down profit and loss by fiscal year, market, and month.

The project significantly boosted my data analysis skills. I delved into advanced formulas, mastered data organization, and learned to create impactful data visualizations for clear communication. Additionally, I built adaptable data frameworks for future analysis needs.

This experience equipped me to confidently analyze and visualize sales data using Excel. I'm excited to leverage these skills and explore more advanced data analysis techniques in the future.

PowerBI Project

Business Insights 360

Developed a Power BI report for AtliQ Hardware with five interactive dashboards for deep operational insights. Utilized advanced skills in DAX measures, KPIs, interactive buttons, data modeling, bookmarks, and data visualization across financial, sales, marketing, supply chain, and executive views.

View Project
Engagement

Business Insights 360

Finance View: Track profits, margins, & analyze financial health with P&L statements & dynamic performance insights.

Business Insights 360

Sales View: Analyze customer & product trends, measure profitability & make data-driven sales decisions.

Project Details

Built an interactive Power BI report for AtliQ Hardware, giving them a deep dive into their business. 5 dashboards provide insights on:
Finance: Analyze profits, margins, & overall financial health.
Sales: Track customer & product trends, measure profitability, & make data-driven decisions.
Marketing: See regional & product performance, analyze effectiveness, & visualize key metrics.
Supply Chain: Optimize inventory by analyzing forecasts, errors, & customer/product data.
Executive View: Compare market share, identify top performers, & plan strategically based on revenue breakdowns.
Project honed my Power BI skills:
DAX Measures: Uncover hidden data insights.
KPIs: Easy performance monitoring.
Interactive Buttons: Smooth navigation.
Data Modeling: Built custom data models.
Bookmarked Transitions: Clear visual flow.
Data Visualization: Clear presentations with color-coded charts & graphs.
This report empowers AtliQ Hardware to make informed decisions & improve performance.

Project video

Live Interactive Dashboard