Mary Series 3: Using SSIS to extract terms

Posted on June 5, 2014March 20, 2021 by jayanth.kurup

All characters, events and data in this series are fictional. Any resemblance to any person living or dead is simply probability at work (More on that in the series).

In the first video we explored how Mary uploaded her bank statement into SQL Server and started her first analysis of the accounts.

PART 1 http://www.youtube.com/watch?v=m4WXmhopmQQ

In the second video Mary enriches her data to be able to slice and dice the data in order to better analyse what’s going on.

PART 2 http://www.youtube.com/watch?v=0Mppf1kIaA4

In the third video Mary uses SSIS to extract keywords from the descriptions in her bank statement. This will allow her to create primary key tables and filter data more meaningfully later on

PART 3
https://www.youtube.com/watch?v=jVoEbXEdHfg

Please Consider Subscribing

jayanth.kurup

This post was written by Jayanth Kurup. A Microsoft SQL Server Consultant and Trainer based out of Bangalore, India. Jayanth has been working on MS SQL Server for over 15 years. He is a performance tuning and Business Intelligence expert. Having worked with companies like Microsoft, DELL, Wells Fargo, Thomson Reuters and many other fortune 100 companies. Some other technologies Jayanth works on include Microsoft Azure, PowerBI, Python and AWS. When he isn’t consulting or training, Jayanth like to travel, paint and read. He is also very active in social causes and the founder of Enabled Business Solutions. Visit his company by clicking the link in the menu or email him directly.