Objective: 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 Source: Connected to SQL database and imported data directly from SQL database ensuring up-to-date information.
-
Data Processing: Used DAX queries for creating calculated columns and calculated measures, to provide weekly metrices and trends.
-
Dashboard: Created two interactive dashboards consisitng of various slicers and buttons for dynamic graphs for deeper exploration and analysis.
** Credit Card Transaction Report: This dashboard shows revenue by Expenditure Type, Job Type, Use Chip, Card category, and Education Level of the customer.
** Credit Card Customer Report: This dashboard provides analysis on revenue by Gender, Age Group, States, Income Group, Dependent, Education Level and Income Group. This dashboard also provides comparison between revenues generated by Male and Female customers.