Excelでの業務効率化に興味を持っている方の中には、「PowerPivot（パワーピボット）」という機能を耳にしたことがある方も多いのではないでしょうか。ただ、同じように「PowerQuery」や「ピボットテーブル」も聞いたことがあり、「結局、何がどう違うの？

Have you found this content useful? Use the button above to save it to your profile. Business intelligence expert Philip Taylor (aka ExcelCrafter) puts the case for using the PowerPivot add-in for ...

Last week I pulled a new pair of running shoes out of the box and laced them up. As much as I love running and a pristine new pair of shoes, I have no intention of giving up my bicycle or car and ...

In the previous post in this series I looked at how MDX set expressions could be used inside Excel to give you total control over what appears on the rows and columns axis of your PowerPivot ...

Some Excel functions that can pull data directly from the PowerPivot datamodel (basically like a super lightweight RDBMS inside Excel designed to take your pivot ...

In part 4 of this series (sorry for the long wait since then!) I finished off looking at what you can do with named sets. Now, before I go on to more important topics like Excel cube functions and ...