This is the project where we analyst the credit card details for insight
Excited to Share My Latest Power BI Project! 🚀
Project: Credit Card Transaction Dashboard Data Source: Credit_Card.csv
𝐒𝐭𝐞𝐩-𝐛𝐲-𝐒𝐭𝐞𝐩 𝐉𝐨𝐮𝐫𝐧𝐞𝐲: Step 1: 📥 Imported Data to SQL Database (Note: In real-world scenarios, we often get data from pipelines, but I handled this manually.) Step 2: 🔗 Fetched Data from MySQL to Power BI Step 3: 🛠️ Created Measures using DAX
𝐒𝐭𝐞𝐩 𝟒: 📊 𝐃𝐞𝐯𝐞𝐥𝐨𝐩𝐞𝐝 𝐭𝐡𝐞 𝐃𝐚𝐬𝐡𝐛𝐨𝐚𝐫𝐝
𝐋𝐢𝐯𝐞 𝐋𝐢𝐧𝐤 - https://shorturl.at/YPMT0
𝐆𝐢𝐭𝐡𝐮𝐛 :- https://shorturl.at/xuOTH
𝐊𝐞𝐲 𝐌𝐞𝐭𝐫𝐢𝐜𝐬 𝐚𝐧𝐝 𝐈𝐧𝐬𝐢𝐠𝐡𝐭𝐬: Project Insights - Week 53 (31st Dec): Revenue increased by ##% 📈 Total Transaction Amount & Count increased by xx% & xx% 💳 Customer count increased by xx% 🙋
𝐎𝐯𝐞𝐫𝐯𝐢𝐞𝐰 𝐘𝐓𝐃:
- Overall revenue is $55M 💰
- Total interest is $8M 💸
- Total transaction amount is $45M 💵
- Male customers contribute more to revenue:
$#hashtag#M, Female: $ #hashtag#M 👨👩 - Blue & Silver credit cards contribute to 93% of overall transactions 🔵⚪
- TX, NY & CA contribute to % 🌍
- Overall Activation rate is % ✅
- Overall Delinquent rate is %
⚠️
✨ This project has been an incredible learning experience in handling data, creating measures, and visualizing insights with Power BI. Excited to hear your thoughts! 🌟