Portfolio - Ayush | Codebasics

Excel Project

P&L report for AtliQ Hardware

Generated comprehensive P&L reports for AtliQ Hardware using Excel and DAX, analyzing key financial metrics and showcasing significant year-over-year growth in Net Sales and Gross Margin. Explore my portfolio for details.

View Project
on GitHUB

Analyzed market performance vs. target for 2019-2021 using Excel, revealing a total sales shortfall of 9.2% in 2021, with detailed country-specific in

Comparison of financial metrics (2019-2021) shows remarkable growth in Net Sales (204.5%), COGS (208.6%), and Gross Margin (197.6%). However, GM% decl

Project Details

This project involves generating comprehensive Profit & Loss (P&L) reports for AtliQ Hardware for fiscal years 2019, 2020, and 2021. Using advanced Excel features like Pivot Tables and DAX measures, I analyzed and visualized key financial metrics such as Net Sales, Cost of Goods Sold (COGS), and Gross Margin (GM%). Each fiscal year's data is segmented by month and quarter, providing granular insights into revenue streams and expense categories. The data showcases significant improvements in financial performance, with notable increases in Net Sales and Gross Margin percentages over the years.

A detailed Net Sales comparison highlights year-over-year growth, showing a 204.5% increase in 2021 compared to 2020 and a 124.8% increase in 2020 compared to 2019. These insights are critical for strategic decision-making and demonstrate the impact of effective data analysis and financial planning. Explore my portfolio to see how I transform raw data into actionable bus

SQL Project

Famous Paintings And Their Artist

Explore the fascinating world of art through data analysis of renowned paintings and their creators. Delve into trends in artwork sizes, museum displays, and subject preferences, unveiling captivating stories behind timeless masterpieces. Discover the hidden narratives within the art world.

View Project
Engagement

View Project
on GitHUB

An SQL query identifies 16 museums without paintings, including Ohara Museum of Art and Musée Marmottan Monet, with details on ID, name, address, and

An SQL query identifies the country (USA) and cities (New York, Paris, Washington, London) with the most museums, using separate columns for clarity.

Project Details

Dive into the enchanting world where art meets data, revealing the secrets of renowned masterpieces and their creators. Explore canvas sizes, museum displays, and the timeless themes that captivate audiences across generations. Unveil the hidden narratives behind the brushstrokes, shedding light on the profound interplay of creativity and analysis. Join us on a journey that transcends boundaries, offering new perspectives on the art that shapes our world.

PowerBI Project

Banking Domain

A data analyst at AtliQ Data Services is tasked with analyzing a sample dataset of 4000 customers for Mitron Bank. The goal is to deliver actionable insights on online spending and customer details to tailor credit card offerings, aiming to secure the full project by impressing the bank's strategy t

View Project
Engagement

View Project
on GitHUB

Consumer Behavior Report: 4000 customers, 2597 male, 1403 female, 3136 married. Avg spend: 51.7K, income: 614.5. Key cities: Mumbai, Delhi NCR, Bengal

Consumer Behavior Report: Total spend 216M, avg txn 1001.4, avg monthly spend/customer 9012.9. High spend in electronics, food, groceries. Key cities:

Project Details

After discovering an opportunity, a proposal was made to Mitron Bank for a project. The bank requested a pilot using a sample dataset before committing fully. This dataset includes online spending details for 4000 customers across five cities.

A data analyst was assigned to analyze the data and report key findings to Mitron Bank's strategy team. The goal is to tailor the bank's credit card offerings to better meet customer needs and market trends.

The analysis will include:
- Demographics: Age, gender, location, occupation breakdowns.
- Spending Insights: Online spending patterns and trends.
- Income Utilization: Income levels and spending capacity.
- Key Insights for Customization: Features appealing to segments.
- Recommendations: Personalized rewards, tailored credit limits, and marketing strategies.

This analysis aims to help Mitron Bank develop better-aligned credit card products.

Live Interactive Dashboard

PowerBI Project

Food & Beverage Industry

CodeX, a German beverage company, recently launched its energy drink in 10 Indian cities. With a focus on increasing brand awareness and market share, the Marketing team conducted a survey, receiving feedback from 10,000 respondents. These insights will drive their strategic actions in the Indian ma

View Project
Engagement

View Project
on GitHUB

Survey results show a young, male-dominated respondent base. Online ads are the top marketing channel. Frequent consumption is noted among males aged

Codex report analyzes brand performance across Indian cities. It measures reputation, taste, price, and packaging to help companies refine marketing s

Project Details

CodeX, a German beverage company, aims to make its mark in the Indian market. A few months ago, they launched their energy drink in 10 cities in India. The Marketing team, tasked with increasing brand awareness, market share, and product development, conducted a survey with 10,000 respondents. Peter Pandey, a marketing data analyst, is converting these survey results into actionable insights.

Demographics: Analyzes age, gender, income, and location to tailor strategies.

Consumer Preferences: Examines flavor, packaging, and brand preferences for product development.

Purchasing Behavior: Studies purchase frequency, preferred channels, and spending patterns.

Competition Analysis: Identifies competitors, market share, strengths, and weaknesses.

Marketing View: Assesses marketing campaign effectiveness and brand recall.

CodeX Performance: Evaluates market penetration and customer satisfaction.

These insights will guide CodeX’s strategic actions in the Indian market.

Hello, I am

Ayush

1

1

2

About

Key

My

P&L report for AtliQ Hardware

Famous Paintings And Their Artist

Banking Domain

Food & Beverage Industry

Awards

Contact Me

Email

Github

Linkedin

Call

Ayush

Download Resume