Fazlul's Information and Communication Technology Blog

PowerPivot is a Business Intelligence reporting feature of SharePoint. PowerPivot helps analyze the data in more efficient way. It is highly interactive and user self-service reporting tool. Using PowerPivot we can analyze data from SQL Server Analysis services or any other OLAP data mart. Now let us see how we can configure the PowerPivot for SharePoint. To install and configure PowerPivot, we will need the following things hands:   1.        SharePoint Service account for PowerPivot and Excel Services. If we use the same service account, the whole process will be easy. 2.        SQL Server 2008 R2 Enterprise Edition Installer Installation of PowerPivot:   To start with the installation, the first thing we have to do is to create a configuration file like this:   1.        Create a text file in notepad and paste the following paragraph into there: <?xml version="1.0" encoding="utf-8" ?> <configuration>            ...

PerformancePoint is a Business Intelligence reporting feature of SharePoint. To start working with PerformancePoint, we have to configure it correctly and make sure that all the required services are started and correctly configured. Let us see which services are needed for PerformancePoint. Services:   1.        PerformancePoint Service 2.        Secure Store Service To View and Enable the services, we have to go to SharePoint Administration -> Application management -> Service Applications (Manage services on server) Now, let me guide you through the configuration process of the above mentioned services. To do that, we have to go to Application management -> Service Applications (Manage service applications) Then, find out is the service applications are created or not. If not created then create the service applications by selecting "PerformancePoint Service Application" o...