Performance Point Services
Over the last few years Microsoft has been releasing a serious of new capabilities in in Business Intelligence offering. SQL Server has always been the central technology around the MSBI offerings and that makes sense. Now the current emphasis is evangelizing the self-service BI trend where we hope to expect that IT personnel are no longer need to build the reports and dashboards and this task is handled by non-IT staff and “Power Users”. Performance Point services is not part of the self-service BI space. It remains an Enterprise BI solution.
In this video, I going to show you how to create a Performance Point dashboard that uses filters to change the report data. This type of Dashboard will highlight some of the most common uses of performance point services. To be able to take advantage of the full capabilities of Performance Point Services, you must use an OLAP cube. Performance Point works with either Microsoft cube technologies – MDX or Tabular.
Creating a Data Source
This is the first process of building any Performance Point Services object. Almost all content requires a data source to connect to. Therefor this must be done first and correctly. In my example I will connect to the Tabular database called Tom’s Diner (restaurant data).
Creating a Report
I will create two reports, both analytical (i.e. connect to OLAP DB) reports. I will use a list view and a graphical view. Both of these reports will connect to the same Tom’s Diner data source.
To allow the reports to be modified by the user preferences, I will create a filter using the Category dimension that will filter the two Analytical reports. You can only apply filters to reports that have been added as part of a dashboard. I will demonstrate this process.
Publishing a Dashboard
This is the final part of the demonstration and the most important. Once publish you can now have users explore the capabilities of Performance Points Services.