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

From Excel To Data Science

Today I was doing plenty of data prep stuff in Excel using Power Query, and waiting for it to load my changes over and over again. While I was waiting, I had an idea: could I transition my Excel work over to R? I found this: https://medium.com/district-data-labs/how-to-transition-from-excel-to-r-f9304fabcbab And this: So it seems very realistic for me Read More

This Excel Guy Is An Analyst

It is not uncommon for me to compare my last job with this one and feel grateful for what I’m doing now. Today I found myself there again. Recently I’ve been tracking my working time on Toggl, not everything but close enough. Today, all my time spent working on the report came to less than an 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