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. 

Related Posts

Microsoft Azure For Cloud Data Management | Wci Solutions
Should My Business Use Azure for Cloud Data Management? The Pros and Cons

In the ever-evolving landscape of cloud computing, choosing the right platform for your business's data management needs is critical. Microsoft…
A Data Management Consultant Helping A Client Utilize Wci'S Aws Cloud Migration Consulting Services.
5 Questions To Ask When Choosing a Business Intelligence Consulting Firm

Businesses looking to leverage the power of their data and analytics often turn to business intelligence consulting to help them…

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.

Contact Us