Maintaining Parallel Power Pivot and SSAS Tabular Models-Tales from the Trenches

This post is really a collection of field notes and some lessons learned from recent project experience. I've done plenty of SSAS Tabular projects over the past few years - usually starting with a Visual Studio project rather than Power Pivot. I've also done a bit of Power Pivot work for clients. These projects were either delivered to an analyst using Excel on their desktop or some business users through SharePoint. But, authoring in Excel Power Pivot and deploying to a server-hosted Tabular model has been mainly theoretical up to this point so I thought I'd share my experience.