Loan disbursement Analysis in Power BI Project Dashboard (1/30)
151.9 هزار بار بازدید -
4 سال پیش
-
Power BI Loan Disbursement Analysis
Power BI Loan Disbursement Analysis - Real Time Project in Power BI Dashboard Report Examples
What Kind of Projects will be implemented in Power BI
We also covered, what are all the things that we need to consider before
starting the project and how to implement it.
Source File
Loan Details
https://drive.google.com/file/d/1F9Ob...
Loan
https://drive.google.com/file/d/18azg...
Dim Date
How to Create Date Table or Date Dime...
Power Bi File
https://drive.google.com/file/d/1neIJ...
Project Requirement
This Project Covers Following Loan Disbursement Analysis Requirement.
1. Monthly disbursements in EUR for the last 6 months. Please consider principal_amount_eur as a measure
2. Disbursements per loan_officer. Please use visualization to show the count of loans disbursed per each loan officer for the last month. In addition, we would like to see the volume of disbursed loan as well (sum(principal_amount_eur)).
3. Portfolio at risk. Please use visualization (KPI) to show the (sum of principal_amount_outstanding_eur) with overdue days is greater than 30 divided by total sum(principal_amount_outstanding_eur)
4. Please add filters to breakdown by branch_key, product, and loan_officer
#powerbi #PowerBIProject #PowerBIDashboard
🏬 Reference Books : https://www.amazon.in/shop/analyticsw...
✉ Business Queries / Analytics Consulting ✉ : [email protected]
💬 For Learners Post queries and Interact 💬 : http://t.me/analyticswithnags
Complete Playlists
Power BI Tutorials - Complete Playlist 📚📖 How to do Power BI Installation - Pow...
Power BI Desktop Tips and Tricks 📚📖 How to Remove Top N rows in Power BI ...
Power BI DAX - Complete Playlist 📚📖 What is DAX in Power BI DAX Tutorial ...
Power BI Project Dashboards - Power BI Realtime Projects - Playlist 📚📖 Loan disbursement Analysis in Power B...
Power Pivot 📚📖 Power BI Tutorial (15/50) - What is P...
Power Query 📚📖 Power BI Tutorial (15/50) - What is P...
Power BI Services Playlist 📚📖 Introduction to Power BI Service (1/30)
Power BI Tamil Tutorials 📚📖 How to do Power BI Installation in Ta...
Power BI Telugu Tutorials 📚📖 How to do Power BI Installation Power...
SQL Full Course | SQL Tutorial For Beginners 📚📖 Learn SQL Complete | Course Introduct...
SSAS Tutorials - SQL Server Analysis Services 📚📖 Introduction to SQL Server Analysis S...
MSBI Tutorials - SQL + SSAS + SSIS 📚📖 Learn SQL Complete | Course Introduct...
Data Analyst - Complete Reference - Playlist 📚📖 Data Analytics For Beginners | Introd...
BI Developer - Complete Reference - Playlist
📚📖 Power BI Tutorial From Beginner to Pr...
BI Architect - Complete Reference - Playlist
📚📖 Power BI Full Course - Learn Power BI...
ETL Developer - Complete Reference - Playlist 📚📖 Building an Enterprise ETL Framework ...
Database Developer - Complete Reference - Playlist 📚📖 SQL Tutorial - Full Database Course f...
What Kind of Projects will be implemented in Power BI
We also covered, what are all the things that we need to consider before
starting the project and how to implement it.
Source File
Loan Details
https://drive.google.com/file/d/1F9Ob...
Loan
https://drive.google.com/file/d/18azg...
Dim Date
How to Create Date Table or Date Dime...
Power Bi File
https://drive.google.com/file/d/1neIJ...
Project Requirement
This Project Covers Following Loan Disbursement Analysis Requirement.
1. Monthly disbursements in EUR for the last 6 months. Please consider principal_amount_eur as a measure
2. Disbursements per loan_officer. Please use visualization to show the count of loans disbursed per each loan officer for the last month. In addition, we would like to see the volume of disbursed loan as well (sum(principal_amount_eur)).
3. Portfolio at risk. Please use visualization (KPI) to show the (sum of principal_amount_outstanding_eur) with overdue days is greater than 30 divided by total sum(principal_amount_outstanding_eur)
4. Please add filters to breakdown by branch_key, product, and loan_officer
#powerbi #PowerBIProject #PowerBIDashboard
🏬 Reference Books : https://www.amazon.in/shop/analyticsw...
✉ Business Queries / Analytics Consulting ✉ : [email protected]
💬 For Learners Post queries and Interact 💬 : http://t.me/analyticswithnags
Complete Playlists
Power BI Tutorials - Complete Playlist 📚📖 How to do Power BI Installation - Pow...
Power BI Desktop Tips and Tricks 📚📖 How to Remove Top N rows in Power BI ...
Power BI DAX - Complete Playlist 📚📖 What is DAX in Power BI DAX Tutorial ...
Power BI Project Dashboards - Power BI Realtime Projects - Playlist 📚📖 Loan disbursement Analysis in Power B...
Power Pivot 📚📖 Power BI Tutorial (15/50) - What is P...
Power Query 📚📖 Power BI Tutorial (15/50) - What is P...
Power BI Services Playlist 📚📖 Introduction to Power BI Service (1/30)
Power BI Tamil Tutorials 📚📖 How to do Power BI Installation in Ta...
Power BI Telugu Tutorials 📚📖 How to do Power BI Installation Power...
SQL Full Course | SQL Tutorial For Beginners 📚📖 Learn SQL Complete | Course Introduct...
SSAS Tutorials - SQL Server Analysis Services 📚📖 Introduction to SQL Server Analysis S...
MSBI Tutorials - SQL + SSAS + SSIS 📚📖 Learn SQL Complete | Course Introduct...
Data Analyst - Complete Reference - Playlist 📚📖 Data Analytics For Beginners | Introd...
BI Developer - Complete Reference - Playlist
📚📖 Power BI Tutorial From Beginner to Pr...
BI Architect - Complete Reference - Playlist
📚📖 Power BI Full Course - Learn Power BI...
ETL Developer - Complete Reference - Playlist 📚📖 Building an Enterprise ETL Framework ...
Database Developer - Complete Reference - Playlist 📚📖 SQL Tutorial - Full Database Course f...
4 سال پیش
در تاریخ 1399/06/20 منتشر شده
است.
151,900
بـار بازدید شده