This repository contains two interactive Power BI dashboards that visualize airline customer data to uncover insights into customer loyalty, CLV (Customer Lifetime Value), education level, and geographic behavior. These dashboards are built to help analysts and business decision-makers identify trends, segment customers, and enhance loyalty programs.
Key Features:
- CLV by gender
- Average salary comparison
- Total and average distances traveled
- Points accumulation vs. redemption by month
- Distance and CLV trends by month and education
- Year and month filter slicers
Use Case:
Ideal for understanding customer trends and monthly KPIs at a high level across the airline’s loyalty program.
Key Features:
- Median, Min, and Max CLV by education
- Redeemed rate tracking
- Top loyalty members by distance, salary, and CLV
- CLV vs Salary scatter by education level
- Points accumulated by province
- Filters by gender, province, enrollment type, and education
Use Case:
Perfect for detailed segmentation of loyalty program participants based on educational background and provincial patterns.
- Power BI (dashboard development)
- Microsoft Excel / CSV (data source)
- DAX (data modeling and measures)