214.891.7417 Let's Chat

Microsoft SSIS Data Cleansing Process Tutorial

SSIS Data Cleansing

Watch the video to discover how to cleanse “dirty data” using the 2012 version of MS SSIS.

View the SSIS Data Cleansing tutorial video to learn about:

  • How to reformat manual entries to be used in a report
  • Examining client addresses and cities for correct formatting
  • Correcting misspelled city names and non-capitalized cities
  • Running a nightly job
  • Filtering for dirty data
  • The use of a SQL command
  • What a Fuzzy Lookup is and when to use it
  • Joining reference tables
  • How to preview table data

If you have any further questions about MS SSIS data cleansing or other business intelligence tools, don’t hesitate to reach out to us. Contact us to discuss how we can help.