Travel Agency Analytics
PUBLISHED ON: July 28, 2022

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.

Trend analysis of Gift Warieta Travel-King Ltd

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

  1. Overview: This provides a summary insights into the performance of the company
  2. Trend: this report gives us insight into the number of customers on a monthly basis and their primary interest for the year 2021.
  3. 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.
  4. 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.

RELATED CONTENT

Stay informed

Shop Sales Analysis

Shop Sales Analysis

The data visualization dashboard was built to provide business insights into the sales person performance level, using dataset provided for a fictitious Sales Shop called Amazing Shop.

read more
Gadget Sales Analysis

Gadget Sales Analysis

Gadget sales analysis dashboard designed by Warieta Gift Ejovwoke, a Business Intelligence Specialist using Microsoft Power BI tool.

read more
Cafe Product Sales Analysis

Cafe Product Sales Analysis

The data visualization dashboard was build using a dataset provided for a fictitious Cafe Business using PowerBI to provide business insights

read more
error: Content is protected !!