Latest Stories In: Panoply Blog - Data Management, Data Warehousing, And Data Analysis. | Tutorials

HubSpot is a leading platform for inbound marketing, sales, and customer relationship management. With HubSpot, you can get exhaustive data on your marketing efforts. 
Tutorials

How to Analyze HubSpot Email Campaigns with SQL

If you use HubSpot, you know it captures a ton of data about your customers, marketing campaigns, and so much more. And while native HubSpot reporting is a great way to ...
Tutorials

HubSpot & SQL: A New Way to Understand Your Revenue

Poorly designed databases can cause many problems, including a waste of resources, difficult maintenance, and faulty performance. That's why having a great database ...
Best Practices

Database Schema Design Examples

MongoDB's data flexibility is a breeze for developers but can be a major headache for analysts and data scientists. Here's how to wrangle your non-relational MongoDB ...
Data Analysis

How to Analyze MongoDB Data in Tableau

For the final entry in our SQL and pandas series, we’re going to be talking today about closing the loop. We’ve talked about the difference between pandas and SQL, how ...
Data Analysis

How to load pandas dataframes into SQL

Welcome back, data folk, to our 3-part series on managing and analyzing data with SQL, Python and pandas. In our first post, we went into the differences, similarities, ...
Data Analysis

How to read a SQL query into a pandas dataframe

SQL and pandas are both invaluable tools for any analyst or data scientist. They tend to be mentioned in the same breath when talking about data manipulation and ...
Data Analysis

SQL and pandas: A Rosetta Stone for Analysts

This tutorial was authored by Ahmed Shaaban, a MeasureMatch partner.
Mysql

MySQL Replication for Analytics and Visualization: A Panoply Tutorial

At Panoply, we get a lot of customers who are looking to use Grafana to analyze data stored in DynamoDB instances. If you’ve ever looked into this, you’ve probably seen ...
Data Analysis

How to analyze DynamoDB data in Grafana

DATEDIFF is a super useful function that returns the difference between date parts (or dateparts) of two date or time expressions. For this post we will use data from: ...
Learning Sql

Creating Elapsed Time Histograms in SQL Using DATEDIFF

This blog post is the first of a two-part series. The first part will focus on Hubspot lead analytics and will equip you with the tools you need to go beyond standard ...
Learning Sql

Hubspot Lead Analytics in SQL, Beyond CRM Reporting

Ecommerce is getting more competitive every day as big players like Amazon and Alibaba consume more markets and scrappy D2C players try to disrupt them. It is impossible ...
Bi And Data Visualization

Building Shopify Dashboards in Tableau, Power BI and Google Data Studio

In this post, we’ll walk through three ways to subtract dates (or timestamps) in Redshift:
Learning Sql

Tutorial: How To Subtract Dates In Redshift

 
Learning Sql

Comparing Metrics Over Time in SQL

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

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

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

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

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

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

  Whatever your relationship with ETL processes is, you’re probably aware that it’s an inescapable element of modern data management and data warehousing practices. Data ...
Etl

ETL with Singer: a Tutorial

  Today I want to show you how you can combine performance metrics from three popular ad networks, Google Ads, Bing Ads, and Facebook Ads without exporting a CSV or ...
Data Analysis

Combining Data from Google Ads, Bing Ads, and Facebook Ads in Google Data Studio

In an increasingly data-focused world, the term “machine learning” is more popular than ever. However, many find the concept intimidating and believe that it is too ...
Redshift

Connecting R to a Redshift Data Warehouse for Machine Learning

Cloud-based data warehouses are quickly replacing their on-premise counterparts, allowing organizations with big data needs to potentially save millions in costs. Amazon ...
Data Warehousing

Setting Up A Cloud Data Warehouse: A Schema To SQL Tutorial

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