Abhishek Kumar

Data Analyst @Umoja Marketplace

[email protected] +91 9110154191

Resume

Hello, I am

Abhishek Kumar.

5

PowerBI
Projects

About Me

I am a skilled and enthusiastic B.Tech graduate specializing in Electronics and Communication Engineering, with a passion for uncovering insights through data. With proficiency in cutting-edge data analysis tools and a portfolio of impactful projects, I bring a creative and analytical approach to solving complex problems. My positive mindset, coupled with excellent communication and soft skills, makes me a valuable team player. I am actively seeking Data Analyst roles to contribute innovative solutions and drive success.

Key Skills

numpy

panda

matplotlib

python

sql

data analysis

My Projects

Credit-Card-Transactions-and-Customer-Report

Domain/Function: Finance

Driving Engagement: Insights into Employee Attrition with Power BI

Domain/Function: Employee Attrition Analysis

Customer Churn Analysis-Bank Data

Domain/Function: Finance

Atliq Hotels Revenue Data Analysis

Domain/Function: Hospitality

T20 World Cup Data Analysis

Domain/Function: Sports

My Experience

Currently working as a Data Analyst at Umoja Marketplace.

Ex-Data Analyst Intern at Yasham Software Services Pvt. Ltd.
Ex-Business Analyst Intern at Quantuva Technologies

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.

Mail Me

[email protected]

http://www.linkedin.com/in/abhishek-stcet

Call Me

+91 9110154191

GitHub

http://www.github.com/abhishek-stcet

PowerBI Project

Credit-Card-Transactions-and-Customer-Report

Domain/Function: Finance

Discover key insights through interactive dashboards that showcase total transactions, interest earned, and revenue. With filters for quarterly trends, demographics, and card types, gain a deeper understanding of customer behavior and top-performing states.

View Project
Engagement

View Project
on GitHUB

Credit Card Transaction Report

Credit Card Customer Report

Project Details

In this project, I aim to uncover patterns and trends in credit card transactions to inform strategic business decisions. I will analyze customer demographics to understand spending behaviors and preferences, optimizing revenue streams through targeted marketing campaigns and product offerings. By enhancing decision-making processes with data-driven insights, I seek to identify opportunities for growth and profitability in the credit card market while improving customer satisfaction and loyalty through tailored services.

Live Interactive Dashboard

PowerBI Project

Driving Engagement: Insights into Employee Attrition with Power BI

Domain/Function: Employee Attrition Analysis

Analyzed employee attrition and tenure using Power BI, exploring age, salary, education, gender, job role, and tenure. Provided insights for better retention and engagement.

View Project
Engagement

View Project
on GitHUB

HR Analytics report

These are the insights from the project.

Project Details

Using Power BI, this project examined why employees leave and how long they stay. Insights revealed that employees aged 26-35 and those earning up to 5k experience the highest attrition rates, often within their first year, particularly among males and those with life sciences backgrounds. Recommendations include targeted retention programs, reviewing compensation and benefits, conducting exit interviews, and offering career development opportunities to improve retention and foster a supportive workplace culture.

Live Interactive Dashboard

PowerBI Project

Customer Churn Analysis-Bank Data

Domain/Function: Finance

Analyzed customer churn for a bank using SQL and Power BI to identify patterns in data from over 10,000 clients. Findings revealed high churn rates among customers with low credit scores and high balances. Developed targeted retention strategies to enhance customer loyalty and satisfaction.

View Project
on GitHUB

Other Tools

MS Excel

SQL

Customer Churn Analysis Dashboard

Insights Generated from the project.

Project Details

In this project, I analyzed customer churn for a bank using data from over 10,000 clients. I employed SQL to extract and query data, focusing on key metrics such as churn rates, credit scores, account balances, and customer demographics. Using Power BI, I created interactive dashboards and visualizations, including KPIs, doughnut charts, and area charts, to reveal insights into customer behavior and churn trends. Key findings indicated higher churn rates among customers with low credit scores and high account balances. I developed targeted recommendations for retention strategies, including personalized financial advisory services and premium offerings. The project aimed to enhance the bank’s ability to retain customers and improve overall customer satisfaction.

Live Interactive Dashboard

PowerBI Project

Atliq Hotels Revenue Data Analysis

Domain/Function: Hospitality

Conducted revenue analysis for Atliq hotel chain using Power BI, examining key metrics like RevPAR, ADR, and occupancy rates. Identified trends in peak revenue periods and regional performance. Provided strategic recommendations for dynamic pricing, enhancing services, and boosting online presence.

View Project
on GitHUB

Other Tools

MS Excel

Atliq Hotels Revenue Data Analysis Dashboard

Insights generated from the project.

Project Details

For the Atliq hotel chain revenue analysis, I utilized Power BI to thoroughly examine and visualize hotel revenue data. The analysis involved cleaning and transforming data to create key performance indicators (KPIs) such as Revenue, RevPAR (Revenue per Available Room), ADR (Average Daily Rate), Occupancy%, and Realization%. I developed interactive dashboards with detailed visualizations, including graphs, doughnut charts, and line charts, to track performance and identify trends. The analysis highlighted peak revenue periods, regional performance variations, and the impact of booking channels. Based on these insights, I recommended implementing dynamic pricing strategies, enhancing luxury services, improving service quality, and boosting the hotel's online presence. The goal was to provide actionable insights to optimize revenue and performance across the hotel chain.

Live Interactive Dashboard

PowerBI Project

T20 World Cup Data Analysis

Domain/Function: Sports

Analyzed T20 World Cup player performance data using Python and Power BI. Developed a comprehensive six-page dashboard with interactive features, showcasing detailed KPIs and performance metrics. The project provided insights into player stats and trends across matches for enhanced decision-making.

View Project
on GitHUB

Other Tools

Pandas

MS Excel

T20 World Cup Data Analysis main dashboard.

T20 World Cup Data Analysis Final 11 team selection.

Project Details

In the T20 World Cup player analysis project, I gathered and analyzed detailed performance data for players from various matches. Using Python with Pandas, I cleaned and transformed the data, creating new columns and merging tables to enhance the dataset. I then developed a six-page interactive dashboard in Power BI, incorporating advanced DAX queries to calculate key performance indicators (KPIs) and metrics. The dashboard featured interactive elements like filters, tooltips, and action buttons, allowing users to explore player performance data effectively. The project aimed to provide in-depth insights into player stats, performance trends, and match impact, facilitating better decision-making and strategic planning for teams and analysts.