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

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

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

All Of My Google Analytics Data Disappeared!

Yesterday was a reminder of how much I still have to learn about using Google Analytics. I created a new view to see my site traffic excluding my own ip and applied it. With the new view applied, the traffic coming in from sources besides my own ip were… nothing. There were absolutely no visits to 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

Learning Teaches Us How Little We Really Know

The more you learn, the more you realise how much there is left to learn. I was reminded of this important lesson today when I was trying to use a smarter way to populate an Excel report and came up against some challenges. Even though the way I was preparing the report was much better than Read More

Master Excel Reporting With PowerPivot And CUBE Formulas

Here’s a post for the Excel nerds out there, because this was so helpful to me over the past couple of days that it is worth talking about. For non-Excel nerds, if you work in analysis or reporting, give this post a quick glance at least, you might pick up something useful!