Portfolio - J. Sai Pavan Kumar | Codebasics

Powered by
Codebasics Bootcamp

Hello, I am

J. Sai Pavan Kumar

Data Aspirant

1

Excel
Project

2

PowerBI
Projects

1

SQL
Project

About

Me

Hi there! I'm Sai Pavan. Even though I started with a degree in Mechanical Engineering, I realized my passion lies within data analysis.

I'm good at using Excel, PowerBI, SQL, and Python to figure out what the numbers mean. It's like being a detective for data!

I might not have tons of job experience yet, but I've been doing real business projects. You can check them out in my portfolio – they show that I know how to make sense of data.

My unique combination of an engineering background and data skills is pretty cool. Let's chat and see how I can help your team with data stuff!

Technical

Skills

Excel

PowerBI

Python

SQL

Tableau

Data Analytics

Stakeholder management

My

Projects

Sales & Finance Analysis

Sales & Finance Analysis

AtliQ Hardware, known for PCs, mice, and computers, is embracing data-driven growth. They're seeking strategic advice to boost sales and marketing by analyzing disorganized sales data, aiming to spot trends and KPIs for a better performance overview.

Business Insights 360

Business Insights 360

AtliQ Hardware aims for a competitive edge through Power BI analytics. This dashboard covers Finance, Sales, Marketing, Supply Chain and Executive view throughout globally.

Hospitality Analysis

Hospitality Analysis

This study demonstrates the enormous potential of data analytics in the hotel industry. This analytics dashboard enables AtliQ Grand to improve its hospitality offerings and make more data-driven decisions to ensure its success.

Finance and Supply Chain Analytics

Finance and Supply Chain Analytics

AtliQ Hardware was significantly impacted by the project. The business was able to decide on product development, marketing tactics, and market expansion by leveraging the information I produced. Profitability rose and market share rose as a result.

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

Data Analytics Bootcamp 3.0: With Practical Job Assistance + AI Module

Data Analytics Consulting Virtual Internship

Google Data Analytics Professional Certificate

Contact Me

Github

https://github.com/imSaiPavan27

Linkedin

https://www.linkedin.com/in/saipavankumar27/

J. Sai Pavan Kumar

Data Aspirant

Excel Project

Sales & Finance Analysis

AtliQ Hardware, known for PCs, mice, and computers, is embracing data-driven growth. They're seeking strategic advice to boost sales and marketing by analyzing disorganized sales data, aiming to spot trends and KPIs for a better performance overview.

View Project
Engagement

View Project
on GitHUB

Sales & Finance Analysis

This shows how much money each customer made in different years. We check if they made more money this year compared to the year before.

Sales & Finance Analysis

This helps people see how well the country is doing and if it's meeting its targets.

Project Details

In this project, I've created a detailed sales report using Excel's pivot tables. It's meant to help companies find the best discounts for customers, have successful negotiations, and discover growth chances in promising markets. The reports give practical suggestions, so businesses can improve their sales tactics, make customers happier, and make more money.

Sales Report:
Objective is to Generate a
- Customer Performance Report
- Comparisons using Market Performance vs. Target.
- Finding the Top 10 products
- Division Level report
- Top 5 and bottom 5 Products in terms of quantity sold
- New products -2021
- Top 5 countries in terms of net sales

Finance Report:
Generate a Profit and Loss (P&L) reports based on Fiscal Year, Months, Quarters, Sub zones and Markets.

PowerBI Project

Business Insights 360

AtliQ Hardware aims for a competitive edge through Power BI analytics. This dashboard covers Finance, Sales, Marketing, Supply Chain and Executive view throughout globally.

View Project
Engagement

View Project
on GitHUB

Business Insights 360

The homepage is the main place to go to other pages. It's designed to be user-friendly and serves as the starting point of the dashboard.

Business Insights 360

The displays and measurements are simple for users and can adjust to show the desired results.

Project Details

Objective:
The primary objective of this project was to create a comprehensive dashboard with various perspectives, each offering insights into key financial metrics:

1. Finance view
2. Sales view
3. Marketing view
4. Supply Chain view
5. Executive view

The process includes:
1. Project Overview
2. Project Planning
3. Importing & Exploring Data
4. Data Modelling
5. Dashboard Designing
6. Project outcomes

Live Interactive Dashboard

PowerBI Project

Hospitality Analysis

This study demonstrates the enormous potential of data analytics in the hotel industry. This analytics dashboard enables AtliQ Grand to improve its hospitality offerings and make more data-driven decisions to ensure its success.

View Project
Engagement

View Project
on GitHUB

Hospitality Analysis

The KPIs with more visuals attracts stakeholders to have a glimpse of dashboard

Hospitality Analysis

The Detailed analysis by Revenue, Occupancy, Booking and Rating.

Project Details

Context:
AtliQ Grand, a well-known hotel chain, approached us with a clear objective to improve their decision-making processes and enhance operational efficiency. They expressed a strong desire to leverage the potential of data to enhance the guest experience and increase profitability.

The Approach:
1️⃣ Data Importation
2️⃣ Data Validation
3️⃣ Data Modeling (including some transformation and cleansing using Power Query)
4️⃣Crafting Measures using DAX
5️⃣Designing a Dashboard with the right visualizations

Key Performance Indicators (KPIs):*
Total Revenue
RevPAR (Revenue per Available Room)
DSRN (Daily Sellable Room Nights)
ADR (Average Daily Rate)
Realization Percentage
Occupancy Percentage

Live Interactive Dashboard

SQL Project

Finance and Supply Chain Analytics

AtliQ Hardware was significantly impacted by the project. The business was able to decide on product development, marketing tactics, and market expansion by leveraging the information I produced. Profitability rose and market share rose as a result.

View Project
Engagement

View Project
on GitHUB

Finance and Supply Chain Analytics

Croma India Product Wise Sales Report for Fiscal Year -2021

Finance and Supply Chain Analytics

Top 5 Customers for the Financial Year - 2021 w.r.t Net Sales

Project Details

⭐Project Summary:
- Using SQL functions, a thorough market analysis was carried out to find important performance indicators, market trends, and competition insights. This allowed the business to make data-driven decisions.
- Using SQL, visually appealing reports and dashboards were created to show findings in a way that was easy to grasp for stakeholders and improved overall company understanding.

⭐Key Takeaways:
- Used Common Table Expression technique (CTE)
- Worked with User-Defined Functions
- Created Database Views
- Employed JOINS
- Implemented Stored Procedures
- Applied Window Functions like OVER, ROW_NUMBER, RANK, DENSE_RANK
- Used Temporary Tables
- Worked with Indexes and Database Creation/Update
- Understood Data Integrity and Entity-Relationship Diagrams (ERD)

Full Name *

Email *

Phone Number *

I want to know about: *

I agree to use my communication details for further communication from codebasics.