Seriously, this has been the best 3 days of my life. Well except for my wedding day of course (sorry honey). There were many great sessions at the PASS BA Conference – about half of them I attended I would classify as “invaluable”. And there were many other sessions I couldn’t attend due to timing clashes, but then again I have purchased the video pack so I will get to see those in the next few weeks. But probably the best thing of all from this conference was the networking and face to face contact with 600 Excel super dudes that think just like me :-). That was seriously awesome. And then finally there was this T-Shirt – I would have come all this way just to get that!
Day 2 Conference Highlights
My day started with a Microsoft Excel Breakfast with the Excel Development team. Dany Hoter shared some of the great new features that are coming to Excel. The things I liked most (in addition to the T-Shirt) are:
- The new visualisations (particularly the Tree Map) look great.
- Power Query will be fully integrated into the data ribbon, and importantly the UNDO button will work for Power Query, so you will be able to recover that accidental deletion.
- You will be able to use VBA to create calculated fields in Power Pivot – sweet!
- They have fixed the “undocumented feature” where by the Pivot Table will “drop” your calculated field out of the Pivot Table if you rename it.
- There is a new forecasting wizard an functions called “Forecast Sheet”. Dany warned to be careful when you say that phrase 🙂
- And there is improved drilling in Pivot Charts
The Keynote by Miko Yuk was very interesting. We could all benefit from drawing more pictures when we communicate – let me work on that! This was also the first time I heard that 80% of all BI projects fail. It is no wonder Power Pivot is such a compelling tool to lower risk and speed up delivery of actually BI solutions that people actually want to use.
Chris Webb – Power Query
It was really great to go to Chris Webb’s session on Power Query. I am a fan of Chris’s blog and content that he shares in various locations including SQLBits. Chris really opened my eyes to techniques on how to use Power Query in a more robust way by adding fail safe error checking into the code. I will definitely be applying these concepts in my work moving forward.
Kasper – Power BI Designer
Kasper’s session on Power BI Designer was great. I can’t wait for this product to continue to develop into the main stream. And the new intellisense features for writing DAX including commenting, formula formatting, auto completion of missing brackets and being able to use the TAB key are all long over due. Kasper, please just make sure these features make it into the Excel version of Power Pivot too.
And of course there was the socalising at the bar afterwards – where the real value is created. You can see me here rubbing shoulders (and hoping something will rub off) with some REAL Excel Gurus (Chandoo, Rob Collie, Scott Senkeresty and Ken Puls).
And then there was Power Planner
Finally I had a private meeting with the team from Power ON. They are the guys that developed Power Update, and now have another tool called Power Planner. I already love Power Update, so I was super excited to get a demo of the Power Planner software as I had only heard a small amount about it but I had never seen it in action. You really have to see this software to believe it. You can take your last year’s sales in your Power Pivot workbook, copy the numbers with a couple of clicks and call it “Budget”, and then manually or semi-automagically change the budget numbers directly in the pivot table, and write them back to a SQL database at the leaf level. You can do remarkable things like:
- add 3% to a group of products
- goal seek the sales numbers across selected products to hit a specified profit target
- apportion an incremental $ value target across a group of products based on their relative importance
- Did i mention you can change the numbers directly in the pivot table and write them back to a SQL database?!
Just think about what you do every year when you build your budgets (or track your forecast) – this tool will do it for you in a snap. If this tool can’t save you 3 week’s effort each year, I’ll go he for chasey. Send me an email if you would like to know more and I will give you a demo. I am pleased to be officially working with Power ON as a partner for Australia and I will be building some local content on the topic shortly. In the mean time, you can get more information from the Power Planner Website.
Well just 22 hours of travel ahead of me now – leave San Jose at 12 noon Thursday and arrive home 7am Saturday. That’s something to look forward to 🙁