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. 

Get Started

Want a FREE on-site discovery session with your team?  Receive a FREE data management evaluation session with one of our veteran data architects. Reap the benefits of an expert’s outlook on taking control of your business insights and data. Stop missing out on data-driven opportunities,  and start making smarter, more profitable decisions today.