Before we get into the details of creating some SQL Server Reporting Services reports, Power View reports, and Excel Services, we have a few quick steps to get our SharePoint Site ready.
In this chapter, we assume some previous experience with SharePoint and that you are familiar with the concept of SharePoint features.
SharePoint features are bundles of functionality that can be activated by users with appropriate rights enabling a set of capabilities in the product.
In this case, let’s start by ensuring that a few Site Collection scoped features are enabled. Without these features enabled, SharePoint will not have the components to support the business intelligence scenarios we’ll be walking through during this solution. To enable them, navigate from the Site Actions menu to Site Settings to Site Collection features, as shown in Figure 24-1. Enable the following features:
Power View Integration Feature
Power View Integration for Site Collections
Report Server Integration Feature
If these features were already enabled, that’s no problem. Different SharePoint site definitions will start with different features enabled; we just want to confirm that they are enabled in order to complete the following tasks.