Ans:
- Developed interactive dashboards using transaction and customer data from an SQL database, to provide real-time insights.
- Streamlined data processing & analysis to monitor key performance metrics and trends
- Shared actionable insights with stakeholders based on dashboard findings to support the decision-making process.
To develop a comprehensive credit card weekly dashboard that provides real-time insights into key performance metrics and trends enabling stakeholders to monitor and analyze credit card operations effectively
Data was collected from an online open-source platform. Then it was imported in the SQL server using PostgreSQL. After that the SQL server was connected to the Power BI. From there it was imported to the Power BI dashboards. If the SQL server data updates then the dashboard updates after refreshing the data in Power BI.
current_week_revenue = CALCULATE(
SUM('public cc_detail'[revenue]),
FILTER(
ALL('public cc_detail'),
'public cc_detail'[week_num2]=MAX('public cc_detail'[week_num2])
)
)
prev_week_revenue = CALCULATE(
sum('public cc_detail'[revenue]),
FILTER(
ALL('public cc_detail'),
'public cc_detail'[week_num2]=MAX('public cc_detail'[week_num2])-1
)
)
wow_revenue = DIVIDE(([current_week_revenue]-[prev_week_revenue]),[prev_week_revenue])
Revenue increase by 28.8%
Total Transaction Amount & Volume increased by 35% and 3.4%
Customer count increased by 12.8%
Overall revenue 56.5 Million
Total interest is 8 Million
Total Transaction amount is 45.5 Million
Male customers are contributing more in revenue.
Blue and Silver Credit Card holders are contributing 93% of overall transaction
TX, NY and CA is contributing to 68%
Overall Activation rate is 57.5%
Overall Delinquent rate is 6.06%
- Email: lutfulkabir1757@gmail.com
- LinkedIn: Md. Lutful Kabir
- Portfolio: Md. Lutful Kabir