Portfolio - Karthikeyani S

PowerBI Project

T20 Cricket Analysis

Domain/Function: Cricket Analysis

Created a Power BI dashboard analyzing T20 World Cup player data to select a balanced 12-member squad. Focused on player roles to build a team that can score 180+ and defend 150. Includes interactive visuals and filters for custom team selection and match planning.

View Project
on GitHUB

This is the player analysis page . You can find the same for each position - top candidates are filtered. There is also a tooltip if you hover over.

This is the final 12 page where the global team and their stats are listed , you can also add the players via the side pane.

Project Details

eveloped a Power BI dashboard by analyzing T20 Cricket World Cup data of global players to pick the best 12-member squad
The analysis focused on evaluating player performance by position to ensure a balanced and high-impact team.
The output was a balanced squad capable of scoring an average of 180 runs and defending a target of 150.
The dashboard includes interactive visuals, filters for custom team selection, and data-driven insights to support strategic decisions for team composition and match planning.

Live Interactive Dashboard

Excel Project

Sales and Finance Analytics

Domain/Function: Sales & Finance

Built interactive Excel dashboards with pivot tables and slicers to analyze sales and finance data, enabling insights and decisions across customer channels.

View Project
on GitHUB

Consolidated report of all the hotel properties of Atliq hotel chains comprising of total revenue generated and average rating

Consolidated report of booking platforms by week and their total revenue generated

Project Details

Created Excel-based reports for Atliq Hardware to support their transition from traditional reporting to more structured data analysis.
Reports focused on Sales and Finance Analytics across various customer channels, including retailers, distributors, and direct sales.
These insights helped Atliq better understand revenue trends, profitability, and customer performance using familiar Excel tools.
Incorporated pivot tables, dynamic charts, and slicers to create interactive dashboards that enabled stakeholders to explore KPIs with ease.

Python Project

Hospitality Analysis

Domain/Function: Hospitality Domain

Used Python to analyze booking and customer data for a hotel chain, revealing trends in revenue, city ratings, and platform share to help identify top hotels and boost revenue.

View Project
on GitHUB

Exploring the hotel data set .

Finding insights to questions from stakeholders.

Project Details

Analyzed declining revenue trends for Atliq Grands, a hotel chain across India, by exploring booking and customer data.
Used Python to extract insights like revenue per hotel, average city ratings, and platform-wise revenue share.
Delivered actionable insights through visualizations, helping management identify high-performing hotels and key revenue channels.

SQL Project

Retail Order Analysis

Domain/Function: Retail Domain

Cleaned retail order data using Python, loaded it into SQL, and analyzed revenue trends, top products, and sales peaks to drive efficient and accurate business insights.

View Project
on GitHUB

Imported data form Kaggle and cleaned the data using Python.

Using SQL to get insights on the data and answer questions.

Project Details

Performed extensive data cleaning and preprocessing in Python on a Retail Orders dataset downloaded via Kaggle API.
Uploaded the cleaned dataset to SQL and wrote optimized queries to analyze product revenue, year-over-year sales trends, and category-wise performance.
Identified top-performing products, peak sales months, and high-growth sub-categories, enabling actionable retail business insights.
Streamlined the data pipeline from raw CSV to SQL-based analytics, improving efficiency and accuracy in business reporting.

PowerBI Project

Business 360

Domain/Function: E-commerce Domain

Built a Power BI dashboard to unify global sales data, replacing Excel reports and enabling real-time KPI tracking and faster decisions after losses in Latin America.

View Project
on GitHUB

Power BI dashboard depicting Finance insights with interactive components.

Power BI dashboard depicting Sales insights with interactive components.

Project Details

A consumer electronics company operating globally suffered losses in Latin America due to inefficient Excel-based analytics.
Business teams struggled to derive insights from fragmented spreadsheets, hindering timely decision-making across regions.
Used Power BI to build an interactive dashboard that unified sales, profit, and product performance data across countries.
Replaced static reports with a dynamic analytics platform, empowering executives to monitor KPIs and detect regional risks in real time.

Hello, I am

Karthikeyani S

1

2

1

1

About

Key

My

T20 Cricket Analysis

Sales and Finance Analytics

Hospitality Analysis

Retail Order Analysis

Business 360

My

Awards

Contact Me

Email

Github

Linkedin

Call

Karthikeyani S