Tag: power bi

Power Pivot eBook Coming Soon

It's been a long time coming, but we are putting the finishing touches on the third installment of our free 'DIY BI' series. Consequently, we are excited to announce that the Power Pivot eBook will be officially released on Tuesday,

Read More »

Ranking Method Choices in Power Query

My recent post on showing the Top X with Ties inspired a discussion on ranking methods.  Where I was looking to rank using what I now know as a standard competition rank, Daniil chose to use a dense ranking method

Read More »

Unlock Excel Conference

Unlock Excel Returns to Australia and New Zealand We're really excited that Ken is going to be heading back "down under" this April for CPA Australia's Unlock Excel conference. Spending two days in each of four different cities, Unlock Excel

Read More »

Free ‘DIY BI’ e-Books

Today I wanted to just make a quick announcement that we are currently working on a series of free 'DIY BI' e-Books. Free 'DIY BI' e-Books? Tell me more! Over the past few years of working with Excel an Power

Read More »

October News and Events

It’s a busy month here at Excelguru. Instead of a technical post we wanted to catch everyone up on our October news and events! Live Course: Master Your Excel Data  Ken is teaching a LIVE, hands on course in Victoria, BC

Read More »