Powered by
Codebasics DA Bootcamp

Gunjan Revar

Data Aspirant

+91 9429486901 [email protected]

Resume

Hello, I am

Gunjan Revar.

2

PowerBI Projects

2

Excel Projects

1

SQL Project

About Me

Hello! 👋 I'm Gunjan Revar, a dedicated data enthusiast on an exciting journey to becoming a skilled data analyst.

With a strong background in mathematics and a growing expertise in tools like Excel, Power BI, MySQL, and Python, I am passionate about transforming raw data into meaningful insights that drive impactful decisions.

Here’s why I stand out:
📊 Analytical Thinker: Analytical thinking helps me to break down complex problems and tackle them with precision and clarity.
🛠️ Data Tools Expert in Training: I’m actively mastering cutting-edge tools and techniques to stay ahead in the ever-evolving field of data analysis.
🧩 Solution-Oriented: I thrive on using data to solve real-world challenges, finding innovative approaches to optimize outcomes.
🔎 Detail-Focused: My attention to detail ensures accurate analysis and reporting, supporting informed decision-making.
🌟 Lifelong Learner: I’m deeply committed to continuous improvement and embracing opportunities for growth.

Key Skills

Power BI

SQL

Problem Solving

Creative Dashboard

Advanced Excel

Python

Data Visualization

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/gunjan-revar-a9861a139/

+ 91 9429486901

https://github.com/gunjandodiya

PowerBI Project

AtliQ_Hospitality_Analysis

Domain/Function: Hospitality

The Atliq Hospitality Analysis project focuses on evaluating hotel income and analyzing booking trends across properties. It provides actionable insights through dashboards, helping stakeholders track key metrics like revenue, bookings, cancellations, and operational performance for informed decisio

View Project
on GitHUB

AtliQ_Hospitality_Analysis

This Power BI dashboard provides key performance metrics for Atliq Grands' hotel properties, showcasing revenue, occupancy rates, RevPAR (Revenue per

AtliQ_Hospitality_Analysis

This Power BI dashboard highlights booking trends for Atliq Grands, covering metrics like total bookings, cancellation rates, capacity, and realizatio

Project Details

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 is losing its market share and revenue in the luxury/business hotels category. As a strategic move, the managing director of AtliQ Grands wanted to incorporate “Business and Data Intelligence” to regain their market share and revenue.

Live Interactive Dashboard

Excel Project

Customer Performance Report

Domain/Function: Sales & Finance

Design an analytics system to track sales performance, perform data analysis, and generate detailed reports to optimize customer discounts and identify opportunities for business growth.

View Project
Engagement

View Project
on GitHUB

Customer Performance Report

This report shows the Net Sales Performance of customers from 2019 to 2021, showing a significant overall growth of 324% in 2021 compared to 2020.

Customer Performance Report

This report presents Net Sales, COGS, Gross Margin, and GM% across various markets for 2021. It provides a clear comparison of financial performance.

Project Details

In this project, I developed a sales report using Excel pivot tables to help businesses identify effective customer discount strategies, improve consumer negotiations, and uncover potential opportunities for expanding into new markets. The reports generated offer actionable insights and recommendations for optimizing sales strategies, enhancing customer satisfaction, and maximizing revenue growth.

Through this project, I gained expertise in the following areas:

1. Pivot Tables
2. Power Query
3. Basics of DAX
4. Conditional Formatting
5. Report Enhancement and Presentation
6. Sales Domain Metrics Analysis

PowerBI Project

Business-insight-360

Domain/Function: FMCG Domain

AtliQ Hardwares, a rapidly growing consumer electronics company, struggles to compete effectively with data-driven competitors because many of its reports are still managed in Excel. My objective is to implement an advanced analytics solution using Power BI to provide actionable insights.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

MySQL

Business-insight-360

Analyze Profit & Loss statements, Net Sales trends, and top-performing products and customers by various criteria.

Business-insight-360

Developed an executive dashboard for real-time performance monitoring. Shows revenue by division, customers, products and channels.

Project Details

Finance View: Financial planning and Expense Management
Analyze Profit & Loss statements, Net Sales trends, and top-performing products and customers by various criteria.
Sales View: Increase sales revenue with Customer and Product Performance
Examine Customer and Product performance, with insights into Net Sales, Gross Margin %, and unit economics, including COGS and deductions.

Marketing View: Implement data-driven marketing strategies
Gain a comprehensive view of Product, Market, Regional, and Customer performance, while tracking GM% and NP% across segments. Delve into unit economics with detailed COGS, operational expenses, and NP analysis.

Supply Chain View: Optimization metrics for efficient supply chain management
Track Forecast Accuracy, Net Error, and Absolute Error metrics. Observe Accuracy and Net Error trends and review metrics by product for supply chain optimization.

Executive View: Developed an executive dashboard for real-time performance monitoring.

Live Interactive Dashboard

SQL Project

Goodcabs : Transportation & Mobility

Domain/Function: Transportation & Mobility

Goodcabs, a revolutionary cab service focused on tier-2 cities in India, aimed to evaluate its 2024 performance goals. My role was to analyze operational data, extract actionable insights, and craft an interactive dashboard for the senior leadership team.

View Project
Engagement

View Project
on GitHUB

View Project
on Codebasics

Other Tools

PowerBI

MySQL

Goodcabs : Transportation & Mobility

This SQL query calculates the percentage distribution of repeat passengers based on trip frequencies (from '2-Trips' to '10-Trips') for each city.

Goodcabs : Transportation & Mobility

Cities are categorized into 'Top 3' if they rank among the top 3 highest and 'Bottom 3' if they rank among the lowest 3 based on new passenger count.

Project Details

𝗠𝗮𝗷𝗼𝗿 𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀 & 𝗔𝗰𝗵𝗶𝗲𝘃𝗲𝗺𝗲𝗻𝘁𝘀:
Trip Trends & Patterns: Identified trip volumes and their distribution across cities, highlighting key growth patterns.
Customer Satisfaction Analysis: Tracked passenger satisfaction trends and pinpointed areas for quality improvement.
Loyalty Insights: Examined retention and loyalty through repeat passenger rates, uncovering actionable insights.
Growth Evaluation: Analyzed the balance between new and returning passengers to explore growth opportunities.

𝗧𝗼𝗼𝗹𝘀 & 𝗧𝗲𝗰𝗵𝗻𝗶𝗾𝘂𝗲𝘀:
Power BI & Excel: Designed a dynamic dashboard and conducted in-depth analysis.
SQL: Tackled specific data requests using complex SQL queries, including joins, subqueries, and aggregations.
Power Query: Transformed and cleaned raw data for precise and reliable analysis.

Excel Project

Personal Finance Tracker

Domain/Function: Finance Tracker

This Personal Finance Tracker gives a clear view of income, spending, and balance trends. It highlights top expenses, monthly and weekly patterns, and income sources - helping you stay on top of finances with a smart, visual dashboard.

View Project
Engagement

Personal Finance Tracker

Track income, spending, and trends with this smart finance dashboard. View top expenses, income sources, and balance for better money management.

Personal Finance Tracker

Track income, spending, and trends with this smart finance dashboard. View top expenses, income sources, and balance for better money management.

Project Details

1) Overview Panel – Shows available balance, card details, total spending, and income at a glance.

2) Income Sources – Breaks down income from Data with Decision, YouTube, and Teachable with amounts and percentages.

3) Top Spending Categories – Lists major expense areas like Housing, Groceries, Clothes, Entertainment, and Cash Loan.

4) Spending vs Income Trends – Monthly and weekly charts help track and compare earnings and expenses over time.

5) Maximums Highlighted – Clearly displays the month with max spending ($900) and max income ($5,000).

6) Interactive Filters – Side panel allows selection by month (Jan–Oct) for focused analysis.

7) Visual Insights – Clean, visual layout makes it easy to understand financial trends and take informed actions.

8) Financial Control – Helps monitor, analyze, and manage your finances effectively and efficiently.