The popular Shopify e-commerce service has everything you need to create, market, and manage an online business. The platform’s in-app payment platform works on ...

ETL/ELT

Top 6 Shopify ETL Tools for your Ecommerce Data Pipeline

By Trisha McNary   |   December 3, 2019

Comparing metrics over time is a great way to benchmark progress and to identify issues as they come up. In order to compare metrics over time, the dates in your ...

Learning SQL

Comparing Metrics Over Time in SQL

By Lori Brok   |   November 13, 2019

Congratulations! You’ve connected to your data warehouse (or database). You are on your way towards analytics awesomeness. But first, you need to get your bearings. ...

Learning SQL

Exploring Tables And Columns In Redshift: A PG_TABLE_DEF Tutorial

By Lori Brok   |   November 6, 2019

In this blog post, I will introduce you to the basics of using CASE statements/expressions. This post will also cover comparison operators (greater than, less than, ...

Learning SQL

Postgres CASE Statement Basics by Example

By Lori Brok   |   October 22, 2019

When I started my SQL journey not too long ago, I diligently completed interactive tutorials and to be honest, thought I had a grasp on this thing. Fast forward a couple ...

Learning SQL

A Beginner’s Guide to Formatting Dates in SQL

By Lori Brok   |   October 15, 2019

MySQL is one of the more popular flavors of SQL-based databases, especially when it comes to web applications. Owned by Oracle, MySQL is free and open source, so it’s a ...

Databases

MySQL as a Data Warehouse: is it really your best option?

By Peter Weinberg   |   October 10, 2019

This post has been updated to reflect changes to Instagram's API (Facebook's Graph API). You will now need to switch to an Instagram Business account to perform this ...

Data Analysis

Instagram Data Analysis using SQL, part the third: Identifying Top Followers

By Peter Weinberg   |   September 25, 2019

This post has been updated to reflect changes to Instagram's API (Facebook's Graph API). You will now need to switch to an Instagram Business account to perform this ...

Data Analysis

Analyzing Instagram API Data, part 2: Engagement Over Time

By Peter Weinberg   |   September 24, 2019

This post has been updated to reflect changes to Instagram's API (Facebook's Graph API). You will now need to switch to an Instagram Business account to perform this ...

Data Analysis

Instagram Analytics with SQL Queries part 1: Getting Started

By Peter Weinberg   |   September 23, 2019

Getting the right data into the right hands is our specialty here at Panoply. With our data management platform, teams collect their numerous data sources into one place ...

Product

Announcing Panoply’s New Data Governance Features

By Jason Harris   |   August 29, 2019

Elasticsearch is the search and analytics engine that powers the Elastic Stack, a suite of products from the Elastic company. This popular search and analytics engine ...

ETL/ELT

Top 10 ETL Tools the Extract and Load Elasticsearch Data

By Trisha McNary   |   August 20, 2019

Salesforce is an industry-leading customer relationship management (CRM) platform. This BI tool supports integrated sales, automated marketing, and data analytics and ...

ETL/ELT

11 Powerful ETL Tools For Salesforce Data Integration

By Trisha McNary   |   August 13, 2019

Twitter, the punchy platform that gave us the #hashtag, turned 13 this year.

Data Stack

Top 12 Twitter Analytics Tools

By Jason Harris   |   August 8, 2019

If you’re in the marketing and data circles, keeping tabs on your social media ads performance is constantly at the forefront of your mind. This is why we’ve built ...

Product

Social Ad Managers: Introducing Our LinkedIn Ads Data Source And Updates To Twitter Ads

By Jason Harris   |   July 30, 2019

ETL/ELT

11 Top ETL Tools For PostgreSQL Data Warehouses and Databases

By Trisha McNary   |   July 23, 2019

One thing we see a lot of here at Panoply is customers looking to use Tableau to analyze data stored in DynamoDB instances. If you’ve ever looked into this, or tried it ...

Data Analysis

DynamoDB Analytics and Visualization in Tableau: Step by Step Tutorial

By Peter Weinberg   |   July 16, 2019

Facebook began as a dorm-room startup, and now the social platform dominates our culture. Few could have predicted that Facebook would become such a fixture of our ...

Data Stack

Top Eight Facebook Analytics Tools

By Jason Harris   |   July 11, 2019

We know that many in the data analyst and data decision making world are often teams of one. There might be one data analyst in a company, even an SMB or large company, ...

Working in Data

Surviving and Thriving as Data Team of One

By Marissa Ramirez   |   July 2, 2019

With Cumul.io and Panoply, ProSoccerData built a data stack that enables business intelligence based off data from the soccer startup’s production application, support ...

Customer Stories

Goal! Building Smarter Athletes with Data and Intelligence. How ProSoccerData Does It

By Jason Harris   |   June 27, 2019

There are so many different types of business intelligence (BI) tools in the market now, such as Looker, Mode, Tableau, Periscope, etc. As the go-to-data-person at my ...

BI and Data Visualization

Tableau vs. Mode: Comparing Pricing, Integrations and Deployment

By Ka Hou Sio   |   June 25, 2019

With Looker and Panoply, Moment was able to migrate off RJMetrics and build a robust, scalable business intelligence platform. Now data is democratized across the entire ...

Customer Stories

Moment Shines With A Panoply Powered Data Stack

By Jason Harris   |   June 21, 2019

One billion people use Instagram every month. 4.2 billion likes each day—to be exact. With over 25 million businesses using Instagram, the competition is fierce for all ...

Data Stack

Follow the Data: the Top Instagram Analytics Tools

By Jason Harris   |   June 19, 2019

So your startup is growing... Great! The only problem is, you can’t say exactly why it’s growing or how to increase the rate of growth. You know that analytics are ...

Being Data-Driven

How to Build your Startup's Analytics Operation from Scratch: Tools and Tips

By Peter Weinberg   |   June 18, 2019

The R Project is an open source programming environment that supports statistical computing and graphic design. For R work or any data operations, you need an ETL tool ...

ETL/ELT

The 9 Best ETL Packages for R Programming

By Trisha McNary   |   June 12, 2019

The typical customer funnel is easy to understand and is useful for creating a strategy for your entire Sales, Marketing, and Customer Success teams. However, you likely ...

Data Analysis

Advanced Customer Lifecycle Analytics with HubSpot

By Marissa Ramirez   |   June 11, 2019