Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Koen Verbeeck

Koen Verbeeck is a Microsoft Business Intelligence consultant at element61, helping clients to get insight in their data. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. He's also a speaker at various conferences.

Archives: June 2013

SQL 2014 CTP1, where is my BIDS?

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…

Read more

10 comments, 979 reads

Posted in Koen Verbeeck on 28 June 2013

Building a SharePoint 2013 BI Demo Environment Part 10 – Creating a BI site

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

9 comments, 1,449 reads

Posted in Koen Verbeeck on 12 June 2013

Building a SharePoint 2013 BI Demo Environment Part 9 – Installing Reporting Services

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

1 comments, 2,663 reads

Posted in Koen Verbeeck on 11 June 2013

Building a SharePoint 2013 BI Demo Environment Part 8 – Verifying PowerPivot Integration

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

1 comments, 1,510 reads

Posted in Koen Verbeeck on 10 June 2013

Building a SharePoint 2013 BI Demo Environment Part 7 – Configuring SharePoint

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

0 comments, 425 reads

Posted in Koen Verbeeck on 7 June 2013

Building a SharePoint 2013 BI Demo Environment Part 6 – Installing PowerPivot for SharePoint

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

2 comments, 1,603 reads

Posted in Koen Verbeeck on 6 June 2013

Building a SharePoint 2013 BI Demo Environment Part 5 – Installing SharePoint

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

0 comments, 1,401 reads

Posted in Koen Verbeeck on 5 June 2013

Building a SharePoint 2013 BI Demo Environment Part 3 – Installing the OS

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

0 comments, 370 reads

Posted in Koen Verbeeck on 3 June 2013