Portfolio - Rachit Gupta | Codebasics

Powered by
Codebasics DA Bootcamp

Hello, I am

Rachit Gupta

Data Aspirant

Resume

1

Excel
Project

1

PowerBI
Project

About

Me

I am an aspiring Data Analyst with hands-on expertise in Excel, Power BI, SQL, and Python for transforming raw data into actionable insights. With a Master’s degree in Computer Applications, I have built a strong technical foundation, but it was through exploring real-world datasets that I discovered my natural abilities in data analysis and problem-solving.

Although I have not yet worked within a formal organization, I have independently completed several business-oriented projects, showcased in my portfolio below. These projects highlight my ability to clean, analyze, and visualize data to uncover trends, support decisions, and tell impactful stories.

I thrive at the intersection of technical skills and business understanding, and I am eager to apply my analytical mindset to help organizations make smarter, data-driven decisions. Driven, curious, and continuously learning, I am ready to take on challenging roles where I can contribute and grow as a Data Analyst.

Key

Skills

Excel

Power BI

SQL

Python

Problem Solving

My

Projects

Sales Analytics

Sales Analytics

Domain/Function: IT Hardware Sales Analysis

This project focuses on analyzing the company's sales performance and market standing. The insights provided by advanced Excel techniques such as Pivot Tables and Power Query, help the sales team optimize strategies, improve customer relationships, and track market goals effectively.

Business Insights 360

Business Insights 360

Domain/Function: Sales & Business Performance Analytics in the Hardware Industry

AtliQ Hardware faced challenges managing data in Excel, limiting insights into key areas. My objective was to transition the company to Power BI, enabling better analysis of finance, sales, and supply chain, utilizing a substantial dataset of 1.8 million entries for informed decision-making.

Awards

& Certificate

CB Cert

Excel: Mother of Business Intelligence

CB Cert

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

SQL (Basic) Certificate

SQL (Basic) Certificate

Foundations: Data, Data, Everywhere By Google

Foundations: Data, Data, Everywhere By Google

Contact Me

Email

[email protected]

Github

https://github.com/Rachitgupta9993

Linkedin

https://www.linkedin.com/in/rachit-gupta-1b8971214

Call

+91 8720897026

Rachit Gupta

Data Aspirant

Download Resume

Resume

Excel Project

Sales Analytics

Domain/Function: IT Hardware Sales Analysis

This project focuses on analyzing the company's sales performance and market standing. The insights provided by advanced Excel techniques such as Pivot Tables and Power Query, help the sales team optimize strategies, improve customer relationships, and track market goals effectively.

View Project
Engagement

View Project
on GitHUB

Sales Analytics

Customer Net Sales Performance displays the yearly net sales performance for each customer

Sales Analytics

Market Performance vs Target Report

Project Details

In this project, I developed a sales report using Excel Pivot Tables to help businesses understand their sales performance better. This report is a powerful tool for identifying the best customer discounts, making negotiations easier, and finding new markets to explore.

The insights from these reports can help businesses improve their sales strategies, boost customer satisfaction, and increase revenue.

During this project, I learned how to:

1. Use Pivot Tables for quick data analysis.
2. Apply Power Query for smooth data processing.
3. Understand the basics of DAX (Data Analysis Expressions).
4. Use Conditional Formatting to highlight important information.
5. Make reports visually appealing and easy to read.
6. Analyze key sales metrics effectively.

Overall, this project gives businesses the insights they need to enhance their sales efforts and discover new growth opportunities through data analysis.

PowerBI Project

Business Insights 360

Domain/Function: Sales & Business Performance Analytics in the Hardware Industry

AtliQ Hardware faced challenges managing data in Excel, limiting insights into key areas. My objective was to transition the company to Power BI, enabling better analysis of finance, sales, and supply chain, utilizing a substantial dataset of 1.8 million entries for informed decision-making.

View Project
Engagement

View Project
on GitHUB

Business Insights 360

Dashboard's homepage

Business Insights 360

Executive View

Project Details

The main aim of this project was to create a comprehensive dashboard for stakeholders across sales, marketing, finance, and the executive team. The focus areas included:

Robust Data Model: Building a solid foundation for data analysis.
User-Friendly Design: Creating intuitive reports that cater to user needs.
Interactive Insights: Offering drillable features for in-depth data exploration.

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 & Supply Chain metrics

Live Interactive Dashboard