Portfolio - Dudekula Safina begum

SQL Project

Telangana-Tourism-Analytics

Domain/Function: Tourism Analytics

Developed an interactive Telangana Tourism Analytics Dashboard using SQL, Power BI, and Power Query to analyze domestic and foreign tourist trends, district performance, tourism growth, and revenue insights through dynamic visualizations and KPI-driven reporting.

View Project
Engagement

View Project
on GitHUB

This SQL query calculates the Compound Annual Growth Rate (CAGR) of domestic tourist visitors across Telangana districts between 2016 and 2019.

This interactive Telangana Tourism Analytics Dashboard was developed using Power BI, SQL, and Power Query to analyze domestic and foreign tourist trends across Telangana districts.

Project Details

The Telangana Tourism Analytics Project is a data analytics solution built using SQL, Power BI, Power Query, and Excel to analyze domestic and foreign tourist trends across Telangana districts. The project focuses on district-wise tourism performance, seasonal patterns, tourism growth, and revenue forecasting.

Data cleaning, transformation, and validation were performed using SQL and Power Query to ensure accurate analysis. Advanced SQL techniques including CTEs, Aggregate Functions, CAGR calculations, and Stored Procedures were used for tourism trend analysis and forecasting.

Interactive Power BI dashboards and KPI visualizations were created to track tourist growth, footfall ratios, top-performing districts, and projected visitor trends, enabling data-driven insights and tourism growth analysis.

Project video

PowerBI Project

AtilQ Garnd-Hotel Performance Dashboard

Domain/Function: Hospitality Analytics

Developed an interactive Hotel Performance Analytics Dashboard in Power BI to analyze revenue, occupancy, ADR, RevPAR, customer ratings, and booking trends for AtliQ Grand Hotels, enabling KPI tracking, business insights, and data-driven decision-making in the hospitality domain.

View Project
Engagement

View Project
on GitHUB

Interactive Power BI dashboard analyzing hotel revenue, occupancy, ratings, cancellations, and booking trends with KPIs, filters, and visualizations to identify performance gaps and support data-driven business decisions.

Interactive Power BI popup highlighting cancellation trends, occupancy gaps, booking platform performance, and customer ratings using bookmarks and buttons to support storytelling, business insights, and data-driven decision-making.

Project Details

The AtliQ Grand Hospitality Analytics Project is a data analytics solution developed using Power BI, Power Query, and Excel to helpAtliQ Grand Hotels improve business performance through data-driven insights. The dashboard analyzes key hospitality metrics such as Revenue,Occupancy %, ADR, RevPAR, Realization %, Cancellation Rates, and Customer Ratings across multiple cities and booking platforms.

The project involved data cleaning, transformation, KPI creation, and interactive dashboard development with slicers, tooltips, and bookmark-based navigation for enhanced user experience. Week-over-Week analysis was implemented to track business trends and performance changes over time.

Through detailed analysis, the dashboard identified important insights such as high cancellation rates, weekday occupancy gaps, and top-performing cities and booking platforms, helping generate actionable recommendations to improve revenue, occupancy, and customer satisfaction.

Live Interactive Dashboard

PowerBI Project

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

Domain/Function: Business Analytics

AtliQ Hardwares is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights and make in

View Project
Engagement

View Project
on GitHUB

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

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard

Excel Project

Sales Analytics

Domain/Function: Sales Analytics

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

View Project
on GitHUB

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 created a sales report using excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

Hello, I am

Dudekula Safina begum

1

2

1

About

Key

My

Telangana-Tourism-Analytics

AtilQ Garnd-Hotel Performance Dashboard

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

Sales Analytics

Contact Me

Email

Github

Linkedin

Dudekula Safina begum

Download Resume