Portfolio - Ganga Chakradhar Dulla | Codebasics

Powered by
Codebasics DA Bootcamp

Hello, I am

Ganga Chakradhar Dulla

Data Aspirant

Resume

1

Excel
Project

2

PowerBI
Projects

About

Me

👋 Step into my digital Realm!
I’m Ganga, a data enthusiast driven by curiosity and purpose — on a mission to grow as a Data Analyst who transforms raw data into meaningful business stories.

Though my academic journey began in Electrical and Electronics Engineering (EEE), my fascination for uncovering patterns and insights led me to the world of data. With tools like Excel, Power BI, DAX, and SQL by my side, I explore data like an analyst on a quest — revealing the hidden trends and opportunities that help businesses thrive.

Through my projects across Hospitality and FMCG domains, I’ve learned to translate numbers into narratives that empower decisions and spark improvement.

So, take a look around, explore my work, and let’s uncover new business insights together — one dataset at a time.

Key

Skills

Advanced Excel

Power BI

SQL

Python

Data Visualization

DAX

Data Modelling

Data Storytelling

Power BI Services

My

Projects

AtliQ Grand Hotels

AtliQ Grand Hotels

Domain/Function: Hospitality Domain

Designed an interactive Power BI dashboard to analyze key hospitality metrics such as Revenue, ADR, RevPAR, Occupancy %, No-Show Rate, and Average Ratings. The project provides actionable insights into revenue performance, customer behavior, and operational efficiency for AtliQ management.

Business Insights 360

Business Insights 360

Domain/Function: FMCG

AtliQ Hardware is rapidly growing company in the recent years, and they have decided to implement the data analytics using Power Bi in their company for the first time to surpass their competitors in the market and to make data driven decisions.

Customer Performance Report

Customer Performance Report

Domain/Function: FMCG

Created 2 reports for the Sales department which will help in evaluating Customer Performance and understand their Market Performance with respect to their targets.

Awards

& Certificate

CB Cert

Excel: Mother of Business Intelligence

CB Cert

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

Python

Contact Me

Github

https://github.com/ganga2233

Linkedin

https://www.linkedin.com/in/ganga-chakradhar-dulla-8a5566276/

Ganga Chakradhar Dulla

Data Aspirant

Download Resume

Resume

PowerBI Project

AtliQ Grand Hotels

Domain/Function: Hospitality Domain

Designed an interactive Power BI dashboard to analyze key hospitality metrics such as Revenue, ADR, RevPAR, Occupancy %, No-Show Rate, and Average Ratings. The project provides actionable insights into revenue performance, customer behavior, and operational efficiency for AtliQ management.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

AtliQ Grand Hotels

Show Revenue Contributions by Hotels, cities, and Key metric table.

AtliQ Grand Hotels

Shows the data modelling that resembles the star schema.

Project Details

AtliQ Grand Hotels, a leading hospitality brand, faced challenges in tracking business performance due to fragmented data across multiple properties. Management lacked a centralized view of key KPIs like revenue, occupancy, and customer satisfaction, which limited data-driven decision-making.

To overcome this, I built an interactive Power BI dashboard using Excel data sources, integrating multiple datasets to monitor Revenue, ADR, RevPAR, Occupancy %, No-Show Rate, and Average Ratings. The dashboard delivered actionable insights on revenue trends, city-wise performance, and guest experience, helping identify areas for operational improvement.

Learning Outcomes:

Data modeling, cleaning, and transformation

DAX implementation and KPI design

Data storytelling and visualization

Built strong knowledge in the hospitality domain

Project video

Live Interactive Dashboard

PowerBI Project

Business Insights 360

Domain/Function: FMCG

AtliQ Hardware is rapidly growing company in the recent years, and they have decided to implement the data analytics using Power Bi in their company for the first time to surpass their competitors in the market and to make data driven decisions.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

MySQL

Business Insights 360

Data Modelling

Business Insights 360

Home page

Project Details

A comprehensive Power BI solution built to deliver a unified 360° view of AtliQ Hardware’s business performance across Finance, Sales, Marketing, HR, and Supply Chain. The dashboard transforms raw data into actionable insights, enabling stakeholders to make faster, data-driven decisions.

Developed using a star schema model, it integrates data from multiple sources with Power Query transformations and advanced DAX measures for key KPIs such as Revenue, Gross Margin, YTD vs. YTG trends, Forecast Accuracy, and Customer Performance.

Featuring interactive visuals, drill-through navigation, and an executive summary view, this solution highlights business performance at every level — from operational details to strategic overviews — providing clear visibility into growth opportunities and efficiency improvements.

Project video

Live Interactive Dashboard

Excel Project

Customer Performance Report

Domain/Function: FMCG

Created 2 reports for the Sales department which will help in evaluating Customer Performance and understand their Market Performance with respect to their targets.

View Project
Engagement

View Project
on GitHUB

Customer Performance Report

Customer Performance Report Shows the Net Sales performance of each year across different customers.

Customer Performance Report

Market performance VS Target Report across different years. Enabling stakeholders to access the different markets (Countries).

Project Details

The Customer Performance Report empowers businesses to delve into their sales data and extract valuable insights for strategic decision-making. Utilizing advanced Excel techniques, including DAX formulas and Pivot tables, combined with Power Query for data manipulation, the report provides a comprehensive overview of customer performance metrics. From determining effective customer discounts to facilitating negotiations and identifying expansion opportunities, this report equips stakeholders with actionable insights.

I have learned the following:
1. Advanced Excel functionalities: DAX formulas, Pivot Tables, Conditional Formatting.
2. Power Query for data transformation and cleaning.
3. Comprehensive knowledge on Sales Domain Metrics.
4. Uncovered the sales patterns
5. Report Beautification

By leveraging this tool, businesses can optimize their customer relationships, drive sales growth, and make informed decisions to stay ahead in today's competitive market