“A spreadsheet is just data in single-player mode” Last week I made a mistake. I boldly claimed that “A spreadsheet is just data in single-player mode.” And while I stand by that claim. I didn’t expect to be called to account for it. As it turns out, the post was pretty popular and I think […]
From Spreadsheets to SQL: Step One towards the Minimum Viable Data Stack Read More »
As a data analyst, your credibility is as valuable as your analytical skills. And to maintain your credibility, it’s important to be able to answer questions correctly and consistently. That’s why you must be careful to integrate reproducibility into your SQL analyses. This tutorial is going to show you how you can use Redshift User
Intro to SQL User-Defined Functions: A Redshift UDF Tutorial Read More »
As a digital marketer, I use SQL every single day. And looking back on my career so far, it would be fair (though a bit reductive) to say that I could define my career by two distinct periods: before I learned SQL and after I learned SQL. The two periods are distinct for three main
Getting Started with SQL for Marketing (with Facebook Ads Example) Read More »
Pssst… have you heard about Google Search Console’s BigQuery integration?? The thing I enjoy most about SEO is thinking at scale. Working at Postmates was fun because sometimes it’s more appropriate to size opportunities on a logarithmic scale than a linear one. But there is a challenge that comes along with that: opportunities scale logarithmically,
SEO with the Google Search Console API and Python Read More »
When you reach the limits of Google Analytics custom reports and you still need more, Google Spreadsheets and the Google Analytics Add-On can take you past sampling, data consistency and dimension challenges. This post is all about the Google Analytics + Google Spreadsheets workflow. It is an end-to-end example of how you can extract more
Google Analytics to Google Spreadsheets is Data to Insights Read More »
From AOL Instant Messenger to WeChat stickers, digital communication has always fascinated me. From the beginning, there has always been so much we don’t understand about digital communication. It’s kind of like GMO; we just started using it without considering the implications. We are continually learning how to use the the digital medium to achieve
Is Slack Messenger Right for My Team? Analytics and Answers Read More »
If you are like most people doing business online, it seems like there is always a long list of digital to-dos that are somewhere between “that will happen in Q4” and “that should have happened by Q4 last year.” Aside from the constant stream of daily hiccups that arise due to the asynchronous nature of
Agile Strategy for Data Collection and Analytics Read More »
