Following on from my post yesterday, I wanted to give a small update.
I’m now halfway through the Excel certification that contributions to the BI Reporting badge and I am learning some useful new features.
As I mentioned before, I’ve been using PowerPivot for around 4 months, and while I’m aware there is still much to learn, there are some basics that make it a lot easier.
One is that once you load a pivot table from Power Pivot into Excel, you can right-click on any table in the pivot table fields menu to create or edit measures. That doesn’t sound like much, but when I first started using PowerPivot I found it a little jarring learning how to create measures and stuff in the editor. Putting them together in a little pop-up window with familiar old Excel in the background feels far less alien. Now when I want to demo the strength of power pivot to someone, I’ll do it that way instead!
That’s all for now, I’m halfway through and I want to get the Excel part done by the end of this week if I can!
Here is the course if you want to follow it yourself:
And the BI Reporting badge it leads to: