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

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

Experience So Far With A Udacity Nanodegree

Predictive Analytics has been pretty interesting so far. While there was some content I had already been through before, I definitely needed a refresher. I basically re-did everything I’d done before just to make sure I knew what I was doing. Alteryx certainly helps make a lot of data prep and analysis work super easy. If Read More

I Just Started My Nanodegree

Yesterday marked the beginning of my Udacity Nanodegree in Predictive Analytics for Business; from 8pm onwards in fact. At 8:01pm I was refreshing the page and finally accessing the content. Not much later I was already beginning to work on my first project. Then this morning I was working on it again in the hope I Read More

Failing At A Paid Course And Enjoying It

Today I took the plunge on the Business Statistics Specialization I’ve been enjoying for the past few weeks. I fully enrolled with the 7 day free trial then £37 a month until I complete the course. Why? Because I finally started working on the final capstone course and saw that there are peer-reviewed assessments. Having got 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