Customer-Analytics

Overview:

This repository presents a Bank Customer Analytics dashboard created using Power BI, offering insights and visualizations based on a bank's customer dataset obtained from Kaggle.

Dataset:

The project utilizes a dataset sourced from Kaggle, encompassing customer information from a bank. Variables within the dataset include customer ID, customer name, gender, region, job classification, date joined, and more.

Project Structure:

The repository structure is organized as follows:

1. Readme file: README.md
2. Raw dataset file: P6-UK-Bank-Customers.csv
3. Bank_Customer_Analytics_Dashboard.pbix: A Power BI file containing the dashboard with various visualizations based on the dataset.

Feel free to explore the Bank_Customer_Analytics_Dashboard.pbix file to examine the specific visualizations employed in this analysis.

Dashboard Components:

The Bank Customer Analytics dashboard comprises the following components:

1. KPI Metrics: Key performance indicator metrics, including the total number of customers and the distribution between male and female customers.
2. Account Balance Analysis: Examination of account balance distribution across different age groups, providing insights into wealth distribution among customer segments.
3. Geographic Distribution: Visualization of the total number of customers based on geographical regions, facilitating identification of the bank's market reach and customer distribution.
4. Top Customers: Highlighting the top five customers based on their account balances for quick identification of high-value customers.
5. Job Classification: Analysis of the total number of customers based on their job classifications, offering insights into the bank's customer base.
6. Yearly Trends: Presentation of the total number of customers on a yearly basis, allowing identification of customer growth patterns and trends over time.

Screenshots:

Usage:

To explore the Bank Customer Analytics dashboard:

1. Clone the repository: git clone https://github.com/chinmoy2306/Bank_Customer_Analytics.git
2. Open Power BI Desktop or Power BI Online.
3. Import the customer dataset located in the repository into Power BI.
4. Open the Power BI project file (bank_customer_analytics.pbix) in the repository.
5. In Power BI, refresh the data connection to ensure the dashboard uses the latest dataset.
6. Interact with different dashboard components to gain insights into bank customer data.
7. Customize the dashboard as per your requirements by modifying visuals, adding new insights, or connecting additional data sources.

Dependencies:

To work with the Bank Customer Analytics dashboard, you will need:

1. Power BI Desktop or Power BI Online: The dashboard was designed using Power BI and requires Power BI Desktop or Power BI Online to explore visuals and interact with data.
2. Dataset: Obtain the customer dataset located in the repository and import it into Power BI.

Please ensure you have the appropriate software and dataset available before using the dashboard.

License:

The dataset used in this project is sourced from Kaggle and is subject to the licensing terms provided by the dataset author. Refer to the Kaggle dataset documentation for more information on licensing and usage restrictions.

Acknowledgments:

Special thanks to Kaggle for providing the Bank Customer dataset, enabling the creation of this analytics dashboard. We appreciate their efforts in collecting and sharing the data for analysis.