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
The following presentation came from SQLBits, where I gave a discussion on mobilising business intelligence with PowerPivot. Tableau Software was used in order to display the data from the PowerPivot, and the next blog in the series will present more technical detail on how the solution was built.
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
Here is the presentation that I produced for SQL Server Days in Belgium in November 2011:
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.
2 thoughts on “SQLUniversity: Introduction to PowerPivot and Mobile Business Intelligence”
The convergence of two technological shifts – with the rise of the smartphone use and the meteoric popularity of social media – has created a seismic shift in consumer behaviour. Business Mobiles
great post, really awesome work. thanks for posting, keep sharing.