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.