Portfolio - Vishal Garg | Codebasics

Powered by
Codebasics DA Bootcamp

Hello, I am

Vishal Garg

Data Aspirant

Resume

1

PowerBI
Project

1

Excel
Project

About

Me

Hello, I'm Vishal, a determined Data Analyst enthusiast. Over the past six months, I've passionately immersed myself in the world of data analytics, driven by a curiosity to uncover insights that drive meaningful decisions.

My journey has been marked by two significant projects. Firstly, I meticulously crafted a P & L report for AtliQ Hardwares, showcasing my knack for distilling intricate financial data into actionable insights.

In my second endeavor, I designed an interactive dashboard for AtliQ Hardwares. This venture spotlighted my ability to transform raw data into engaging and empowering effective decision-making with the grasp of advanced excel concepts.

My passion naturally led me to explore Power BI, where I acquired proficiency in ETL processes, data modeling, DAX calculations, and Power Query transformations. Within a singular Power BI dashboard, I seamlessly integrated finance, sales, marketing, supply chain, and executive views.

Thank You

Key

Skills

Stakeholder Management

Python for Data Analysis

My

Projects

Business insights

Business insights

AtliQ Hardware, in its rapid growth, grapples with competition due to limited Excel-based data. 🌟My mission: Employ Power BI's advanced analytics to empower data-driven decisions and elevate the company's competitive edge

Sales and Finance Analytics

Sales and Finance Analytics

Develop a customer performance report to assess customer engagement.
Conduct a comprehensive comparison between market performance and sales targets.
Generate Profit and Loss (P&L) reports categorized by Fiscal Year & Months.
Create Profit and Loss (P&L) reports segmented by Markets.

Contact Me

Email

[email protected]

Github

https://github.com/Vishal1garg

Linkedin

https://www.linkedin.com/in/vishal-garg-01b1aa211/

Call

+91 7015784292

Vishal Garg

Data Aspirant

Download Resume

Resume

PowerBI Project

Business insights

AtliQ Hardware, in its rapid growth, grapples with competition due to limited Excel-based data. 🌟My mission: Employ Power BI's advanced analytics to empower data-driven decisions and elevate the company's competitive edge

Business insights

The home page serves as the central hub, offering easy access to a variety of views and comprehensive support resources for seamless navigation

Business insights

Data Model

Project Details

Explored AtliQ Hardware Project:

Designed interactive dashboard
Integrated sales, marketing, financial data
Empowered data-driven decisions

✨ Power BI learning journey enriched my data-driven decision-making experience.

🎯 Tools Used:

Excel, Power Query
Power BI, DAX
DAX Studio optimization

🎯 Business Metrics:

Gross Sales, Net Invoice Sales
Net Sales, Gross Margin
Net Profit, Deductions
COGS, YTD, YTG, Market Share

🎯 Essentials:

KPI Indicators, Calculated Columns
Advanced Data Modeling
DAX Measures, Bookmarks
Navigational Precision

Live Interactive Dashboard

Excel Project

Sales and Finance Analytics

Develop a customer performance report to assess customer engagement. Conduct a comprehensive comparison between market performance and sales targets. Generate Profit and Loss (P&L) reports categorized by Fiscal Year & Months. Create Profit and Loss (P&L) reports segmented by Markets.

View Project
on GitHUB

Sales and Finance Analytics

Customer performance report

Sales and Finance Analytics

Profit and Loss statement by fiscal year

Project Details

Purpose of Sales Analytics:
Enhanced businesses' ability to monitor and evaluate sales activities and achievements.

Significance of Analyzing Sales Data:
Identified sales trends and monitor key performance indicators (KPIs).

Role of Reports:
Determine optimal customer discounts.
Facilitate negotiations with consumers.
Identify potential expansion opportunities in promising markets.
Purpose of Finance Analytics:
Evaluate financial performance, support decision-making, and engage stakeholders effectively.

Importance of Analyzing Finance Data:
Benchmark against industry peers and historical data, providing a foundation for budgeting and forecasting.

Role of Reports:
Align financial planning with strategic goals.
Instill confidence in the organization's financial outlook.