A near real-time dashboard view of agent and company performance with customizable filters to allow the user to select the combination of dates and metadata that they want to see.
The manager of a group of real estate professionals needed a way to track team performance and analyze sales metrics on a per user basis. Having no way to track data for the team made it very difficult to make effective personnel decisions.
No way to view agent performance over time and track key metrics related to company growth.
Utilizing SharePoint as a backend storage solution, we ingested the teams data using a combination of Power Automate and plain old Excel. After we had all the data in one place, we designed a Power BI dashboard that would focus on the KPIs and metrics that this manager wanted to target.
The Power BI report gives an overall team view as well as provides a snapshot of an individual agent over a customizable period of time. Filters on the page allow the user to break down each piece of metadata to any depth and combination needed.
Providing a map view of the properties sold allowed the team to focus on historically weak areas and pinpoint where they were strong.