Powered by
Codebasics DA Bootcamp

Rajvardhan Singh Parmar

Data Analyst

+91 8319017110 [email protected]

Resume

Hello, I am

Rajvardhan Singh Parmar.

1

Excel Project

5

PowerBI Projects

1

SQL Project

1

Python Project

About Me

👋Welcome to my portfolio!📈I'm an aspiring Data Analyst with a passion for uncovering meaningful insights from raw information.🔍Armed with proficiency in MySQL, PowerBI, Tableau, Python, and Advanced Excel, I possess a knack for transforming complex data into actionable strategies.

My journey into the world of data analysis began with a Bachelor's degree in BBA (Business Analytics).🎓While studying, I realized my innate talent and fervor for diving deep into data, which led me to hone my skills independently.

Despite not having formal corporate experience, I've delved into numerous business projects, each showcased in detail within my portfolio.📑These projects serve as a testament to my dedication, expertise, and innovative approach to utilizing data to drive informed decision-making.

I thrive on solving intricate data challenges to generate impactful results.💡Explore my portfolio to witness how I provide practical solutions for tough data problems.🌟

Key Skills

MySQL

Python

Stake Holder Management

Power BI

Advanced Excel

Tableau

Alteryx

My Projects

My Experience

AtliQ Technologies – Data Analyst Intern June 2024 – July 2024

· Enhanced data integrity by standardizing, deduplicating, and normalizing client datasets.

· Conducted variance analysis and business trend evaluation using Pandas, Excel, and Power BI.

· Debugged SQL queries in MySQL Workbench for accurate data extraction.

· Created interactive dashboards and visualizations using Power BI to present findings to senior management.

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

Python: Beginner to Advanced For Data Professionals

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

Tableau Mini

Data Analyst Internship Certificate

Data Analyst Internship Certificate

Data Analyst Internship Certificate 2

Data Analyst Internship Certificate 2

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/rajvardhan-singh-parmar/

+ 91 8319017110

https://github.com/RajvardhanSinghParmar

PowerBI Project

‎EV Vehicle Analysis 🔋

Domain/Function: Automotive

This challenge focused on uncovering insights for AtliQ Motors, which holds a 25% market share in North America but under 2% in India. Led by Bruce Haryali, we set out to decode the Indian EV market.

View Project
Engagement

Other Tools

Excel

Power Query

MS PowerPoint

‎EV Vehicle Analysis 🔋

‎

‎EV Vehicle Analysis 🔋

‎

Project Details

‎ ‎🚗 𝗢𝗯𝗷𝗲𝗰𝘁𝗶𝘃𝗲:

● Grasp the current landscape of the EV market in India.
● Spot key trends and identify growth opportunities.
● Break down sales data by state, manufacturer, and vehicle category.
● Deliver actionable insights and strategies to boost AtliQ Motors' market share.

🔍 𝗞𝗲𝘆 𝗧𝗮𝗸𝗲𝗮𝘄𝗮𝘆𝘀:

🏆 𝗧𝗼𝗽 𝗘𝗩 𝗠𝗮𝗸𝗲𝗿𝘀 (𝗙𝗬 𝟮𝟬𝟮𝟯 & 𝟮𝟬𝟮𝟰):
● 𝗢𝗟𝗔 𝗘𝗹𝗲𝗰𝘁𝗿𝗶𝗰: Leading the pack for two consecutive years, while smaller players like Jitendra and Battre Electric are struggling to keep up.

🌍 𝗧𝗼𝗽 𝗦𝘁𝗮𝘁𝗲𝘀 𝗯𝘆 𝗘𝗩 𝗣𝗲𝗻𝗲𝘁𝗿𝗮𝘁𝗶𝗼𝗻 (𝗙𝗬 𝟮𝟬𝟮𝟰):
● 𝗚𝗼𝗮: Dominates in 2-wheeler adoption!
● 𝗞𝗲𝗿𝗮𝗹𝗮: Excelling in both 2-wheelers and 4-wheelers.💥

📊 𝗤𝘂𝗮𝗿𝘁𝗲𝗿𝗹𝘆 𝗧𝗿𝗲𝗻𝗱𝘀 𝗳𝗼𝗿 𝗟𝗲𝗮𝗱𝗶𝗻𝗴 𝟰-𝗪𝗵𝗲𝗲𝗹𝗲𝗿 𝗘𝗩 𝗠𝗮𝗸𝗲𝗿𝘀:
● 𝗧𝗮𝘁𝗮 𝗠𝗼𝘁𝗼𝗿𝘀: Outpacing competitors with the highest quarterly growth. 🔥

Live Interactive Dashboard

PowerBI Project

Supply Chain Analysis ⛓️

Domain/Function: FMCG

This project, created for the Codebasics Supply Chain Challenge, helps AtliQ Mart improve order fulfillment. The dashboard tracks key metrics like OT%, IF%, OTIF, LIFR, and VOFR across cities, customers, and product categories.

Other Tools

Excel

Power Query

Supply Chain Analysis ⛓️

‎

Supply Chain Analysis ⛓️

‎

Project Details

🚨 𝗞𝗲𝘆 𝗙𝗶𝗻𝗱𝗶𝗻𝗴𝘀:

📉 𝗟𝗼𝘄 𝗙𝘂𝗹𝗳𝗶𝗹𝗹𝗺𝗲𝗻𝘁 𝗥𝗮𝘁𝗲𝘀:

● OTIF (On-Time In-Full) performance is WAY below target: 29.02% vs. a target of 66%

● OT% stands at 59% — far from the target of 86%

● IF% is at 52.78%, underperforming the target of 77%

🌆 𝗖𝗶𝘁𝘆-𝘄𝗶𝘀𝗲 𝗣𝗲𝗿𝗳𝗼𝗿𝗺𝗮𝗻𝗰𝗲:

● Surat performed slightly better in OT%, but all three cities (Ahmedabad, Surat, Vadodara) missed the OTIF target.

💡 𝗖𝘂𝘀𝘁𝗼𝗺𝗲𝗿 𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀:

● Lotus Mart is lagging with a poor OTIF of 16.3%, compared to Propel Mart at 40.9%.

● Despite delays, VOFR remains high (~97%), showing that while quantity is fulfilled, it's not on time.

🛍️ 𝗣𝗿𝗼𝗱𝘂𝗰𝘁 𝗣𝗲𝗿𝗳𝗼𝗿𝗺𝗮𝗻𝗰𝗲:

● Major products like AM Biscuits and AM Butter exhibit a consistent LIFR of ~66% and VOFR of ~96%, pointing to inventory or delivery planning issues.

⏰ 𝗗𝗲𝗹𝗶𝘃𝗲𝗿𝘆 𝗗𝗲𝗹𝗮𝘆𝘀:

● 13,000+ orders were delivered late!

● The average delay per order: 1.69 days, highlighting scheduling ineffi

Live Interactive Dashboard

PowerBI Project

Mitron Bank Credit Card Analysis💳

Domain/Function: Banking

🔍𝗣𝗿𝗼𝗷𝗲𝗰𝘁 𝗢𝘃𝗲𝗿𝘃𝗶𝗲𝘄: Mitron Bank is set to introduce groundbreaking credit cards. AtliQ Data Services kicks off by meticulously analyzing a dataset encompassing the online spending habits of 4000 customers.

View Project
Engagement

View Project
on GitHUB

Mitron Bank Credit Card Analysis💳

‎

Mitron Bank Credit Card Analysis💳

‎

Project Details

🎯𝗧𝗮𝗿𝗴𝗲𝘁 𝗔𝗰𝗾𝘂𝗶𝘀𝗶𝘁𝗶𝗼𝗻𝘀: Our objectives were crystal clear:
- Unleash the power of data insights to refine the credit card development process.
- Steer strategies that align seamlessly with customer preferences and dynamic market trends.

📊𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀: Our dive into demographics, spending behaviour, and customer segments was an eye-opener. The insights gathered from 4000 customers spanning cities, professions, and age brackets were pivotal in shaping our strategies.

𝐊𝐞𝐲 𝐅𝐢𝐧𝐝𝐢𝐧𝐠𝐬💡
1. Credit cards are the top choice for customer payments.💳
2. Major spending categories include bills, groceries, electronics, and health-wellness products.🛒📱💊
3. Male and married customers dominate the spending trends.👨‍👩‍👦‍👦💰
4. The 25-35 and 35-45 age groups exhibit the highest spending patterns.👨‍💼👩‍💼💵
5. Mumbai emerges as the top spending city among all.🏙️💸
6. Salaried IT Employees and Other Salaried Employees drive the majority of transactions.💼💻💰

Live Interactive Dashboard

PowerBI Project

AtliQ Mart Analysis🛒

Domain/Function: Retail

🔍𝗣𝗿𝗼𝗷𝗲𝗰𝘁 𝗢𝘃𝗲𝗿𝘃𝗶𝗲𝘄: AtliQ Mart, a prominent retail chain with 50 supermarkets in southern India, conducted extensive promotions-for their AtliQ branded products during Diwali 2023 and Sankranti 2024. The sales director aims to assess the success of these promotions across all stores t

View Project
Engagement

View Project
on GitHUB

AtliQ Mart Analysis🛒

‎

AtliQ Mart Analysis🛒

‎

Project Details

🌟𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐇𝐢𝐠𝐡𝐥𝐢𝐠𝐡𝐭𝐬🌟

🏪𝐒𝐭𝐨𝐫𝐞 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬: Conducting a comprehensive analysis of store performance to identify key metrics and areas for improvement.

📢𝐏𝐫𝐨𝐦𝐨𝐭𝐢𝐨𝐧 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬: Analyzing the effectiveness of promotions to optimize future marketing strategies.

🔠𝐂𝐚𝐭𝐞𝐠𝐨𝐫𝐲 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬: Analyzing category trends and performance to enhance inventory management and assortment strategies.

📦𝐏𝐫𝐨𝐝𝐮𝐜𝐭 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬: Conducting a detailed analysis of product performance for informed decision-making and strategic planning.

💡𝐊𝐞𝐲 𝐅𝐢𝐧𝐝𝐢𝐧𝐠𝐬💡

📌Both campaigns experienced remarkable boosts in 𝐬𝐚𝐥𝐞𝐬 𝐚𝐧𝐝 𝐫𝐞𝐯𝐞𝐧𝐮𝐞, with 𝐒𝐚𝐧𝐤𝐫𝐚𝐧𝐭𝐢 showing particularly impressive percentage gains.

📌Standout performers included 𝐌𝐲𝐮𝐬𝐮𝐫𝐮 and 𝐁𝐞𝐧𝐠𝐚𝐥𝐮𝐫𝐮, while Vijayawada and Coimbatore stores highlighted areas for enhancement.

Live Interactive Dashboard

PowerBI Project

AtliQ Business Insights 360🔍

Domain/Function: Business Intelligence

AtliQ Hardware encountered difficulties handling data in Excel😕. Goal: Transition from Excel to Power BI for improved understanding 📊. Objective: Gain insights into finance💰, sales💼, and supply chain areas🛒. Data Volume: 1.8 million entries📈. Tools Utilized: SQL, Power BI, Excel, DAX Studio💻.

View Project
Engagement

View Project
on GitHUB

AtliQ Business Insights 360🔍

Creating a data model with over 10 tables 📊💻

AtliQ Business Insights 360🔍

Designing a compelling landing page that connects seamlessly with users, establishing it as an indispensable feature of our dashboard interface. 🎨🤝

Project Details

🌟𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐇𝐢𝐠𝐡𝐥𝐢𝐠𝐡𝐭𝐬🌟

🏠𝐇𝐨𝐦𝐞 𝐏𝐚𝐠𝐞: The central hub is designed for effortless navigation, offering swift entry to crucial information.

💰𝐅𝐢𝐧𝐚𝐧𝐜𝐞 𝐕𝐢𝐞𝐰: Vital financial key performance indicators (KPIs), interactive charts, and adaptable parameters for a comprehensive financial analysis.

📈𝐒𝐚𝐥𝐞𝐬 𝐕𝐢𝐞𝐰: Gain insights into sales dynamics through scatter charts, product/customer performance data, and donut charts.

📢𝐌𝐚𝐫𝐤𝐞𝐭𝐢𝐧𝐠 𝐕𝐢𝐞𝐰: Explore in-depth marketing insights, including segment performance, waterfall charts, and versatile tables.

🚚𝐒𝐮𝐩𝐩𝐥𝐲 𝐂𝐡𝐚𝐢𝐧 𝐕𝐢𝐞𝐰: Streamline the supply chain by utilizing key metrics, trend charts, and detailed breakdowns.

👨🏻‍💼𝐄𝐱𝐞𝐜𝐮𝐭𝐢𝐯𝐞 𝐕𝐢𝐞𝐰: An essential section tailored for executives, delivering crucial metrics, revenue contributions, trend charts, and detailed tables.

Live Interactive Dashboard

Excel Project

Excel-Sales and Finance Analytics Project of AtliQ Hardwares (FMCG)

Domain/Function: Sales & Finance

🔍This project delves into the company's financial health and market position. 📊Using advanced Excel techniques, we craft insightful reports like "Customer Net Sales Performance" and "Market Performance vs. Target" to guide strategic decisions.

View Project
Engagement

Excel-Sales and Finance Analytics Project of AtliQ Hardwares (FMCG)

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

Excel-Sales and Finance Analytics Project of AtliQ Hardwares (FMCG)

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 impactful project, I've leveraged Excel pivot tables to create dynamic sales reports that empower businesses to optimize customer discounts, streamline negotiations, and identify lucrative market opportunities. These reports aren't just data summaries; they're strategic assets delivering actionable insights to elevate sales strategies, bolster customer satisfaction, and drive revenue growth.

My journey through this project honed my expertise across pivotal areas:
1. Mastering pivot tables for comprehensive data analysis.
2. Harnessing the power of Power Query for seamless data integration.
3. Commanding the fundamentals of DAX for advanced data modeling.
4. Elevating data presentation through strategic conditional formatting.
5. Extracting invaluable insights from sales metrics to fuel strategic decisions.

This project is more than just number-crunching—it's about arming businesses with the tools and knowledge to supercharge their sales initiatives.

SQL Project

Consumer Goods AD-HOC Insights💡

Domain/Function: Consumer Goods

Using SQL queries🔍10 AD-HOC requests guided AtliQ's success journey with data. Key insights revealed📈increased product diversity, dominance in 'Notebook' sales📒, and seasonal trends📊. SQL, Power BI, and PowerPoint tools were utilized.🛠️

View Project
Engagement

View Project
on GitHUB

Other Tools

Power BI

PowerPoint

Consumer Goods AD-HOC Insights💡

‎

Consumer Goods AD-HOC Insights💡

‎

Project Details

🌐𝐀𝐛𝐨𝐮𝐭 𝐭𝐡𝐞 𝐂𝐨𝐦𝐩𝐚𝐧𝐲: AtliQ Hardware excels in the computer hardware sector, serving both domestic and international markets.

🔍𝐓𝐡𝐞 𝐂𝐡𝐚𝐥𝐥𝐞𝐧𝐠𝐞: Responding to the need for data-driven decisions, AtliQ Hardware's management initiated a SQL challenge to strengthen their analytics team. My task was to interpret 10 ad-hoc SQL requests and transform them into actionable insights.

🎯𝐊𝐞𝐲 𝐈𝐧𝐬𝐢𝐠𝐡𝐭𝐬 𝐚𝐧𝐝 𝐓𝐚𝐤𝐞𝐚𝐰𝐚𝐲𝐬:

📌𝐌𝐚𝐬𝐭𝐞𝐫𝐞𝐝 𝐃𝐚𝐭𝐚 𝐈𝐧𝐭𝐞𝐫𝐩𝐫𝐞𝐭𝐚𝐭𝐢𝐨𝐧: Emphasized thorough understanding of data before delving into SQL queries.

📌𝐄𝐧𝐡𝐚𝐧𝐜𝐞𝐝 𝐒𝐐𝐋 𝐒𝐤𝐢𝐥𝐥𝐬: Explored advanced concepts like Common Table Expressions (CTE), JOIN operations, Stored Procedures, etc.

📌𝐋𝐢𝐧𝐤𝐞𝐝 𝐒𝐐𝐋 𝐭𝐨 𝐑𝐞𝐚𝐥-𝐖𝐨𝐫𝐥𝐝 𝐀𝐩𝐩𝐥𝐢𝐜𝐚𝐭𝐢𝐨𝐧𝐬: Demonstrated practical applications of SQL in business contexts, beyond mere skill.

Python Project

AtliQ Grand Data Analysis Project Using Python 🐍

Domain/Function: Hospitality

🔍𝐓𝐡𝐞 𝐂𝐡𝐚𝐥𝐥𝐞𝐧𝐠𝐞: AtliQ Grands, a premier Indian hotel, faces intense competition and falling revenues. Lacking in-house data experts, they've hired external specialists to analyze data, uncover actionable insights, and develop strategies to improve customer retention and boost revenue.

View Project
Engagement

View Project
on GitHUB

AtliQ Grand Data Analysis Project Using Python 🐍

‎

AtliQ Grand Data Analysis Project Using Python 🐍

‎

Project Details

🎯𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐌𝐢𝐬𝐬𝐢𝐨𝐧: Harnessing Python for a thorough analysis of the hotel landscape, this project aims to empower Atliq Grands with data-driven insights and strategic recommendations, helping them make informed decisions and regain their competitive edge.

🌟𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐇𝐢𝐠𝐡𝐥𝐢𝐠𝐡𝐭𝐬:

● 𝐃𝐚𝐭𝐚 𝐂𝐥𝐞𝐚𝐧𝐢𝐧𝐠: Eliminated missing values and outliers to ensure pristine data quality.

● 𝐃𝐚𝐭𝐚 𝐓𝐫𝐚𝐧𝐬𝐟𝐨𝐫𝐦𝐚𝐭𝐢𝐨𝐧: Added occupancy percentage columns for richer insights.

📊𝐊𝐞𝐲 𝐈𝐧𝐬𝐢𝐠𝐡𝐭𝐬 𝐔𝐧𝐜𝐨𝐯𝐞𝐫𝐞𝐝:

● 𝐀𝐯𝐞𝐫𝐚𝐠𝐞 𝐎𝐜𝐜𝐮𝐩𝐚𝐧𝐜𝐲 𝐑𝐚𝐭𝐞 𝐛𝐲 𝐑𝐨𝐨𝐦 𝐓𝐲𝐩𝐞.
● 𝐀𝐯𝐞𝐫𝐚𝐠𝐞 𝐎𝐜𝐜𝐮𝐩𝐚𝐧𝐜𝐲 𝐑𝐚𝐭𝐞 𝐩𝐞𝐫 𝐂𝐢𝐭𝐲.
● 𝐎𝐜𝐜𝐮𝐩𝐚𝐧𝐜𝐲 𝐑𝐚𝐭𝐞𝐬 𝐨𝐧 𝐖𝐞𝐞𝐤𝐝𝐚𝐲𝐬 𝐕𝐒 𝐖𝐞𝐞𝐤𝐞𝐧𝐝𝐬.
● 𝐉𝐮𝐧𝐞 𝐎𝐜𝐜𝐮𝐩𝐚𝐧𝐜𝐲 𝐟𝐨𝐫 𝐃𝐢𝐟𝐟𝐞𝐫𝐞𝐧𝐭 𝐂𝐢𝐭𝐢𝐞𝐬.
● 𝐑𝐞𝐯𝐞𝐧𝐮𝐞 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬 𝐩𝐞𝐫 𝐂𝐢𝐭𝐲.
● 𝐌𝐨𝐧𝐭𝐡𝐥𝐲 𝐑𝐞𝐯𝐞𝐧𝐮𝐞 𝐓𝐫𝐞𝐧𝐝𝐬.
● 𝐑𝐞𝐯𝐞𝐧𝐮𝐞 𝐛𝐲 𝐇𝐨𝐭𝐞𝐥 𝐓𝐲𝐩𝐞.