This report contains a detailed review about customer's account and an overview of the current Churn rate.
- Don't know their customer's informations and can't send personal email marketing messages to the target audience.
- Don't know which months and years are critical in terms of Churn rate.
- Don't know how many of their customers use actively the bank.
First Step: -Importing the data into Power Query and then cleaning and transforming it. -Creating a Date table.
Second Step: -Data Modelling: Creating the relationships between the tables and setting up the cardinality type. -The Model is in a Star Schema.
Third Step: -Understanding the business problems and making DAX measures to solve them.
Fourth Step: -Creating the right visualisation with the DAX measures.
Fifth Step: -Designing the whole report to make it user-friendly and easily understandable.
This project is licensed under the MIT License. You are free to use, modify, and share this project with proper attribution.
Contact me on LinkedIn