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
powerpivot
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
Gitgud At Excel, Fast
Anyone who has read my blog for any length of time should know that I am a whiz at Excel. I have graduated from the Excel guy to analyst now, but for a good few years I was the Excel guy and becoming an analyst has only expanded my Excel skills further. So one thing that Read More
The Death Of The Desktop Is A Tragedy
Something you often notice in modern workplaces is that a lot of people are working from laptops, even when they have a desk and never move it. This isn’t necessarily a bad thing, portability is inherently useful and more easily allows remote working after all. Remote working is the way to go! But when you have Read More
Stop Overusing Power Query!
This is mainly a post to remind myself to stop relying so heavily on using Power Query to do everything. I am almost certain that if I learned how to use Power Pivot, it would do all of the things I keep doing in Power Query much faster. Today I used Power Query to create multiple Read More
The Secret Powers Of Excel
As I’ve progressed through the Business Statistics Specialization on Coursera, one of the things that I’ve noted, and been grateful for, is that you don’t need to fully understand the maths of statistical methods to use them. The main thing you need to know and be able to us, are Excel functions. There are Excel functions 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!