|
| 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 Audio Downloads 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 Audio Downloads 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 Audio Downloads 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 Audio Downloads 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 Audio Downloads 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 Audio Downloads 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 Audio Downloads 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. Presented by Jacques Victor. Video Downloads Audio Downloads 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 Audio Downloads 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 Audio Downloads 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 Audio Downloads 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 Audio Downloads 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 Audio Downloads 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 Audio Downloads 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 Audio Downloads 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 Audio Downloads Length: 13 minutes 43 seconds |