Here is the second post for SQL University, where we introduce the topic of mobilising PowerPivot data. As an introduction, I thought it might be useful to share the presentations that I did recently. Tomorrow’s blog will talk more about the details of mobilising PowerPivot data using Tableau, but I thought that these articles might provide some introductory material for people to use, and re-use, in order to expose the usefulness of PowerPivot as a data source. Here is a brief overview:

Essentially,the Ordnance Survey and Census data were mashed up together and linked together in PowerPivot. The PowerPivot was then used as a source to Tableau, which was used to visualise the data.  As an introduction to the process, I generated some presentations to use when I was talking around this solution. and I have provided these presentations here.

Here is a very introductory presentation on PowerPivot in Sharepoint. This presentation was designed to be given in around 5 minutes before being supported a series of demos, and the intended audience was people who hadn’t seen PowerPivot previous to the presentation.

Power pivot in Sharepoint Introductionhttp://static.slidesharecdn.com/swf/ssplayer2.swf?doc=powerpivotinsharepoint2-1-111124100544-phpapp01&stripped_title=power-pivot-in-sharepoint-introduction&userName=jenstirrup

iPad and Mobile Business Intelligencehttp://static.slidesharecdn.com/swf/ssplayer2.swf?doc=ipadandmobilebi1-3-111124102715-phpapp02&stripped_title=ipad-and-mobile-business-intelligence&userName=jenstirrup

Sql server 2012 mobile business intelligencehttp://static.slidesharecdn.com/swf/ssplayer2.swf?doc=sqlserver2012-mobilebusinessintelligence-111124100810-phpapp02&stripped_title=sql-server-2012-mobile-business-intelligence&userName=jenstirrup

I hope that you enjoy these presentations, which I’ve provided for people to use and enjoy as they wish. Tomorrow’s SQLUniversity post will provide more detail on the mobilisation of PowerPivot with Tableau.