Lisa Smith

Articles by Lisa Smith

Lisa Smith - keepin' it simple.

Metrics Maven: Mode d'Emploi - Finding the Mode 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 have a look at mode to round out our series on mean, median, and mod…

Continue reading »

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 »

Deeper into RethinkDB 2.3 - Fold in Use

Earlier this year, RethinkDB released their Fantasia 2.3 version. In this article, we're going to take a closer look at one of the lesser-known features that came out with that release - the aggregation fold command. Background You can find the offic…

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 »

Visualizing Compose PostgreSQL Data with Leftronic

At Compose, we use Leftronic for metrics at-a-glance. Leftronic is a real-time, browser-based data visualization service that makes it easy to create smart looking dashboards. We like it so much that we wanted to share how we're using it because we t…

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 »

Using Query String Queries in Elasticsearch

In Elasticsearch, query string queries are their own breed of query - loads of functionality for full text search rolled into one sweet little package. In this article, we'll take a closer look at why query string queries are special and how you can…

Continue reading »