Facelift!

Facelift!

Well folks it’s been nearly six years since we launched PowerPivotPro.com, and we were long overdue for an update. The idea here is to give you the same information as always, but in a visually-clearer and more modern format. Expect…

Read the Rest

Some “Biz,” Then Reflection on Connection

Post by Rob Collie

image

Some Obligatory “Biz” Stuff Today, Then Something “Deeper”

I find myself “stuck” in a thoughtful, somewhat unproductive mood these days.  I think I’ve figured out why, and I think it’s worth sharing.  But first let me get some “biz” stuff out of the way, because that stuff is important too.

Biz #1: Power Pivot / Power BI In-Person Classes:  Dates in DC and Indy.

Power Pivot / Power BI Class Power Pivot / Power BI Class

Today we’re announcing class dates in Indianapolis (Oct 13-14) and Washington DC (Nov 3-4).

Hope to see you there, and at the social gathering on Evening #1 – more on that in “connection.”

Biz #2: DAX 2nd Edition Pre-Order / Fund Color Printing / Cool Perks


Our pre-order campaign is going great, thanks everyone!  We’ve exceeded the original $3k goal already, which we originally set to help us offset the startup costs of printing in color, and because we didn’t dare to expect the response we’re getting.  The full costs of a large color print run, however, are quite a bit higher, and if we hit our stretch goal of $20k, that would cover the entire first print run, so if possible we’d like to “reach” a bit.

And you get something in return, too:  “early-bird” delivery of your printed book, anywhere in the world, long before Amazon will start shipping them.

Plus the cool perks, like the exclusive DAX stickers, posters, and t-shirts:

image

Biz #3: Introducing the Newsletter

Read the Rest

Some Good Power Pivot / Power BI Computers

Post by Rob Collie

Good Computers for Power Pivot / Power BIA Lot More Work Than Expected!

Last month I posted a survey of computer performance for Power Pivot and Power BI usage.  I underestimated how much work it would be, to synthesize the results into something useful for the community.  At bare minimum, this has been five different tasks:

  1. Throwing out untrustworthy outlier results
  2. Cross-referencing with CPU benchmark sites
  3. Finding computer models that contain those CPU’s
  4. Verifying that those models have good RAM
  5. Pulling together a view different price points
  6. Repeating for Desktop vs. Laptop

So for now, I’ve only managed to pull together options from HP.
(I will add other manufacturers later, but I have always liked HP hardware, especially their laptops, so it’s a great place to start).

Desktops – High End Options

If you want a true beast of a computer that chews through DAX workloads, you might consider something like THIS monster:

 The Z840 Workstation is an Obvious Candidate.
(But the Next One Below is Better AND Cheaper.)

16GB of RAM is more than enough for Power Pivot and Power BI workloads.  Seriously, 8 GB is gonna be enough for most of your needs until/unless you start transitioning into SSAS Tabular because you have too much data for Power Pivot.

Note that this workstation above offers much faster RAM than most other machines, at 2133 GHz.

But it also carries the ultra-premium Xeon E5 2620 v3 CPU – which the test results and benchmarks indicate is a LESS effective processor (for our purposes) than many lesser models of Xeon, such as the E3 family.

So, for $1300 less, you could have the following workstation, which in all likelihood performs even BETTER for our needs:

Read the Rest