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). Instead of R, this time I’m going to explore an ARIMA time-series analysis in Python. If you want … Read more
Relational data theory is the process of modeling how data should be organized in a database system. E.F. Codd introduced the relational data model in 1970 while working at IBM. Prior to this, data was stored in files, in a hierarchical structure. Accessing data in this kind of structure was challenging and required custom programming. … Read more
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