Portfolio - Yash Khandelwal | Codebasics

Powered by
Codebasics DA Bootcamp

Yash Khandelwal

Data Analyst

EMAIL

[email protected]

PHONE

+91 8269695595

Download CV

About Me

Hello there! 👋

I'm Yash, a data enthusiast confidently embarking on my journey into the world of analytics. It all began with mastering Excel and Power BI, where I discovered my passion for transforming raw data into compelling insights.

Currently, I'm gearing up to dive into the realm of SQL. The prospect of efficiently managing and extracting valuable insights from databases truly excites me. Python is next on my agenda. Automation and advanced analytics are beckoning, and I'm more than ready to answer the call.

𝗦𝗸𝗶𝗹𝗹𝘀:
-- Power BI
-- MS Excel
-- DAX Queries
-- Data Modelling
-- Data Analysis
-- Market Analysis
-- Data Visualization
-- Business Intelligence
-- Extract Transform Load (ETL)

Passion for Data:

I firmly believe that when you are passionate about your work, boredom is never an issue.
I find great joy in connecting with individuals who share the same enthusiasm for data. If you're reading this, you're the one!
Let's connect and stay in touch here... 🤗

1

Excel Project

1

Python Project

1

SQL Project

1

PowerBI Project

Key Skills

Python

SQL

Google Sheets

Power BI

My Projects

My Experience

Trainee Businee Analyst, Physics Wallah

Streamlined operational processes by leveraging Google Apps Script to automate repetitive tasks, reducingmanual effort and enhancing team efficiency.
Developed and maintained interactive Power BI dashboards to provide actionable insights for the sales team,enabling them to monitor targets and performance effectively.
Designed and implemented custom solutions in Google Sheets, including automated payment reminders,incentive trackers, and workflow optimizations, improving accuracy and productivity across teams.
Delivered data-driven reports and analytics on a daily, weekly, and monthly basis, empowering top-levelmanagement to make informed strategic decisions.

Awards & Certificate

SAS Programming Course

SAS Programming Course

Excel: Mother of Business Intelligence

Excel: Mother of Business Intelligence

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

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

SQL Beginner to Advanced For Data Professionals

SQL Beginner to Advanced For Data Professionals

Let's Work Together!

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

[email protected]

Call Me

+91 8269695595

LinkedIn

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

Excel Project

Excel-Sales and Finance Analytics Project of AtliQ Hardwares

The objective of this project is to offer in-depth analysis of the company's financial health and its standing in the market. It involves generating a range of reports such as "Customer Net Sales Performance" and "Market Performance vs. Target" using a combination of fundamental and advanced Excel.

View Project
Engagement

Excel-Sales and Finance Analytics Project of AtliQ Hardwares

This report allows stakeholders to evaluate the country's performance over multiple years and compare it to the established targets.

Excel-Sales and Finance Analytics Project of AtliQ Hardwares

The Customer Performance Report displays the yearly net sales performance for each customer.

Project Details

I have successfully completed a sales report project using Excel pivot tables. This report is a valuable resource for businesses seeking to optimize customer discounts, streamline negotiations, and identify growth opportunities in promising markets. The reports I have created provide actionable insights that help businesses enhance their sales strategies, improve customer satisfaction, and increase revenue.
Throughout this project, I have developed expertise in the following key areas:
Utilizing pivot tables: I have effectively used pivot tables to summarize and analyze sales data, enabling businesses to gain a comprehensive understanding of their performance.
Harnessing the capabilities of Power Query: By leveraging Power Query, I have efficiently imported, transformed, and combined data from various sources, ensuring accuracy and efficiency in the analysis process.

Python Project

Hotel Domain Analysis Using Python

Atliq Grands faced fierce competition and a revenue decline. They aimed to utilize data and strategic insights but lacked internal expertise. I intend to conduct an in-depth Python analysis to empower Atliq Grands with customer retention and revenue growth insights.

View Project
Engagement

Hotel Domain Analysis Using Python

Crafted a table of average occupancy rate per city.

Hotel Domain Analysis Using Python

Crafted average rating per city and pie chart of revenue per booking platform.

Project Details

In this project, I performed the following operations to generate insights for Atliq Grands:
Data Cleaning:
Handled missing values and outliers in the dataset.
Data Transformation:
Added occupancy percentage columns to enhance the analysis.
Insights Generation:
Calculated average occupancy rates by room type and city.
Identified occupancy rates on weekdays and weekends.
Analyzed revenue generated per city.
Examined monthly revenue trends.
Assessed revenue by booking platforms.
These operations aimed to provide Atliq Grands with valuable insights for customer retention and revenue growth.

SQL Project

Finance and Supply Chain Analysis

Domain/Function: SQL

This SQL project is for the Data Analyst Bootcamp at CodeBasics. It analyzes financial and supply chain data from Atliq Hardwares, with a focus on Croma India. The goal is to address analytical questions about sales, gross sales, market, product, customers, and supply chain forecasting.

View Project
Engagement

Finance and Supply Chain Analysis

Top Market and Customers for a Financial Year "2021"

Finance and Supply Chain Analysis

Top 2 Market in Every Region by their Gross Sales Amount

Project Details

We analyzed AtliQ Hardware's database to uncover critical insights into sales, products, customers, and regions. Our goal was to answer key questions in sales reporting, market analysis, customer behavior, and supply chain forecasting to enhance strategic decisions. Key findings showed Amazon as the top performer with $109.03 million in net sales for FY 2021, followed by AtliQ Exclusive with $79.92 million. India led the markets, generating $210.67 million in net sales, with the USA following at $132.05 million. Amazon contributed significantly, accounting for 13.23% of total net sales, and dominated the APAC region with a 12.99% share. India also led in total gross sales within APAC. This project demonstrated our advanced data analysis capabilities, proficiency in MySQL for complex database queries, and problem-solving skills, transforming raw data into strategic business insights.

PowerBI Project

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

Domain/Function: Business Insights 360

AtliQ Hardwares, a rapidly expanding consumer electronics company, struggles to compete due to reliance on Excel reports. My goal is to implement Power BI for advanced analytics, enabling better insights and informed decisions.

View Project
Engagement

Other Tools

Excel

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

User-empathetic landing page as a part of dashboard design

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

Finance View

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance, Executive View & Supply Chain metrics

Live Interactive Dashboard