Achieving Work-Life Integration at a High-Growth Startup

Periscope Data’s vice president, finance & operations, offers tips on managing personal and professional commitments in a startup environment.

Read More
Geographic Analysis in SQL: Measuring Polygon Area from Latitude and Longitude

Computing the area of polygons on the Earth's surface can be difficult, especially when the polygons are complex and have a large number of vertices. Here is a pure SQL solution to help you get started with your geographic analysis.

Read More
How Sales Teams Use Periscope Data

In sales, being able to optimize your time is a critical skill. Periscope Data Sales Manager Justin Bullock shares how his team uses data to more effectively target prospects and grow our pipeline.

Read More
Using Raspberry Pis to Build Beautiful Wall-Mounted Dashboards

Everyone wants a beautiful, wall-mounted dashboard for their primary KPIs—but setting one up can be challenge. Here's an easy and affordable way to display your dashboards without hiding a desktop computer under a desk.

Read More
Building a Data-Driven Culture Starts With the Right Players

Being a data-driven organization is an ongoing process—you need to invest in the right team, infrastructure, software, and processes that can promote lasting change.

Read More
Using Python to Write a Create Table Statement and Load a CSV into Redshift

For wide tables, it can be a pain to write those long create table statements and load the data into Redshift. Here is some simple Python to get the job done using the 2017 Stack Overflow survey.

Read More
Automated Identification and Graphing of SQL Dependencies

Over time, your company’s data model becomes increasingly complex. Visualizing your data model can help you understand how to optimize your ETL processes, but requires time and effort to code into a graph. Here’s a way to do it in an automated fashion by using Python, GraphViz, and some clever RegEx

Read More
June Product Updates: More Database Support, Management Options, and More

It’s been a busy month at Periscope HQ! Our teams have been hard at work shipping updates that will give users more ways to query and analyze data and new opportunities to manage their Periscope Data instance.

Read More
3 Ways Communication Can Help Analysts Be More Successful

Being a great analyst is more than SQL, Python or reporting—great analytics is a human exercise, a communications skill and way to grow a data-driven culture. Here are 3 simple techniques will help take your dashboards from simple intrigues to impactful business necessities.

Read More
How Periscope Approaches Customer Support

Periscope Data is well known for its stellar customer support. Sunny Xu shares what makes her group unique and how she plans to scale the Solutions team.

Read More
Optimize Your Periscope Instance With Usage Data

As more users start to access Periscope Data, knowing who is using what, and what is using up the most resources is key to keeping your Periscope instance tidy and running smoothly.

Read More
Introducing Controlled Dashboard Refresh

Today we’re launching Dashboard Refresh Management, a new feature that enables admins to take charge of data freshness and improve the end-user experience.

Read More
SQL History and Why 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.

Read More
SQL Query Order of Execution

The SQL order of execution defines the order in which the clauses of a query are evaluated. Let's look at how your query SQL executes, and how you can use that knowledge to write faster SQL

Read More
How to Get Started With AWS Spectrum in Minutes

AWS Redshift Spectrum is Amazon’s newest database technology, allowing exabyte scale data in S3 to be accessed through Redshift. This is not simply file access; Spectrum uses Redshift's brain, deploying workers by the thousands to order, join and aggregate your data before sending the minimum amount of data needed back to your Redshift cluster to finish your query. Learn how to get started!

Read More
Introducing Color Themes: A New Way to Help Your Data Shine

Our latest feature release lets admins create custom color palettes that can be applied to Spaces, dashboards, and charts.

Read More
Achieving Work-Life Integration at a High-Growth Startup

Periscope Data’s vice president, finance & operations, offers tips on managing personal and professional commitments in a startup environment.

Read More
Using Raspberry Pis to Build Beautiful Wall-Mounted Dashboards

Everyone wants a beautiful, wall-mounted dashboard for their primary KPIs—but setting one up can be challenge. Here's an easy and affordable way to display your dashboards without hiding a desktop computer under a desk.

Read More
Using Python to Write a Create Table Statement and Load a CSV into Redshift

For wide tables, it can be a pain to write those long create table statements and load the data into Redshift. Here is some simple Python to get the job done using the 2017 Stack Overflow survey.

Read More
Automated Identification and Graphing of SQL Dependencies

Over time, your company’s data model becomes increasingly complex. Visualizing your data model can help you understand how to optimize your ETL processes, but requires time and effort to code into a graph. Here’s a way to do it in an automated fashion by using Python, GraphViz, and some clever RegEx

Read More
3 Ways Communication Can Help Analysts Be More Successful

Being a great analyst is more than SQL, Python or reporting—great analytics is a human exercise, a communications skill and way to grow a data-driven culture. Here are 3 simple techniques will help take your dashboards from simple intrigues to impactful business necessities.

Read More
SQL History and Why 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.

Read More
SQL Query Order of Execution

The SQL order of execution defines the order in which the clauses of a query are evaluated. Let's look at how your query SQL executes, and how you can use that knowledge to write faster SQL

Read More
How to Get Started With AWS Spectrum in Minutes

AWS Redshift Spectrum is Amazon’s newest database technology, allowing exabyte scale data in S3 to be accessed through Redshift. This is not simply file access; Spectrum uses Redshift's brain, deploying workers by the thousands to order, join and aggregate your data before sending the minimum amount of data needed back to your Redshift cluster to finish your query. Learn how to get started!

Read More
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.

Read More
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...

Read More
How Sales Teams Use Periscope Data

In sales, being able to optimize your time is a critical skill. Periscope Data Sales Manager Justin Bullock shares how his team uses data to more effectively target prospects and grow our pipeline.

Read More
June Product Updates: More Database Support, Management Options, and More

It’s been a busy month at Periscope HQ! Our teams have been hard at work shipping updates that will give users more ways to query and analyze data and new opportunities to manage their Periscope Data instance.

Read More
Optimize Your Periscope Instance With Usage Data

As more users start to access Periscope Data, knowing who is using what, and what is using up the most resources is key to keeping your Periscope instance tidy and running smoothly.

Read More
Introducing Controlled Dashboard Refresh

Today we’re launching Dashboard Refresh Management, a new feature that enables admins to take charge of data freshness and improve the end-user experience.

Read More
Introducing Color Themes: A New Way to Help Your Data Shine

Our latest feature release lets admins create custom color palettes that can be applied to Spaces, dashboards, and charts.

Read More
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.

Read More
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.

Read More
Achieving Work-Life Integration at a High-Growth Startup

Periscope Data’s vice president, finance & operations, offers tips on managing personal and professional commitments in a startup environment.

Read More
Building a Data-Driven Culture Starts With the Right Players

Being a data-driven organization is an ongoing process—you need to invest in the right team, infrastructure, software, and processes that can promote lasting change.

Read More
How Periscope Approaches Customer Support

Periscope Data is well known for its stellar customer support. Sunny Xu shares what makes her group unique and how she plans to scale the Solutions team.

Read More
Periscope Data’s $25M Series B

We’re excited to announce that we’ve raised $25M in Series B Funding!

Read More
Announcing Periscope Data’s $9.5M Series A

We could not be more excited to announce that we have raised $9.5M in Series A funding from Josh Stein at DFJ!

Read More

Archives

What you Need to Know about SQLs Group By

SQL Text Analysis with Donald Trump’s Tweets

Net Promoter Score and Survey Analysis in SQL

How Joins Work

Data Warehouse Management: Redshift, Bigquery, and Snowflake

Interactive Analytics: Redshift vs Snowflake vs BigQuery

Tracking KPIs using SQL for Effective Revenue Growth Analysis

SQL Symbol Cheat Sheet

The Best Redshift Optimization Blog Posts of 2016

Calculating Proportional Values in SQL

Valuing User Subscriptions Over Time with SQL

Safety in San Francisco: A Numbers Game

Creating Ranked Position Time Series with SQL

Building a Better Pokédex with SQL

IMDb vs RottenTomatoes Ratings with SQL Trendlines

Cohorted Engagement: 7-day and 30-day Metrics

Feature Analysis with Mean-Time-Between-Usage Calculation

Cohorted Engagement with Comparable Time Windows in SQL

Common Salesforce Reports In SQL

Calculating Distance Between Data Centers On A Globe

Converting MySQL Syntax and Functions into Redshift

Understanding Outliers with Skew and Kurtosis in SQL

Predicting Churn Using Hypothesis Testing

Calculating Money Growth using PL/pgSQL

Coalesce Down Using Correlated Subqueries

Getting Started With Regular Expressions

Analyzing Disparate Data With Segment Sources

Simple Lead Scoring With Enrichment

Impact or No? -- Simple Event Study in SQL Part I

Analyzing Your Email With SQL

Rolling Classifications by X Previous Aggregations

Managing A Six-Figure Ad Budget With SQL

Portfolio Risk Analysis In SQL

Bigram Frequencies In Pure SQL

String Parsing In SQL

Calculating Expected Value vs. Actual Results for Super Bowl Contenders

Binomial Options Pricing In Postgres

Finding Nearest Neighbors In SQL

Outlier Detection In SQL

Using CTEs and Unions to Compute Running Totals

How to Really Use SQL Views

Funnel Metrics - Step-over-Step Drop Rates

Multi-dimensional Clustering Using K-Means in Postgres SQL

One Dimensional Clustering In Postgres

Creating a Histogram in Redshift

Adding Summary Statistics to your SQL Table

SQL Joins For Data Analysis

Concatenating Rows in Redshift, Postgres, & MySQL

Marketing Attribution In SQL

Calculating Year-over-Year Metrics

Building The Periscope Cache With Amazon Redshift

Analyzing Your Olark History with SQL

Calculating Significance of A/B Tests in Redshift

Understanding Distributed Analytics Databases, Part 2 — Data Distribution

Understanding Distributed Analytics Databases, Part 1: Query Strategies

Cash Flow Modeling In SQL

Analyzing Your Salesforce Data With SQL

Solving the Traveling Salesman Problem with Postgres Recursive CTEs

Connecting to a Redshift Cluster with a Private IP

Setting up Your Redshift Cluster

Game Revenue Metrics — What Matters, and When

International Analytics In SQL

How to ETL Data into and out of Amazon Redshift

Building Your Own User Analytics System In SQL

Thinking Critically About Mobile Game Retention

Explain And Other Tools For Query Optimization

Understanding Website Response Time with SQL

Comparing IP Addresses In SQL

4 Reasons Not To Use MySQL For Analysis

The Top SQL Analysis Errors We See

10 Rules for a Better SQL Schema

Optimizing Query Management on Redshift

Getting the First Row per Group 5X Faster

Extrapolating Data with Day-of-Week Effects

Daily, Weekly and Monthly Charts On The Same Graph

Helpful Redshift Admin Queries

Analyzing Our Long Term Blog Metrics With SQL

Single Event Tables and Common Analysis Queries

Splitting Comma-Separated Values In MySQL

Redshift User Defined Functions in Python

SQL for Marketers — Your Most Profitable Channels

Understanding SQL's Null

The Lazy Analyst's Guide To Postgres JSON

Exact Row Counts for All Tables in MySQL and Postgres

$3000 Data Warehouse — Redshift vs. Postgres

Importing Data into Redshift from MySQL and Postgres

SQL for Marketers — 3 Ways to Slice Your Acquisition Data

Counting Comma-Delimited Values in Postgres, MySQL, Amazon Redshift and MS SQL Server.

Reuse Calculations in the Same Query with Lateral Joins

Demystifying Redshift — What's Up with My Disks?

Redshift Maintenance 101

SQL for Marketers — Making Where More Powerful

Aggregating into Strings without String_agg or Array_agg in Amazon Redshift

Changing Dist and Sort Keys on Giant Tables in Redshift

Rolling Averages in MySQL and SQL Server

Extrapolating to the End of the Month in SQL

SQL for Marketers Part 4 — Common Analysis Queries

Medians In SQL

Cross-Database Joins

SQL for Marketers Part 3 — Our Most Valuable Traffic Source

Day-Over-Day Changes Without Window Functions

SQL for Marketers Part 2 — Users over the Last 30 Days

Optimizing Your PSQL

Comparing Hourly Revenue In SQL

SQL For Marketers

Using Row Numbering And Full Joins To Transpose Wide Tables

Fun with Window Functions

Estimating Conversions With Poisson Distributions

Beyond Random() — Normal Distributions in SQL

Selecting Only One Row Per Group

Use Subqueries and Window Functions to Compute Running Averages

Computing Day-Over-Day Changes With Window Functions

Date Parts In SQL Server

Computing Day-Over-Day Changes With Window Functions

Using Self Joins To Calculate Your Retention, Churn, And Reactivation Metrics

How To Optimize Lifetime Distinct Counts Using Window Functions

Predicting Exponential Growth With SQL

How To Calculate Cohort Retention In SQL

Hashing Tables to Ensure Consistency in Postgres, Redshift and MySQL

Hyperloglog In Pure SQL

How to Format Numbers as Currency in Postgres, MySQL and Redshift

Generate Series in Redshift and MySQL

Faster Redshift Queries with Materialized Views — Lifetime Daily ARPU

How To Sample Rows in SQL 273X Faster

Counting Conditionally In SQL

How To Calculate Confidence Intervals In SQL

Use window functions for time-series percentage

4 Ways to Join Only The First Row in SQL

Count Distinct Compared on Top 4 SQL Databases

2X Your Redshift Speed With Sortkeys and Distkeys

Use generate_series to get continuous results

How To Speed Up Where Clauses By 3,000X

Use Subqueries To Count Distinct 50X Faster

Range joins give you accurate histories