Navigating the sea of data One of the many things which amazes me about Power Pivot time after time is its ability to effortlessly convert raw data into crucial information as soon as it happens. For example, receivables not being paid…
What do you get when you combine Power Query with Amazon Web Services? You get a powerful new data source for your business needs and open a world of analytics possibilities. I’ll have some of that! I am certainly not…
Not long after I started my career in FP&A, I became interested in KPI development. It’s a natural progression I think: you get the budgeting, forecasting, and reporting under control, and then you begin to dig a little deeper. When…
Post by Rob Collie
Seriously, I Want to Hug the Computer and Every Software Engineer in Redmond
Tales from the Preview
I’m traditionally very slow to look at interim releases of software, but the Office 2016 public preview is out. Everything listed below is now also available to you to look at as well.
Just go grab the preview and slap it on a “spare” computer.
***UPDATE Oct 2015: The preview period is now closed, but this post will help you find a version of Office 2016 that includes Power Pivot.
Rundown of Improvements
The next release of Excel (2016) brings MAJOR improvements to our world. Unlike 2013, which offered us little noticeable benefit over 2010 Power Pivot, I can’t wait for 2016 to become mainstream. It’s a monstrous win.
Each of these improvements warrants its own in-depth blog post, but for now, let’s just run through the list of things that catch my eye…
Measure Icons and Search in the Field List!
We Had Both of these in 2010. 2013 Took Them Away. 2016 Puts them Back
A bit cosmetic perhaps, but if you never used 2010 Power Pivot, you have NO IDEA how useful these are. We welcome them back to our world with open arms.
Even Better: Right Click and Edit Measures in Field List!
So what is Power Pivot? I think a lot of people arriving at this site for the first time already know quite a bit about what Power Pivot is, but a few people have expressed curiosity: it would be easier…