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

Even the most potent database is still prone to the terrifying error any database system can face: query bottlenecks.

Data Warehousing

Redshift Query Queues: The Complete Guide

By Daniel Paes   |   November 12, 2021

Google Cloud Platform has long been the cloud provider of choice for web analytics, with the impressive BigQuery being Google's massively parallel processing (MPP) ...

Data Warehousing

BigQuery Data Types Examined & Explained

By Daniel Paes   |   November 12, 2021

Data visualization is defined as the graphical representation of information and data. Using visual elements like charts, graphs, and maps helps audiences to see and ...

Being Data-driven

History of Data Visualization: Pivotal Moments Analysts Can Learn From

By Allen Hillery   |   November 5, 2021

At some point, you will begin to recognize that there is more potential in your data than just charts and dashboards.

Etl/elt

5 Best Reverse ETL Tools & Their Alternatives

By Andrew Zola   |   October 15, 2021

A data warehouse aims to make sense of a specific subject over time by analyzing historical data. This system, also called the decision-making support system, can tackle ...

Data Warehousing

Incremental Loading: The Smarter Way to Update Data

By Daniel Paes   |   September 24, 2021

Did you know that data collection is one of the most time-consuming steps in the process of data science? But it's definitely not as terrifying as data cleaning.

Being Data-driven

Complete Guide to Data Collection for Data Science: Step-by-Step

By Zulaikha Greer   |   September 23, 2021

Google Ads is Google's platform for digital business advertisement. If you're new to Google Ads analysis, you'll need to understand the kind of data on the platform.

Data Analysis

The Analyst's Guide to Google Ads & Successful Ad Spends

By Temilade Adefioye Aina   |   September 14, 2021

A data dictionary defines all the critical metrics and terms your business uses. It's a simple idea that dramatically impacts how effectively your business can use its ...

Being Data-driven

5 Ways to Create a Data Dictionary + (Free Template!)

By Adam Murphy   |   September 2, 2021

Power BI increases its adoption among the most experienced users each day. Thanks to being a user-friendly tool with various data sources to connect to, it helps analyze ...

Tutorials

How To Analyze PostgreSQL Data in Power BI

By Daniel Paes   |   August 31, 2021

The world has changed; companies now use hybrid and multi-cloud environments to store their data. You probably do too. Gone are the days where you had to build a data ...

Being Data-driven

Data Orchestration Guide & Directed Acyclic Graphs (DAG) Examples

By Adam Murphy   |   August 25, 2021

Modern consumers expect a streamlined & personalized service from the retailers with whom they do business. If you can’t fulfill their expectations for an efficient ...

Being Data-driven

How Data Analytics Can Help You Grow Your Retail Business

By Josh Iversen   |   August 25, 2021

Google released Google Analytics 4 (GA4) in October 2020 in an effort to improve upon the previous generation called Universal Analytics (UA).

Data Analysis

The Analyst's Guide to Google Analytics 4

By Temilade Adefioye Aina   |   August 17, 2021

Google BigQuery is a serverless data warehouse solution that aims to be cost-effective and highly scalable, allowing businesses to analyze large amounts of data with ...

Data Warehousing

9 Most Useful BigQuery SQL Functions for Efficency

By Carlos Schults   |   August 17, 2021

In the world of data and analytics, data observability is an important but often overlooked process.

Data Observability

6 Best Data Observability Tools: Comparing Usability & Features

By Andrew Zola   |   August 6, 2021

 

Data Warehousing

How to Convert/Translate PostgreSQL Queries Into BigQuery SQL

By Carlos Schults   |   August 6, 2021