Excel team blog – great PowerPivot content

One of my longtime friends, Joe Chirilov, has a great series of posts running on the official Excel Team blog.  Think of it as the 5-minute walkthru of everything, whereas my Football project is going to take its sweet time on every last detail. So if you’re getting impatient with me and want to see everything now, definitely check it out: Introducing PowerPivot Using PowerPivot With Excel 2010 PowerPivot:  The Business User’s Perspective Note that the introduction post is written…

Read the Rest

PowerPivot Data Cleaning: Three Options (with a football angle of course)

In the previous PowerPivot football project post, recall that I’d encountered some dirty data.  Even in the world of sports stats, data quality is a huge problem: Some players have names, others are just numbers.  And we can’t edit/delete these records in-place, for the PowerPivot compression reason I outlined last time.  I mentioned three options to address this problem, so what are they? Option #1a – Pre-filter the data during import (graphically) In my previous post, I used the point-and-click…

Read the Rest

Article on Enterprise BI Mashups

Given the extremely mashup-friendly nature of PowerPivot, I found this article fascinating: http://searchsoa.techtarget.com/news/article/0,289142,sid26_gci1372670,00.html#  Especially liked this part (my emphasis): "Mashups won't succeed in a BI context unless it's fun, unless its highly interactive and the user says 'wow that's totally easy to use let me use that so I can build my reports,'" said Kobielus. "If it's approached where IT is forcing self-service on reluctant users, I think it will fail. It's got to be user enthusiasm that drives this."…

Read the Rest

Better image sizes

I apologize for the poor size of the images in my posts thus far.  I’m still figuring my way around this blogging thing. Changed the theme so that images could be larger inline, and figured out how to upload larger images so that when you click to get a bigger image, it truly is bigger.

Read the Rest

Football: loading the data

No more messing around, let’s dive in.  Rather than boiling the ocean up front, let’s set a modest goal for getting started:  I want to end up with a report that shows passing yards by player.  (PowerPivot lends itself quite well to this approach – no need to build an all-encompassing model up-front like with traditional BI tools.  This is more like…  Excel.) First, I launch Excel 2010 (with the PowerPivot addin installed), and using the PowerPivot ribbon tab, I…

Read the Rest

PowerPivot’s impact on BI pros?

A few of us are having a really interesting discussion on Twitter right now that I thought could use a different forum. “PowerPivot – bad for BI developers and consultants because it removes some need for their services, or good because it opens more doors?” Here are some of the posts, I mean, tweets: VidasM: Preparing key points to talk at #sqlpass FoB lunch.Topic #PowerPivot impact on DW projects.More/less work for us?I welcome any suggestions. andrewbrust: @VidasM I think #PowerPivot…

Read the Rest