Data management remains a top challenge for companies across all industries. The vast majority of organizations have a hard time moving data from point to point and ...

Data Management

Data Management KPIs: 6 Metrics to Measure and How to Improve Them

By Justin Reynolds   |   December 9, 2022

Overseeing a fast-moving, dynamic marketing department is no easy task. Chief marketing officers (CMOs) need to juggle a variety of responsibilities while making sure ...

CMO

Why You Need a CMO Dashboard and What to Put on It

By Justin Reynolds   |   December 5, 2022

If you're looking for a great metric to track user engagement and growth on your platform, you might want to measure your daily active users (DAU). But keep in mind that ...

Daily Active Users

How to Calculate Your Daily Active Users and Why It Matters

By Gift “Gigi” Kenneth   |   October 25, 2022

We’ve developed a way to make the platform even better for our data-loving customers: let’s talk about usage reports - the data on your data! In the past, Panoply users ...

Product

Usage Reports: Get the Data on Your Data

By Allison Foster   |   September 1, 2022

There are few things more validating for a business than happy customers and positive testimonials. Not to toot our own horn, but peer-to-peer review site G2 awarded ...

Data Bytes

G2 Recognition with Panoply Founder Yaniv Leven

By Allison Foster   |   August 19, 2022

If it seems like data and analytics companies can’t stop talking about a “single source of truth,” well… you’re right. Single source of truth (SSOT) has emerged as a ...

Data Bytes

Data Bytes: Everyone Needs a Single Source of Truth

By Allison Foster   |   August 15, 2022

MongoDB database is really popular these days. Developers often use it instead of MySQL, but these two platforms aren’t in direct competition. While MySQL is a ...

Data Management

Important MongoDB Best Practices You Should Follow

By Dawid Ziolkowski   |   August 2, 2022

Data Warehousing

Step By Step: Export Shopify Data Using Panoply

By Keshav Malik   |   July 21, 2022

Reflecting on the first-ever offsite team meetup

Data Bytes

Data Bytes Episode 2: The Panoply Meetup

By Allison Foster   |   July 18, 2022

What better way to kick off a new video series than by sitting down with the CEO?

Data Bytes

Data Bytes Episode 1: After the Acquisition

By Allison Foster   |   July 6, 2022

Google has announced that Universal Analytics (UA) will have its sunset – will be switched off, to put it straight – by the autumn of 2023. Enterprise users are given ...

Data Industry Trends

Google Moves Marketers to GA4: Good News or Not?

By Yulia Lukashina   |   June 29, 2022

Moving your business from disparate data sources and ad hoc reporting to a single source of truth data warehouse solution is a sign of growth in the right direction.

Being Data-Driven

10 Questions to Help Define a Successful Data Warehouse Strategy

By Taurai Mutimutema   |   June 13, 2022

The buzzwords “big data” have been around for a few years. Simply put, it refers to extremely large amounts of information. As this data grows in quantity, variety, and ...

Data Management

Data Management Best Practices and How They Help Your Team

By Ibrahim Ogunbiyi   |   June 7, 2022

Using insights generated from company data is essential when making business decisions. Having reliable data enables a company to make strategic decisions to optimize ...

Data Stack

Top 6 Power BI Benefits For Your Business

By Gift “Gigi” Kenneth   |   June 1, 2022

With the launch of our new 21-day Free Proof of Value, new users have plenty of time to begin seeing the value that Panoply adds as a part of their tech stack. In order ...

Panoply News

Proof of Value Onboarding Checklist

By Tan Kim Tran   |   May 18, 2022

Earlier this year we partnered with Square to tackle a common problem: how can Square sellers unlock more robust reporting, without hiring a full data team? While we ...

Product

Analyzing Square Data with Panoply: No Code Required

By Alon Brody   |   April 27, 2022

Data flows like never before, and with so much at our disposal, making the best use of it is a challenge. Many businesses use Google Sheets for everything from content ...

Data Warehousing

6 Use Cases for Connecting Google Sheets to Panoply

By James Konik   |   March 10, 2022

A recent IDC DataSphere forecast report predicts that the compound annual growth rate of global data creation and replication will reach 23% between 2020 and 2025.

Data Warehousing

10 Benefits and Use Cases for A Data Warehouse

By Deborah Ruck   |   February 22, 2022

Sometimes, the only thing standing between an analyst and a catastrophic management decision could be knowing the difference between the tables:

Data Warehousing

Data Warehouse Naming Conventions Guide

By Roel Peters   |   February 17, 2022

This article will cover how to work with time series/datetime data in Redshift.

Learning SQL

Manipulating Time Series Data with SQL in Redshift

By Manoj Mokashi   |   January 25, 2022

Data is the lifeline of any modern organization. At any point, every day, you work on molding data points into information to derive profits. Therefore, having the right ...

ETL/ELT

ETL and SQL: The Dynamic Data Duo & Examples

By Taurai Mutimutema   |   January 20, 2022

Panoply News

Panoply has joined the SQream data family!

By Yaniv Leven   |   December 15, 2021

The enterprise data warehouse (EDW) is a fairly new entrant into the universe of databases mainly optimized for reading operations. By structuring data in a rigid ...

Data Warehousing

What Does a Modern Data Warehouse Do?

By Roel Peters   |   December 10, 2021

Data analytics can mean a lot of things. Sometimes you’re delivering relevant metrics to analysis experts; other times, you’re identifying which tools, resources, and ...

Data Analysis

The Pros and Cons of Open-source Software in Data Analytics

By Corissa Haury   |   December 6, 2021

One of the significant challenges in handling data comes from the massive amount of data your organization is most likely generating constantly. Having the ability to ...

Data Warehousing

Data Warehouse Design: The Good, the Bad, the Ugly

By Daniel Paes   |   November 17, 2021