Powered by
Codebasics Bootcamp

Santhoshkumar MS

Data Analyst

+91 9123596803 [email protected]

Resume

Hello, I am

Santhoshkumar MS.

2

Excel Projects

3

PowerBI Projects

1

SQL Project

About Me

Welcome to my portfolio! I'm excited about digging into data and discovering its secrets as I aspire to be a skilled Data Analyst. I'm familiar with Excel, PowerBI, SQL, and Python, tools that help me make sense of data and find valuable insights.

Even though I graduated in Electronics and Communication Engineering, I found my true passion in data analysis. Through some projects I've tackled, which you can check out below, I've become adept at unraveling data puzzles and drawing meaningful conclusions.

While I haven't yet worked in a formal setting, my determination to master data analysis keeps me going. Take a look at my portfolio to see how I'm putting my skills to work. Let's dive into the world of data together and uncover its endless possibilities!

Key Skills

Excel

PowerBI

SQL

Python

MYSQL

My Projects

Awards & Certificate

Excel: Mother of Business Intelligence

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

SQL Beginner to Advanced For Data Professionals

Python (Basics)

Data Visualisation: Empowering Business with Effective Insights

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.

[email protected]

https://www.linkedin.com/in/santhoshkumar-ms/

+ 91 9123596803

https://github.com/santhosh803

PowerBI Project

IPL 2024 Analysis based on Last 3 year's Data

This project aims to find insights into Last 3 IPL Seasons on the basis of given data sets. It's project challenge conducted by Codebasics as a Resume Project Challenge. This project has given me the opportunity to showcase my ability and interest in analytics.

IPL 2024 Analysis based on Last 3 year's Data

This slide helps us in analyzing the Batters Performance based on last 3 year's data

IPL 2024 Analysis based on Last 3 year's Data

This slide helps us in analyzing the Bowlers Performance based on last 3 year's data

Project Details

"Sports Basics" is a sports blog company that entered this space recently. They wanted to get more traffic to their website by releasing a special edition magazine on IPL 2024. This magazine aims to provide interesting insights and facts for fans, analysts and teams based on the last 3 years' data.

Live Interactive Dashboard

PowerBI Project

Promotion Analysis for AltiQ Mart

AtliQ Mart is a retail giant with over 50 supermarkets in the southern region of India. All their 50 stores ran a massive promotion during the Diwali 2023 and Sankranti 2024 (festive time in India) on their AtliQ branded products. Analyse the performance of promotions during campaigns.

Other Tools

MySQL

Excel

Promotion Analysis for AltiQ Mart

This slide helps us in analyzing the performance of Promotions during Diwali and Sankranti campaigns

Promotion Analysis for AltiQ Mart

This slide helps us in analyzing the performance of Products & Categories during Diwali and Sankranti campaigns

Project Details

🔍 Problem Statement:
As a data enthusiast at AtliQ Mart, I took on the challenge to analyze promotions and provide tangible insights to our Sales Director, Bruce Haryali. With AtliQ Mart running a massive promotion across all 50 stores during Diwali 2023 and Sankranti 2024, the goal was to determine the effectiveness of these promotions and inform strategic decisions for future campaigns.
💼 Domain: FMCG
📊 Function: Sales / Promotions

📈 Project Overview:
Utilizing tools like MySQL and Power BI, I meticulously analyzed promotion data to unveil key insights for AtliQ Mart's sales strategy. The comprehensive analysis encompassed store performance, promotion effectiveness, and product-category dynamics.

🔍 Insights Delivered:
- Identified top-performing stores and promotions to replicate success.
- Analyzed product and category trends to optimize promotional strategies.
- Provided actionable recommendations to enhance future promotional efforts.

Live Interactive Dashboard

PowerBI Project

Business Insights 360

Business Insights 360 Dashboard is for analyzing Finance, Sales, Marketing, Supply Chain & Executive aspects of a ficitional hardware company called AtliQ Hardwares. It is designed in a way to get actionable insights from business operations/relationships of AtliQ Hardwares with its Customers.

Other Tools

MySQL

Excel

Business Insights 360

This slide helps us in analyzing the Financial operations of AtliQ Mart

Business Insights 360

This slide helps us in analyzing the Marketing operations of AtliQ Mart

Project Details

● Build a multi-functional Power BI dashboard to analyze fictional company named AtliQ hardware's sales trends over the global market by gathering data from 2 different sources (Excel/CSV files and a SQL database).
● 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

Excel Project

Financial Report

Financial Report gives actionable insights on the Financial operations of AtliQ Hardwares through P & L analysis and Gross Margin % analysis for Quarters in Subzone

View Project
on GitHUB

Financial Report

This helps us in analyzing P & L of AtliQ Hardwares for different markets

Financial Report

This report helps us in analzing Gross Margin % of sales for quarters in Subzone for different fiscal years

Project Details

This report helps us in analyzing the Financial operations of AtliQ Hardwares with its Customers in selling hardwares

Excel Project

Sales Report

Sales Report gives actionable insights on the Product Sales of AtliQ Hardwares through analyzing the performance of products as per country, year and through Division Level Sales and finally through analyzing the performance of New product sales in specific year

View Project
on GitHUB

This slide helps us in analyzing the Top 10 best performing products as per sales in 2020 and 2021

This slide helps us in analyzing the Division Level Sales in 2020 and 2021

Project Details

This report helps us in analyzing Top 10 best performing products and Division Level Report for product sales. This also helps us in analyzing New product sales in 2021, Top 5 country as per 2021 sales, 5 Best & 5 Worst performing products

SQL Project

Adhoc Insights Analysis in Consumer Goods Domain

Utilizing the power of SQL in MysQL, I answered every ad-hoc requests that are raised by Sales Director/Stake Holders on sales happened in FY2020 & FY2021. Report on Adhoc Insights helps stake holders to take quick data informed decisions.

View Project
Engagement

View Project
on GitHUB

Other Tools

MySQL

Adhoc Insights Analysis in Consumer Goods Domain

AtliQ Hardware's Quarterly Results on Total Sold Units in the fiscal year 2020

Adhoc Insights Analysis in Consumer Goods Domain

Top 5 Indian Customers who received high average pre-invoice discount percentage

Project Details

Domain: Consumer Goods | Function: Executive Management

Atliq Hardwares (imaginary company) is one of the leading computer hardware producers in India and well expanded in other countries too. However, the management noticed that they do not get enough insights to make quick and smart data-informed decisions. They want to expand their data analytics team by adding several junior data analysts. Tony Sharma, their data analytics director wanted to hire someone who is good at both tech and soft skills. Hence, he decided to conduct a SQL challenge which will help him understand both the skills

Full Name *

Email *

Phone Number *

I want to know about: *

I agree to use my communication details for further communication from codebasics.