The goal of this article is to present an unbiased view and play-by-play breakdown of how much it would cost to build your own ETL pipeline and data warehouse vs. using ...

Being Data Driven

Build or Buy? Panoply vs. Self-Managed Solution (By the Numbers)

By Adam Murphy   |   October 11, 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

Disclaimer: The current Google Analytics connector in Panoply works with Universal Analytics. Stay tuned for our updated connector before UA is sunset in 2022.  Google ...

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.

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

Designing and creating a data dictionary for your company is a big process with big returns. It's something you need to do if you want deep insights from your data and ...

Best Practices

7 Best Practices for Building a Data Dictionary

By Adam Murphy   |   August 6, 2021

On a high-level, ETL transforms your data before loading, while ELT transforms data only after loading to your warehouse. In this post, we'll look in detail at ...

Etl

ETL vs ELT: The Difference is in the How

By Malsha Ranawaka   |   July 27, 2021

When you love a piece of software the way our users love Panoply, there’s nothing more exciting than finding out what new features are on the roadmap. 

Panoply News

Panoply’s Product Roadmap - Q3 2021

By Johel Davila   |   July 23, 2021

When it comes to storing data, we generally have two options: SQL (relational databases) and NoSQL (non-relational databases).

Data Stack

SQL vs. NoSQL: The Differences Explained

By Imoh Promise Chinedu   |   July 21, 2021

In our last post, Dashboards 101, our intrepid analyst Regina was building a dashboard for her company’s management team. Regina works at a fictitious coffee delivery ...

Bi And Data Visualization

Data Visualization 101: How Gestalt Principles Yield Better Charts

By Allen Hillery   |   July 20, 2021

Data transformation tools help change data formats, apply business logic, and otherwise play the "T" role in ETL. This is especially important when consolidating both ...

Data Stack

8 Best Data Transformation Tools Compared for 2021

By Andrew Zola   |   July 16, 2021

Companies today are increasingly collecting large volumes of data from cloud services, mobile applications, and connected devices. Yet many struggle with deploying data. ...

Data Stack

What Is Operational Analytics?

By Justin Reynolds   |   July 14, 2021

For years, Microsoft has been a leader in Gartner's quadrant for intelligence and analytics platforms. In other words: it has a complete vision and can execute it.

Data Analysis

How to Analyze DynamoDB Data in Power BI

By Roel Peters   |   July 13, 2021

Data warehouses are becoming increasingly popular as many businesses, nonprofits, and municipal organizations realize the value of storing their current and historic ...

Data Warehousing

Can PostgreSQL Work as a Data Warehouse?

By Corissa Haury   |   July 12, 2021

In today's complex business landscape, where information pours in from many different locations throughout the day, it's crucial to work with multiple data sets.

Etl

Data Blending Explained: What It Is and How to Do It

By Justin Reynolds   |   July 9, 2021

So you're at the point of your project where the discussion of SQL vs. NoSQL is old news, and NoSQL is the path forward.

Databases

DynamoDB vs. MongoDB: How to Choose the Right One for You

By Mauro Chojrin   |   July 9, 2021

One of the significant challenges to data-driven companies comes when integrating different application systems. Major public cloud providers, such as Amazon or Google, ...

Data Stack

AWS Spectrum, Athena, and S3: Everything You Need to Know

By Daniel Paes   |   July 8, 2021

Imagine that you are in a meeting with a potential investor, and they ask you for specific information about your company to help them decide whether to invest in your ...

Data Warehousing

7 Signs You Need a Data Warehouse

By Néstor Campos   |   July 7, 2021