Travel Projects, Revenue and Risk Analysis Dashboard

Project Overview

This Power BI project provides a comprehensive analysis of travel agency operations. The suite consists of two primary dashboards designed to bridge the gap between financial reporting and project management:

1. Projects & Revenue Dashboard: High-level executive view of growth, forecast accuracy, and volume.
2. Risk & Variance Dashboard: Deep-dive into financial slippage, at-risk projects, and departmental performance.

Key Insights & Features

• Revenue Growth Tracking: Monitored a total actual revenue of $1.97 Billion with a 99.11% YoY growth rate.
• Risk Mitigation: Identified and categorized 2,945 at-risk projects, allowing for proactive intervention.
• Financial Accuracy: Analyzed a -4.67% variance against estimates to improve future forecasting models.
• Multi-Dimensional Analysis: Breakdown of performance by Project Category (Luxury, Corporate, Leisure, etc.), Department, and Project Status.
• Interactive UI: Features custom navigation bars, gradient KPI cards, and dynamic filtering by Year, Month, and Department.

Tools Used

• Power BI Desktop: Data modeling, DAX measures, and visualization.
• Power Query: Data transformation and cleaning.
• DAX (Data Analysis Expressions): Created custom measures for Revenue Variance %, YoY Growth, and Forecast Accuracy.

Repository Contents

• Travel_Agency_Analysis.pbix: The main Power BI file containing all dashboards and data models.
• Analysis Dashboard: High-resolution images of the dashboard for quick preview.
• Data_Dictionary.md: (Optional) A brief explanation of the fields used in the dataset.

How to View

1. Download the .pbix file from this repository.
2. Open it using Power BI Desktop.
3. (Optional) If you have a Power BI Service account, you can publish it to your workspace to view the web version.

---

Developed by Benchz Sobrepeña/leigberk2002 Business Operations Analyst | Data Visualization Specialist