Landscape analysis is an important part of preparing for any data migration. It provides an overview of the source and target systems, enabling the project team to understand how each system works and how the data within each system is structured.

Within each migration, data has to come from a source system to be migrated to a target system, however in order for this data to be migrated it has to be structured, formatted, organised and most importantly validated.

Within the Discovery Phase of a migration strategy we have four main phases, these are:

When preparing for a migration migFx would normally ask the client to make sure their data reaches the expectations of being clean, structured, formatted, organised and validated.

Most data storage systems may have many structures where one category may link to other categories and live data may be joint to reference tables which may be updated daily.

This would be based on the dimension cube of the data storage system and could be very complicated in some cases.

In a Pre-Migration Plan, we have key activities where we establish:

  • Data assessments
  • Data cleansing
  • Extract Transformation and Load

The output of this Phase requires the following:

  • Scope and Strategy document
  • Clean source data
  • ETL jobs and source migration script.

This is where Power Bi could benefit a migration process, Power BI could show:

  1. Validated data
  2. How data is being formulated in a data storage set-up 
  3. Aggregated data entries
  4. Different types of data entries
  5. Cleaned data vs unclean data
  6. Product types/categories which are associated with reference tables.

Power BI can produce finalised reports ready for the next steps in a migrations strategy, which will ultimately make the project team planning phase a lot easier.