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 Read More

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

Fancy New Updates And Fancy New Skills

Last week there was an update rolled out to my copy of Microsoft Office. Usually this wouldn’t merit much discussion, but this update included improvements to a tool I’ve been using extensively for the past few months; Power Query. What improvement was that? It was the super useful Intellisense feature, as well as syntax highlighting. Basically, Read More

Some Quick Tips For Success With Power Query

PowerQuery is an amazing addition to Excel. It can transform entire columns of data in a couple of clicks. It can unpivot monthly trackers, instantly normalising the data. You can use it to stitch multiple csv/txt files together just by pointing it at a folder. And it can read, import and transform any sheets or tables Read More

Never Back Down!… Is Not Great Advice

Tonight at 8pm the Nanodegree course I enrolled on, Predictive Analytics for Business, finally opens. You would think I would be writing about that tonight, but no. Even though I am pretty excited (and a little intimidated) by it, I have something else in mind. Failure! Again! Over the last couple of weeks I have spent Read More