The data visualization dashboard was built to provide business insights, using dataset provided for a fictitious Travel Agency called Gift Warieta Travel-King Ltd, a company well know as a good brand especially with regards to customer service.
The dashboard was built on providing insights into their business performance for the year 2021.
Insights
- Total number of customers
- Age grouping of customers
- Customer gender variance
- Customers’ country of residence
- Activities engaged on by customers at holiday destination (e.g. Island visited, SPA activities and Sport activities etc.)
- Revenue generated
Analytical Reports
- Overview: This provides a summary insights into the performance of the company
- Trend: this report gives us insight into the number of customers on a monthly basis and their primary interest for the year 2021.
- Reservation Insights: gives an overview of the number of repeat customers, how customers reached out to the company and insights into revenue generated in the year under review based on country and customers’ reservation type.
- Customers: this report provides a deeper insight into the customer engagement.
Visualization Tool: Microsoft Power BI
Dataset Source Type: Microsoft Excel
Dataset used: Click here to download it
Below is an interactive view of the dashboard I created using the provided dataset
Check my other dashboards here.