Smoothing data with moving averages

When dealing with time series data, we will often interact with data that is very noisy with multiple peaks and troughs.

To address this, moving averages are a helpful technique to smooth noisy data whilst preserving the overall shape of the distribution.

In this exercise, we will explore how to utilize Tableau's user interface to create a 7 day moving average using Table Calculations to smoothen some otherwise noisy water trading data!