Week 2 - Travel Insurance Data
Dashboard Overview
The dashboard visualizes key metrics and trends related to travel insurance sales, commissions, claim rates, and customer demographics. It enables users to analyze performance based on agency, product type, destination, gender, and distribution channels.
Key Metrics Displayed
Total Sales: 1M – Represents the overall sales revenue generated from travel insurance.
Total Commission: 337K – Indicates the commission earned from sales transactions.
Average Duration: 68.71 – Average duration of insurance policies in days.
Commission Percentage: 32.15% – The proportion of sales revenue allocated as commission.
Visualizations
Total Sales by Agency: A bar chart showcasing the contribution of various agencies (C2B, JZI, LWC, etc.) to total sales.
Total Sales by Product Name: Displays sales performance across different insurance plans (Annual Silver, Gold Plan, Basic Plan, etc.).
Total Sales by Destination: A geographical map highlighting insurance sales distribution across regions.
Total Sales by Gender: A comparison between male and female customers regarding travel insurance purchases.
Claim Rate by Distribution Channel: A bar chart showing claim rates for online vs. offline sales.
Claim Rate by Age: A visualization of how claim rates vary across different age groups.
Filters Available
Agency Type: Allows users to filter sales data by different agency types.
Destination: Filters sales and claims data based on selected travel destinations.
Distribution Channel: Provides an option to view trends by online or offline sales channels.
Purpose and Insights
This dashboard helps businesses:
Identify top-performing agencies and products.
Analyze sales distribution across demographics and destinations.
Understand claim trends based on distribution channels and age groups.
Optimize marketing and commission structures based on performance insights.