How to Compute a Moving Average in BigQuery Using SQL

Smooth out variations, spot trends, and visualize them in Data Studio

Stock market station (Credits: https://unsplash.com/@behy_studio)

The problem

When looking at time-series data, decisions can be influenced by random, short-term fluctuations (price of a cryptocurrency, number of Covid-19 cases reported).