- Dialing in my workflow: Markdown There are so many advantages of Markdown I’m surprised everyone isn’t using it.
- Apple's product strategy is really confusing Apple keeps making things bigger and better, but who are they building them for?
- Initial thoughts on switching from a Mac to a Pixelbook Go. After almost twenty years, I’ve decided to switch from macs to a Pixelbook Go. Is it going to work for all of my needs?
- I Don't Write On My Blog Much Anymore. That Probably Won't Change. I don’t blog much anymore and that’s okay with me.
- Questions for Google Analytics: How many users were on my site? If you have Google Analytics data in BigQuery, sometimes its fun just to ask questions.
- Running Google Search Console Scripts in Docker on Google Compute Engine Running a Docker image on Google Compute Engine that pulls Google Webmaster Tools data and stores it in BigQuery.
- What if newspapers and reporters used Git & GitHub? What if newspapers used a version control system to author, collaborate and publish all of their work? Would that be possible?
- #chiptip: Launch RStudio from the command line A quick tip on how to launch RStudio from the command line by adding an alias to your bash_profile.
- In my other life, I was a cook I’m not saying I love food, but yeah, I really do.
- Our recent trip to Colorado We finally got to visit Colorado again!
- Sentiment Analysis of Frasier Let’s look at data from the television show Frasier.
- Text Analysis: Part III More Adventures in Cleaning Data Round three of preparing unstructured text data for analysis.
- Text Analysis: Part II More Adventures in Cleaning Data Round two of preparing unstructured text data for analysis.
- My Foray Into Prepping Data for Analysis My first attempt into preparing unstructured text data for analysis.
- Analyze Your Google Location History: Time & Distance Let’s analyze our time and distance data from our Google Location History
- Analyze Your Google Location History: Exploring Data Let’s analyze our Google Location History Data
- Analyze Your Google Location History: Getting and Loading Data Let’s take a look at the Google’s Timeline History to see what we can learn
- Invest In Yourself By Reading More Books Want to get ahead in your personal life or career? You should start here.
- White House salary analysis Creating a portfolio by analyzing open data.
- My Summer of Data Science Part One: Mathematical Modeling #sods17 I’m spending the summer learning and growing through data science
- You Should Never Stop Learning Graduation doesn’t mean you’ve reached the end of the road.
- An Analysis of 2015 Fort Collins Employee Earnings An analysis of how much public employees are earning in Fort Collins, Colorado
- 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.
- My favorite books of 2016 A short list of some of my favorite books read during 2016
- 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.
- Automating Marketing With R Trying to make complex marketing requests more simple
- Prove When Addition Equals Multiplication Using Code The things that keep me busy when I’m bored
- Analyzing Google AdWords With R Part II Step Two is some light EDA
- Analyzing Google AdWords With R Step One Getting Setup With Authentication
- I've moved from Wordpress To Github Pages Why I moved from Wordpress To Github Pages
- 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.
- Dinner ideas: Palmetto Grilled Cheese Sandwiches with Bacon and Tomato Missing home? This comfort food sandwich will take you back to your childhood with a spin on a classic grilled cheese.
- Dinner ideas: Gourmet Grilled Cheese with Nutella, Brie & Bacon A legitimately amazing grilled cheese sandwich.
- Super Simple Sunday Brunch: Open Face Breakfast Sandwich This is a simple brunch or breakfast idea. It’s an open faced sandwich on bolillo rolls with fried or scrambled eggs, applewood smoked bacon, baby spinach mix and provolone cheese.
- 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.
- What statistical analysis should I use? A list of statistical tests that you can use in R.
- 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.
- Books on tap For February & March 2016 Here’s a list of books I’ve read, currently reading or plan to read over the next month:
- We hate math: Is it tools or the way we teach? The future relies on us to think programmatically and solve the worlds greatest mysteries. The way that we teach math currently won’t get us there.
- Books on tap for November & December Upcoming books I’ll be ready over the next four weeks.
- November Reads: 10 books 10 books I’ve read in November that I think are worth sharing.
- Dear blog and readers: I haven't forgotten about you We’ve just been so busy enjoying our new lives in Colorado!
- How to: Create an AdWords budget with Google Sheets Today, we’ll show you how to manage and keep an eye on your clients AdWords spend with Google Sheets.
- Google Analytics & 'Fake Traffic': Garbage In, Garbage Out? YAY! My traffic has increased 50 bajillion percent over last month. Wait, what do you mean 50% of it might be FAKE? NOOO!
- How to: Translate Cells in Google Spreadsheets from English to Spanish (maybe!) This Google App Script for Spreadsheets will automatically convert words and sentences from English to Spanish.
- How to: Format cells in Google Spreadsheet based on a previous cells value For example, if the value of B1 is greater than A1, set the background of B2 to lime green.
- Format Your Google Spreadsheet Using App Scripts Formatting your Google Sheets using Google App Scripts.
- How to pull Youtube Metrics from the Adwords API A quick and painless way to pull key Trueview metrics through the Adwords API.
- Doing things the hard way vs the harder way Sometimes there is no easy answer to a problem. Let’s take a look at why.