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

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 Analysis

How To Analyze MongoDB Data In Tableau

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

Amazon Redshift is a massively popular data warehouse service that lives on their AWS platform, making it easy to set up and run a data warehouse. Redshift clusters can ...

Data Warehousing

Set Up Your First AWS Redshift Database: A Schema To SQL Tutorial

Jupyter notebooks have quickly become one of the most popular, if not the most popular way, to write and share code in the data science and analytics community. Jupyter ...

Postgres

Connecting Python Pandas And Jupyter Notebooks To PostgreSQL For Data Analysis

Designing a database schema is the first step in building a foundation in data management. Ineffective schema design can creates databases that are heavy consumers of ...

Best Practices

Database Schema Design Examples