PowerBI

PowerPivot 3: Managing the Data Model

PowerPivot 3: Managing the Data Model

Analyzing ginormous files with Microsoft PowerPivot.

How's it going readers? If you've been paying attention and/or have the basic ability to count, you'll notice that this is the third post in a series about using Excel's secret Weapon of Math Destruction: PowerPivot. I highly suggest that if you haven't read the previous two posts, that you go ahead and do that. If you had, you would already:

  1. Have enabled Powerpivot through the COM add-ins.
  2. Know what Powerpivot is.
  3. Understand why powerpivot can make your life as an analyst a great deal easier.
  4. Be ready to power-up some ginormous flat files.

I'm going to assume that

PowerPivot 2: What's the Deal with Delimiters?

PowerPivot 2: What's the Deal with Delimiters?

Working with large flat files in PowerPivot.

Hey there budding Excel wizards, this post picks up RIGHT where my previous post left off, so if you haven't enabled Powerpivot yet, I highly recommend that you read the previous post and enable the add-in before moving forward. Don't worry, we'll wait...

Good to see you again! If you've gotten this far, you've already won half the battle by enabling Powerpivot. To recap, technically PowerPivot is the desktop version of one of the cornerstones of Microsoft's Business Intelligence cloud platform: Power BI. Functionally however, PowerPivot is the answer to dealing with enormous files in a way that they're still

Power to the Pivot Redux: Enter PowerPivot

Power to the Pivot Redux: Enter PowerPivot

Dipping into Microsoft's PowerPivot add-on for Excel.

Well, hello again dear reader, it's been a while. I've been hard at work moving around and summarizing ever expanding datasets using nothing but the wonderful tools offered to me in the Microsoft office suite (and occasionally using SAS Enterprise guide for a very unintended purpose, but that's for a later post...and hopefully, a never post).  I know I promised a post about hardware, and maybe I'll include something about that in my next post. However, there are much more pertinent and useful things at foot, and the truth is, you're probably working on a laptop anyways.

Those of