Recently a customer reached out to me to help with the challenging task of understanding the assessment results of 61 SQL environments including over 500 databases being considered for migrating to Azure SQL Database. Now there is already a great solution that exists for aggregating DMA assessment exports but it only works for assessment exports in .JSON format. The existing solution also requires that the assessment results be written to a SQL Server database.
So I built a solution that uses Power BI to parse the DMA assessment exports (.CSV format) and aggregate the data so it can be more effectively browsed and understood in a report.
Click through for a link to download that template, as well as additional resources.