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
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
Introduction Time-series analysis is a powerful way to predict events that occur at a future time. In this post I am going to be following up from three previous posts (Pt 1 –> https://rebrand.ly/l1tf4p1, Pt 2 -> https://rebrand.ly/zjgpw8v and Introduction to Time-Series –> https://rebrand.ly/z4lomwu). In Pt 2, I used a dummy dataset to show how to create an ARIMA … Read more
Introduction Time-series analysis is a powerful way to predict events that occur at a future time. In this post I am going to be following up from two previous posts (Pt 1 –> https://rebrand.ly/l1tf4p1 and Introduction to Time-Series –> https://rebrand.ly/z4lomwu) and I’m going to mainly use the forecast package to explore an ARIMA time-series model in R. Retrieving … Read more
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