Building a Flexible and Efficient Client-Side PowerPivot Solution in Excel 2013

considered doing this as multiple blog postings but then as I worked on I thought of how much I hate it when I see "To be continued .." on the screen at the peak of a TV show . Then having to wait a week (if I do in fact tune in then) to see the rest. So this is going to be an end-to-end solution in one "Mother of All" blog posts.