Portfolio - Abhishek kumar

Abhishek kumar

Data Aspirant

Resume

3

PowerBI Projects

About Me

Hi, I’m Abhishek Kumar 👋
I’m an aspiring Data Analyst who loves turning raw numbers into meaningful insights that help businesses make smarter decisions. With a background in Electronics & Telecommunication Engineering, I discovered my passion for data while solving analytical problems during my projects—and I haven’t looked back since.

Tools & Technologies I work with

Excel

SQL

Python

Power BI

My Functional Areas

Data Cleaning & Transformation

Data Visualization & Dashboarding

Problem-Solving through Analytics

Automating repetitive tasks

Storytelling with Data

🌟 I strongly believe in learning in public, which is why I share my learnings and project experiences regularly.
📩 If you’d like to collaborate or explore opportunities, feel free to connect with me here.

Key Skills

Data Analysis

SQL

Python

Power BI

Tableau

Data Visualization

Statistical Analysis

Excel

Power Query

Market Research

Problem-Solving

Critical Thinking

Communication Skills

Team Collaboration

My Projects

Hospitality Performance & Revenue Optimization Dashboard

Domain/Function: Hospitality

Business Insights 360 — Enterprise P&L & Forecasting Dashboard

Domain/Function: Finance

AQI Analytics & Air-Purifier Market Intelligence Dashboard

Domain/Function: Marketing

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/abhishek-kumar-593915199

Call Me

+91 6267384181

PowerBI Project

Hospitality Performance & Revenue Optimization Dashboard

Domain/Function: Hospitality

Developed automated KPI dashboards for 50+ hotels, driving ₹2.0B annual revenue with 50% YoY growth. Reduced cancellations by 12% and boosted RevPAR by 18% through OTA analysis and channel optimization.

View Project
Engagement

Other Tools

SQL

Excel

Hotel performance dashboard tracking revenue, occupancy, ADR, RevPAR, cancellations, ratings, and city/category/property insights.

Hotel bookings dashboard showing total bookings, cancellations, realization %, platforms, room class trends, city-wise data, and daily patterns.

Project Details

Automated KPI dashboards across 50+ properties, covering ?2.0B annual revenue with +50.2% YoY growth.
Reduced cancellation rates by 12% through OTA cohort analysis and retention levers.
Recommended direct-channel promotions that improved Realisation% from 84% to 91% and boosted RevPAR by 18%.
Outcome: Enhanced portfolio profitability and improved channel mix efficiency.

Project video

Live Interactive Dashboard

PowerBI Project

Business Insights 360 — Enterprise P&L & Forecasting Dashboard

Domain/Function: Finance

Built enterprise dashboards tracking sales, margins, and profit across 4 regions & 6 product lines. Improved forecast accuracy to 81%, enabling ~10% margin recovery and reducing inventory mismatch risks by 15%.

View Project
Engagement

Financial performance dashboard showing net sales, gross margin, net profit, P&L statement, sales trends, regional and product-wise contributions.

Customer & product performance dashboard showing net sales, gross margin, profitability by clients/segments, performance matrix, and unit economics.

Project Details

Implemented enterprise dashboards tracking Net Sales, Gross Margin, Net Profit across 4 regions & 6 product
segments.
Achieved Forecast Accuracy of 81.17%, reducing inventory mismatch risk by 15%.
Built top/bottom ranking visuals across 200+ SKUs and 300+ customers, enabling focused margin recovery actions.
Outcome: Improved leadership decision-making and supported strategies that led to ~10% margin recovery.

Live Interactive Dashboard

PowerBI Project

AQI Analytics & Air-Purifier Market Intelligence Dashboard

Domain/Function: Marketing

Created AQI dashboards for 150+ cities, analyzing PM10/PM2.5 trends and EV adoption impact. Delivered competitor benchmarking across 6 vendors, driving 2 new product features and shaping regional marketing strategies.

View Project
Engagement

Air quality dashboard showing AQI trends, most/least polluted cities, city-wise differences, monthly AQI, bottom AQI areas, and top 5 states by AQI.

Air purifier market dashboard comparing brands on price, coverage area, noise levels, warranty, and filtration stages for competitive benchmarking.

Project Details

Built AQI dashboards covering 150+ cities and 20+ states, identifying PM10/PM2.5 as top pollutants in 70% regions.
Correlated EV adoption with AQI; revealed high EV-adoption states had ~12% lower average AQI levels.
Conducted competitor analysis across 6+ major vendors, benchmarking features (CADR, coverage, smart controls).
Outcome: Delivered insights that supported 2 new product features and informed regional marketing strategy.