Skip to main content
 

PowerPivot Data Refresh in SharePoint

This 4-part video series from Lee Graber provides an introduction to PowerPivot for SharePoint architecture. Part 3 describes the security context for PowerPivot data refresh.

Transcript-PowerPivot for SharePoint Architecture: Part 3

Video Downloads
WMV | WMV (ZIP) | MP4 | PSP

Audio Downloads
AAC | WMA | MP3 | MP4

Length: 10 minutes 05 seconds

 

Using PowerPivot Workbooks as a Data Source

This 4-part video series from Lee Graber provides an introduction to PowerPivot for SharePoint architecture. Part 4 describes the security context for using PowerPivot workbooks as a data source.

Video Downloads
WMV | WMV (ZIP) | MP4 | PSP

Audio Downloads
AAC | WMA | MP3 | MP4

Length: 07 minutes 52 seconds

 

Security Context of PowerPivot Connections in a Farm

This 4-part video series from Lee Graber provides an introduction to PowerPivot for SharePoint architecture. Part 2 builds on part 1 by explaining how user identity is flowed when a user requests PowerPivot data.

Video Downloads
WMV | WMV (ZIP) | MP4 | PSP

Audio Downloads
AAC | WMA | MP3 | MP4

Length: 11 minutes 38 seconds

 

Creating Effective Aggregations - Technical Article

Aggregations are the key to getting the best performance out of your cube. MVP Chris Webb demonstrates the steps he takes to design effective aggregations.

Presented by Chris Webb, SQL Server MVP and Principal Consultant for Crossjoin Consulting. You can view Chris' Analysis Services blog at http://cwebbi.spaces.live.com.

Video Downloads
WMV | WMV (ZIP) | MP4 | PSP

Audio Downloads
AAC | WMA | MP3 | MP4

Length: 41 minutes 52 seconds

 

How Do I: Creating an Analysis Services Project?

This video demonstrates how to create an Analysis Services project, define a data source, and define a data source view. You will also learn how to change the value of the FriendlyName property for objects in the data source view to increase the user-friendliness of their names.

Video Downloads
WMV | WMV (ZIP) | MP4 | PSP

Audio Downloads
AAC | WMA | MP3 | MP4

Length: 04 minutes 53 seconds

 

How Do I: Modifying Measures, Attributes and Hierarchies?

This video demonstrates how to modify the measures, attributes and hierarchies in a cube.

Video Downloads
WMV | WMV (ZIP) | MP4 | PSP

Audio Downloads
AAC | WMA | MP3 | MP4

Length: 13 minutes 16 seconds

 

How Do I: Defining and Deploying a Cube?

This video demonstrates how to define and deploy an OLAP cube using Analysis Services.

Presented by Mary Brennan.

Video Downloads
WMV | WMV (ZIP) | MP4 | PSP

Audio Downloads
AAC | WMA | MP3 | MP4

Length: 08 minutes 08 seconds

 

How Do I: Design High Performance Cubes in SQL Server 2008 Analysis Services?

In this video, Jacques Victor explains how to Design High Performance Cubes in SQL Server 2008 Analysis Services.

The benefit of building a cube to house data is that business rules can be centralized for calculations that can't easily be stored in a relational data mart.

Note: The AdventureWorks Db is used in this video.

The Db can be found here: http://msftdbprodsamples.
codeplex.com/wikipage?title=
Installing%20Databases

Presented by Jacques Victor.

Video Downloads
WMV | WMV (ZIP) | MP4 | PSP

Audio Downloads
AAC | WMA | MP3 | MP4

Length: 33 minutes 31 seconds

 

How Do I: Monitor SQL Server Analysis Services Performance?

In this video, Jacques Victor explains how to monitor SQL Server Analysis Services performance with SQL Server Profiler which can be used as a performance optimization and monitoring tool for Analysis Services.

Presented by Jacques Victor.

Video Downloads
WMV | WMV (ZIP) | MP4 | PSP

Audio Downloads
AAC | WMA | MP3 | MP4

Length: 15 minutes 00 seconds

 

Create and Publish a Data Cube for SQL Server Analysis Server 2008

This video shows how to use Business Intelligence Development Studio (BIDS) to create an data cube for SQL Server Analysis Server 2008This demo shows how to:Use BIDS to create a data model projectCreate Data Sources, Data Views, Dimenions, & CubesDeploy the project to SSAS 2208

Video Downloads
WMV | WMV (ZIP) | MP4 | PSP

Audio Downloads
AAC | WMA | MP3 | MP4

Length: 7 minutes 53 seconds

 

Installing PowerPivot for SharePoint on a Domain Controller - Complete (Parts 1-4)

In this webcast Dave Wickert shows you how to install PowerPivot on a standalone server. Besides the installation itself, he also demonstrates how to add the domain controller role to the server and get everything installed and running. This webcast can also be viewed as 4 separate videos.

Video Downloads
WMV | WMV (ZIP) | MP4 | PSP

Audio Downloads
AAC | WMA | MP3 | MP4

Length: 29 minutes 45 seconds

 

Part 4: Installing PowerPivot for SharePoint on a Domain Controller

Dave Wickert shows you how to install PowerPivot for SharePoint. This video is part 4 of "Installing PowerPivot for SharePoint on a Domain Controller."

Video Downloads
WMV | WMV (ZIP) | MP4 | PSP

Audio Downloads
AAC | WMA | MP3 | MP4

Length: 11 minutes 29 seconds

 

Part 3: Installing PowerPivot for SharePoint on a Domain Controller

Dave Wickert shows you how to install SharePoint. This video is part 3 of "Installing PowerPivot for SharePoint on a Domain Controller."

Video Downloads
WMV | WMV (ZIP) | MP4 | PSP

Audio Downloads
AAC | WMA | MP3 | MP4

Length: 8 minutes 22 seconds

 

Part 2: Installing PowerPivot for SharePoint on a Domain Controller

Dave Wickert shows you how to add user accounts to your domain controller. This video is part 2 of "Installing PowerPivot for SharePoint on a Domain Controller."

Video Downloads
WMV | WMV (ZIP) | MP4 | PSP

Audio Downloads
AAC | WMA | MP3 | MP4

Length: 4 minutes 22 seconds

 

Part 1: Installing PowerPivot for SharePoint on a Domain Controller

Dave Wickert shows you how to install a domain controller. This video is part 1 of "Installing PowerPivot for SharePoint on a Domain Controller."

Video Downloads
WMV | WMV (ZIP) | MP4 | PSP

Audio Downloads
AAC | WMA | MP3 | MP4

Length: 5 minutes 51 seconds

 

SharePoint User Identify Fundamentals for PowerPivot Server Administrators

This 4-part video series provides an introduction to PowerPivot for SharePoint architecture. Part 1 explains how user identity is flowed throughout the SharePoint system.

Video Downloads
WMV | WMV (ZIP) | MP4 | PSP

Audio Downloads
AAC | WMA | MP3 | MP4

Length: 13 minutes 43 seconds