How to Build Loan Officer Dashboards in Power BI for Mortgage Teams?

Imagine a scenario: It’s a Monday morning. You are having your pipeline review in thirty minutes. You are waiting for the processing manager to pull numbers from Encompass. The loan officer lead is taking screen-prints of the spreadsheets they have. And someone else is sending an email that contains a PDF report from last Thursday. When you finally sit down, you have three different versions of reality, and none of these fall on the same date as today. 

Currently, this is the harsh truth for most mortgage lenders. Many mortgage lenders would prefer to adjust or change. However, most of them have not had the opportunity to experience a different system to generate a much more productive way to operate their business. Loan Officers are now using the Loan Officer Dashboard of Power BI which entirely changed how mortgage teams do business. 

With this guide, you will learn how to develop an actual usable Power BI mortgage dashboard, what to display, how to arrange the features, how to link your source data and what other mortgage teams using Power BI have to say about it. Regardless of whether you are starting at zero or have developed an incomplete dashboard, this guide provides all of the information you will need. 

What is a Loan Officer Dashboard in Power BI?

Power BI Loan Officer Dashboard creates a live/interactive reporting layer for reporting on anything related to the mortgage industry. It provides users with a variety of ways to visually represent KPI’s, graphs, and filtered information while drawing from many databases, including the LOS, CRM, spreadsheet(s), and other databases. 

The Power BI Dashboard for lenders isn’t just a periodic static report. The data on the dashboard refreshes either on a schedule or near real time using DirectQuery or streaming architectures where supported. The information in your custom Power BI mortgage dashboards can be shared with all other members of your team using a web browser, Microsoft Teams, or the Power BI mobile app. 

Typical metrics tracked by a Power BI mortgage team include: 

• Active Pipeline by Loan Officer and Stage 
• Pull Through Rate (Application to Closing) 
• Days to Close by Loan Officer and/or Loan Product 
• Delinquency Rate by Type of Borrower 
• Monthly Volume Trend – Approved vs. Denied 
• Lock-up Expiration and Fallout Risk 

What’s a Pull Through Rate? 

The “Pull Through Rate” is a ratio representing the number of loan applications that successfully close compared to the total number of loan applications received. A “Pull Through Rate” of 65% means that the mortgage provider has received a total of 100 applications for loans. However, 35 of those applications were either denied, withdrawn or given to another provider (i.e., not closed). The Pull Through Rate is one of the most widely used metrics in all mortgage retailers. 

Why Power BI And Not Just a Spreadsheet?

Many people think of spreadsheets as the reason for all their problems but, in reality, it’s the manual inputting of the data that creates the issues with these tools. If a person’s job is to update a pipeline report using a spreadsheet every Friday, by Thursday afternoon or evening the information being reported is already four days old and irrelevant. 

These four days can mean the difference between being able to make an informed decision regarding what files to push through the process, which borrowers need to be followed up with, and which branches are underperforming. 

In addition, Power BI has direct connections to all of your data sources (Encompass, LoanPro, Salesforce, SQL Server, Excel files, etc.). Users always see the latest available refreshed dataset without manually exporting reports.

According to a mortgage operations manager for a regional lender who took part in a Power BI Community discussion, “We used to spend 30 minutes debating which numbers were correct every Monday morning. Now it takes us five minutes because we can pull the dashboard up off the projector and be done.” 

In addition to solving problems routing from data freshness, Power BI also allows for: 

• To allow the branch managers to see their individual pipeline using role level security 
• By letting users to click on a chart which will filter all the other charts on the dashboard 
• To allow for the ability to drill from an overall metric to one specific loan 
• Automatic refreshing of data with no one having to touch a current file 

A lot of mortgage lenders that had been previously using static reporting tools are upgrading to new reporting infrastructures with migration to Crystal Reports to Power BI. Moving from legacy reporting systems to dynamic Power BI dashboards provides lending teams with access to real-time analytics, self-service reports, automatic refreshes and a much better overall view of their business!

What is A Power BI Mortgage Dashboard?

A Power BI dashboard for mortgages is an interactive reporting tool for the lending industry that integrates critical loan information (pipeline status; approvals; closings; delinquency rates; and borrower risk) onto one visual platform to show a complete picture of all key loan aspects. The loan officer dashboard Power BI pulls in actual data from the various sources and uses this raw data to create charts, KPIs and filter data out by category. This way teams can view performance, track trends and make quicker data-driven lending decisions. 

The 5 Core Dashboard Pages Every Mortgage Team Needs

Using real-world implementations, such as the open-source mortgage analytics project (MoBaker35) found on GitHub and frameworks realized by Power BI Consulting’s enterprise banking team, we have identified 5 pages which appear in all effective mortgage dashboards: 

Page 1: Executive Overview

This is the home page of the Power BI Mortgage dashboard. The layout is so simple that all staff can understand this page no matter if you’re the CEO or Branch Manager. 

What lives here:

Maintain a clutter-free report. Utilize a maximum of (6) KPI cards, (1) trend line, and (1) map or bar chart. Executives prefer not to scroll down for data. The goal of Power BI for mortgages is to provide the executive immediate visual of the status through color-coded indicators (red or green). 

Page 2: Pipeline & Loan Analysis

This is the way the processing team and loan officers will truly experience their day-to-day work function. The question being answered is, “where is everything currently at?”, and “what is at risk?”. 

Key visuals to display on this page will be as follows: 

• Funnel Chart representing the number of loans in each stage of processing and underwriting process. (Application → Processing → Underwriting → Clear To Close (CTC) → Closed) 
• Scatter Plot graph showing the amount of days each loan has been in their current state of processing and how that amount of time compares to the total loan amount. (this will allow flagging high dollar loans that have been stalled in processing.) 
• Bar Chart displayed side-by-side to show the volume of loans per loan officer, as well as approval rate and average days to close. 
• Table of loans that will expire their lock within the next 7, 14, and 30 days. (this is critical) 

What’s a lock expiration, and why does it matter so much?

A borrower receives their interest rate from the lender for an agreed upon period. Generally, it ranges from 30, 45 or 60 days depending on the loan type. If the loan does not close prior to the end of their lock period, then the lender will either incur a cost to extend the lock or pay a cost to sell off the lock. A lock expiration tracker in Power BI allows you to inform you of your lock expiration before it becomes a surprise cost for you. 

According to the Power BI Consulting team’s banking framework, mortgage lending relies on velocity of the pipeline to survive. It means that pipeline velocity (the time from application to closing) directly impacts pull through rate, cost of lock expiration and satisfaction of the borrower. 

Page 3: Borrower & Risk Analysis

This page of the outline explains who is in the portfolio. So, it provides a better understanding for the risk & compliance departments 

Create visuals for the following: 

1. Credit score distribution chart (by loan type) 
2. LTV Buckets (Loan-to-Value) (below 80%, 80%-90%, 90% or greater) 
3. DTI (Debt-to-Income) trends over time. Are you approving riskier borrowers? 
4. Delinquencies by borrower segment (first-time buyers, refinance, investment) 
5. Geographic heat map of where your loans are and where your defaults are clustered. 
6. An additional but often overlooked item to add is an approval/denial breakdown by product type and loan officer. If one loan officer has a 40% denial rate while others are 15%, then this indicates possible training gaps or issues with the quality of the pipeline. 

The loan officer dashboard is a centralized location where lenders & analysts can track multiple aspects of loan performance, borrower behavior, and monthly trends.

Page 4: Property Analysis

When evaluating a property for its value, you will be provided with different types of data related to that property. However, none of the property data may reflect the true condition of either that property or the borrower linked with it. Lastly, there are two sides or approaches to property-related data. Therefore, there may be obvious differences between local property markets for specific locations. 

• Asset class diversity: The distribution of assets by the asset class that comprises the lending block (e.g., housing, commercial real estate, etc.). 
• Price-to-value disparity tracking: Indices showing the number of loans closed versus appraisals at less than purchase price. 
• State/Metro area data representing the number of loans that have defaulted and/or continued to perform for 180 days past due. 
• Average loan-to-value of secured properties categorized by property class: If an investment property has an 85 percent loan-to-value, this statistic should be monitored. 

If you are working with many states or areas, the page will help provide real-time information on the geographic focused risks before becoming a problem with regulators. This view includes the total payable balance by state, MSA or county, which has regulatory requirements agreed with geographic risk as well as CRA compliance. 

Page 5: Monthly Trends & Performance

This page allows you to evaluate your previous performance and define future plans. It answers questions such as: Are our numbers improving? Will we be able to speed up our process? The following graphics should be on this page for monitoring: 

• A line graph showing the applications as they compare to the number of loans that are both approved and closed on a rolling monthly basis. 
• A bar chart comparing the average number of days it takes closing a loan from month to month. 
• An area chart displaying loan volume according to type of loan (e.g., installment vs. open-ended). 
• A table showing the underlying branch performance as compared to the prior period using month vs. month and year vs. year format. 

Once a continuous date table is created and marked as a Date Table in the model, built-in DAX time intelligence functions such as SAMEPERIODLASTYEAR() and DATEADD() become available. 

Step-by-Step: How to Build an Effective Mortgage Dashboard in Power BI?

1. Define the Key Metrics First

Before opening Power BI for your project, you should have a clear understanding of the key metrics that are valuable to your mortgage team as per the previous performance. Those metrics include the following: 

• Lock expiration date (7, 14, or 30 days).
• Pull-through rate in comparison with the team. 
• Average days to close in comparison to goals.
• Any loans that have been stalled at any stage of the loan process. 

2. Connect Your Data Sources

Import your data from your LOS, CRM, or Excel spreadsheet into Power BI.

Common Examples of Data Sources: 

• Loan pipeline data.
• Rate Lock data.
• Loan Officer Performance data.
• Closing Historical records

All of your data sources must share the same or common identifier (document number, or standard Loan ID). 

3. Clean and Structure the Data

Utilize Power Query Editor in Power BI to:

• Identify & remove duplicate records from your data set.
• Name stage names consistently (i.e., “Processing” or “In Process”).
• Address missing or inconsistent dates in your data set.
• Add new fields to your data set (e.g., calculating the number of days in each stage).
• Ensure the accuracy of your reports by cleaning up the data in the above processes. 

4. Build Core Data Models

Create relationships to provide seamless integration of related information from tables including:

• Loans to Stages
• Loans to Loan Officers
• Loans to Rate Lock

By establishing relationships between these tables, all of your visuals will be able to “speak” with each other. 

5. Create Key Calculated Metrics (DAX)

Add measures to your calculations such as:

• Days in Pipeline
• Average Time to Close
• Pull-Through Rate
• Loans Expiring Soon

These types of calculations extract value-added insights from your data. 

6. Design the Dashboard Layout (Keep It Simple)

Custom Power BI mortgage dashboards need to be designed like a snapshot of what is happening at the moment.

Top Section: Active loans by total

• Locks that expire soon
• KPIs and performance shows

Middle Section: Pipeline stages by loan type (Visual Chart)

Bottom Section: List of loans that have been stalled 

7. Add Visuals That Tell a Story

The best way To illustrate this:

• Bar Charts → Stage Of loan In pipeline
• Line Charts → Trends over time
• Cards → Main KPIs
• Table→ Loans that have stalled or are at Risk or both

Avoid having too much visual clutter. Each visual should only answer one question. 

8. Apply Filters for Loan Officers

Use slicers in order for users to filter by:

• Loan officer.
• Branch.
• Date range.
• Stage of Loan.

Slicers will keep dashboards personal while adding no extra layer of difficulty. 

9. Optimize for Speed and Clarity

• Reduce volume of distracting visuals.
• Utilize summarized data tables.
• Avoid large calculations at post-load time.
• Keep the layout focused on being one page. 

10. Publish and Set Refresh Schedule

When finished:

• Publish to Power BI Service.
• Set auto-refresh to daily/hourly if that’s doable.
• Distribute User access by their functional roles (Loan Officer, Manager, Executive). 

The mortgage industry will continue to create new datasets for each entity (loan) in their lifecycle over time. The Power BI Incremental Refresh feature allows data relevant with a loan to be re-freshed with recent transactions without changing historical records. Hence, the total time used to perform a full refresh is greatly reduced and improves the reliability of large mortgage portfolios. 

How to Connect Your Data: The Practical Part

Here’s what you need to know if you’re using either Encompass, Excel or CSV files, or a CRM system:

• Encompass (ICE Mortgage Technology): The API of Encompass allows for connection with Power BI through a custom connector as well as exports to flat files as CSV or Excel sheets. The most common method of creating reports from Encompass is through scheduled exports to SQL Server either on a daily or hourly basis, then connecting with Power BI. This is usually more than most enterprises require.
• Excel and CSV Files: Use Power BI’s built-in connections (Folder for a set of CSV files; Excel for a single workbook) to load data into Power BI. After you’ve connected Power BI to your data source, you can schedule refreshes using Power BI Service (cloud solution). This method of getting data into Power BI is the simplest way to start using Power BI.
• Salesforce or other CRM Solutions: Power BI has a native connector to Salesforce that connects directly to objects containing loan data. This will allow you to extract information related to pipeline stages, activity logs, and contact information without the need for prior exports from Salesforce.

Composite Models / Direct Query vs. Import Mode

This is critical for mortgage systems:

The data model you actually want:

A star schema ensures that a mortgage dashboard provides accurate data. 

Fact_LoanTape 

    ├── Dim_LoanProduct (type, rate type, term)

    ├── Dim_LoanOfficer (name, branch, region)

    ├── Dim_Borrower (segment, income category, credit tier)

    ├── Dim_Property (type, state, MSA)

    └── Dim_Date (calendar + fiscal periods)

Fact tables will include Loan_Tape (one record per Loan for each reporting date), Payment_History and Delinquency_Status, where each fact table is connected to dimension tables for Loan Product, Branch, Borrower, Date and Geography. 

Mortgage companies that are looking into how to scale their long-term reporting will often evaluate how Power BI compares to comparable enterprise analytics platforms before determining the best reporting architecture. Our guide on Top Business Intelligence Tools to Consider in 2026 demonstrates how Power BI, Tableau, Looker, etc. differ from each other in respect to governance, performance, customization, and operational reporting capabilities. 

Security: Who Can See What?

In the mortgage industry, the creation of a star Schema is the best practice because Loan data is confidential information. Also, the branch managers cannot have access to the Loan Pipelines of different Branch Offices.

Power BI has the ability to achieve this through the use of Row Level Security (RLS).

When you set up RLS for Power BI, you must establish roles (Branch Manager, Regional Director, Executive and Compliance) and create DAX Filters to restrict the number of rows. Power BI uses Microsoft Entra ID (Azure AD) authentication and applies assigned security roles to know about accessible rows. 

Dynamic RLS will limit the view of loan origination data to their specific Branch Office for Branch Managers, their respective Region for Regional Directors, and the entire Mortgage Portfolio for the Executive Level.

Separate role(s) should be created for all Compliance and Auditing Users to give them full access to the Mortgage Portfolio along with the use of Audit Logging for tracking user access to the Mortgage Portfolio. 

Real Observations from Teams Using This

After connecting its mortgage industry reporting dashboard to Power BI, teams pick three outcomes:

1. Shorter Monday morning meetings with everyone looking at live data. The teams don’t have to spend time altering prior to talking.
2. Loan officers pay attention to metrics that they have historically ignored, especially revenue metrics like pull-through rate. Average days-to-close are now visible to management.
3. Getting your data model built correctly takes more time than you realize. Create your star schema first.

As a data analyst recently posted in the Power BI community: “Using SSRS for mortgage performance we used to take a week to compile reports. Utilizing the Power BI pipeline tracker with the Encompass connector allowed our operations team to find snapshots of the loan status on the same day rather than at the end of a month.” 

A Note on Benchmarks: What Good Looks Like

The major thing that mortgage dashboards lack is contextual information. A loan taking 45 days to close is a decent time-unless the average for that loan type in the industry is 30 days. According to Q1 2026 data from Fannie Mae, the average time to close conventional purchase loans for retail lenders is well within a range of 43-47 days. 

Use that as a baseline, but also create your own historical internal baseline, as you can act more efficiently with a 90-day rolling average. Here is a quick reference table with the KPIs: 

Common Mistakes to Avoid

1. If you had a flat table of all loan records that contained borrower info, property info, officer info and date info in each row, the model will perform poorly and the calculations will be inaccurate as well. You should be normalizing this into a star schema.
2. Time intelligence features in Power BI will only work if there is a proper date dimension table with a valid continuity of dates. You can build this with either the CALENDAR() or CALENDARAUTO() functions
3. Build your loan officer dashboard Power BI for processors and branch managers. These are the people that will log onto this dashboard every day. Executives should have summary pages, but if the operational pages are not useful then no one will be using the dashboard.
4. If your dashboard is going to refresh once a day at midnight and your team is reviewing the pipeline at 9am, you should be fine. If your team expects live data but the refresh fails silently, trust in the tool will quickly disappear. Set up email alerts for Power BI Service refresh failures.
5. Every visual has a burden as it will slow down render time and will compete for the view on the visual to be viewed. 

Where to Start This Week?

If you are new to all of this, here are some reasonable starting point(s): 

• Export 3 months worth of data from your LOS to Excel or CSV such as loan ID, loan stage, originator, loan open date, loan close date, loan amount, loan status, and state of the loan. 
• Load the data into Power BI Desktop (download from Microsoft for free). 
• Create a date table utilizing CALENDAR(DATE(2024,1,1),DATE(2026,12,31)). 
• Put up 4 measures: Total Pipeline ($USD), Pull-Through Rate (%), Average Days to Close, and Active Loans Count. 
• Generate one page of those 4 measures and a simple bar chart of volume by originator. 

This is your working Dashboard. From here you can add pages, connect to a live datasource, and use Row Level Security (RLS). You can have a usable Dashboard after a few hours of work. There is no need to wait until you have everything perfect to have a functional Dashboard! 

To Sum Up

Developing a robust mortgage dashboard in Microsoft Power BI is much more than creating visuals, it is about establishing a single point of reference for your entire lending team. When all loan officers, processors, and managers are working from the same source of real-time data, decision-making occurs more quickly and accurately with less reliance on manual reporting or multiple spreadsheets. 

An organized mortgage dashboard helps in identifying pipeline health, recognizing stalled loans early, tracking lock expiration dates, and highlighting any possible performance issues before they become critical. The primary objective of Power BI mortgage dashboard is to keep it simple and focused and to align it with how your teams actually do their jobs. 

Going forward, investing in Power BI dashboard development and building reports in Power BI will enable you to grow from basic reporting to a completely interconnected and automated decision-making system. 

Are you looking to modernize your mortgage reporting approach? Consider collaborating with professional Power BI dashboard developers at Awesome Technologies Inc. to create customized mortgage analytic tools that provide better operational visibility, improve efficiency, and foster informed decision making! Talk to an expert.

Frequently Asked Questions

1. What is Power BI, and how does it help lenders?

Power BI is a reporting tool created by Microsoft. It takes data from spreadsheets, loan software, or a database and presents it in the form of real-time charts and dashboards that can be read by your staff. For lenders, this means no longer having to create manual weekly pipeline reports. Staff can see which loans have stalled, the speed at which particular loan officers are closing, or if there are more defaults from one platform and at any time of day. 

2. Is Power BI secure enough for mortgage data?

Yes when configured properly. Power BI uses the Microsoft Azure platform, which has a SOC 2 Type II and ISO 27001 certification for data security. Power BI has built-in Microsoft Azure security controls, including encryption at rest and in transit, identity management, and role-based access controls. One of the most critical features for a mortgage team is an RLS (Row-Level Security). This is a great method for lenders to prevent employees from viewing competitor pipelines or viewing borrower records they do not have permission to see. 

3. How to visualize mortgage data in Power BI?

The initial step involves obtaining the data source either through an Excel export from Encompass, a SQL database or CSV file. After you have the data source in place, you will then be able to select an appropriate type of visual that will allow you to answer your questions:

4. What is the best dashboard for loan officers?

Loan Officers require a pipeline-oriented view rather than a higher level Executive Summary format. A Loan Officer will require five items on one page of their dashboard. It allows him to easily view everything needed, without having to switch back and forth between tabs. The five key aspects are: 

• Active Loans by stage (i.e., processing; underwriting; CTC)
• Locks about to expire in 7/14/30 days
• How does their individual pull through rate compare with the average of their team
• Benchmarks vary by lender size, loan mix, and market conditions 
• All stalled loans in a stage for a more time period.

The goal is: Open up the dashboard, understand what you need to do that day in seconds, and get back to closing loans! 

5. What makes Power BI different from Excel?

The short version: Excel is an excellent calculator whereas Power BI is a means of live reporting. So, you should stop manually refreshing the spreadsheet every week to send it out. 

6. Can Power BI connect directly to Encompass? 

Yes, but there will be some configuration required to achieve this. The Encompass product offers the Encompass API, and you can connect to it using either the web connector or a custom connector from Power BI. Many teams utilize an intermediate SQL database to ensure cleaner data and quicker refresh times when using Power BI. 

7. Do loan officers need a Power BI license? 

Yes. Every person who accesses a Power BI dashboard that is published must have at least a Power BI Pro license (subscription-based) or be within a Premium capacity workspace. 

8. How long does it take to build a mortgage dashboard from scratch? 

A simple pipeline/overview dashboard with a good data source will take 2-4 days to create. A full 5-page dashboard, complete with RLS, a star schema and multiple sources of data should take approximately 2-4 weeks. This also includes time for testing and feedback from stakeholders.