Jessiewilliam/Ghana-Adventures-Travel-and-Tour-Project
Domaine:
socioeconomicType de record:
project
Créateur:
Jes
Hôte:
Data-driven business insight project for Ghana Adventures Travel & Tour. Uses Power BI and Excel to uncover customer behavior, tour profitability, and strategic recommendations for boosting off-peak bookings and customer loyalty.
# Ghana-Adventures-Travel-and-Tour-Project
Data-driven business insight project for Ghana Adventures Travel & Tour. Uses Power BI and Excel to uncover customer behavior, tour profitability, and strategic recommendations for boosting off-peak bookings and customer loyalty.
# Ghana Adventures Travel & Tour Analysis
Welcome to the official GitHub repository for the **Ghana Adventures Travel & Tour** business insight project. This project aims to provide actionable insights through data storytelling and interactive dashboards to help the company improve customer engagement, boost off-peak bookings, and drive long-term growth.
## 🔍 Project Overview
**Objective:**
To utilize data analytics and visualization tools (Excel, Power BI, and PowerPoint) to:
- Analyze customer return rates and spending patterns.
- Understand which tour packages are most and least profitable.
- Recommend strategies to boost customer loyalty and drive sales, especially during off-peak seasons.
## 📊 Files Included
| File Name | Description |
|-----------|-------------|
| `Ghana Adventures Travel & Tour Project.pbix` | Main Power BI report with interactive dashboards and visualizations. |
| `Ghana Adventures Travel & Tour Analysis.xlsx` | Cleaned dataset used for the Power BI report and analysis. |
| `Microsoft-Power-BI-Storytelling.pptx` | Final presentation summarizing insights and recommendations. |
## 💡 Key Insights
### ✅ Top Performing Tours
- **New Year Safari**, **Volta River Cruise**, and **Christmas Safari** are high-performing, both in popularity and profitability.
- Suggested actions: Expand these into premium or multi-day experiences.
### ❗ Underperforming Tours
- **Larabanga Mosque Visit** shows lower engagement.
- Suggested action: Bundle with other spiritual or cultural attractions and rebrand as a "Spiritual Heritage Tour."
### 👥 Customer Loyalty
- Return rate: **~45.7%** – shows strong customer loyalty.
- Returning customers spend **more (GH₵ 824.32)** than new custome …