Portfolio - Abhyuday Pandey | Codebasics

Powered by
Codebasics Bootcamp

Hello, I am

Abhyuday Pandey

Data Analyst

1

Excel
Project

1

PowerBI
Project

1

SQL
Project

1

Python
Project

About

Me

Hello! Welcome to my data analyst portfolio. I am Abhyuday Pandey ,a dedicated data analyst with a profound curiosity for unraveling insights hidden within data. With a background in [Your Field or Education], I have cultivated a strong foundation in data analysis techniques and methodologies, allowing me to thrive in deciphering complex datasets.

My journey in data analysis is ongoing and I'm always learning new things to stay updated.

In this portfolio, I invite you to explore a showcase of my projects, each offering a glimpse into my analytical prowess and problem-solving abilities.

Come take a look at my portfolio and let's chat about how I can help your business make sense of data and drive success!

Technical

Skills

Excel

PowerBI

Sql

Python

Dax

Pandas

Pivot table

Power Query

My

Projects

Sales Analytics And Finance Report

Sales Analytics And Finance Report

Experience the dynamic story of annual net sales, comparing market achievements to targets. Dive into detailed P&L insights covering net sales, COGS, gross margin, and GM%.

Hotel Data Analytics

Hotel Data Analytics

Atliq Grand, a reputable hotel, operates in multiple cities across India, including Delhi, Mumbai, Hyderabad, and Bengaluru. The chain offers a diverse range of hotel types to cater to various guest preferences, including Atliq Seasons, Atliq Exotica, Atliq Bay, and Atliq Palace.

Consumer Good Domain

Consumer Good Domain

Atliq Hardwares is one of the leading computer hardware producers in India and well expanded in other countries too. So we have to took the insight .

Sales Analytics

Sales Analytics

Atliq Hardware is company which sells Computer hardware and Peripheral manufacturer to different clint like Surge Store, Nomad Store, Excel Store and Electrical Sara Store.

Awards

& Certificate

CB Cert

Excel: Mother of Business Intelligence

CB Cert

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

CB Cert

SQL Beginner to Advanced For Data Professionals

CB Cert

Python For Beginner and Intermediate Learners

Contact Me

Email

[email protected]

Github

https://github.com/abhyuday345

Linkedin

https://www.linkedin.com/in/abhyuday-pandey-22a641223/

Call

+91 7359757545

Abhyuday Pandey

Data Analyst

Download Resume

Resume

Excel Project

Sales Analytics And Finance Report

Experience the dynamic story of annual net sales, comparing market achievements to targets. Dive into detailed P&L insights covering net sales, COGS, gross margin, and GM%.

View Project
Engagement

View Project
on GitHUB

Sales Analytics And Finance Report

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Sales Analytics And Finance Report

Calculate P&L Statement every year and compare the 2020 and 2021 percentage increase and decrease

Project Details

1)Sales Analytics and Finance Report:-

-In Sales Analytics we comapre net sales against target goals,and actual performance with market expectation
-We also perform top and bottom performaters in division wise
-In Finance Report we create P&L Report
-We derive COGS,GM, and Gm% every year
-this insghts hight strength and are of improvement throughout the year.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics
7.Power Pivot

Python Project

Hotel Data Analytics

Atliq Grand, a reputable hotel, operates in multiple cities across India, including Delhi, Mumbai, Hyderabad, and Bengaluru. The chain offers a diverse range of hotel types to cater to various guest preferences, including Atliq Seasons, Atliq Exotica, Atliq Bay, and Atliq Palace.

View Project
on GitHUB

Hotel Data Analytics

Bar chart comparing occupancy rates across 4 cities, aiming to identify highest performing locations.

Hotel Data Analytics

Analyzing revenue distribution across booking platforms via pie chart.

Project Details

Key areas of analysis include:

1)Room Type Performance: Assessing the occupancy rates and revenue generation for each room type (Standard, Elite, Premium, Presidential) across different hotel types to determine which categories perform the best.

2)Booking Platform Preference: Analyzing booking patterns to understand which platforms (Atliq website, third-party sites, offline bookings) are most commonly used by guests when making reservations.

3)Room Category Performance: Evaluating the performance of different room categories within each hotel type to identify trends in guest preferences and demand.

By gaining insights into these key metrics, Atliq Grand can optimize its operations, marketing strategies, and customer experience initiatives to better meet the needs and preferences of its guests, ultimately driving enhanced performance and profitability across its hotel portfolio.

SQL Project

Consumer Good Domain

Atliq Hardwares is one of the leading computer hardware producers in India and well expanded in other countries too. So we have to took the insight .

View Project
on GitHUB

Consumer Good Domain

Provide a report with all the unique product counts for each segment and sort them in descending order of product counts.

Consumer Good Domain

Generate a report which contains the top 5 customers who received an average high pre_invoice_discount_pct for the fiscal year 2021 and in

Project Details

the management noticed that they do not get enough insights to make quick and smart data-informed decisions. They want to expand their data analytics team by adding several junior data analysts. Tony Sharma, their data analytics director wanted to hire someone who is good at both tech and soft skills. Hence, he decided to conduct a SQL challenge which will help him understand both the skills.

PowerBI Project

Sales Analytics

Atliq Hardware is company which sells Computer hardware and Peripheral manufacturer to different clint like Surge Store, Nomad Store, Excel Store and Electrical Sara Store.

View Project
Engagement

View Project
on GitHUB

Sales Analytics

This report is from profit Analysis how much profilt is generated in each city and customer name

Sales Analytics

This report shows the performance of margin vs performance

Project Details

Atliq Hardware is company which sells Computer hardware and Peripheral manufacturer to different clint like Surge Store, Nomad Store, Excel Store and Electrical Sara Store. Now Bhavin Patel is the Sales director of the company and want to get the project insights on that

Live Interactive Dashboard