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