Bhushan Gaidhane

Data Analyst Aspirant

[email protected] +91 +919370821755

Resume

Hello, I am

Bhushan Gaidhane.

1

Excel
Project

3

PowerBI
Projects

1

SQL
Project

About Me

Hey there! Bhushan here, your friendly neighbourhood data explorer. I've got a talent for turning ordinary numbers into compelling stories that light the way for smart decisions.

So, what's fueling my journey?
I'm on the hunt for opportunities that match my skills, give me a good challenge, and let me sprinkle some meaningful magic.

Why give me a shot?
I've got this passionate drive for turning raw data into real-world gold using Excel, SQL, and Power BI.

Real action, real skills
I might not have taken the traditional office route, but that didn't stop me from diving headfirst into exciting projects that shout out loud what I'm made of.

What's my secret sauce?
Team fit? Nailed it. Adaptability? Check. Strong detective skills? You betcha. I slide right into teams, bringing quick positive vibes and some serious analytical magic. Let's team up and make data dance!

Key Skills

Stakeholder Management

SQL

Python

Effective Presentation

My Projects

Sales and Finance Analytics

Business Insights 360 Views

Revenue Insights in the Hospitality Industry

Ad-Hoc Insights - Consumer Goods Domain

Mitron Bank: Analysis Of New Credit Card Launch

Awards & Certificate

Trainity Virtual Internship Certificate.

Trainity Live Project Certificate

KPMG Data Analytics Virtual Internship Certificate

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.

Mail Me

[email protected]

https://www.linkedin.com/in/bhushan-gaidhaneskills/

Call Me

+91 +919370821755

GitHub

https://github.com/bhushan1011

Excel Project

Sales and Finance Analytics

Crafted actionable insights through comprehensive sales and financial analytics in the FMCG sector. Empowered businesses with data-driven strategies for growth and expansion. Acquired proficiency in ETL, Power Query, Power Pivot, DAX, and user-centric report design.

View Project
Engagement

View Project
on GitHUB

Customer Net Sales Performance Report and Market Performance vs Target Report .

Relationships (Data Model ), Profit & Loss Statement By Yearly, Monthly and Quarterly.

Project Details

I made a sales report using Excel that helps businesses figure out good discounts for customers, talk better with them, and find new places to grow. The report gives advice on how to make sales better, make customers happier, and earn more money.

I learned to:

1. Use special tables in Excel
2. Work with data in a smart way
3. Do some basic math for data
4. Make things look pretty with colors
5. Make reports nice to look at
6. Know important sales numbers

This project is all about giving businesses the tools they need to watch, understand, and improve how they sell things. By looking at sales info, companies can find chances to do better, grow, and stay ahead in the changing market.

Project video

PowerBI Project

Business Insights 360 Views

AtliQ Hardware, a consumer electronics firm, faces tough competition due to limited data usage, mainly relying on Excel for reports. My objective is to implement a robust Power BI analytics solution, enabling the company to gain crucial insights for smarter decision-making.

View Project
Engagement

View Project
on GitHUB

Dashboard's Home Page

Relationships (Data Model)

Project Details

In this project, the primary objective was to create a unified report for stakeholders in sales, marketing, finance, and the executive team. Key areas of focus included:

1. Building a Robust Data Model
2. Designing User-Centric Reports
3. Providing Drillable Insights

During this project, I acquired the following skills and knowledge:

1. Proficiency in Power Query, covering both basic and advanced operations.
2. Mastery of basic and complex DAX formulas.
3. Expertise in data modeling with over 10 interconnected tables.
4. Selection of appropriate visuals and formatting techniques.
5. Skill in using bookmarks for enhanced user experience.
6. Deployment on the Power BI service platform.
7. Actively incorporating stakeholder feedback.
8. Analysis and reporting of metrics across sales, marketing, finance, and supply chain domains.

Project video

Live Interactive Dashboard

PowerBI Project

Revenue Insights in the Hospitality Industry

Transformed AtliQ Grands with data insights! Created a dynamic Power BI dashboard analyzing RevPAR, ADR, and more. Explore the interactive dashboard and project details on GitHub. Check out my portfolio for more data-driven successes!

View Project
Engagement

View Project
on GitHUB

Overall Analysis of Hospitality Domain Analytics.

Relationships (Data Modeling)

Project Details

Working with AtliQ Grands, a renowned luxury hotel chain, we implemented "Business and Data Intelligence" strategies to revitalize their market share and revenue. Our primary task was to create a dynamic Power BI dashboard to glean insights from their historical data.

Key areas of focus included:
1. Developing an interactive Power BI dashboard for real-time data analysis.
2. Implementing crucial hospitality domain metrics like Occupancy%, Average Daily Rating, Cancellation% , Revenue Analysis by Weekly& Monthly and Revenue Analysis by room Category& City wise.
3. Analyzing historical data to uncover revenue-enhancing opportunities.
4. Providing actionable insights to guide pricing and occupancy decisions.

During this project, I acquired the following skills and knowledge:
1. Proficiency in Power BI for data visualization and analysis.
2. Deep understanding of key hospitality metrics and KPIs.
3. Data-driven decision-making for pricing and occupancy optimization.

Project video

Live Interactive Dashboard

SQL Project

Ad-Hoc Insights - Consumer Goods Domain

Atliq Hardwares, a fictional company, is a major computer hardware maker in India and abroad. Yet, they lack quick insights for smart decisions. So, a SQL challenge is on the horizon to fill this data gap.

View Project
Engagement

View Project
on GitHUB

Ad-Hoc Requests No. 1 along with Output & Insights

Ad-Hoc Requests No. 3 along with Output & Insights

Project Details

In the Sales Performance Enhancement project, our mission was to empower decision-makers with actionable insights. Focused on boosting sales, key priorities included:

1. Executing In-Depth Data Queries
2. Informing Decision-Making Strategies
3. Enhancing Overall Sales Performance

Throughout this project, I developed the following skills:

1. Proficiency in SQL data querying, covering diverse business questions.
2. Mastery of data interpretation and strategic decision support.
3. Selection of effective visualizations for clear data representation.
4. Successful implementation of SQL solutions in a business context.
5. Comprehensive analysis of key sales metrics for informed decision-making.

Project video

PowerBI Project

Mitron Bank: Analysis Of New Credit Card Launch

Mitron Bank wanted better credit cards. We studied spending habits with AtliQ Services and found trends. By making special offers, we aim to make customers happier and more loyal, making Mitron Bank more successful.

View Project
Engagement

View Project
on GitHUB

Customer Spending Behaviour With Various Category.

Insights Found with Based On Various Category.

Project Details

In the Mitron Bank Credit Card Expansion, our aim was to diversify offerings and boost market presence.

Key findings:
1. Spending trends: Bills, Groceries, Electronics dominate, with Mumbai leading.
2. Income impact: Salaried IT, Business Owners, Other Salaried are top spenders.
3. Age preferences: 25-34, 21-24 focus on Entertainment, Apparel, Travel.
4. City dynamics: Mumbai leads, diverse patterns in Delhi NCR, Bengaluru, Chennai.
5. Gender & marital impact: Males, married individuals prominent card users.

Learnings:
1. Crafted targeted offers for demographics.
2. Introduced category-specific features.
3. Prioritized customer engagement.
4. Holistic approach - age, location, profession.
5. Anticipated positive business impact - higher card usage, increased spending, enhanced brand image for Mitron Bank. This project signifies the synergy between data analytics and business strategy, poised to elevate Mitron Bank's standing in the financial market.