Powered by
Codebasics DA Bootcamp

Shravan Katukojwala

Data Analyst

+91 8309137372 [email protected]

Resume

Hello, I am

Shravan Katukojwala.

1

Excel Project

3

PowerBI Projects

1

SQL Project

1

Python Project

About Me

Welcome to my world of data-driven possibilities!

I’m Shravan Katukojwala, worked as Data Analyst at Intense technologies for 1.5 years, who consume data and communicate insights and loves working with Power BI, SQL, Advanced Excel and Python.

I have the experience of working on real time and my personal projects. A few of my personal projects are attached below. Explore my portfolio to see how I turn complex data into clear, strategic insights that support business decision-making.

Come on, take a look at what I've up my sleeves in my portfolio. I'm passionate about sharing my knowledge and experiences with others, Let's connect and explore opportunities to leverage data for impactful solutions.

Key Skills

SQL

Python

Tableau

SSIS

SSAS

DWH

Advanced Excel

My Projects

My Experience

Dec 2022 - Aug 2024

@Intense technologies Ltd, Hyderabad - Associate Application Support Engineer/Data Analyst

● Created interactive dashboards to provide valuable insights, enabling informed decisions on how to enhance the sales performance.

● Designed and implemented dynamic reports in Excel, Power BI, and SQL, delivering actionable insights that enabled stakeholders to optimize sales tactics, driving a 20% increase in quarterly revenue.

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/shravankatukojwala

+ 91 8309137372

https://github.com/Shravan-DataAnalyst

PowerBI Project

Business Insights 360 - Power BI

Domain/Function: E-commerce / FMCG

AtliQ Hardware is rapidly growing company in the recent years, and they have decided to implement the data analytics using PowerBI in their company for the first time to surpass their competitors in the market and to make data driven decisions. This project is hoped to give answers to the questions.

View Project
on GitHUB

Business Insights 360 - Power BI

Sales View: Unlock sales potential with data-driven precision. Track performance, identify opportunities, and boost revenue.

Business Insights 360 - Power BI

Concise insights for decision-makers. Visualize critical metrics, spot trends, and drive strategy. Empower executives with data-driven clarity.

Project Details

This project, which combines Power BI, SQL, and Excel, centers around addressing operational issues at AtliQ Hardware, a prominent global consumer electronics company. This company led to significant losses in some regions. To rectify this, senior management aims to initiate a data analytics project, leveraging data from the previous year to enhance performance and drive improvements.

Finance View: shows profit and loss statement like GM,NP,NS etc. and performance over time chart w.r.t to key metrices.

Sales View: Shows customers and product performance , unit economics and performance matrix by NS and GM%.

Marketing View: Shows region and product performance , unit economics and performance matrix by NS and GM%.

Supply Chain View: shows forecast accuracy, Net Error, trends and key metrices by customers and product.

Executive View: shows market share of competitors, trends,revenue by division and channel, top 5 customer.

Live Interactive Dashboard

PowerBI Project

Hospitality Analysis - Power BI

Domain/Function: Hospitality

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

Hospitality Analysis - Power BI

Explore the diverse mattresses of the hospitality landscape and gain powerful insights for strategic decision-making.

Hospitality Analysis - Power BI

Discover the secrets to maximizing revenue in the dynamic world of hospitality. Our data-driven approach unravels hidden patterns.

Project Details

AtliQ Grands, renowned for its chain of five-star hotels across India, boasts a rich 20-year history in the hospitality sector. Nevertheless, they currently grapple with diminishing market share and revenue in the luxury and business hotel segment, attributed to competitive pressures and less effective management choices. In response to this challenge, the managing director of AtliQ Grands is embarking on a strategic initiative to integrate "Business and Data Intelligence" into their operations. The primary aim is to recapture market share and bolster revenue.

Live Interactive Dashboard

Excel Project

Road Accident Analysis - Excel

Domain/Function: Public Safety Analytics / Transportation Analytics

An Excel dashboard analyzing UK road accident data. I've dived deep into the numbers to uncover insights about accident trends, locations, and contributing factors.

View Project
on GitHUB

Road Accident Analysis - Excel

The dashboard covers all the important KPIs and also time series filter to view the data insights monthly and quarterly.

Road Accident Analysis - Excel

This sheet has all Pivot tables used for creating the Dashboard.

Project Details

Hello everyone! 🌟

I'm excited to share my latest Excel project on "Road Accident Analysis Dashboard"! 📊

📌 𝐎𝐛𝐣𝐞𝐜𝐭𝐢𝐯𝐞 :-
The main objective of this project is to analyze the road accident in two different years.
▪️ Finding total number of casualties happened in Two years.
▪️ Which helps in getting actionable insights that will helps in reducing road accident by taking necessary measures.

📌 𝐊𝐞𝐲 𝐅𝐢𝐧𝐝𝐢𝐧𝐠𝐬 :-
✔️ KPI's :
▪️ Current year casualties by Monthly Trend
▪️ Previous year casualties by Monthly Trend
▪️ Casualties by Road Surface
▪️ Casualties by Road Type
▪️ Casualties by Location/Area
▪️ Casualties by Light Condition

📌 𝐂𝐨𝐧𝐜𝐥𝐮𝐬𝐢𝐨𝐧 𝐨𝐟 𝐭𝐡𝐞 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬 :-
When we see the analysis we get to know that the casualties are happened more on Car.
▪️ When you compare the casualties between two year that is 2021 and 2022, The number of casualties is decreasing in 2022 when you compared to 2021.

PowerBI Project

Bank Loan Analysis - Power BI

Domain/Function: Finance/Banking/Risk management

Conduct comprehensive analysis of bank loan data to track key performance indicators (KPIs) such as total loan applications, total funded amounts, total received amounts, average interest rates, and average debt-to-income ratios (DTI), aiding in understanding loan trends and patterns.

View Project
on GitHUB

Bank Loan Analysis - Power BI

It provides a comprehensive analysis of bank loan data, offering insights into loan performance.

Bank Loan Analysis - Power BI

It provides a comprehensive analysis of bank loan data, offering insights into loan performance.

Project Details

Dashboard 1: Summary
Delve into our loan portfolio's vital performance indicators (KPIs), covering total loan applications, funded amounts, received amounts, average interest rates, and debt-to-income ratios. Also, dissect the disparities between successful and unsuccessful loans.

Dashboard 2: Overview
Explore interactive charts showcasing monthly trends, geographical analysis, distribution of loan terms, impact of employee length, breakdown of loan purposes, and analysis of home ownership - offering a comprehensive view of our lending activities.

Dashboard 3: Details
This dashboard provides a consolidated perspective on essential loan data, borrower profiles, and loan performance metrics for those seeking in-depth insights.

📌 𝐊𝐞𝐲 𝐏𝐞𝐫𝐟𝐨𝐫𝐦𝐚𝐧𝐜𝐞 𝐈𝐧𝐝𝐢𝐜𝐚𝐭𝐨𝐫𝐬 :-
▪️ Total Loan Application
▪️ Total Funded Amount
▪️ Total Amount Received
▪️ Average Interest Rate
▪️ Average Debt-to-income Ratio

Live Interactive Dashboard

Python Project

Hospitality Analysis - Python

Domain/Function: Hospitality

Atliq Grands encountered tough competition and a decline in revenue. They sought to utilize data and strategic insights but lacked internal expertise. My aim is to conduct a comprehensive analysis using Python to empower Atliq Grands with insights for customer retention and revenue growth.

View Project
on GitHUB

Hospitality Analysis - Python

Crafted average rating per city and pie chart of revenue per booking platform.

Hospitality Analysis - Python

Crafted a table of average occupancy rate per city.

Project Details

In this project , I performed the following operations to get insights.
1. Data Cleaning- Handling missing values and outliers.
2. Data Transformation - Added occupancy% columns.
3. Insights generation-key questions answered
#calculating average occupaancy rate by room type and city.
# Identifying occupancy rate on weekdays and weekends.
# Analyzing revenue generated per city.
# Analyzing monthly revenue trends.
# Assessing revenue by booking platforms.

SQL Project

Ad-hoc Analysis - SQL

Domain/Function: Consumer Goods Domain

Atliq Hardware (imaginary company) is one of the leading computer hardware producers in the globe. Higher management wants to expand their data analytics team by adding several junior data analysts to get enough insights for making quick and smart data-informed decisions.

View Project
on GitHUB

Ad-hoc Analysis - SQL

Line chart for output of SQL query of screenshot for visualizing monthly sales trends

Ad-hoc Analysis - SQL

SQL query for the monthly sales amount report for the customer 'ATLIQ EXCLUSIVE'

Project Details

In the "Consumer Goods Domain" project , I worked on database of Atliq Hardwares. Facing the challenge of data-informed decisions, I answered ten ad-hoc requests to extract actionable insights.
Findings revealed a substantial increase in unique products, a dominant 'Notebook' segment, and a flourishing 'Accessories' category. Sales seasonality and the pivotal role of the 'Retailer' channel were uncovered.
Key learnings included the transformative potential of data analytics for informed decisions, the consumer goods market's dynamic nature, the value of product diversity, the significance of seasonality awareness, and the role of distribution channels in shaping sales outcomes.
The project enhanced my data analysis, problem-solving, and communication skills, contributing to my growth as a data analyst.