You're right in that it is indeed challenging to consolidate all the data in a meaningful way. The tool is scheduled for release in May so you'll have the chance soon to try it out yourself.
As for the method that is used for the data consolidation, it's not AI or machine learning. It is designed to be as simple as possible by using SQL queries. Once it has been released, you'll even be able to take a look at the queries used for the consolidation.