Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

Making Sense of Data Migration Assistant Assessments with Power BI

  • 6 December 2017
  • Author: DustinRyan
  • Number of views: 110
  • 0 Comments

The Data Migration Assistant is a great tool developed to assess your SQL Server environment for a migration to a modern SQL Server platform such as SQL Server 2017 or Azure SQL Database. If you’re assessing a single SQL Server with only a few databases, reading the exported results (which can be in .JSON or .CSV format) may not be that difficult. But if you’re assessing dozens of environments including hundreds of databases, we need a better way to understand the results.

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.

Download the Power BI Template file here

I’ve created a Power BI template file that you can download here to use with your own DMA assessments. The Power BI template has one parameter used to specify the location of the assessment files. When you open the template file you’ll be asked to specify the directory where the assessments are located. Keep in mind that your assessments should be in a .csv format for use with this template.

image

Make sure that the AssessmentDirectory parameter ends with a slash, as seen above. Once you provide the AssessmentDirectory parameter value, click Load and your reports will light up. Below you can see the reports that are included with the template, but you can create any other reports you might need based on the dataset.

image

image

image

image

I hope that you find this useful for simplifying your migration to a modern SQL Server platform. Let me know if you found this useful or if you have a question by leaving a comment down below! Thanks for reading!

Resources

Download the DMA Assessment Analysis Power BI template file

Download the Data Migration Assistant to perform a migration assessment of your environment

Download Power BI Desktop

Print
Categories: Uncategorized
Tags:
Rate this article:
No rating
DustinRyan

DustinRyanDustinRyan

Other posts by DustinRyan

Please login or register to post comments.