𝐂𝐮𝐬𝐭𝐨𝐦𝐞𝐫 𝐂𝐡𝐮𝐫𝐧 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬 - 𝐑𝐁𝐂 𝐁𝐚𝐧𝐤

suparnababu8 — Thu, 13 Feb 2025 09:50:11 GMT

Hello Everyone!

I'm really excited to share one more project which is related to Banking domain 🏦.

I took datasets from KSR Datavizon and the project explanation was very beautiful from Ms.Uma

➡ Project details as mentioned below ⬅

1️⃣ Objective of this project

The objective of this project is to find out the churn analysis from given data sets across various categories and to present meaningful insights to stakeholders of this bank.

2️⃣ Tables used
➖ Bank churn fact
➖ Active Customer Dim
➖ Credit Card Dim
➖ Customer info Dim
➖ Exit Customer Dim
➖ Gender Dim
➖ Geography Dim
➖ Date Master

3️⃣ Data Model

⭐ From the above tables I created a Star schema data model in power pivot.

4️⃣ Measures Created

📜 Active Customers
📜 Inactive customers
📜 Exit Customers
📜 Churn Percentage
📜 Calendar table
📜 Credit Card Holders
📜 Non-Credit Card Holders
📜 Retain Customers
📜 Credit Score Type

5️⃣ Charts used

📊 New Card
📊 Column Chart
📊 Bar Chart
📊 Donut Chart
📈 Area Chart
📊 Matrix Chart

6️⃣ Slicers used

📌 Year
📌 Country
📌 Gender
📌 Customer Status

❇ I implemented bookmarks concept in this project.

❇ I created page navigation in this project.

I am happy to hear your feedback/comments.

Thank you all.

eyJrIjoiYjI1MjFlNDYtZmIzNi00MGY1LWJiNWEtNmI2ZjIyOTg3NjJlIiwidCI6Ijk0ZWFkZTY1LTQ4NDEtNDIxNC05NjkxLTFiM2NkYWU1YTM3NyJ9

Re: 𝐂𝐮𝐬𝐭𝐨𝐦𝐞𝐫 𝐂𝐡𝐮𝐫𝐧 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬 - 𝐑𝐁𝐂 𝐁𝐚𝐧𝐤

Magudeswaran_MR — Thu, 17 Apr 2025 04:22:09 GMT

Impressive Report with Valuable Insights suparnababu8

topic Re: 𝐂𝐮𝐬𝐭𝐨𝐦𝐞𝐫 𝐂𝐡𝐮𝐫𝐧 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬 - 𝐑𝐁𝐂 𝐁𝐚𝐧𝐤 in Data Stories Gallery

𝐂𝐮𝐬𝐭𝐨𝐦𝐞𝐫 𝐂𝐡𝐮𝐫𝐧 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬 - 𝐑𝐁𝐂 𝐁𝐚𝐧𝐤

Re: 𝐂𝐮𝐬𝐭𝐨𝐦𝐞𝐫 𝐂𝐡𝐮𝐫𝐧 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬 - 𝐑𝐁𝐂 𝐁𝐚𝐧𝐤