Latest Stories

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

We’re happy to announce that Panoply’s data management capabilities are now available on Microsoft Azure Synapse Analytics.
Data Technology

Announcing Panoply Availability On Microsoft Azure

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

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

MySQL databases 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 ...
Databases

MySQL As A Data Warehouse: Is It Really Your Best Option?

Welcome back to all the Instagram brand ambassadors, social media analysts and savvy influencers-to-be who have been with us since the beginning of this series. For ...
Data Analytics

Instagram Data Analysis Using SQL, Part The Third: Identifying Top Followers

Ok, Instagram datanauts, welcome back to the second installment of our ongoing series covering how to analyze your Instagram data using SQL and Panoply. We covered most ...
Data Analytics

Analyzing Instagram API Data, Part 2: Engagement Over Time

Even though Instagram isn’t one of the original social media platforms (shouts out Friendster and Myspace), it has become one of the most dominant social media companies ...
Data Analytics

Instagram Analytics With SQL Queries Part 1: Getting Started

What is ETL? ETL stands for Extract, Transform, Load. In computing, it is a type of data integration used to blend data from multiple data sources. It is a process that ...
ETL

Stitch Vs. Fivetran: Which One Is Best For Your Organization?

Panoply is the ultimate cloud data warehouse - with scalable storage and optimizations that make your warehouse and queries perform in the fastest possible way, Panoply ...
Product

Making Data Management Easier With Preview, Now In Panoply

  A Dashboard is a tool that allows us to see at-a-glance the insights and performance of an organization through a set of carefully identified and relevant key ...
Leading With Analytics

Dashboards 101: Basics Of A Great Dashboard

  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 ...
Product

Announcing Panoply’s New Data Governance Features

  The past few years have been pretty exciting for cloud computing. With extensive offerings from Amazon, Google, Microsoft, Snowflake and others, developers can now ...
Leading With Analytics

Snowflake Vs BigQuery: Comparing Pricing, Performance And Usability

  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

Top 10 ETL Tools That Extract And Load Elasticsearch Data

ETL

11 Powerful ETL Tools For Salesforce Data Integration

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

Top 12 Twitter Analytics Tools

The speed, flexibility and ease of setup of NoSQL-style databases have all contributed to the rapid rise in popularity of MongoDB in recent years. Despite its advantages ...
Data Analytics

How To Analyze MongoDB Data In Tableau

  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

ETL

10 Best ETL Tools For Postgres Data Warehouses And Databases

Connecting Tableau to AWS DynamoDB 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 ...
Data Analytics

DynamoDB Analytics And Visualization In Tableau: Step By Step Tutorial

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 ...
Analytics Leadership

Top Eight Facebook Analytics Tools

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, ...
Analytics Leadership

Surviving And Thriving As Data Team Of One

  Mixpanel is one of the leading business analytics solution that tracks user interactions with web and mobile applications and provides tools for targeted ...
Product

Panoply Is Now Fully Integrated With Mixpanel

  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 ...
Panoply

Goal! Building Smarter Athletes With Data And Intelligence. How ProSoccerData Does It

Work smarter, better, and faster with weekly tips and how-tos.