Portfolio - Shubham Kumar Verma

Shubham Kumar Verma

Data Aspirant

Resume

1

Excel Project

2

PowerBI Projects

About Me

Hi, I’m Shubham, an aspiring Data Analyst with a passion for turning raw data into clear, useful business insights. During my BCA, I realised that working with data was where I felt most interested and confident. I enjoy finding patterns, solving problems, and using numbers to understand what is really happening in a business.

I use Excel, SQL, Power BI, and Python to clean data, analyse it, create dashboards, and share insights in a simple way. The projects in my portfolio show how I have worked on business problems and turned data into practical findings and recommendations.

I am starting my career in data analytics, but I bring hands-on project experience, strong attention to detail, and a willingness to learn. I’m looking for an opportunity to grow with a team and help make better decisions through data.

Key Skills

Excel

Power BI

SQL

Python

Data Visualization

Business Analysis

Effective Communication

Data Analysis & Exploratory Data Analysis (EDA)

Data Visualization & Dashboard Design

Pivot Tables

XLOOKUP

and Excel Charts

SQL Joins

CTEs

and Window Functions

Pandas and NumPy (Python)

DAX (for Power BI)

My Projects

Sales and Finance Analytics

Domain/Function: Sales & Finance

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

Domain/Function: Business Analysis

GRANDORA HOTELS Hospitality Performance Dashboard

Domain/Function: Hospitality Domain

Awards & Certificate

Excel: Mother of Business Intelligence

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

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.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/shubham-verma-baa797373/

Call Me

+91 6202093050

GitHub

https://github.com/

Excel Project

Sales and Finance Analytics

Domain/Function: Sales & Finance

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

View Project
Engagement

View Project
on GitHUB

Other Tools

Power Query

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

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

Project Details

Created a Sales and Finance Analytics report in Excel for AtliQ Hardwares to analyse customer, product, market, and financial performance. Using Power Query, PivotTables, basic DAX measures, conditional formatting, and interactive filters, I explored sales and profitability across countries, customers, divisions, and products.

The report tracks key metrics including Net Sales, COGS, Gross Margin, GM%, year-over-year growth, and performance against targets. It helps identify high-value customers, top and low-performing products, markets falling below target, and countries with growth potential. These insights can support better discount planning, sales discussions, market expansion, and profitability decisions.

Through this project, I strengthened my skills in Excel reporting, data preparation, PivotTables, basic DAX, finance metrics, and dashboard design.

Project video

PowerBI Project

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

Domain/Function: Business Analysis

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 in

View Project
Engagement

Other Tools

Excel

MySQL

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

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

Project video

Live Interactive Dashboard

PowerBI Project

GRANDORA HOTELS Hospitality Performance Dashboard

Domain/Function: Hospitality Domain

Built an interactive Power BI dashboard to analyze May–July 2022 booking data across 25 hotels. It highlights revenue, occupancy, ADR, RevPAR, cancellations, no-shows, and weekly trends by city, hotel category, and room class

View Project
Engagement

Other Tools

Excel

Power Query

DAX Measures

Data Modelling

Power BI hotel dashboard showing revenue, RevPAR, occupancy, ADR, and realization KPIs. Filters and charts explore weekly trends, hotel-category revenue, booking-platform results, and property-level performance.

Combined view of six Power BI tooltip charts tracking weekly ADR, DSRN, occupancy, realization, revenue, and RevPAR, with Business and Luxury comparisons across May–July 2022.

Project Details

Built an interactive Power BI dashboard to analyze hotel booking performance across 25 properties using 134,590 bookings and room-capacity data from May to July 2022. DAX measures track realized revenue, occupancy, ADR, RevPAR, cancellations, no-shows, realization, and daily room-night metrics.
Users can explore weekly trends and compare results by city, hotel category, room class, and booking outcome. The dashboard helps compare revenue, demand, and booking outcomes across properties and categories.
Across the dataset, overall occupancy was 57.9%, cancellations were 24.8%, no-shows were 5.0%, realization was 70.1%, and realized revenue was approximately 1.71B.

Project video

Live Interactive Dashboard

Already have an account? Sign in