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 […]
What this is for: Extracting bulk data from the NPI registry and downloading as CSV Requirements: Knowledge of JSON, Pandas dataframes Concepts covered: Making an API request, flattening JSON, combining dataframes Download: Download the Jupyter notebook If you work with health care provider data, you are no doubt familiar with NPI (National Provider Identifier) data. […]