What research tells us about fitness apps, social networking and their impact on motivation and self-esteem I’ve never been the fastest athlete, so imagine the rush I felt when I got my first leaderboard times on Strava. These initial top 10 times and KOMs motivated me to keep cycling and train harder, especially on days […]
If you’re working with weighted quantitative data, statistical software like SPSS (and its open source counterpart PSPP) have easy built-in functionality to handle the weights. But it’s less straightforward if you’re working in other programs, so this quick tutorial shows how to complete basic calculations with weighted survey data in Power BI. For this tutorial, […]
Skyline Drive at Shenandoah National Park is hands down my favorite place to ride. Breathtaking views, challenging terrain, limited traffic, cooler weather – the park should be on every cyclists’ list of places to visit on the East Coast. I’ve been fortunate to have ridden there several times, so here are a few quick tips […]
When I’m working with data, I probably spend 90% of my time cleaning. In a recent project, I ran into an issue where I needed to make ZIP codes consistent – some were five-digit, some had the plus-four, some had a hyphen while others didn’t, and some were just invalid. I searched for a simple […]
If you work with large volumes of data in Google Analytics, you have likely encountered sampled data at some point. Seeing that your data has been sampled might make you suspicious – can I really trust the data if it is sampled at 50%? What about only 5%? To get to the bottom of this, […]
What this does: Append rows from one Google sheet to another & schedule the task to run daily Requirements: Baseline understanding of Google sheets Concepts covered: Google Apps Scripts, Google Sheets One of the coolest features of Google Sheets is the ability to automate tasks via scripts. For example, say you need to perform a […]
What this does: Cleans text from meta tags using basic JavaScript to pass to Google Analytics reports Requirements: Google Analytics deployed through Tag Manager, understanding of regular expressions & JavaScript, admin access to Google Analytics Over the years I’ve found one of the more useful tools in Google Analytics is the ability to pass custom […]