May 25, 2017

Using Spline Interpolation in SQL to Analyze Sparse Data

Data scientists use spline interpolation to produce smooth graphs and estimate missing values by “filling in” the space between discrete points of data. We can use SQL to better approximate our real world data.

May 23, 2017

How ZeroCater Made Our Lunch Data-Driven: Survey Analysis and the IoT

Here at Periscope we absolutely love data, so I couldn’t help but notice when our catering company, ZeroCater, brought in an amazing device to collect survey data about our lunches in real time. ZeroCater has always delivered us a great meal, but for a data driven analyst like myself this this was too interesting to ignore...

May 16, 2017

Feature Release: Query Management

Over the past few months we’ve been working with customers to empower a new level of visibility and control over their databases. With great joy we’re now introducing the incredible power of Query Management.

May 12, 2017

Precision Recall and ROC Curves for Pregnancy Tests

As a data nerd who hates taking chances, I thought I’d perform an example analysis on pregnancy tests to figure out whether or not the current standard of measuring the hormone hCG (human chorionic gonadotropin) is the most optimal method. After all, no matter if you are a woman who wants to be pregnant or a woman who doesn’t, having an incorrect prediction is not something you want to risk. With Periscope Data, use SQL to map out Precision-Recall and Receiver Operating Characteristic (ROC) curves.

May 10, 2017

What You Need To Know About SQL's GROUP BY

The SQL 'group by' is one of the most common keywords. Here is how it works, and a few special cases you want to be aware of

April 13, 2017

The War SQL Won: Your Database Isn't Really Relational

Rather than a true relational database, SQL is a compromise between convenience and the rigour of relational algebra. Here's how it's different.

March 16, 2017

Introducing Periscope Data for Slack

Over the past year our customers have asked us to improve our link sharing functionality in a place where they are increasingly working and communicating more: Slack.

March 2, 2017

SQL Text Analysis with Donald Trump’s Tweets

There were many unique aspects of the 2016 U.S. presidential election, with one of the most interesting being Donald Trump’s use of Twitter. As luck would have it, tweets happen to be very easy to extract and put into relational database format.

February 28, 2017

Net Promoter Score and Survey Analysis in SQL

Introduced by Fred Reichheld in 2003, Net Promoter Score (NPS) is a simple method for measuring the likelihood your customers will recommend your product or service. It requires that you survey respondents and ask one simple question: “How likely are you to recommend [Company/Product/Service] to a friend or colleague?”

February 1, 2017

How Joins Work

The SQL join operation is one of the most powerful and commonly used SQL operations, but little attention is paid to how the internal SQL engine breaks down the tasks of join operations.

The SQL 'group by' is one of the most common keywords. Here is how it works, and a few special cases you want to be aware of

April 13, 2017

The War SQL Won: Your Database Isn't Really Relational

Rather than a true relational database, SQL is a compromise between convenience and the rigour of relational algebra. Here's how it's different.

March 2, 2017

SQL Text Analysis with Donald Trump’s Tweets

February 28, 2017

Net Promoter Score and Survey Analysis in SQL

February 1, 2017

How Joins Work

The SQL join operation is one of the most powerful and commonly used SQL operations, but little attention is paid to how the internal SQL engine breaks down the tasks of join operations.

October 21, 2016

Data Warehouse Management: Redshift, Bigquery, and Snowflake

In our post comparing Redshift, BigQuery, and Snowflake on query performance and cost for interactive analytics, we looked at the trade-offs across different data warehouses from a performance perspective.

October 20, 2016

Interactive Analytics: Redshift vs Snowflake vs BigQuery

Every day customers ask us what the best data warehouse technology is for handling the workload of their growing analytics department: they want to run queries at interactive, real-time speeds at a price-point that fits in their budget.

May 16, 2017

Feature Release: Query Management

March 16, 2017

Introducing Periscope Data for Slack

Over the past year our customers have asked us to improve our link sharing functionality in a place where they are increasingly working and communicating more: Slack.

No items found.