#ProjectServer #PowerView report in #Excel 2013 #PS2010 #PS2013 #Office2013

March 1, 2013 at 11:51 pm | Posted in Administration, Configuration, Functionality, Reporting, T-SQL | 1 Comment
Tags: , , , , , , ,

This post will take a brief look at creating a map view of Project Server data – this does assume you tag your projects with a location!

For the purpose of this post I will use the example Excel file shown below – this pulls data from one of my test Project Server PWA instances, hence the project names!

image

In Excel 2013, click Insert > Power View Reports:

image

You will now see a Power View report:

image

To create a map with the projects plotted in the correct location by cost, see the steps below.

On the design tab, click Map and you will see the following:

image

Now click the map and modify the Power View fields shown below:

image

For this example, add ProjectCost to the size property, add Project Locations to the Locations property and set the colour property to ProjectName:

image

Increase the size of the map and add a title:

image

You can hover over the data circles and a tooltip will appear with the project details:

image

The data can be refreshed and the map updates.

A quick and simple report to show projects by location.

About these ads

1 Comment »

RSS feed for comments on this post. TrackBack URI

  1. [...] This article has been cross posted from pwmather.wordpress.com (original article) [...]


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com. | The Pool Theme.
Entries and comments feeds.

Follow

Get every new post delivered to your Inbox.

Join 693 other followers

%d bloggers like this: