Colliers Explores Competitive Edge with Microsoft’s Queryon


ColliersWith a vision for modernization, efficiency, and excellence, Colliers aims to provide their workforce with critical, relevant, and up-to-date insights at their fingertips. They turned to Queryon to help with the design and deployment of a worldwide Power BI solution. 



Vast amounts of data were being generated from tens of thousands of professionals and transactions, as well as millions of website visits. Although daunting, the amount of data was also exciting because Power BI is an excellent tool for mining the data and deriving useful business intelligence from it. Prior to Power BI, the Colliers analytical team had to gather data and manually build reports in order to provide information to the field agents. Delays in providing the report might result in a lost opportunity to close a deal.



Because data accuracy was a key aspect, extensive audits were performed which resulted in the strengthening of several Extraction Transformation and Loading processes to eliminate data issues. To address the different organizational access privileges, row-level security was implemented. As a user logs into the Power BI solution, the user will only be able to see what the specific profile allows. Profiles were created for Regional managers, Country managers, Real Estate associates, to name a few. An important strategy was to have the right mix of talent from both Colliers and Queryon. Being foundational to the project, Colliers’ vision and business needs were inspiring and well-articulated. The Queryon team pulled from multi-faceted experience to bring that vision to fruition by devising simple yet powerful visual reports, navigation, and functionality.



The synergies and collaboration between Colliers and Queryon contributed to the success of the solution design. After deployment in several regions of the globe, Colliers professionals can now easily access key up-to-date business intelligence about their properties, which gives them a competitive edge. With the information, they can make the right decisions faster and therefore close transactions more promptly. Similarly, Regional and Country managers can now analyze their portfolios, thus managing their teams more efficiently with the opportunity to maximize their potential.


Must see news