In my previous PowerPivot post i created a SSRS report based on a published PowerPivot app with DAX measures. In this post we are going to create a PerformancePoint 2010 dashboard based on the published PowerPivot App and publish it to SharePoint. First you need to enable PerformancePoint in SharePoint 2010, to do this the PerformancePoint team has created an excellent blog post: Deploying PerformancePoint 2010 Soup to Nuts
Ok we start at the PerformancePoint site:
And click start using PerformancePoint Services:
Click the Run dashboard designer button to start the o so familiar dashboard designer (same as 2007). we start by adding a Datasource which points to our PowerPivot xlsx:
I selected the “Per user identity” because i haven’t got my installation really ok (the unattended service account is not installed). Next we can create a scorecard, right mouse on PerformancePoint content, new, Scorecard
Select analysis services and click OK, select the datasource we just created:
We need to create the KPI ourselves, so we select the measures created in PowerPivot, I want to see the the totals sales last month measured against the avg last year, we select the band method “increasing is better”, because more ordeer are better 🙂
We select the year we want our KPI shown against
The next steps we keep the default values, click finish to create and load the dashboard:
Now we want to show the sales kpi by Promotioncategory, you can drag the dimension you want into the scorecard. Don’t forget to click update to show the new result.
I rather like other indicators than the default, so go to the KPI, click scoring and patterns and doubleclick the indicator to select a new indicator, I like the indicator below:
save the indicator, go to the scorecard and update again:
Next i wanted to get a graph to show the orderquantity by year, create a new report and select graph. Put the measure in series and calendaryear on the bottom axis.
Last we create the dashboard to show the data, i created a 2 column dashboard with a top bar. I dragged the scorecard to the right column and the chart report in the left column. You can add a date selection in the top bar when want, or even the new time intelligent filter. I did not add one this time.
Next we save and deploy the dashboard to SharePoint:
It will automaticly open the dashboard in SharePoint, looks great in my opinion:
As last item I wanted to show you one neat thing: the new silverlight decomposition tree. Right click on a bar in the chart and click decomposition. I clicked on the 2007 bar.
When you click the value you can expand the value to a dimension and so on:
Using PerformancePoint on a PowerPivot App is another great way to show the data to you customers, the creation of dashboards are doable for the analysts.