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
