Powered by
Codebasics Bootcamp

Parth Agheda

Data Analytics

+91 7359078587 [email protected]

Hello, I am

Parth Agheda.

1

Excel Project

1

PowerBI Project

About Me

Data isn't just numbers, it's a story waiting to be told, and I'm here to tell it. Let's connect and explore how data can empower your business or project.

From crunching numbers to uncovering hidden insights, I thrive on turning raw data into actionable information.

My toolkit includes:

-Power BI (Power Query, DAX, DAX Studio)
- SQL (MySQL, SQL Server)
- Advanced Excel (Power Query, Pivot Table, DAX)
- Storytelling with Data

I believe in data's power to make informed decisions, and I'm proud to say that my data analysis skills are my superpower.

Key Skills

SQL

Stakeholder Management

MS Excel

PowerBI

My Projects

Awards & Certificate

Data Analyst Internship Certificate

Data Analyst Internship Certificate

Data Analytics and Visualization Virtual Experience

Data Analytics and Visualization Virtual Experience

Story Telling using Power BI

Story Telling using Power BI

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/parthagheda/

+ 91 7359078587

https://github.com/ParthAgheda

Excel Project

Sales And Finance Analytics (FMCG) Report

Domain/Function: FMCG

Created a comprehensive P&L report for AtliQ Hardware. This project provides an in-depth analysis of the company's financial health and market position, generating reports like "Customer Net Sales Performance" and "Market Performance Vs. Target" using fundamental and advanced Excel techniques.

View Project
Engagement

View Project
on GitHUB

Sales And Finance Analytics (FMCG) Report

Customer Performance Report: Delivers a comprehensive analysis of each customer’s net sales performance over multiple years.

Sales And Finance Analytics (FMCG) Report

Market Performance vs. Target Report: Provides stakeholders with a detailed evaluation of the market's performance over the years.

Project Details

In this project, I crafted an advanced sales report using Excel pivot tables to empower businesses to determine optimal customer discounts, streamline negotiations, and identify growth opportunities in emerging markets. These comprehensive reports deliver actionable insights to refine sales strategies, enhance customer satisfaction, and boost revenue.

Skills Acquired:

- Proficient use of Excel pivot tables
- Advanced data analysis with Power Query
- Fundamental DAX (Data Analysis Expressions) knowledge
- Effective conditional formatting
- Report aesthetic enhancement techniques
- Deep understanding of sales metrics

This project equips businesses with essential tools and insights for monitoring, evaluating, and improving sales activities, unlocking new growth avenues, and maintaining a competitive edge in dynamic markets.

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain Management

Domain/Function: Finance, Sales, Marketing and Supply Chain Management

AtliQ Hardware encountered challenges managing extensive datasets in Excel. They transitioned to Power BI to enhance data comprehension and derive actionable insights in finance, sales, and supply chain. The project handled 1.8 million records using SQL, Power BI, Excel, and DAX Studio.

View Project
Engagement

View Project
on GitHUB

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain Management

This is the main gateway of the dashboard, providing users with streamlined navigation to various analytical sections.

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain Management

Data modeling encompassing more than 10 tables requires intricate structuring and integration to establish robust relationships and optimize data ret

Project Details

This project integrates Power BI, SQL, and Excel to tackle operational inefficiencies at AtliQ Hardware, a global leader in consumer electronics. Previous heavy reliance on Excel led to regional losses. Senior management initiated a data analytics transformation using last year's data to drive strategic enhancements.

- Finance View: Provides a profit and loss overview, tracking Gross Margin (GM), Net Profit (NP), Net Sales (NS), and performance trends.
- Sales View: Analyzes customer and product performance, unit economics, NS, and GM%.
- Marketing View: Evaluates region and product metrics based on NS and GM%.
- Supply Chain View: Monitors forecast accuracy, net error, and trends by customer and product.
- Executive View: Insights into competitor market share, revenue trends, and top 5 customers.

Live Interactive Dashboard