Codebasics Logo

Powered by
Codebasics DA Bootcamp

Home

About

Projects

Experience

Certificates

Contact
Hello, I am

Rohan Kewat

Data Aspirant
Resume
Rohan Kewat

2

PowerBI
Projects

1

Excel
Project

About

Me

👋 Hi, I’m Rohan — a detail-oriented professional with a strong foundation in data analytics, currently transitioning from a customer support background into a full-time analytics role.

With over a year of experience in chat support at IGT Solutions (Frontier Airlines process), I developed a passion for solving problems using data. During my time there, I analyzed thousands of chat records using Excel, built Power BI dashboards to track key metrics like AHT and CSAT, and helped the team reduce handling time by 12%.

I’ve since strengthened my skills in Power BI, Excel, and SQL, and completed multiple hands-on projects in stock analysis, business insights, and customer behavior.

I’m currently looking for opportunities where I can apply my analytical mindset to solve business problems, uncover insights, and drive better decision-making.

📊 Tools I work with: Power BI, Excel, SQL, DAX
📌 Interested in: Data Analyst, BI Analyst, Reporting Analyst roles

Key

Skills

Excel

PowerBI

Tableau

SQL

Effective communication

Data cleaning

Data modeling

Stakeholder Management

My

Projects

Business Insights 360 Dashboard
Business Insights 360 Dashboard

Domain/Function: Finance, 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 in

See My Work PowerBI
Hospitality Analysis
Hospitality Analysis

Domain/Function: Hospitality Sector

I'm on board to help AtliQ Grand, a well-known hotel chain with five-star properties in major Indian cities. Despite its good reputation, they're seeing a drop in revenue and market share. They seek my help to analyze data and offer insights. Using Power BI, I'll chart the course to success.

See My Work PowerBI
Excel - Sales Analytics
Excel - Sales Analytics

Domain/Function: Sales Analytics(FMCG)

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.

See My Work Excel

My

Experience

1). Analyzed over 5,000+ customer chat records using Excel to identify common response delay patterns, contributing to a 12% improvement in Average Handling Time (AHT).
2). Designed and built an interactive Power BI dashboard to track daily chat volume, first response time, resolution rates, and CSAT trends, enabling team leads to make data-driven performance decisions.
3). Collaborated with quality analysts to create weekly reports on agent performance and service metrics.
4). Supported internal process improvements through data insights, leading to faster response workflows and better customer satisfaction.
5). Managed 3 concurrent chats efficiently while maintaining a CSAT score above target.

Awards

& Certificate

CB Cert

Excel: Mother of Business Intelligence

CB Cert

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