August 29, 2022

Analyzing Time-series without the Llama Drama

Barry Burns

Some argue that time is a flat circle. Most analysts, however, can agree that working with time-series data is tough.

Processing large volumes of transactional records, building rolling period aggregations, and implementing fiscal calendars are tedious. Don’t even get me started on time-zone transformations.

Savant Time Series Rollups

The pain is near and dear to our hearts at Savant, which is why we built a tool to greatly simplify time-series operations.

Let’s say we had a data set that tracks how many llamas each Savant employee pets on a given day.

No alt text provided for this image

Now, we’re a bit competitive at Savant, so we want to be able to track who pet the most llamas every quarter, as well as who is improving in their llama petting on a rolling month-to-month basis.

The Savant time series tool easily takes our raw data and creates the roll-ups needed for these calculations.

See how it works in this short video:

With just a few more steps in Savant, I’m able to automate a competition tracker that updates our llama scores on a daily basis:

No alt text provided for this image

About the author

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros elementum tristique. Duis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere.

Barry Burns