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

SharePoint Conf 2009: Observations #2 and #3

Continuing my series of 5 Things the ‘Pro Wants You to Know (About the Show)… #2: If it isn’t SharePoint, it isn’t Microsoft BI Another one of those things that’s been creeping up on us with no formal announcement (until the conference, and even then only in a few places).  Every MS team that builds BI tools has, over the past couple of years, decided to embrace SharePoint.  Excel Services was first, then Reporting Services offered it as a mode,…

Read the Rest

Football data source tables

OK, last post for the night.  Turns out there were over 40 tables of data that went into the MSN football cube.  These are the tables I will be importing into PowerPivot. It was pretty difficult finding a way to list them all out in one place, with their column names, so everyone can see.  I eventually settled on a db diagram from SQL Server Mgmt Studio. Filter/Grouping Tables First, here are the tables that contribute to all of those…

Read the Rest