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

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

ARIMA Modeling – Homebrew Edition

ARIMA modeling has felt like a bit of a nemesis since I was first exposed to it. Figuring out what settings to use with it has been my main challenge. The ACF and PACF plots are supposed to help here, but you have to learn to read them somewhat. There is an auto.arima option, which tests 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

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

Good News Everyone!

I got the confirmation today that I would be accepted to join a Data Science Apprenticeship degree. The head of admissions approved me based on my work experience (years of business metrics, Excel and VBA) and self-study (Business Statistics and Advanced Excel)! To clarify, this apprenticeship will be for an actual Bachelor’s degree in Data Science. Read More

Here Comes The Predictive Analysis!

My next Nanodegree project feels more like my regular work than the last. I basically need to cleanse and combine multiple data sources, then use that data to predict future sales. It’s also reassuring that a course in analytics is starting to resemble my current job role. Not reassuring of the course content, but reassuring of Read More

How I Met My Study Buddy

School was not my favourite because I really didn’t fit in. In fact, I hated the majority of it. So when the opportunity came to drop out at 16, I did. I then went to community college just to do my GCSEs and a GNVQ in IT and found a completely different environment that reminded me Read More