- Technical Debt: The achilles heel of data science It’s the one simple reason you’re not more successful.
- Ideas on using API.AI to report information from BigQuery What if I could build a system to analyze information and allows me to do more important work?
- It's HOW expensive to rent in Colorado? An examination of information from data.colorado.gov.
- The code behind my Colorado rent analysis Examining ways you might automate reporting for analysis.
- How To: Automating BigQuery jobs A short example of how I automate my BigQuery jobs using bash.
- How To: Run Github Code on a Remote Server A short example of how you can run remote code with version control.
- Why I'm Fascinated With Reproducible Code I’m not the only one who hates typing the same thing repeatedly, right?
- A Reproducible Research Template for R A quick and easy template for reproducible research in R.
- Programming for data analysts Today I’m trying to answer the question “Why should I learn to program?”
- I don't care what language you use; just solve problems I’m throwing my hat into the R vs Python debate. So what?
- Please don't hardcode your SQL values Let’s try to make our queries more dynamic, shall we?
- Why I version control all of my analysis and data science work Explaining the pedantic reasons why I use version control even when I work alone.
- Importing Shopify data into Google BigQuery A simple shell script that uploads data from Shopify’s API into Google BigQuery
- Upload Your Woocommerce data to Google BigQuery with a Shell Script A simple tutorial to use a shell script to upload data from a Woocommerce API and push it to Google Bigquery.
- Automatically open issues on Github using Google Apps Script How to open issues on Github using Google Apps Script
- Automatically open issues on Github using Google Apps Script A simple Google Apps Script that automatically opens issues in a Github repo.
- Tracking On page SEO Changes with Google BigQuery A sql query that can be used in Google BigQuery to help you track your SEO optimization efforts.
- Skills For Analysts: Learning to Communicate Learning to communicate clearly with others is one of most important skills to have.
- What does learning how to code actually teach us? Programming a computer is the by-product of learning how to code. Let’s look at what it really teaches us.
- The 500 folder problem: A Real World Automation Example You have a deadline driven task that needs to be done in one hour, but the task takes 3-4 hours. What do you do?
- The 500 folder problem: A Real World Automation Example You have a deadline driven task that needs to be done in one hour, but the task takes 3-4 hours. What do you do?
- Upload your Google Play Developer Reports Using A Shell Script Since you can’t natively upload files from the Google Play Developer Console, I’ve written a shell script to help me automate that on a monthly basis.
- How to send your Google Analytics data to BigQuery with Apps Script How I import Google Analytics data into BigQuery using Google Apps Script.
- How I became enamored with automation The story about shutting up and building those damn boxes.
- Automating reports in R and version control with a shell script In this post, I’ll share how I use a shell script to automate some of my Github Flow work.
- How to: Query an API and send the results to Google BigQuery with Apps Script In this post, we’ll look at how to use Google Apps Script to query an API, parse the results and upload the information to BigQuery.