Articles in metrics maven

Metrics Maven: Meet in the Middle - Median in PostgreSQL

In our Metrics Maven series, Compose's data scientist shares database features, tips, tricks, and code you can use to get the metrics you need from your data. In this article we'll cozy-up to calculating a median in PostgreSQL. To set the stage for m…

Continue reading »

Metrics Maven: Beyond Average - A Look at Mean in PostgreSQL

In our Metrics Maven series, Compose's data scientist shares database features, tips, tricks, and code you can use to get the metrics you need from your data. Over the next few articles, we'll get cozy with mean, median, and mode in PostgreSQL. Mean,…

Continue reading »

Metrics Maven: Creating Pivot Tables in PostgreSQL Using Crosstab

In our Metrics Maven series, Compose's data scientist shares database features, tips, tricks, and code you can use to get the metrics you need from your data. In this article, we'll look at the crosstab function in PostgreSQL to create a pivot table…

Continue reading »

Metrics Maven: Making Data Pretty in PostgreSQL

In our Metrics Maven series, Compose's data scientist shares database features, tips, tricks, and code you can use to get the metrics you need from your data. In this article, we'll look at how you can make your reports more understandable (aka "pret…

Continue reading »

Metrics Maven: Calculating a Moving Average in PostgreSQL

In our Metrics Maven series, Compose's data scientist shares database features, tips, tricks, and code you can use to get the metrics you need from your data. In this article, we'll look at how to calculate a moving average in PostgreSQL. This articl…

Continue reading »

Metrics Maven: Window Frames in PostgreSQL

In our Metrics Maven series, Compose's data scientist shares database features, tips, tricks, and code you can use to get the metrics you need from your data. In this article, we'll take a closer look at window frames in PostgreSQL. In our last artic…

Continue reading »

Metrics Maven: Window Functions in PostgreSQL

In our Metrics Maven series, Compose's data scientist shares database features, tips, tricks, and code you can use to get the metrics you need from your data. In this first article, we'll look at how to use window functions in PostgreSQL. PostgreSQL…

Continue reading »