Banking Data Analysis Project
Python • Power BI • Data Science
Workflow
Project Introduction
• This project explores a bank's marketing
dataset using Python and Power BI.
• Key objectives include:
• - Understanding customer behavior
• - Performing feature analysis and
transformation
• - Building insightful dashboards to guide
marketing decisions
Dataset Overview
• The dataset contains marketing campaign data
for a Portuguese bank.
• Key features include:
• - Age, Job, Marital status, Education
• - Loan status, Contact method
• - Previous campaign outcome and response
• - Target variable: 'y' (whether client subscribed
to a term deposit)
Python Workflow Summary
• 1. Data Loading and Cleaning using Pandas
• 2. Exploratory Data Analysis (EDA) using
Matplotlib & Seaborn
• 3. Encoding categorical data
• 4. Visualizing correlations and distributions
• 5. Preparing dataset for modeling
Power BI Dashboard Overview
• A Power BI dashboard was created using the
same banking dataset.
• Key elements include:
• - Customer segmentation visuals
• - Conversion rate KPIs
• - Interactive slicers for age, job, and marital
status
• - Monthly trend charts and bar plots
Conclusion & Insights
• The project demonstrates how Python and
Power BI can be integrated to:
• - Conduct detailed exploratory analysis
• - Build visual dashboards for business
decisions
• - Uncover insights from structured customer
marketing data