Data refresh from PowerPivot

In a series of articles I explored the different scenarios around SQL and data refresh. One of the scenarios that I have not covered is how to create a data refreshable diagram from Analysis Services. If you do not already know this, Visio and Visio Services cannot refresh directly from Analysis Services, however we could use PowerPivot as a middle man. Imagine a scenario.

where the Visio diagram is data connected to a pivot table in an Excel workbook and the data for that pivot table is refreshed on a schedule by PowerPivot's data refresh feature in SharePoint 2010. Visio Services supports refreshing data from Excel Services so as long as PowerPivot's data refresh schedule is configured our diagrams will stay up to date.