TrustRadius: an HG Insights company

Panoply

Score8.6 out of 10

11 Reviews and Ratings

What is Panoply?

Panoply, from Sqream since the late 2021 acquisition, is an ETL-less, smart end-to-end data management system built for the cloud. Panoply specializes as a unified ELT and Data Warehouse platform with integrated visualization capabilities and storage optimization algorithms.

Media

Simply click to connect 100 data sources.

It is easy to use and has multiple functions

Pros

  • It’s a good choice for building quick, multipurpose data stack for a variety of businesses needs.

Cons

  • The user interface could use some improvement for analytical tools. Apart from that, it’s great.

Return on Investment

  • The user interface could use some improvement for analytical tools. Apart from that, it’s great.

Usability

Panoply Offloads Everything!

Use Cases and Deployment Scope

Panoply is a large warehouse to store data. Our company uses it to host large quantities of data when we no longer need them. They are stored there and then we can refer back to things when we need them. It is a great alternative to offload data when we need it.

Pros

  • data management
  • organization

Cons

  • search feature

Most Important Features

  • offloading data

Return on Investment

  • offload 80% of data from the past year

Alternatives Considered

Google Drive

Other Software Used

Google Drive

Panoply is easier than Redshift

Pros

  • Redshift setup -- so much easier with Panoply, rather than messing around with AWS mishegoss
  • Automated data ingestion and formatting -- I love not having to write out SQL table schema
  • Easy scaling and data warehouse maintenance -- I don't like to have to mess with this in previous redshift implementations

Cons

  • I hate the chat bots
  • The automated data ingestion is great, but does sometimes make for weird columns

Return on Investment

  • Saved time on Redshift setup
  • Saved support costs (monetary and temporal) by not having to set up on-premise
  • Widens the BI tool use in organization; lowers the barrier to entry and makes organization more productive in analytical terms

Other Software Used

Tableau Desktop, Adobe Illustrator CC, Microsoft Azure

Time to value is unbeatable

Pros

  • Ease of data integrations. Importing data into the data warehouse is a point-and-click effort.
  • Automated data modeling. The data is modeled in a way that facilitates analysis without having to look into it myself.
  • Query speed. Automated query optimization has really sped up our dashboards.

Cons

  • Needs more user control

Return on Investment

  • There is no question that Panoply is more affordable than many building and managing similar solutions

Alternatives Considered

Amazon Redshift, Google BigQuery, ETL for Amazon Redshift and Snowflake

Other Software Used

HubSpot, Google Analytics, Chartio