Archives: June 2013
Oh wait sorry, I meant SSDT. Or was it SSDTBI? To avoid confusion about the developer tool to create BI solutions, Microsoft has changed its name a few times. You know, to make it less confusing. Here’s a nice overview:
- BIDS or Business Intelligence Development Studio. The most non-confusing name…
In the final part of this series, we will create a BI subsite in our site collection. You can use this site as the starting point for your SharePoint BI demos. Browse to the PowerPivot site we created earlier in part 7 and go to Site Contents. Click on… Read more
Finally we are getting to the really sweet stuff: Power View. But first we have to install Reporting Services in SharePoint integrated mode. The steps we are going to follow are described in the following MSDN document: Install Reporting Services SharePoint Mode for SharePoint 2013.
Attach the SQL Server… Read more
After configuring SharePoint in the part 7, we will now verify if the configuration was successful and if everything works correctly. The verification process is described in the following MSDN article: Verify a PowerPivot for SharePoint Installation. First of all let’s start by verifying the site level integration.… Read more
In this blog post we go over one of the most important parts of the series: running the PowerPivot Configuration Wizard in order to configure our SharePoint installation. If you followed the previous walkthroughs, you can find the wizard in the start menu. It is not necessary to run the… Read more
Before we can configure SharePoint, we will have to install the Analysis Service instance that will host the PowerPivot workbooks used in SharePoint, also known as “the PowerPivot instance”.
The first step is to create a service account for this instance. I named it SP2013BI\SPPowerPivot.
The next step is attaching… Read more
Let’s get started with the next step in the series: installing SharePoint. We will install only the software, but we do not configure it. We will do this later with the PowerPivot Configuration Tool, which is explained in another blog post.
The first step is to create a farm account.… Read more
This part of the series will focus on installing the Windows Server 2012 OS on the virtual machine. In most cases, you have an image file with the installation media available. In the VM settings, go to the DVD drive and attach the image.
Now start the VM.
While the… Read more