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 Read More
Power BI
Getting Certified in BI Reporting
From looking into the learning around Power BI, it seems like the difficult part is combining data and adding calculated measures. For the last 9 months, I’ve been using Power Query and for the last 4 months I’ve been using Power Pivot. Both of these are the backend in Power BI that drive all the data Read More
What Can I Bring To The Table(au)?
In the last section of the Nanodegree, I’m learning how to use Tableau to investigate my data. It was one of my main goals in taking this particular Nanodegree actually, so I’m glad I’m finally at that point! With that said, I have been getting a lot more comfortable and capable with Power Query. I feel Read More
Master Excel Reporting With PowerPivot And CUBE Formulas
Here’s a post for the Excel nerds out there, because this was so helpful to me over the past couple of days that it is worth talking about. For non-Excel nerds, if you work in analysis or reporting, give this post a quick glance at least, you might pick up something useful!
Your Career Is Made Up Of Life And Business Skills
One of my hopes for this blog, and generally the content I share here, is that it may help others who find themselves somewhere on the same path as I am. That may be where they’ve learned enough Excel to be able to list it as one of their skills, and they want to know where Read More
If You Do Anything With Data In Excel, Learn PowerQuery!
This week I’ve been digging into the wonderful world of PowerQuery and Power BI, two excellent tools developed by Microsoft that make preparing and visualising data something akin to magic.