Mary Series 3: Using SSIS to extract terms

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.


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.


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


Please Consider Subscribing

Leave a Reply