Model Checks - Best Practices and Most Useful Metrics

[skyeg321]

Just wanted to check in with all the BIM-panzees on this forum. We are beginning to run periodic model checks at my company using the interoperability tools and checksets. We are starting with using the Autodesk 'Revit Model Dashboard.xml' checkset file and Power Bi report template. A few questions:

1. In your experience, what is the most useful information you have been able to gleam from a checkset or model audit in general? 

2. How do I extract data from these .xlsx files after we have built up a lot of them? For instance, model size. We will want to be able to get an average of all model sizes for our own information. Do I need to write code of some sort that will goin to all these files and pull this data? Can this be done with Power Bi?

[handjonathan]

Hi @skyeg321 

Thanks a lot for posting your question to the forums!   Im tagging @SteveKStafford @ToanDN @Alfredo_Medina who may be able to offer some insights here. 
 
We look forward to hearing back from you with more information so we can help you as a community! 

[Alfredo_Medina]

Sorry. I cannot help with this question. I have not used those tools.