Hi folks, just a quick note: we are moving the dates for our Indy class to December 15 and 16, 2015. (Originally scheduled for Oct 13 and 14). Washington DC remains scheduled for Nov 3-4. Register for Washington DC Register…
All I Did Was Import my Excel 2016 Power Pivot Workbook (Then Create the Chart) Just Checking… In last week’s post, I emphasized that I was using a new DAX function, PRODUCTX, that doesn’t appear in Power Pivot 2010 or…
But in a Good Way… The Microsoft Power BI team just purchased the ad slot on the last page of our DAX 2nd Edition book. First of all, thank you thank you thank you, Power BI team! This is SUPER…
Post by Rob Collie http://polldaddy.com/poll/9082405/
By Matt Allington One of the many things I love about Power Pivot and Power Query is that these tools have put BI into the hands of users and there is no longer a reliance on highly technical IT skills such…
Post by Rob Collie
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.
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:
Biz #3: Introducing the Newsletter
Post by Rob Collie Solid Analyst / Data Modeler / Dashboard Dev Available Immediately A few months ago, I convinced one of my younger friends to take a big risk. Proficient in DAX and M, the heart and soul of…
Post by Rob Collie No, We’re Not Opening a Store… Not any time soon anyway. if we do any “merch” stuff near-term, it would be as SPECIAL GIFTS. But we’d want such stuff to be, ya, know, desirable just the…
Post by Rob Collie
A 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:
- Throwing out untrustworthy outlier results
- Cross-referencing with CPU benchmark sites
- Finding computer models that contain those CPU’s
- Verifying that those models have good RAM
- Pulling together a view different price points
- 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:
Post by Rob Collie
Assortment of Quick and Fun Topics
I keep something called Ye Olde OneNote List of Future Blog Topics. You know, I think of something and go “ooh, that would be a good thing to write about,” so I add it to YOOLOFBT.
Problem is, said list sometimes grows a lot faster than the rate at which I produce finished blog posts. So… good topics just get buried sometimes.
Today, let’s make sure a few of those topics get to see the light of day. Like children who’ve been cooped up in the house all winter, they need to go outside and play in the yard.
#1: DataZen Post “Wins”
Last week’s post on Datazen positively shocked me with the number of page views it got. It set the all-time record for single-day views of a given post, AND that traffic also led to the single best day for overall PowerPivotPro.com traffic. (A rising Datazen topic lifts all posts. Something like that.)
And it wasn’t close, either. Both new records eclipsed the former records by healthy margins.
The take-away, I think, is that mobile visuals SELL. This excerpt from last week sums it up nicely:
So if you’re trying to increase Power Pivot buy-in at your company, Datazen is worth a look. It’s a gateway drug.