PowerPivot for SharePoint 2010 - System Setup

Learn how to properly install and configure SharePoint 2010 with PowerPivot
Course info
Rating
(43)
Level
Beginner
Updated
Apr 25, 2011
Duration
1h 7m
Table of contents
Description
Course info
Rating
(43)
Level
Beginner
Updated
Apr 25, 2011
Duration
1h 7m
Description

Learn how to properly install and configure SharePoint 2010 with PowerPivot. This course will guide you through the installation and setup procedures, including installing SparePoint 2010, PowerPivot, SQL Server, and configuring Active Directory, SharePoint, and PowerPivot to begin working with PowerPivot in SharePoint.

About the author
About the author

Robert C. Cain (arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Pluralsight, team member at Linchpin People, and co-author of 4 books.

More from the author
Kusto Query Language (KQL) from Scratch
Beginner
4h 33m
20 Jun 2018
Azure PowerShell Playbook: Azure SQL
Intermediate
1h 4m
18 Jan 2018
More courses by Robert Cain
Section Introduction Transcripts
Section Introduction Transcripts

Setting up a SharePoint / PowerPivot Development Environment
Hi this is Robert Cain and welcome to Setting up a SharePoint/PowerPivot Development Environment. In this series we're going to be looking at the steps involved to set up a complete SharePoint development environment on a Windows Server computer. This environment will include PowerPivot and SQL Server, as well as Visual Studio. In this video, we're going to be looking at setting up and configuring Windows Server 2008R2, then we'll be installing Microsoft Office with the PowerPivot components. Finally, we'll set up SQL Server 2008R2 for doing development on. I want to stress a very, very important thing as part of this video series. Do not set up your production environment using this video. I cannot emphasize this enough. Within this video we'll be making choices that are appropriate to a single server set up. The choices we make are just fine for a single computer development environment; however, it would be disastrous if you tried to use these in production. So I want to say it one more time. Do not set up your production environment using the instructions in this video. Note that this will take some time. We have highly compressed the installation process through careful editing of the video. Fade transitions will be used to indicate long gaps in time, like this. In a few places, simple cuts will be used to compress the time. The point of all this is your install time may vary. Don't take what you see here as any kind of indication on how long your installs will take. Well, speaking of time, it's time we got started.

Setting up a SharePoint / PowerPivot Development Environment
Hi this is Robert Cain. Welcome to module two of setting up a SharePoint/PowerPivot Development Environment. Now if you haven't seen the previous video, you really need to go back and watch it. Otherwise, you're going to be lost because in the previous video, we set up Windows Server 2008R2, then we installed Microsoft Office 2010, and we added on PowerPivot. Finally, we set up SQL Server as a development tool. Now in this video we're going to continue our work, we're going to get SharePoint up and running, then we're going to install the SQL Server components for PowerPivot. Next, we're going to install Visual Studio 2010, making a few special tweaks. Finally, we're going to configure and test PowerPivot so that you can see a PowerPivot actually running on a SharePoint environment. Now, I said this in the last video and I'm going to say it again in case it's been awhile since you saw it. Do not setup your production environment using this video. This video is not intended as a guide for you to setup your production environment. This targeted at the developers who want to setup a single computer or a single virtual machine in which they can do SharePoint, Windows, and PowerPivot development. This video will take some time. We highly compressed the install process through some really clever editing. Some nifty fade transitions, like this, will be used to indicate long gaps in time. In a few places we'll use simple cuts to reduce the time you have to stare at the screen. The point of all this is, your installs are going to take a lot longer than what you're seeing in this video. With that said, let's get started.