Powered by
Codebasics DA Bootcamp

Rupal Agarwal

Senior Data Analyst

[email protected]

Hello, I am

Rupal Agarwal.

1

Excel Project

3

PowerBI Projects

1

SQL Project

1

Python Project

About Me

Welcome to my portfolio! As a Senior Data Analyst, I bring a unique blend of skills and experiences, honed through a dynamic career journey that began in HR analysis and evolved into data analytics. I am proficient in Excel, Power BI, SQL, and Python, enabling me to extract actionable insights from data and drive strategic decision-making.

My specialization lies in uncovering meaningful patterns and trends that contribute to business success. Whether it's conducting thorough data cleansing and transformation or developing interactive dashboards and reports, I am dedicated to delivering insights that matter.

I invite you to explore my portfolio, where you'll find a diverse range of projects and experiences that showcase my expertise and passion for data analysis.

Key Skills

SQL

Python

Stakeholder Management

DATA MODELING

DAX

Pandas

SSMS

Postgresql

Matplotlib

JIRA

Jupyter Notebook

Data Analysis

Data Cleaning

Data Wrangling

My Projects

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/rupal-agarwal-6293182b7/

https://github.com/rupal20ag

Excel Project

Sales Performance Analysis: Reports for Customer and Market Evaluation

Developed two tailored reports for the sales team to analyze customer performance and gauge market performance against the targets. These reports offer valuable insights, empowering the team to make informed decisions and optimize strategies for enhanced sales and market success.

Sales Performance Analysis: Reports for Customer and Market Evaluation

Customer Performance Report: Provides Net Sales performance for each customer across years.

Sales Performance Analysis: Reports for Customer and Market Evaluation

Market Performance vs Target Report across years: Enables stakeholders to access the country's performance and compare it to set Targets.

Project Details

In this project, I created Excel pivot tables to craft a comprehensive sales report aimed at empowering businesses to make informed decisions regarding customer discounts, negotiate effectively with consumers, and identify potential expansion opportunities in promising countries. The generated report offers actionable insights and recommendations, enabling businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project serves as a powerful tool for businesses to monitor, evaluate, and optimize their sales activities. By harnessing the insights derived from sales data analysis, businesses can unlock new opportunities, drive growth, and maintain a competitive edge in the dynamic market landscape.

PowerBI Project

Business 360 Insights: Integrated Dashboard for Finance, Sales, Marketing, and Supply Chain

Implement an advanced analytics solution using Power BI for Atliq Hardware, a consumer electronics company. Currently reliant on Excel for reporting, by transitioning to a data-driven approach, the company aims to enhance competitiveness and accelerate growth in the rapidly expanding market.

View Project
on GitHUB

Business 360 Insights: Integrated Dashboard for Finance, Sales, Marketing, and Supply Chain

Designing a landing page for the dashboard with a focus on empathy towards users' needs and preferences.

Business 360 Insights: Integrated Dashboard for Finance, Sales, Marketing, and Supply Chain

Managing data modeling involving 10+ tables.

Project Details

Project Goal: Develop a single, comprehensive report for stakeholders in sales, marketing, finance & supply chain teams.

Key Focus Areas:
1- Robust data modeling.
2- User-centric report design for intuitive navigation and usability.
3- Incorporation of drillable insights for deeper analysis and exploration.

Learning Outcomes:
1- Proficiency in Power Query for basic and advanced operations.
2- Mastery of basic and complex DAX formulas.
3- Experience in managing data modeling involving 10+ tables.
4- Skill development in selecting appropriate visuals and formatting techniques.
5- Understanding of dashboard design principles for effective communication.
6- Utilization of bookmarks for enhanced report interactivity.
7- Deployment of reports in Power BI Services for accessibility.
8- Integration of stakeholder feedback for continuous improvement.
9- Inclusion of metrics from sales, marketing, finance & supply chain domains for comprehensive analysis.

Live Interactive Dashboard

Python Project

Airline Revenue Optimization: A Data Analysis Approach

Using Python and SQL for Airline Analysis, we tackle profitability challenges amidst stricter regulations, higher taxes, and increased labor costs. Analyzing the database, we aim to optimize aircraft occupancy rates, enhancing per-seat profit despite external pressures.

View Project
on GitHUB

Airline Revenue Optimization: A Data Analysis Approach

Utilization of Python libraries such as Sqlite3, Pandas, Seaborn, and Matplotlib for data manipulation, visualization, and statistical analysis.

Airline Revenue Optimization: A Data Analysis Approach

Showcasing occupancy rate, increased occupancy rate, and increased total turnover for revenue optimization analysis.

Project Details

Project Goal: To optimize airline revenue through a data-driven approach, utilizing SQL queries and Python libraries for analysis. Amidst profitability challenges in the airline industry, the project aims to identify opportunities to increase revenue streams and enhance financial performance.

Key Focus Areas:
1) Analyze the database to identify factors affecting occupancy rates.
2) Develop strategies to increase occupancy rates while maintaining customer satisfaction.
3) Implement solutions to optimize occupancy rates and enhance profitability.

Learning Outcomes:
1) Implementation of advanced SQL queries in Jupyter Notebook for data extraction, transformation, and analysis.
2) Utilization of Python libraries such as Sqlite3, Pandas, Seaborn, and Matplotlib for data manipulation, visualization, and statistical analysis.
3) Focusing on key areas such as average profit per seat and occupancy rate enhancement.

SQL Project

Consumer Goods Ad-hoc Insights

Atliq Hardware is one of the leading computer hardware producers in India and well expanded in other countries too. The company is currently facing several business challenges related to analyzing its sales and product data, understanding market trends, and optimizing its operations.

View Project
on GitHUB

Consumer Goods Ad-hoc Insights

Using SQL queries, extract insights on product performance, segment analysis, customer behavior, and sales trends.

Consumer Goods Ad-hoc Insights

Utilizing Python libraries for visualization, derive insights and trends from the data through graphical representations.

Project Details

Project Goal: The primary goal of this project is to empower Atliq Hardware with actionable insights derived from their sales and product data, enabling the management to make informed decisions swiftly and effectively.

Key Focused Areas
⦁ Product Analysis
⦁ Segment Analysis
⦁ Cost Optimization
⦁ Sales Performance Tracking

Learning Outcomes
1) Gain proficiency in writing SQL queries, including complex joins and common table expressions (CTEs), to extract and manipulate data efficiently.
2) Develop proficiency in using window functions and analytical queries to perform complex aggregations & rankings.
3) Learn to import data from PostgreSQL databases into Python using libraries like psycopg2.
4) Develop skills in using Matplotlib and Seaborn to create complex visualizations that effectively communicate insights derived from data analysis.
5) Acquire a deeper understanding of business analytics concepts and their application in addressing real-world business.

PowerBI Project

Shield Insurance

Aimed to conduct a comprehensive performance analysis for Shield Insurance, spanning November 2022 to April 2023, leveraging Power BI. Its objective was to provide actionable insights into revenue trends and customer behavior across major cities, sales modes, and age groups.

View Project
Engagement

Shield Insurance

Get the KPIs such as Revenue, Customers, DCG,DRG.

Shield Insurance

Get the AgeGroup VS Policy Preferences

Project Details

🌟 𝗞𝗲𝘆 𝗛𝗶𝗴𝗵𝗹𝗶𝗴𝗵𝘁𝘀

🏠 𝗛𝗼𝗺𝗲 𝗣𝗮𝗴𝗲: Quick access to essential insights.
📊 𝗚𝗲𝗻𝗲𝗿𝗮𝗹 𝗩𝗶𝗲𝘄: Analyze total Customers, Revenue by City/Age Group, Daily Growth.
📈 𝗦𝗮𝗹𝗲𝘀 𝗠𝗼𝗱𝗲 𝗩𝗶𝗲𝘄: Examine Sales Mode performance, customer/revenue split.
👥 𝗔𝗴𝗲 𝗚𝗿𝗼𝘂𝗽 𝗩𝗶𝗲𝘄:Explore Policy preference, Sales mode by Age Group.

💡𝗔𝗿𝗲𝗮𝘀 𝗼𝗳 𝗙𝗼𝗰𝘂𝘀 𝗳𝗼𝗿 𝗦𝗵𝗶𝗲𝗹𝗱 𝗜𝗻𝘀𝘂𝗿𝗮𝗻𝗰𝗲

🏢 Leverage Offline Agents
🎨 Product Customization
🤝 Partnerships with Senior Organizations
🎯 Target Age Group 31-40
👶 Engage Younger Demographics
🗣️ Solicit Customer Feedback

Project video

Live Interactive Dashboard

PowerBI Project

Wavecon Telecom Analysis

• Developed a dashboard in Power BI, for analyzing the impact of 5G launch in regular business. • Provided insights into 3 major aspects of business KPI (Revenue, Average revenue per user, active users), Market share, and Plan level.

View Project
Engagement

Wavecon Telecom Analysis

Get the underperforming KPIs such as Revenue, ARPU,TUsU,TAU before 5G and after 5G.

Wavecon Telecom Analysis

Get the Plan Performance before introduction of 5G and post 5G launched.

Project Details

𝗣𝗿𝗼𝗷𝗲𝗰𝘁 𝗢𝗯𝗷𝗲𝗰𝘁𝗶𝘃𝗲: Dive deep into Wavecon Telecom's post-5G launch performance to uncover key trends, challenges, and growth opportunities.

🔍 𝗞𝗲𝘆 𝗙𝗼𝗰𝘂𝘀𝗲𝗱 𝗔𝗿𝗲𝗮𝘀: Explore the impact of 5G on revenue and user metrics, analyze plan performance, and understand market dynamics.

💡 𝗔𝗿𝗲𝗮𝘀 𝗼𝗳 𝗙𝗼𝗰𝘂𝘀 𝗳𝗼𝗿 𝗪𝗮𝘃𝗲𝗰𝗼𝗻:

📡 Enhance Network Quality
💡 Innovate Service Offerings
😊 Improve Customer Experience
📣 Invest in Marketing
🌍 Expand Market Reach
🔄 Adapt to Market Trends

Live Interactive Dashboard