What Versions Of Office 2016 Contain Power Pivot?

What Versions of Office 2016 Contain Power Pivot?

Long Overdue Post! You Want This, But What Versions Have It? Awhile back, I posted about all of the cool improvements in Power Pivot 2016 as compared to 2013.  This followup helps you decide what version of Office 2016 to purchase. Versions of Office 365 that DO Contain Power Pivot Power Pivot *IS* included in the following three Office 365 Plans: Office 365 ProPlus Office 365 E3 Office 365 E4 Good News:  It’s Also Back in Pro Retail! For those…

Read the Rest
Giving Back: “Steal” This Reference Card!

Giving Back: “Steal” this Reference Card!

A long time coming… The Finalized 8-Page “Reference Card V2” – Download it for Free Below Yes, this took me forever.  I first posted about it more than six months ago.  It took a lot of effort, for sure, but that effort ALSO got interrupted five thousand times by, you know, other work.  And life.  All that jazz. But I am SUPER pleased with the result!  I hope you are, too.  It’s relevant to all versions of Power Pivot, as…

Read the Rest
Interview With Kamal Hathi Of Microsoft, Plus “AMA!”

Interview with Kamal Hathi of Microsoft, plus “AMA!”

Director of Product Management, Microsoft BI (At left: the many faces of Kamal Hathi:  1 – “Seriously, we have to do formal headshots?”, 2 - Explaining, 3 – Explaining, and… 4 – Explaining. Today, I ask him to Explain some things, and he happily obliges.) Yeah folks, this is a rare treat. Kamal’s title can be taken at face value – he’s right there at the top of the MS BI org, reporting directly to the VP of BI. Like…

Read the Rest
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 a few hiccups and small tweaks over the next couple weeks while we finish dialing this all in. Next up, we’re going to be working on the mobile version (which was already improved a few months back, but still needs…

Read the Rest
Mini-Post 2 Of 3: Power BI Desktop Loads 2016 Files

Mini-Post 2 of 3: Power BI Desktop Loads 2016 Files

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 2013. So that technique is NOT available to you in older versions of Excel. But, it IS available to you as part of Power BI Desktop, and that does NOT require you to upgrade your version of Excel! So, today…

Read the Rest
Mini-Post 1 Of 3: We Finally “sold Out” To Microsoft

Mini-Post 1 of 3: We finally “sold out” to Microsoft

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 helpful, we will now be able to consider higher-quality paper in addition to color printing, and that helps all of us out here in the trenches.  I’ve seen what color and high-qual paper did for Bill’s latest book, and it’s…

Read the Rest