Even though PowerView is the only Microsoft Data Visualization tool that is new on that list, it appears that there is some confusion as to how these four options compare with each other. The topic is pretty big, so it will probably take me a few tries to get it done right, but here is the first shot at the comparison.
There are several angles one might take as he/she tries to compare these four technologies. I am going to examine the following:
- End user experience (high tech vs. low tech)
- Flexibility (in the broadest sense of the word)
How technical does a user need to be to build data visualizations? There seems to be two distinct audiences that Microsoft is targeting here. The first one is technical (IT developers). This audience is most likely to gravitate towards Reporting Services as its tool of choice. SSRS is fairly simple to use provided the developer has a decent knowledge of SQL or MDX. Developers would create data connections and data sets and then wire them up to various report components. This process is highly technical in nature which means it will be completely unacceptable for a business power user. Microsoft also offers its ReportBuilder tools that simplifies a lot of technical aspects for a report developer and allows developers to break up reports into individual report parts which then can be subsequently reused to create new reports, but I would still argue that by and large these sets of activities are well outside of the self-service realm.
Excel Services on the other hand is a very power user-friendly technology. Those familiar with Excel and PivotTables should take very little time to be able to build very sophisticated reports. SharePoint 2010 renders Excel reports and dashboards as web pages which makes this technology very easy to deploy. The IT audience generally does not take Excel Services seriously, which is very unfortunate particularly after the Excel team has added a number of CUBEXXX() functions that allow users very granular access to the data and report layout.
PerformancePoint sits somewhere in between. Microsoft has made some claims that this technology is focused on a power user. Judging from my personal experience, I would say that in principle I could see power users build their content using the tool. In reality, however, it does not seem to happen that often, particularly after PerformancePoint services became an integral part of SharePoint. Although I could see a power user build some PPS reports, putting together and configuring dashboards (and linking together filters, scorecards and reports) is too technical and will not be appropriate for a power user.
PowerView is the ultimate self-service BI tool, suitable to both power and not so power users. Only very basic training to necessary to jump-start the development and the deployment of final visualizations is as simple as saving documents to SharePoint.
End user experience
I would say that there are two trends here. First is a highly interactive experience that is enabled by PerfrormancePoint content. Right clicking on a PerformancePoint report gives user a plethora of options (funny fact, plethora sometimes means “too many”, you can read whatever you want into it if you want). A users who is willing to learn the product and the available data set will be rewarded with incredibly powerful options for analysis such as changing dimensionality and measures on the fly and ability to drill up and slice and dice. Those users who are not willing to learn will be left dazed and confused and are probably going to be frustrated by having too many options.
These right-click haters will be much more comfortable with visualizations developed in Reporting Services or Excel Services. Although the two are wildly different from the development perspective, in terms of the final content they are fairly similar. Both allow sophisticated filtering (with Excel Services getting a nod for the new filtering feature -Slicers) but overall, the interactivity is fairly limited.
PowerView adds an interesting angle to this. On one hand, PowerView charts are not drillable (much like Excel or Reporting Services) on the other hand, PowerView introduces a revolutionary way to filter content by clicking on the desired report element which in turn filters the rest of the visualization components on the selected element. I find this feature to be extremely powerful, particularly for Low-Tech users.
This section of the review is really about the strengths and tradeoffs between the aforementioned four technologies:
- SSRS is particularly robust around report distribution options and is probably easiest to scale for a large deployment. It has become comoditized in terms of the skill set
- Excel Services is a remarkably good choice for a Self Service BI scenarios. The ease of development and the flexibility of the UI options are great. The greatest drawback is inability to interact with charts and graphs on the Excel Services rendered web page. Also, if you are trying to delight the end-user with you data visualization, it can be a challenge as the final product at the end still looks very much like Excel
- PerformancePoint is a great fit for a shop that is trying to integrate structured and unstructured content for a seemless experience. The only real drawback (other than requiring some user training for end users) is the fact that this technology does not seem like it has gotten much love from Microsoft. Although Microsoft has been very vocal about stressing the strategic importance of PerformancePoint on is BI stack, one can clearly see that PPS has not changed my in five years. Also there is a very limited ability to customize the look and feel of the reports and dashboards which is very unfortunate.
- PowerView is a great product. Takes little time to learn and interact, and the visualizations look great. There are, unfortunately, a couple of areas of concern:
- SilverLight – does not run on anything other than Windows
- Poor SharePoint integration. PowerView is meant to occupy the entire page which makes it impossible to expose PowerView content along side with other web part in a SharePoint page.
2 thoughts on “Choosing between PerformancePoint, PowerView, Excel Services and Reporting Services for your data visualizations”
thanks for this vivid info, heres some good reasons why excel is one of the best platforms for reporting: http://www.excelreports.info/ms-excel-a-fantastic-tool-for-report-design/
PerformancePoint, from our testing, seems like a forgotten product. There is little content in the help screens, integration with SharePoint isn’t very great, and the designer tool seems like old techology.