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

Laptop And Chart For Decision-Making With Data Visualization
12 Essential Ways to Spot Trends and Enhance Decision-Making with Data Visualization

"The greatest value of a picture is when it forces us to notice what we never expected to see." –…
Business Intelligence Consultants From Wci Data Solutions Helping A Client Make Data-Driven Decisions Through Advanced Analytics And Interactive Dashboards
So, What Exactly Does a BI Consultant Do?

Do you ever feel like you're struggling to make the most of your business intelligence tools?  Or is your data…

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