Trusting the data…

November 4, 2009

…sometimes is easier in the business world than elsewhere.  I loved this short article:

http://sethgodin.typepad.com/seths_blog/2009/11/when-data-and-decisions-collide.html 

Couple excerpts:

The data shows, for example, that texting while driving is more dangerous than driving drunk. It doesn’t feel that way, of course, but will you respect the data and stop, cold turkey?

The data shows that the vast majority of wine drinkers can’t tell the difference between a $20 bottle and a $100 bottle. Will that keep you from buying the fancy wine? How much is the placebo effect worth?

Leave a Comment » | Observations, Trends, and Wild Speculation | Permalink
Posted by powerpivotpro

Hiding fields from the field list in CTP3

November 4, 2009

Colin posted a good comment regarding my last football post:  not all columns/tables from the PowerPivot window are needed in the Field List, and it would be better if we could hide them.

Turns out that there IS such a dialog in CTP3 (I’m told it was also in CTP2, I just never used it):

   PowerPivot Hide Fields Dialog

This is showing me all fields from the DimLeadingVsTrailing table, and lets me hide fields – both from the PowerPivot window, and from the Pivot Field List.

OK, so I marked 3 of those 4 fields to be hidden from the Field List.  I also marked ALL of the fields from the DimHomeAway table, and here is what the Field List shows me now for those tables:

   PowerPivot Hidden Fields in Field List

OK, I only see Description from the one table, as expected.  Nice :)  And the DimHomeAway table is no longer expandable, because all of its fields are hidden.

One could argue, of course, that maybe DimHomeAway should not show up at all.  In fact, I’m gonna go make that argument right now :)

(Update:  we are trying to fix that before we release final bits.  Cross your fingers.)

Next Football Post

2 Comments | Quick Tips & Tricks, The Great Football Project | Tagged: | Permalink
Posted by powerpivotpro