1 / 11

Data Cleansing with SSIS

Data Cleansing with SSIS. Brian Knight Pragmatic Works bknight@pragmaticworks.com. About Brian. SQL Server MVP Founder of Pragmatic Works Author of 13 books Blogs at BIDN.com Twitter: @ BrianKnight. Wasn’t very good with girls Even Kermit the Frog founded a company

cullen-randall
Download Presentation

Data Cleansing with SSIS

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Data Cleansing with SSIS Brian Knight Pragmatic Works bknight@pragmaticworks.com

  2. About Brian SQL Server MVP Founder of Pragmatic Works Author of 13 books Blogs at BIDN.com Twitter: @BrianKnight Wasn’t very good with girls Even Kermit the Frog founded a company All 13 still awaiting a publisher. BI Savvy or BI Curious?

  3. Takeaways • Profiling the data • Cleansing and validating with scripts • Fuzzy techniques

  4. Data Profiling • Retrieves metadata about your data • Help identify data issues • Uses an SSIS Data Profiling Task

  5. Data Profiling Task Demo

  6. Scripting in SSIS • Tasks • Data Flow • Source • Transform • Destination

  7. Cleansing Uses in Scripting • Advanced data cleansing • Complex data validation • Unusual data sources

  8. Script Transform Demo Demo

  9. Fuzzy Techniques • De-duplicating data • Fuzzy catches misspelt words or variants • Fuzzy Grouping and Fuzzy Lookup

  10. Fuzzy Grouping Demo

  11. The End Already? • Questions http://www.bidn.com/people/brianknight @BrianKnight bknight@pragmaticworks.com http://www.youtube.com/pragmaticworks

More Related