Portfolio - Shabbir Garbadawala

Shabbir Garbadawala

Data Aspirant

Resume

1

Excel Project

2

PowerBI Projects

About Me

I’m an aspiring Data Analyst who loves finding stories hidden in numbers. I’m currently pursuing my Bachelor’s in Computer Applications, but along the way, I discovered my real passion—working with data. I’ve built skills in Excel, Power BI, SQL, and Python to clean, analyze, and visualize data in ways that make it easy to understand. While I haven’t worked in a company yet, I’ve completed several real-world style projects that show how I can turn raw data into clear insights to help make better business decisions. For me, it’s not just about numbers—it’s about making data meaningful, simple, and useful. I’m eager to bring my skills into the professional world and help solve business challenges through data.
You can explore my work and projects in my portfolio below.

Key Skills

POWER BI

ADVANCED EXCEL

EFFECTIVE COMMUNICATION

STAKEHOLDER MANAGEMENT

PROBLEM SOLVING

My Projects

Sales Analytics(FMCG)

Domain/Function: Sales & Finance

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

Domain/Function: Business Intelligence

AtliQ Hospitality Analysis

Domain/Function: Hotel Chain Business

Awards & Certificate

Excel: Mother of Business Intelligence

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://www.linkedin.com/in/shabbir-garbadawala/

Call Me

+91 9714945352

GitHub

https://github.com/SHABBIR-G

Excel Project

Sales Analytics(FMCG)

Domain/Function: Sales & Finance

Created two comprehensive and interactive sales reports designed to help the sales team evaluate customer performance in detail, identify top-performing and underperforming segments, and understand their market position compared to targets. These reports provided clear, data-driven insights that sup

View Project
on GitHUB

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

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 project, I developed a Sales Analysis Report in Excel using Pivot Tables to help businesses make better decisions. The report enables companies to determine effective customer discounts, improve negotiations, and identify opportunities for expansion in high-potential countries. These insights support businesses in optimizing sales strategies, increasing customer satisfaction, and maximizing revenue.

Key Skills Learned:

Pivot Tables for dynamic sales analysis

Power Query for data cleaning and transformation

Basic DAX for advanced calculations

Conditional Formatting for highlighting key trends

Report design and beautification for better readability

Understanding sales domain metrics and KPIs

Impact:
This project provides actionable insights to monitor, evaluate, and enhance sales performance. By analyzing sales data effectively, businesses can uncover new opportunities, drive growth, and remain competitive in today’s fast-changing market.

PowerBI Project

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

Domain/Function: Business Intelligence

AtliQ Hardwares, a fast-growing consumer electronics company, struggled to compete with data-driven rivals because most of their reports were still in Excel. My goal was to create an advanced analytics solution in Power BI to transform their reporting process. This solution provides real-time insigh

View Project
on GitHUB

Other Tools

Excel

SQL

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

The goal of this project was to develop a single, unified Power BI report for stakeholders across Sales, Marketing, Finance, and the Executive team. The focus was on creating robust data models for accurate analysis, designing intuitive and user-friendly reports, and enabling drill-down insights for deeper exploration.

Key Learnings & Skills:

Power Query for basic and advanced data transformation

Writing simple and complex DAX formulas

Data modeling with 10+ interconnected tables

Selecting effective visuals and applying clear formatting

Dashboard design best practices for readability and usability

Creating interactive features using bookmarks

Publishing and managing reports in Power BI Service

Implementing stakeholder feedback

Understanding Sales, Marketing, Finance, and Supply Chain metrics

Impact: Delivered a centralized, interactive reporting solution that improved collaboration and enabled data-driven decisions.

Project video

Live Interactive Dashboard

PowerBI Project

AtliQ Hospitality Analysis

Domain/Function: Hotel Chain Business

This project analyzes key hospitality metrics such as revenue, occupancy rate, and customer trends using Power BI. It transforms raw data into an interactive dashboard, helping stakeholders quickly identify performance patterns and make data-driven decisions. The analysis covers insights across diff

View Project
on GitHUB

Other Tools

Excel

Hospitality dashboard showing revenue, bookings, losses, and trends by room, property, city, and class with interactive filters.

Data modelling involving 6 tables

Project Details

In this project, the goal was to create a single Power BI report for stakeholders in Sales, Marketing, Finance, and the Executive team. The focus was on
1) Robust data modelling for accuracy
2)User-focused design for easy navigation
3)And drillable insights for deeper analysis.

I learned
1)To use Power Query (basic and advanced operations)
2)Write simple and complex DAX formulas, and build data models with 10+ tables
3)I also gained skills in selecting visuals applying professional formatting
4)following dashboard design best practices and using bookmarks for interactivity
5)Additionally, I deployed reports in Power BI Service
6)Implemented stakeholder feedback
7)And tracked key Sales, Marketing, Finance, and Supply Chain metrics.
8)A key success was a 15% increase in lead conversion and a 10% reduction in manual reporting time across departments.