Portfolio - Bhavesh Rana

Bhavesh Rana

Data Analyst

Resume

1

Excel Project

2

PowerBI Projects

About Me

👋 Welcome to My Portfolio!

I’m Bhavesh Rana, an aspiring Data Analyst with a passion for transforming raw data into meaningful insights. With an MBA in Marketing and Finance and a Bachelor’s degree in Science, I’ve found my true calling in data analysis.

Using tools like Excel, Power BI, SQL, and Python 🛠️, I work with real-world datasets to uncover patterns, clean data, and build impactful dashboards that help businesses make better decisions. Although I’m new to formal work settings, I’ve completed several business projects that showcase my ability to solve problems and provide actionable insights.

🔍 Explore my portfolio to see how I’ve applied my skills to real-world datasets and impactful projects. I’m eager to collaborate and contribute to a team where I can continue to learn and grow.

Let’s connect and turn data into something amazing! 🚀

Your Future Data Analyst

Key Skills

POWER BI

Excel

Stakeholder Management

Data Visualization

My Projects

Sales and Finance Analytics Project for AtliQ Hardware

Domain/Function: FMCG

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

Domain/Function: FMCG

Hospitality Analysis

Domain/Function: Hospitality Sector

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

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.

Download Resume

Resume

Mail Me

[email protected]

https://in.linkedin.com/in/bhavesh-rana-b69198199

Call Me

+91 9021256013

GitHub

https://github.com/bhavesh033

Excel Project

Sales and Finance Analytics Project for AtliQ Hardware

Domain/Function: FMCG

1. Track Customer Performance: Helping them see which customers are performing well and spot trends in their buying habits. 2. Compare Market Performance with Targets: Giving them a clear view of how they’re doing in the market and where they might need to improve.

View Project
Engagement

View Project
on GitHUB

Customer Performance Report: Tracks each customer's net sales performance over the years.

Market Performance vs Target Report: Helps stakeholders evaluate the country's yearly performance and measure it against targets.

Project Details

I created a sales report using Excel Pivot Tables that helps businesses:
📉 Decide on effective customer discounts.
🤝 Negotiate better with customers.
🌍 Spot new business opportunities in promising countries.

The reports provide clear insights and practical recommendations, allowing businesses to:
✅ Optimize sales strategies
😊 Improve customer satisfaction
💰 Boost revenue

Key Skills Learned:
1. 📊 Pivot Tables – For efficient data analysis.
2. ⚙️ Power Query – To transform and clean data.
3. 🧮 DAX Basics – For advanced calculations.
4. 🎨 Conditional Formatting – To highlight key insights.
5. ✨ Report Beautification– To make reports visually appealing.
6. 📈 Sales Metrics* – Understanding key indicators in the sales domain.

This project empowers businesses with the tools and insights needed to:
🔎 Monitor performance
📊 Evaluate strategies
🚀 Unlock new opportunities
Leveraging sales data helps businesses grow and stay ahead.

PowerBI Project

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

Domain/Function: FMCG

AtliQ Hardwares struggles to compete due to outdated Excel reports. By implementing Power BI, I aim to centralize data, create interactive dashboards, and automate insights delivery. This transformation will enable informed decisions, drive growth, and establish a data-driven culture.

View Project
Engagement

View Project
on GitHUB

The landing page features intuitive navigation with clear buttons, guiding users to Sales, Marketing, Finance, or Executive insights for easy access.

Created a data model using a snowflake schema with 10+ tables, optimizing data relationships for efficient analysis and seamless insights. ❄️

Project Details

The goal of this project was to create one report for stakeholders in Sales, Marketing, Finance, and the Executive team.
1️⃣ Robust Data Modeling
2️⃣ User-Centric Report Design
3️⃣ Drillable Insights

Key Learnings:
1️⃣ ✨ Power Query: Mastered basic and advanced operations.
2️⃣ 🧠 DAX Mastery: Developed both basic and complex formulas.
3️⃣ 🔗 Data Modeling: Connected and modeled 10+ tables.
4️⃣ 📊 Visualization: Selected impactful visuals with proper formatting.
5️⃣ 🎨 Dashboard Design: Applied key design principles for clarity.
6️⃣ 🔖 Bookmarks: Enhanced interactivity for better navigation.
7️⃣ ☁️ Power BI Service: Deployed and shared reports effectively.
8️⃣ 🔄 Stakeholder Feedback: Improved based on feedback.
9️⃣ 📈 Metrics Expertise: Focused on Sales, Marketing, Finance, and Supply Chain KPIs.
This project brought technical innovation and collaboration together to deliver insights that matter! 🚀

Live Interactive Dashboard

PowerBI Project

Hospitality Analysis

Domain/Function: Hospitality Sector

AtliQ Grand faces revenue and market share loss due to competitive pressures and management issues. Using hospitality analytics, the project aims to optimize key metrics like ADR, RevPAR, and Occupancy% through data-driven insights, boosting operational efficiency and strategic decision-making.

View Project
Engagement

View Project
on GitHUB

This dashboard highlights AtliQ Grand's performance with metrics on revenue, occupancy, ADR, RevPAR, cancellations, city data, and platform trends.

This dashboard visualizes AtliQ Grand’s performance with metrics on bookings, cancellations, checkouts, ratings, platforms, city data, and room types.

Project Details

🎯 Project Goal:
Boost AtliQ Grand's market share and revenue using BI tools to drive smarter decisions and outpace competitors in the luxury hotel sector.

📊 Dataset:
Designed with a STAR SCHEMA 3️⃣ dimension tables and 2️⃣ fact tables for efficient data analysis.

🖥️ Dashboard (Four Pages):
1. 🏠 Home Page:** Seamless navigation.
2. 🔍 Overview Page:** Key metrics like ADR, RevPAR, and Occupancy%.
3. 💰 Revenue & Occupancy Page:** Insights on revenue drivers and room utilization.
4. 📈 Booking & Rating Page:** Booking trends, ratings, and cancellations.
🔑 Key Insights:
- Revenue, RevPAR, ADR, and Occupancy% with cancellation patterns.
- Revenue breakdown by city, room type, and booking platform.
- Guest behavior, booking trends, and seasonality insights.

🎓 Learnings:
📊 Visualization, 💡 DAX, 💼 Revenue analysis, and 🎤 Presentation skills.

📚 Hospitality Expertise:
Mastered KPIs, pricing strategies, and operational trends.