Darth-Glennium/competitor-price-monitoring-dashboard

A Power BI dashboard tracking competitor loan interest rates and default risk in Kenya # Competitor Price Monitoring Dashboard This **Power BI Dashboard** provides insights into loan interest rates, approval times, and default risks across different lenders in Kenya. It helps financial analysts and decision-makers track competitor pricing trends and assess lending risks. ## Features - **Interest Rate Trends** : Visualizes interest rate changes over time for different lenders. - **Loan Distribution Analysis** : Displays the total loan amounts issued by each lender. - **Default Risk Analysis** : Shows the proportion of high and low default risk borrowers. - **Loan Approval Time** : Analyzes how long different lenders take to approve loans. - **Interactive Filters** : Allows users to filter by lender and date range. ## Technologies Used - **Power BI** for interactive data visualization. - **DAX (Data Analysis Expressions)** for calculated measures. - **CSV Data Source** for financial records. ## How to Use 1. **Download the Power BI file**. 2. **Open in Power BI Desktop**. 3. **Interact with the visuals** using the filters to explore insights. ## Screenshots ## Data Insights - **Default Rate:** 39.1% of loan applicants are classified as high-risk. - **Interest Rate Variation:** Some lenders offer lower rates, while others maintain higher fixed rates. - **Approval Times:** Approval times vary significantly across different financial institutions. --- **Author:** Glenn Kipanga