“Are we there yet? Are we there yet? Are we there yet?”
Consider this a “Mailbag” Post
Hey, sportswriters do this all the time. They take emails out of their inbox and turn that into a full article. That’s not super appropriate for a blog like this, but I *am* getting three questions repeatedly:
When is the Excel User Group starting up in my city?
Is there a “webcast” option for watching the presentations in Cleveland and Atlanta?
When is your new book, Power Pivot Alchemy being released?
“There are two kinds of people in this world, my friend: Those who learn by reading, and those who learn by seeing.”
My personal mission in life is to help Excel Pros to enjoy more meaningful and rewarding careers – both for themselves and for the organizations that employ them. That may sound cheesy but it’s the absolute truth. I even left my CTO job at my last company so that I could pursue this full time, without distraction.
There are many components to that mission, but it all starts with education. It is the foundation for everything that follows.
But I’ve learned that not everyone can pick up a book to learn new things. Many people (myself included, actually) have to be shown things instead.
So what about the “Show Me” People?
Are you more of a “show me” person than a “read a book” person? If so, until now, the only thing I’ve been able to offer you is onsite or remote training. Those are both great, but I can only train one group at a time, and the price is too high for some organizations.
I’ve long wanted to provide a visual, dynamic class, with hands-on “follow along” materials, that can reach a much broader audience. And now that is finally happening.
PowerPivot Course, Taught by Yours Truly, Delivered at Chandoo.org!
I’m thrilled to announce that my PowerPivot video course launches August 1st!
Last week I mentioned that I was going to rename the book now that the first print run is about to finish selling out. The title was a mistake on my part – it sounds dry and techie, and the reviews all say otherwise. A few people even called it a “page turner” and specifically mentioned that the title made them expect something much drier.
After thinking about it some more, I don’t think completely changing the title is a good idea. I don’t want people who already have the book to get confused and buy it again – that would feel pretty sleazy.
But I WILL change the subtitle.
Help me pick a new one before it goes to the printer . You can pick up to three, and/or write in another suggestion. Thanks folks!
There Are More than 18 Copies Left at the Warehouse. But Not THAT Many More
When I was down at MrExcel HQ With Chandoo this weekend, Bill and I decided to check how many copies of the book were left in inventory at the distributor.
We printed 3,000 copies back in November. The distributor only had about 350 left at the warehouse as of Friday.
Neither of us expected the inventory to be that low. You see, book sales data isn’t exactly a timely business – Bill and I just got paid in April for the books that sold in November. And while Nielsen does provide a window into how many books sold this past week, they only capture part of the market. The proportion out there “in the shadows” is unknown, and it’s significant.
So much like what we see in the night sky is light that left distant stars many years ago, our only reliable sales data lags reality by 4-5 months.
Good News Bad News
Hey good news – the book has been selling even better than we knew! Bill tells me that most books never sell their entire first print run, so to be running out so quickly is a very good sign.
Hey bad news – we gotta scramble to print a second run before the supply runs out
Got a lot of great feedback in response to Friday’s survey – thanks for that. Also, I really enjoyed some of the suggestions people took the time to write in – see the bottom of this post for some of the funnier ones
Based on that last survey, I removed titles that got no love and added a few based on feedback. So if you have a moment, please fill this one in real quick and hit Submit:
Your Funny Write-In Suggestions!
OK, here’s a selection of some of the more creative suggestions. Give you folks an “Other” option in an anonymous survey, and the results are interesting to say the least:
50 Shades of PowerPivot PowerPivot: The Queen’s Gambit Dear God Not Another Book (note from Rob: I sympathize with this one) PowerPivot 221 Baker Street (Sherlock Holmes’ address) Dax the way I like it (uh huh, uh huh. Probably my favorite)
Given the response so far to my first book, I decided to commit to a “sequel” for release in 2013.
The existing book is all about the fundamentals – how to “think in DAX,” primarily, which is obviously the best place to start. This new book is going to collect all of the best specific tricks and techniques from my 3+ years of blogging and hands-on PowerPivot usage.
If this were chess, the first book teaches you the rules, and this new companion book will teach very specific patterns and tactics. Continuing the chess metaphor, you’d learn Queen’s Gambit in this book
Back in the PowerPivot world, this book will cover things like: sorting by slicers, same-store-sales, correcting for seasonality, readout formulas, a bunch of different cube formula tricks, etc…
And even better: since I don’t have time to write another book on my own, Bill Jelen, MrExcel himself, will be co-authoring this one with me!
Question is, what should we name it? I learned, the hard way, that name counts a lot. I’d rename my first book, in hindsight, if I could – the use of the words “formulas” and “pro” make it sound a lot drier and more intimidating than it is.
So before Bill and I commit to a name, would you mind telling us which one of these sounds the most inviting to you?
Bill and I are working hard to get you the PowerPivot skillz, one way or another. 45% comfort level with ALL() tells me I have much work yet to do. But I promise you will make that transition and become ALL()-knowing between pages 69 and 75
Challenge for 24×7 Subscribers: Flip through the book today online and find something you didn’t already know. Let me know what your favorite nugget is. I’m rob. At a place called PowerPivotPro. Dot com.