In this practical demo we'll explore a dataset together using Transforms. Nothing better than seeing freshly updated Elasticsearch records full of clean, accurate data. Still, in their usual state records don't reveal much - there's usually too many to answer any question other than "how many are there". Aggregations make records really come to life by showing groups and patterns. But there are circumstances when aggregations are simply not enough, especially if many need to be chained together to look for insights in data. This is where Transforms come in - they take an index and allow you to save a summary of it. You can then perform further aggregation and analysis, or visualise the result. For those who miss spreadsheet pivot tables - they're back, now with the speed and scale of Elasticsearch. If you ever found yourself wanting to save the results of an aggregation and aggregate them even further, this is the right talk for you.