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

Linear Algebra And Excel Spreadsheets

Although I am just beginning with Linear Algebra, one thing occurred to me about matrices and vectors. I worried that in my ignorance, I was simply misunderstanding, but maybe not. I stumbled across the following quote and my little thought made sense: Linear algebra gives you mini-spreadsheets for your math equations https://betterexplained.com/articles/linear-algebra-guide/ Now THAT is something 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