Portfolio - Ranjith Senthilkumar | Codebasics

Powered by
Codebasics DA Bootcamp

Ranjith Senthilkumar

Data Analyst

EMAIL

[email protected]

PHONE

+91 8608447569

About Me

As a data analyst, I’ve learned that the numbers don’t just tell a story—they reveal the truth.

When I first started, I thought it was all about crunching data and making reports. But over time, I realized it’s much more than that. It’s about understanding patterns, asking the right questions, and uncovering insights that can change the way we think.

The biggest challenge for me? Balancing between the technical side of things and the human side. Yes, data is all about numbers, but at the end of the day, it’s the people that matter. It’s about how the data can make their lives easier, decisions smarter, and businesses better.

I’ve learned that no dataset is perfect. There are gaps, inconsistencies, and challenges. But that’s where the real work happens—finding solutions and making sense of it all.

1

Excel Project

3

PowerBI Projects

1

SQL Project

1

Python Project

Key Skills

PowerBI

Advanced Excel

MySQL

Pandas

Data Cleaning

My Projects

My Experience

Awards & Certificate

Excel: Mother of Business Intelligence

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

SQL Beginner to Advanced For Data Professionals

Tableau Mini

Python for Data Science

Python for Data Science

Data Modeling

Introduction to BI

Introduction to BI

Let's Work Together!

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.

EMAIL

[email protected]

Call Me

+91 8608447569

LinkedIn

https://www.linkedin.com/in/ranjithprofessionall/

GitHub

https://github.com/Ranjith-Senthilkumar

Excel Project

Sales Report : End of Fiscal Year

Domain/Function: Finance

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.

View Project
Engagement

View Project
on GitHUB

View Project
on MS Excel

Sales Report : End of Fiscal Year

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

Sales Report : End of Fiscal Year

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

Project Details

In this project, I created a sales report using excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

PowerBI Project

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

Domain/Function: Business and Data Analytics

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

View Project
on GitHUB

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

User-empathetic landing page as a part of dashboard design

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

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

Live Interactive Dashboard

PowerBI Project

GoodCabs Business Analysis and Data Visualization

Domain/Function: Transportation and Mobility

A two-year-old cab service operating in ten tier-2 cities in India. The goal is to support local drivers and enhance passenger satisfaction through data-driven insights. This project is part of the Codebasics Resume Project Challenge 13.

View Project
Engagement

View Project
on GitHUB

GoodCabs Business Analysis and Data Visualization

City-Level Analysis: Some cities like Mysore and Jaipur have consistently exceeded their target metrics (PR, NP, or Trips).

GoodCabs Business Analysis and Data Visualization

Recommend offering driver incentives, adjusting fares, enhancing passenger experience, and optimizing fleet management to improve Efficiency.

Project Details

The project focuses on analyzing data from Goodcabs, a cab service company established two years ago, operating in ten tier-2 cities across India. The primary objective is to support local drivers and improve passenger satisfaction by leveraging data analytics. The project involves analyzing various performance metrics, such as driver efficiency, passenger ratings, fare trends, and customer behavior, to identify areas of improvement and optimize the overall service experience. The insights generated from this analysis aim to enhance decision-making processes for the company, improve operational efficiency, and ultimately provide better service to both drivers and passengers.

Live Interactive Dashboard

SQL Project

Customer Analysis : Report using SQL Queries

Domain/Function: Finance, Supply Chain, Marketing

Developed solution for Finance, Supply Chain , and Customer/Market/Product, leveraging techniques like user-defined functions, stored procedures, CTEs, and sub queries.

View Project
Engagement

View Project
on GitHUB

Customer Analysis : Report using SQL Queries

Designed an ER diagram, created a database, and implemented SQL methods like triggers, CTEs, and stored procedures for efficient data management.

Customer Analysis : Report using SQL Queries

Optimized SQL query to retrieve pre-invoice deductions in Croma's detailed report, enhancing efficiency and ensuring accurate financial insights.

Project Details

Utilized advanced SQL techniques to deliver key insights into customer, product, and market performance:

Created views and Common Table Expressions (CTEs) to generate detailed pre-invoice and post-invoice discount analysis reports.
Developed stored procedures to identify top-performing markets by net sales and top customers within specific markets and fiscal years.

Python Project

AtliQ Grands Analysis

Domain/Function: Exploratory Data Analysis (EDA)

A Hotel AtliQ Grands needs a help of data analytics team to generate reports and make analysis of their datasets to increase revenue and control the flow of process by data informed.

View Project
Engagement

View Project
on GitHUB

AtliQ Grands Analysis

Utilized matplotlib to visualize the critical data (Charts : Bar, pie)

AtliQ Grands Analysis

Removed outliers - Standard deviation more than 3 and less than -3.

Project Details

This project analyze the hotel booking data for AtliQ Grands to extract insights and patterns for business improvement. Using five datasets(Csv files).

Overview,
• Data cleaning addresses issues such as negative guest counts and outliers in revenue data.
•Bookings with invalid guest numbers are removed.
•Extreme revenue outliers are filtered based on statistical limits.
•Visualizations provide insights into booking patterns and platform usage.
•The project prepares clean, structured data for deeper analysis and predictive modeling to enhance hotel operations and customer experience.

PowerBI Project

Shield Insurance Analysis

Domain/Function: Insurance

As part of virtual internship in AtliQ Technologies, Developed power bi dashboard for client to analyse past 6 months records of their(Shield Insurance) data.

View Project
Engagement

Shield Insurance Analysis

Designed a general view page to analyse the overall performance of shield insurance company - Used complex DAX to produce insights and reports.

Shield Insurance Analysis

Developed a user support page for stack holders to understand working methodology of dashboard.

Project Details

Description:
This project focuses on analyzing data for Shield Insurance, aimed at uncovering valuable insights for improved decision-making. Using tools like Power BI and Excel, the analysis covers customer demographics, premium trends, settlement rates, and Revenue performance across various modes.

Live Interactive Dashboard