SQL

Structured Query Language used by database systems to read, write, & delete data. It is the most essential programming language for data analysis.

Window Functions – Making Your SQL Life Easier

by

SQL window functions have been around for some time now (they were part of the SQL 2003 ISO standard). However, adoption has taken time in some database systems. For example, they weren’t introduced in MySQL until MySQL 8 (2018). Window functions are functions that aggregation data, but are returned to the un-aggregated row. For example, … Read more

Data Analysis: My End-to-End Approach

by

Introduction Have you ever been given a set of data files, asked to clean, model, analyze, and visualize them? This is a post on doing exactly that type of data analysis. Together, we are going to complete this objective, step-by-step. The goal is to understand how to properly analyze datasets in a methodical way. We … Read more

Time-Series Analysis For Digital Analytics in R (Pt. 1)

by

Introduction Time-series analysis is a powerful way to predict events that occur at a future time. One of the most common uses in eCommerce is for sales events. In this post I am going to use the forecast package to explore an ARIMA time-series model in R. I have covered what an ARIMA model is … Read more

Introduction of Time Series Analysis For Digital Analytics

by
time series

Let’s say you want to forecast future revenue. You could fill in a month-to-month or week-to-week spreadsheet template. However, these are very subjective methods of trying to predict the future and often wildly inaccurate.

A better method would be to create predictive models using time series analysis. Time series predictive models are a specific subset of statistical models that deal with data that are ordered by and dependent on time. On a graph, the x-axis would be time, with the y-axis the thing (revenue, in this case) you are measuring.

In this post, I will give an overview of one type of time series models and describe how they work in simple language. I will describe how to implement the models in BigQuery ML. 

Read more