To develop an easy-to-use weekly dashboard for credit cards that shows important data and trends in real-time, helping stakeholders to track and understand credit card operations better.
This project involves the creation of an interactive Power BI dashboard using transaction and customer data sourced from a SQL database. The dashboard provides real-time insights into key performance metrics and trends, facilitating effective monitoring and decision-making for stakeholders.
- Interactive Dashboard:
- Developed an interactive dashboard that visualizes transaction and customer data.
- Displays real-time insights into key performance metrics and trends.
- View dashboards in pdf Dashboard pdf
-
Data Processing and Analysis:
- Streamlined data processing and analysis to ensure accurate and timely information.
- Used SQL queries to extract relevant data and Power BI to transform and visualize the data.
-
Actionable Insights:
- Shared actionable insights based on dashboard findings.
- Supported stakeholders in their decision-making processes by providing clear and concise data interpretations.
- View insights
- Open Power BI: Ensure you have Power BI Desktop installed on your machine.
- Connect to SQL Database: Use your SQL database credentials to connect Power BI to the data source.
- Load Data: Import the transaction and customer data into Power BI. CSV files
- Open Dashboard: Open the provided Power BI dashboard file (.pbix) to view the visualizations.
- Interact with the Dashboard: Use the filters and interactive elements to explore different aspects of the data.
-
Download Power BI Desktop: If you haven't already, download and install Power BI Desktop from the official website.
-
Clone the Repository: Clone this project repository to your local machine.
git clone https://github.com/your-repo/credit-card-dashboard.git
-
Open the Dashboard File: Open the
credit_card_dashboard.pbixfile in Power BI Desktop. Credit_card_Analysis_report.pbix -
Configure Database Connection: Update the database connection settings in Power BI to point to your SQL database.
- SQL Database: The primary data source for this dashboard. It includes tables for transactions and customer information.