Powered by
Codebasics DA Bootcamp

Vishal Kumar Gupta

Data Analyst

+91 7785033135 [email protected]

Resume

Hello, I am

Vishal Kumar Gupta.

1

Excel Project

2

PowerBI Projects

1

SQL Project

About Me

Welcome to my portfolio! As an enthusiastic Data Analyst in the making, I thrive on unraveling the stories hidden within raw data. Armed with proficiency in Excel, PowerBI, SQL, and Python, I embark on a journey to decode complexities and illuminate pathways to actionable insights.

Fuelled by a Bachelor's degree in B Tech, I discovered my innate knack for data analysis. Despite being a fresher in the professional arena, my hunger for knowledge and hands-on experience has driven me to undertake numerous business projects showcased in my portfolio.

My commitment lies in translating data into impactful narratives, driving informed decisions, and catalyzing organizational growth. Join me in exploring the boundless possibilities of data-driven excellence. Let's embark on this transformative journey together. Dive into my portfolio below and witness the fusion of passion, skill, and potential.

Key Skills

Effective Communication

SQL

Python

My Projects

My Experience

Jun 2024 - Jul 2024

Mentorness - Data Analyst Intern

Assist in data collection, cleaning, and preprocessingAssist in data collection, cleaning, and preprocessing
Conduct exploratory data analysis to uncover trends and insights
Develop and maintain dashboards and reports using tools like Power BI
Develops and executes complex SQL queries to extract and analyze data, generating actionable insights for strategic decision-making.

Awards & Certificate

Mentorness Internship Certificate

Mentorness Internship Certificate

DBM & REGISTRATION COMMITTEE UTKARSH '23 CERTIFICATE OF UPPRECIATION

DBM & REGISTRATION COMMITTEE UTKARSH '23 CERTIFICATE OF UPPRECIATION

Let's Connect

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 protected]

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

+ 91 7785033135

https://github.com/Vishaly66

Excel Project

Sale Analytics - Customer Performance Report and Market Performance vs Target Report

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

View Project
on GitHUB

Sale Analytics - Customer Performance Report and Market Performance vs Target Report

Customer Performance Report: Provides net sales performance of each customer across years

Sale Analytics - Customer Performance Report and Market Performance vs Target Report

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

Project Details

In this project, I created a sales report using Excel pivot tables to help businesses determine effective customer discounts, facilitate consumer negotiations, and identify expansion opportunities in promising countries. The reports generated provide actionable insights and recommendations to optimize sales strategies, enhance customer satisfaction, and maximize revenue.

Key learnings include:

Pivot Table
Power Query
DAX (Basics)
Conditional Formatting
Report Beautification
Sales Domain Metrics

Overall, this project empowers businesses with tools and insights to monitor, evaluate, and enhance their sales activities. Leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

PowerBI Project

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

AtliQ Hardwares is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights and make i

View Project
Engagement

View Project
on GitHUB

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

Data modelling involving 10+ tables

Project Details

In this project, the goal is to create a single comprehensive report that can be utilized by stakeholders from sales, marketing, finance, and the executive team. The focus areas include:

1. Robust Data Modeling
2. User-Empathetic Report Design
3. Drillable Insights

I learned the following:

1. Power Query (Basic and Advanced Operations)
2. Basic and Complex DAX Formulas
3. Data Modeling 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

This project aims to equip stakeholders with a versatile report, enabling them to derive actionable insights, make informed decisions, and drive overall business success. By integrating sales, marketing, finance, and supply chain metrics, the report fosters a holistic understanding of business performance and opportunities for growth.

Project video

Live Interactive Dashboard

SQL Project

Atliq Hardware - Finance and Supply Chain Analytics

AtliQ Hardwares is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel.My goals was to implement advanced analutical soluction Using SQL.

View Project
Engagement

View Project
on GitHUB

Atliq Hardware - Finance and Supply Chain Analytics

Gross Sales Report for Atliq Hardware

Atliq Hardware - Finance and Supply Chain Analytics

Net Sales % Global in visuals(bar chart)

Project Details

In this project, the goal is to create a single comprehensive report that can be utilized by stakeholders from finance, and the supply chain team.

The Focus was
->Data-driven decision
->Useful Insight for Finance and Supply Chain team

I learned the following :
1.)User-defined Function
2.)Stored Proc
3)Database View
4.)Sub-quries
5.)Join
6.)CTE
7.)Windows Function
8.)Stakeholder Management
9.)Kanban

This project aims to equip stakeholders with a versatile report, enabling them to derive actionable insights, make informed decisions, and drive overall business success. By integrating finance, and supply chain metrics, the report fosters a holistic understanding of business performance and opportunities for growth.

PowerBI Project

Hosipitality Analysis

AtliQ Grands, a luxury hotel chain in India, seeks to regain market share and revenue lost due to strategic missteps. Lacking an in-house analytics team, they enlisted a 3rd party for business and data intelligence. As a data analyst, your task is to generate metrics from historical data, develop a

View Project
Engagement

View Project
on GitHUB

Hosipitality Analysis

Data modelling

Hosipitality Analysis

User-empathetic landing page as a part of dashboard design

Project Details

AtliQ Grands, a chain of five-star hotels across India with 20 years in the hospitality industry, is losing market share and revenue due to strategic moves by competitors and ineffective management decisions. To regain their market position, AtliQ Grands' managing director decided to incorporate “Business and Data Intelligence” but lacked an in-house data analytics team. They hired a 3rd party service provider to gain insights from historical data.

As a data analyst, my tasks include:

Create Metrics: Develop metrics as per the provided list.
Design Dashboard: Build a dashboard based on stakeholder mock-ups.
Generate Insights: Identify and present additional insights not covered in the provided metrics or dashboard.
Comprehensive Analysis: Conduct overall revenue, booking, and review analysis.
The aim is to leverage data intelligence to provide actionable insights that help AtliQ Grands regain market share and increase revenue.

Project video

Live Interactive Dashboard