Portfolio - Kavin M | Codebasics

Kavin M

Data Aspirant

Resume

1

Python Project

3

PowerBI Projects

1

SQL Project

About Me

Greetings to all profile visitors! 👋 I'm Kavin M, a dedicated data professional fueled by unwavering determination ✨ Hailing from Chennai, Recently completed my undergraduate studies in Computer Science and Engineering. My primary areas of expertise revolve around Python, Power BI, Tableau, SQL, and various analytical tools. Looking forward to connecting and collaborating within the professional sphere.

Key Skills

MySQL

Python

Stakeholder Management

Effective Presentation

My Projects

Hospitality Analysis

Domain/Function: Service Industry

Business Insights 360

Domain/Function: FMCG

IPL Insights 2024

Domain/Function: Entertainment

Ad-Hoc Insights : Consumer Goods

Domain/Function: Consumer Goods

Shield Insurance

Domain/Function: Healthcare

Awards & Certificate

Data Analytics Certification by Pro5.ai

Codebasics Resume Project Challenge

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/kavin-m-124a42206/

Call Me

+91 7305430917

GitHub

https://github.com/Kavin-M-2002

Python Project

Hospitality Analysis

Domain/Function: Service Industry

Atliq Grands owns multiple five-star hotels across India. They have been in the hospitality industry for the past 20 years. Due to strategic moves from other competitors and ineffective decision-making in management, Atliq Grands are losing its market share and revenue in the luxury/business hotels

View Project
on GitHUB

The code snippet suggests the pie chart shows booking revenue grouped by booking platform.

The line graph showing the population of four Indian cities: Delhi, Hyderabad, Mumbai, and Bangalore.

Project Details

As a strategic move, the managing director of Atliq Grands wanted to incorporate “Business and Data Intelligence” in order to regain their market share and revenue. However, they do not have an in-house data analytics team to provide them with these insights.

Their revenue management team had decided to hire a 3rd party service provider to provide them insights from their historical data.

PowerBI Project

Business Insights 360

Domain/Function: FMCG

To improve the transparency and enable data driven decision making across markets and functions and therefore deliver a quantitative benefit of 10% incremental profit.

View Project
on GitHUB

AtliQ's sales dashboard provides a detailed view of customer and product performance, unit economics, and regional sales metrics for 2019.

AtliQ's supply chain dashboard shows key metrics by customer and product, including forecast accuracy, net error, and ABS error for 2019.

Project Details

To Customize a multi-functional Power BI dashboard to analyze AtliQ hardware's sales trends over the global market by gathering data from 2 different sources (Excel/CSV files and a SQL database). Built data model and visualizations in Power BI, and optimized the report with DAX studio which improved the performance of the report by 5%. The dashboard enabled Atliq hardware to analyze different department sales trends and make data-driven decisions, leading to a projected 10% revenue acceleration and 20% reduction in data-related expenses.

Live Interactive Dashboard

PowerBI Project

IPL Insights 2024

Domain/Function: Entertainment

Sports Basics is a sports blog company that entered space recently. They wanted to get more traffic to their website by releasing a special edition magazine on IPL 2024.

View Project
Engagement

View Project
on GitHUB

IPL Insights 2024 ranks top openers based on runs, strike rate, and batting average from the past three years (2021-23), showcasing player strengths.

IPL Insights 2024 ranks all rounders based on runs, strike rate, and batting average from the past three years (2021-23), showcasing player strengths.

Project Details

To enhance brand visibility and drive website traffic for Sports Basics, through the release of a special edition magazine focused on the Indian Premier League (IPL) 2024, offering comprehensive insights, analysis, and intriguing facts derived from the data of the past three years. This initiative aims to captivate and engage fans, analysts, and teams alike, establishing Sports Basics as a go-to source for in-depth coverage and expertise in the realm of sports.

Live Interactive Dashboard

SQL Project

Ad-Hoc Insights : Consumer Goods

Domain/Function: Consumer Goods

Atliq (fictitious company) is one of the leading computer hardware manufacture in India. Atliq is a front-runner in computer hardware manufacturing market, where they have expanded all over the world with their excellence.

View Project
Engagement

Notebooks, Accessories & Peripherals showing significant growth on manufacturing as compared to bottom 3 products.

Flipkart and Amazon received highest and lowest pre invoice discount percentage respectively for the fiscal year 2021.

Project Details

The challenge should include tasks that assess candidates' ability to manipulate and analyze data using SQL queries, while also requiring effective communication of their findings. Additionally, incorporate scenarios that test candidates' problem-solving skills, attention to detail, and ability to collaborate within a team environment.

PowerBI Project

Shield Insurance

Domain/Function: Healthcare

Shield Insurance is a forward-thinking health insurance company dedicated to providing comprehensive and affordable healthcare solutions. With a strong focus on customer satisfaction, Shield Insurance offers a wide range of plans tailored to meet the diverse needs of individuals, families, and etc.

View Project
Engagement

View Project
on GitHUB

Shield Insurance has seen a year-over-year increase in total revenue, but a decrease in total customers month-over-month.

Shield Insurance relies on a mix of sales channels, with offline agents being the most dominant for both customer acquisition and revenue generation.

Project Details

The project aims to comprehensively analyze Shield Insurance's customer base and revenue generation. Key requirements include tracking the number of customers, total revenue, daily growth rates, and monthly policy changes.