BI Reporting: Excel Stuff

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:

https://www.edx.org/course/analyzing-and-visualizing-data-with-excel-2

And the BI Reporting badge it leads to:

https://www.microsoft.com/en-us/learning/mcsa-bi-reporting.aspx

Tell me what you think

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: