Extract, Transform, and Load (ETL) is a data warehousing process that uses batch processing to help business users analyze and report on data relevant to their business ...

ETL

20 Great ETL Tools, And The Case For Saying "No" To ETL

 

Data Management

28 Data Management Tools & 5 Ways Of Thinking About Data Management

  At Panoply, we’ve built a smart cloud data warehouse that will let you seamlessly integrate all your data, store it for analysis, and generate business intelligence ...

BI And Data Visualization

Top 25 Business Intelligence Tools Of 2020 And How To Decide

Introduction NurseGrid’s goal is to unite the largest workforce in healthcare with cutting edge staffing and resource technology. NurseGrid creates tools for ...

Being Data Driven

How NurseGrid Quickens Product Improvement Through Data

Data Technology

How To Analyze DynamoDB Data In Grafana

Being Data Driven

Before 2019 Ends: Check Out Azure Synapse Analytics

Happy December! 🥳

Product

Panoply's December User Experience Update

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

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

Top 6 Shopify ETL Tools For Your Ecommerce Data Pipeline

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

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?

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 Analytics

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 Analytics

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