For your PowerPivot Best Practices, Lessons Learned, and random thoughts!
May 23, 2010 by dennyglee | Edit
As you may have noted in my original posting Delegation, Claims, Active Directory…Oh My!…Aw Crap!, it quickly described how to solve issues surrounding the delegation of the claims token within an Active Directory environment. In it I referenced Lee Graber’s excellent posting: The data connection uses Windows Authentication and user credentials could not be delegated.
PowerPivotGeek has been doing a lot of GREAT posts the last week and its getting harder and harder to keep up with greatness! Saying this, here are some great tips, how-to, and A Peek Inside!
Enjoy!
I had a great question from a customer concerning something weird happening with PowerPivot relationships. In this example, we have two tables such as city and state. With the City-State mapping table, it is apparent that the cities of Boston, Quincy, Norwood belong to MA while Seattle and Redmond belong to WA. Even though the relationship makes sense (as per below)
the output doesn’t!
As per many blog postings, press releases, tweets, messages, and streams – PowerPivot went RTM on the 5/12. So what can or should we do now? Here’s some quick great blog postings to get yourself up and running on PowerPivot ASAP:
Enjoy!!
(preliminary pre-release)
Copyright © 2010, Microsoft Corporation, All rights reserved.
Primary Author: Ankur Goyal, SQL-Analysis Services
Technical Reviewer: John Hancock, Dave Wickert, Lee Graber, and Artur Pop
Abstract
The purpose of PowerPivot for SharePoint is to allow users to share their PowerPivot workbooks in a secure and scalable environment. This whitepaper focuses on the features that SQL Server 2008 R2 provides to help IT users to manage and understand the self-service BI activity. This whitepaper also describes key features of the PowerPivot Management Dashboard that we provide with PowerPivot for SharePoint. The PowerPivot Management Dashboard is built using PowerPivot, SharePoint web part pages and Excel Services technologies. This white paper describes how IT users can extend the capabilities of the management dashboard by creating their own custom reports and dashboard.
For a listing of PowerPivotGeek’s PowerPivot sessions at TechEd North America 2010 (also known as the BI Conference 2010), check out:
TechEd NorthAmerica 2010 Sessions.
One thing that is missing from this list is also the joint session between Rob Collie (@PowerPivotPro) and Dave Wickert whom will do a PowerPivot power chalk talk. If you’re in New Orleans for the BI Conf / TechEd NA and into PowerPivot – these are your sessions!
Because PowerPivot for Excel and PowerPivot for SharePoint involve many components from SQL Server 2008 R2 Analysis Services, Office 2010, and SharePoint 2010, this poster contains all of the key components that make up PowerPivot in one view. This view includes nearly all of the logical architecture components and illustrates how these componets work together.
Included in this diagram are the components for:
For more information, please go to the reference sqlcat.com site: PowerPivot Technical Diagram: PowerPivot Client/Server Architecture
Great video by John Hancock on PowerPivot and data feeds
By powerpivotgeek (dwickert@microsoft.com), on April 27th, 2010
Question: By default PowerPivot has two limitations when working with text files (using the Office ACE OLE DB provider): (1) will only import data from files with an extension of .txt, .tab, and .csv; and (2) it will only recognize tab, comma, semicolon, space, colon, and vertical bar and column delimiters. Is there a way to change PowerPivot’s configuration so that it will recognize other file extensions or column delimiters?
By powerpivotgeek (dwickert@hotmail.com), on April 27th, 2010
Recently we have been seeing some users complain about how the PowerPivot Excel client add-in deals with queries. There are three limitations that you need deal with when working with SQL (TSQL, PL/SQL, or whatever) and stored procedures:
Continue reading Querying data within the PowerPivot Excel client add-in
