Powered by
Codebasics DA Bootcamp

VADLAMUDI ARUN KUMAR

Data Analyst

+91 8096583367 [email protected]

Resume

Hello, I am

VADLAMUDI ARUN KUMAR.

1

Excel Project

3

PowerBI Projects

4

SQL Projects

About Me

𝐖𝐞𝐥𝐜𝐨𝐦𝐞 𝐭𝐨 𝐦𝐲 𝐩𝐨𝐫𝐭𝐟𝐨𝐥𝐢𝐨!
I’m an 𝐞𝐧𝐭𝐡𝐮𝐬𝐢𝐚𝐬𝐭𝐢𝐜 𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐬𝐭 ready to turn data into your next strategic advantage. Armed with a 𝐁𝐚𝐜𝐡𝐞𝐥𝐨𝐫'𝐬 𝐝𝐞𝐠𝐫𝐞𝐞 in 𝐌𝐚𝐭𝐡𝐞𝐦𝐚𝐭𝐢𝐜𝐬, 𝐒𝐭𝐚𝐭𝐢𝐬𝐭𝐢𝐜𝐬, 𝐚𝐧𝐝 𝐂𝐨𝐦𝐩𝐮𝐭𝐞𝐫 𝐒𝐜𝐢𝐞𝐧𝐜𝐞.

I Learn 𝐄𝐱𝐜𝐞𝐥, 𝐏𝐨𝐰𝐞𝐫𝐁𝐈, 𝐒𝐐𝐋, 𝐚𝐧𝐝 𝐏𝐲𝐭𝐡𝐨𝐧, transforming complex datasets into clear, actionable insights.Though my professional experience is just beginning, I’ve poured my heart into a series of business projects that showcase my knack for solving real-world problems with data. 𝐄𝐚𝐜𝐡 𝐩𝐫𝐨𝐣𝐞𝐜𝐭 𝐢𝐧 𝐦𝐲 𝐩𝐨𝐫𝐭𝐟𝐨𝐥𝐢𝐨 highlights my innovative approach and commitment to excellence.

I’m excited to bring my 𝐚𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐚𝐥 𝐩𝐫𝐨𝐰𝐞𝐬𝐬 𝐚𝐧𝐝 𝐟𝐫𝐞𝐬𝐡 𝐩𝐞𝐫𝐬𝐩𝐞𝐜𝐭𝐢𝐯𝐞 𝐭𝐨 𝐚 𝐟𝐨𝐫𝐰𝐚𝐫𝐝-𝐭𝐡𝐢𝐧𝐤𝐢𝐧𝐠 𝐭𝐞𝐚𝐦. Dive into my projects below and discover how I can help drive your data-driven decisions forward!

Key Skills

SQL

Effective Comunication

Excel

power BI

Python

Tableau

My Projects

My Experience

Internship_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

Data Analytics Bootcamp 4.0: With Practical Job Placement Support + AI for Data Analysts

Python: Beginner to Advanced For Data Professionals

Scam Awareness Course

Tableau Mini

Data Analytics with Tableau

Data Analytics with Tableau

Letter of Experience Internship

Letter of Experience Internship

Master Data Management

Master Data Management

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/vadlamudi-arun-kumar/

+ 91 8096583367

https://github.com/VAKGK

PowerBI Project

SHIELD_INSURANCE

Domain/Function: Insurance

Track the daily revenue growth rate and daily customer growth rate to monitor our progress.Monitoring changes in policies on a month-over-month basis is also important to identify trends and areas for improvement.

View Project
Engagement

View Project
on GitHUB

SHIELD_INSURANCE

User-empathetic landing page as a part of dashboard design

SHIELD_INSURANCE

Data modelling involving 5 tables

Project Details

🛡️ 𝑺𝑯𝑰𝑬𝑳𝑫 𝑰𝑵𝑺𝑼𝑹𝑨𝑵𝑪𝑬 ✨

𝐒𝐡𝐨𝐫𝐭 𝐈𝐧𝐟𝐨 𝐀𝐛𝐨𝐮𝐭 𝐏𝐫𝐨𝐣𝐞𝐜𝐭 :
Track the daily revenue growth rate and daily customer growth rate to monitor our progress.Monitoring changes in policies on a month-over-month basis is also important to identify trends and areas for improvement.

𝐊𝐞𝐲 𝐌𝐞𝐭𝐫𝐢𝐜𝐬 𝐓𝐫𝐚𝐜𝐤𝐞𝐝:
➜ 𝐑𝐏𝐌 - Revenue Per Month
➜ 𝐂𝐏𝐌 - Customer Per Month
➜ 𝐃𝐂𝐆 - Daily Customer Growth
➜ 𝐃𝐑𝐆 - Daily Revenue Growth
(I have explained the problem statement in the video)

𝐊𝐧𝐨𝐰𝐥𝐞𝐝𝐠𝐞 𝐠𝐚𝐢𝐧𝐞𝐝 𝐟𝐫𝐨𝐦 𝐭𝐡𝐢𝐬 𝐩𝐫𝐨𝐣𝐞𝐜𝐭 :
➜Deepened understanding of Insurance operations and terminology
➜Applied advanced DAX functions (e.g., finding date gaps, Dynamic Titles, Indicators)
➜Used trend chart along with key metrics, just show the trend along with the metrics itself
➜Explored new visualizations, Ribbon Charts,Switch buttons

𝐈𝐧 𝐭𝐡𝐢𝐬 𝐩𝐫𝐨𝐣𝐞𝐜𝐭, 𝐈 𝐡𝐚𝐯𝐞 𝐮𝐬𝐞𝐝 𝐭𝐨𝐨𝐥𝐬 𝐥𝐢𝐤𝐞:
➜ 𝐄𝐱𝐜𝐞𝐥
➜ 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈

Project video

Live Interactive Dashboard

SQL Project

FESTIVE PROMOTION PERFORMANCE ANALYSIS

Domain/Function: Marketing

𝐀𝐭𝐥𝐢𝐐 𝐌𝐚𝐫𝐭, a retail giant with 50 supermarkets, ran major promotions during 𝐃𝐢𝐰𝐚𝐥𝐢 𝟐𝟎𝟐𝟑 𝐚𝐧𝐝 𝐒𝐚𝐧𝐤𝐫𝐚𝐧𝐭𝐢 𝟐𝟎𝟐𝟒. Sales director Bruce Haryali needs immediate insights on promotion performance, and data analyst Peter Pandey is on the job. 📊🚀

View Project
Engagement

View Project
on GitHUB

View Project
on

Other Tools

power bi

FESTIVE PROMOTION PERFORMANCE ANALYSIS

User-empathetic landing page as a part of dashboard design

FESTIVE PROMOTION PERFORMANCE ANALYSIS

Data modelling involving 4 tables

Project Details

🌾 𝗙𝗲𝘀𝘁𝗶𝘃𝗲 𝗣𝗿𝗼𝗺𝗼𝘁𝗶𝗼𝗻𝘀 𝗣𝗲𝗿𝗳𝗼𝗿𝗺𝗮𝗻𝗰𝗲 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀 𝗳𝗼𝗿 𝗔𝘁𝗹𝗶𝗤 𝗠𝗮𝗿𝘁 💥

𝗦𝗵𝗼𝗿𝘁 𝗜𝗻𝗳𝗼 💬 𝗔𝗯𝗼𝘂𝘁 𝗣𝗿𝗼𝗷𝗲𝗰𝘁 :
𝐀𝐭𝐥𝐢𝐐 𝐌𝐚𝐫𝐭, a retail giant with 50 supermarkets, ran major promotions during 𝐃𝐢𝐰𝐚𝐥𝐢 𝟐𝟎𝟐𝟑 𝐚𝐧𝐝 𝐒𝐚𝐧𝐤𝐫𝐚𝐧𝐭𝐢 𝟐𝟎𝟐𝟒. Sales director Bruce Haryali needs immediate insights on promotion performance, and data analyst Peter Pandey is on the job. 📊🚀

𝙍𝙚𝙦𝙪𝙚𝙨𝙩𝙨 𝘼𝙙𝙙𝙧𝙚𝙨𝙨𝙚𝙙:
➜Store Performance Analysis
➜ Promotion Type Analysis
➜ Product and Category Analysis
(I have explained the problem statement in the video)

𝐊𝐧𝐨𝐰𝐥𝐞𝐝𝐠𝐞🧠 𝐠𝐚𝐢𝐧𝐞𝐝 𝐟𝐫𝐨𝐦 𝐭𝐡𝐢𝐬 𝐩𝐫𝐨𝐣𝐞𝐜𝐭 :
➜Deepened understanding of FMCG (𝐅𝐚𝐬𝐭 𝐌𝐨𝐯𝐢𝐧𝐠 𝐂𝐨𝐧𝐬𝐮𝐦𝐞𝐫 𝐆𝐨𝐨𝐝𝐬.) business operations
➜Applied DAX functions and Created Caculated Columns
➜Utilized Scatter charts with 𝐓𝐢𝐭𝐥𝐞𝐬, 𝐏𝐚𝐠𝐞 𝐍𝐚𝐯𝐢𝐠𝐚𝐭𝐢𝐨𝐧, and Tooltips & Maps Visual
➜Explored new visualization techniques

Project video

SQL Project

IPL ANALYSIS (2021 - 2023)

Domain/Function: Sports

Analyzed 𝐈𝐏𝐋 𝐃𝐚𝐭𝐚 (2021–2023) to uncover top 𝐩𝐥𝐚𝐲𝐞𝐫 𝐩𝐞𝐫𝐟𝐨𝐫𝐦𝐚𝐧𝐜𝐞𝐬, 𝐭𝐞𝐚𝐦 𝐭𝐫𝐞𝐧𝐝𝐬 and winning strategies. Delivered insights and predictions for a special 𝐈𝐏𝐋 𝟐𝟎𝟐𝟒 𝐦𝐚𝐠𝐚𝐳𝐢𝐧𝐞 edition by 𝐒𝐩𝐨𝐫𝐭𝐬 𝐁𝐚𝐬𝐢𝐜𝐬.

View Project
Engagement

View Project
on GitHUB

View Project
on

IPL ANALYSIS (2021 - 2023)

User-empathetic landing page as a part of dashboard design

IPL ANALYSIS (2021 - 2023)

Data modelling involving 5 tables

Project Details

🏏𝑰𝑷𝑳 𝑨𝑵𝑨𝑳𝒀𝑺𝑰𝑺 (2021-2023)

📌 𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐆𝐨𝐚𝐥:

Analyzed 𝐈𝐏𝐋 𝐃𝐚𝐭𝐚 (2021–2023) to uncover top 𝐩𝐥𝐚𝐲𝐞𝐫 𝐩𝐞𝐫𝐟𝐨𝐫𝐦𝐚𝐧𝐜𝐞𝐬, 𝐭𝐞𝐚𝐦 𝐭𝐫𝐞𝐧𝐝𝐬 and winning strategies. Delivered insights and predictions for a special 𝐈𝐏𝐋 𝟐𝟎𝟐𝟒 𝐦𝐚𝐠𝐚𝐳𝐢𝐧𝐞 edition by 𝐒𝐩𝐨𝐫𝐭𝐬 𝐁𝐚𝐬𝐢𝐜𝐬.

📊 𝐂𝐨𝐯𝐞𝐫𝐞𝐝:
✔️ Batting & Bowling Performance 🏏
✔️ Team Trends 📊
✔️ Orange & Purple Cap Predictions
✔️ Best Allrounders & Team-11

(𝑰 𝒉𝒂𝒗𝒆 𝒆𝒙𝒑𝒍𝒂𝒊𝒏𝒆𝒅 𝒕𝒉𝒆 𝒑𝒓𝒐𝒃𝒍𝒆𝒎 𝒔𝒕𝒂𝒕𝒆𝒎𝒆𝒏𝒕 𝒊𝒏 𝒕𝒉𝒆 𝒗𝒊𝒅𝒆𝒐)

🧠 𝐖𝐡𝐚𝐭 𝐈 𝐋𝐞𝐚𝐫𝐧𝐞𝐝:
➤ Deeper IPL insights
➤ Advanced 𝐃𝐀𝐗 (e.g., ADDColumns, Summarize)
➤ Dynamic KPIs, Page Navigation, Tooltips, Image URLs
➤ Creative Visualizations

🔧 𝐓𝐨𝐨𝐥𝐬 𝐔𝐬𝐞𝐝:
✅ 𝐌𝐲𝐒𝐐𝐋 – Data querying
✅ 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 – Dynamic dashboards
✅ 𝐏𝐨𝐰𝐞𝐫𝐏𝐨𝐢𝐧𝐭 – Insightful storytelling

Project video

SQL Project

ATLIQ GRANDS HOSPITALITY ANALYSIS

Domain/Function: HOSPITALITY

AtliQ Grands, a five-star hotel chain, is seeking to 𝐫𝐞𝐠𝐚𝐢𝐧 𝐦𝐚𝐫𝐤𝐞𝐭 𝐬𝐡𝐚𝐫𝐞and revenue in the luxury/business segment through "Business and Data Intelligence." They’ve hired a 3rd party service provider to analyze historical data, as they lack an in-house analytics team.

View Project
Engagement

View Project
on GitHUB

View Project
on Codebasics

ATLIQ GRANDS HOSPITALITY ANALYSIS

User-empathetic landing page as a part of dashboard design

ATLIQ GRANDS HOSPITALITY ANALYSIS

Data modelling involving 5 tables

Project Details

🛡️ 𝑨𝑻𝑳𝑰𝑸 𝑮𝑹𝑨𝑵𝑫𝑺 𝑯𝑶𝑺𝑷𝑰𝑻𝑨𝑳𝑰𝑻𝒀 𝑨𝑵𝑨𝑳𝒀𝑺𝑰𝑺 ✨

𝐒𝐡𝐨𝐫𝐭 𝐈𝐧𝐟𝐨 𝐀𝐛𝐨𝐮𝐭 𝐏𝐫𝐨𝐣𝐞𝐜𝐭 :
AtliQ Grands, a five-star hotel chain, is seeking to 𝐫𝐞𝐠𝐚𝐢𝐧 𝐦𝐚𝐫𝐤𝐞𝐭 𝐬𝐡𝐚𝐫𝐞and revenue in the luxury/business segment through "Business and Data Intelligence." They’ve hired a 3rd party service provider to analyze historical data, as they lack an in-house analytics team.

𝐊𝐞𝐲 𝐌𝐞𝐭𝐫𝐢𝐜𝐬 𝐓𝐫𝐚𝐜𝐤𝐞𝐝:
➜ Revenue
➜ Occupancy
➜ Average_Rating

𝐈𝐧 𝐭𝐡𝐢𝐬 𝐩𝐫𝐨𝐣𝐞𝐜𝐭, 𝐈 𝐡𝐚𝐯𝐞 𝐮𝐬𝐞𝐝 𝐭𝐨𝐨𝐥𝐬 𝐥𝐢𝐤𝐞:
➜ 𝗠𝘆𝗦𝗤𝗟 - To Query the Database
➜ 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 - to visualize the data
➜ 𝐏𝐨𝐰𝐞𝐫𝐏𝐨𝐢𝐧𝐭 - to present the Insights

Project video

SQL Project

CONSUMER GOODS AD_HOC_INSIGHTS

Domain/Function: CONSUMER GOODS

Atliq Hardwares, a leading computer hardware producer, lacks the necessary data insights to make informed, timely decisions.The Supply Chain team is implementing a standardized approach to measure service levels using OT, IF, and OTIF metrics.

View Project
Engagement

View Project
on GitHUB

View Project
on

CONSUMER GOODS AD_HOC_INSIGHTS

User-empathetic landing page as a part of dashboard design

CONSUMER GOODS AD_HOC_INSIGHTS

Data modelling involving 6 tables

Project Details

🌟 Consumer Goods Ad-Hoc Insights Project 🌟

I’m thrilled to present my latest project with Atliq Hardwares (an imaginary company), designed to address 10 specific ad-hoc requests. This comprehensive report caters to dynamic business needs and provides actionable insights.ch could be used by ad_Hoc_Requests

Requests Addressed:

➜Atliq Exclusive's Markets
➜ Unique Product Increase
➜ Product Count By Segment
➜ Segment With Highest Increase
➜ Highest and Lowest Manufacturing Cost
➜Top 5 Indian Customers
➜ Atliq Exclusive's Gross Sales Amount
➜Total Sold Quantity by Quarter
➜Gross Sales Amount By Channel
➜Top 3 Products by Division

(I have explained the problem statement in the video)

𝐊𝐧𝐨𝐰𝐥𝐞𝐝𝐠𝐞 𝐠𝐚𝐢𝐧𝐞𝐝 𝐟𝐫𝐨𝐦 𝐭𝐡𝐢𝐬 𝐩𝐫𝐨𝐣𝐞𝐜𝐭 :
➜Deepened understanding of consumer goods business operations
➜Applied new DAX functions (e.g., NATURALINNERJOIN)
➜Utilized Scatter charts with Dynamic Titles, Page Navigation, and Tooltips
➜Explored new visualization techniques

Project video

PowerBI Project

BUSINESS INSIGHTS 360

Domain/Function: Brick & Mortar and E-commerce

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

User-empathetic landing page as a part of dashboard design

BUSINESS INSIGHTS 360

Data modelling involving 10+ tables

Project Details

🌟 Business Insights 360 Project 🌟

I’m excited to share my latest project with Atliq Hardwares (an imaginary company), designed to provide comprehensive insights across multiple functions. This single report caters to the needs of stakeholders from sales, marketing, finance, and executive teams.

Views Included:

➜Economy View
➜ Sales View
➜ Marketing View
➜ Supply chain View
➜ Executive View

(I have explained the problem statement in the video)

𝐊𝐧𝐨𝐰𝐥𝐞𝐝𝐠𝐞 𝐠𝐚𝐢𝐧𝐞𝐝 𝐟𝐫𝐨𝐦 𝐭𝐡𝐢𝐬 𝐩𝐫𝐨𝐣𝐞𝐜𝐭 :

➜Enhanced understanding of and Brick&Mortar and E-commerce business operations
➜Applied advanced DAX functions (e.g., SAMEPERIODLASTYEAR, differences between ISCROSSFILTERED and ISFILTERED)
➜Utilized Scatter charts with Switch Buttons, Dynamic Titles, Page Navigation, and Tooltips
➜Explored new visualization techniques

Project video

Live Interactive Dashboard

PowerBI Project

SUPPLY CHAIN ANALYSIS

Domain/Function: FMCG

AtliQ Mart is a Fast-moving consumer goods company Fast-moving consumer,AtliQ Mart faces difficulties ensuring timely and complete order fulfillment across multiple locations.

View Project
Engagement

View Project
on GitHUB

SUPPLY CHAIN ANALYSIS

User-empathetic landing page as a part of dashboard design

SUPPLY CHAIN ANALYSIS

Data modelling involving 6 tables

Project Details

📊 Supply Chain Analysis Project 📊

This time dataset provided by Atliq Mart(Imaginary Company) is from FMCG company’s supply chain team, in which we have to track the five major key metrics.

Key Metrics Tracked:

➜ OT % - On time delivery percentage
➜ IF % - In Full delivery percentage
➜ OTIF % - On time and In Full delivery percentage
➜ LIFR - Line Fill Rate
➜ VOFR - Volume Fill Rate
(I have explained the problem statement in the video)

𝐊𝐧𝐨𝐰𝐥𝐞𝐝𝐠𝐞 𝐠𝐚𝐢𝐧𝐞𝐝 𝐟𝐫𝐨𝐦 𝐭𝐡𝐢𝐬 𝐩𝐫𝐨𝐣𝐞𝐜𝐭 :

➜Deepened understanding of supply chain operations and terminology
➜Applied advanced DAX functions (e.g., finding date gaps, differences between COUNT, COUNTA, COUNTROWS, DISTINCTCOUNT)
➜Used trend chart along with key metrics, just show the trend along with the metrics itself
➜Explored new visualizations, page navigation, and Switch buttons

Project video

Live Interactive Dashboard

Excel Project

SALES AND FINANCE ANALYTICS

Domain/Function: Consumer Goods

Created 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

SALES AND FINANCE ANALYTICS

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

SALES AND FINANCE ANALYTICS

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

Project Details

🚀 Sales and Finance Analytics Project 🚀

I’m excited to share my latest project with Atliq Hardwares (an imaginary company), where I’ve created comprehensive reports to aid the sales team in evaluating customer performance and understanding market dynamics relative to their targets.

Reports Included:

➜Customer Performance Report
➜ Market Performance Report
➜P&L Statement by Fiscal Year
➜ P&L Statement by Market
➜ P&L Statement by Monthly

(I have explained the problem statement in the video)

𝐊𝐧𝐨𝐰𝐥𝐞𝐝𝐠𝐞 𝐠𝐚𝐢𝐧𝐞𝐝 𝐟𝐫𝐨𝐦 𝐭𝐡𝐢𝐬 𝐩𝐫𝐨𝐣𝐞𝐜𝐭 :
➜Pivot table
➜ Power Query
➜ DAX (Basics)
➜ Conditional Formatting
➜ Report Beautification
➜ Sales Domain Metrics

Project video