Bank Marketing Campaign Analysis

Dataset Overview

- Source: [UCI Bank Marketing Dataset](https://archive.ics.uci.e...)

- Format: CSV (converted to Excel for analysis)

- Records: ~1000+

- Columns: variables including:

- Age, Job, Marital status, Contact type, Campaign outcome, Duration

Project Goals

- Understand customer characteristics that influence response to marketing.

- Identify which segments are more likely to subscribe to a term deposit.

- Build an interactive *Excel Dashboard* with filters and KPIs.

- Practice advanced Excel features: Pivot Tables, Slicers, Charts.

Key Insights

- Most successful contacts were via *mobile phone*.

- *Longer calls* tend to lead to positive outcomes.

-age , education, marital status insights are shown in the Dashboard

Tools Used

- Microsoft Excel

- Pivot Tables

- Slicers

- Conditional Formatting

- Chart Visualizations