Skip to main content
TrustRadius
Panoply

Panoply

Overview

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.

Read more
Recent Reviews

TrustRadius Insights

Panoply has garnered positive feedback from users who appreciate its intuitive and customizable platform for data analysis. With Panoply, …
Continue reading

Time to value is unbeatable

10 out of 10
December 22, 2018
We use Panoply to consolidate our data from everything from our ad networks, to our CRM, to our web and application analytics, to our …
Continue reading
Read all reviews
Return to navigation

Product Details

What is Panoply?

Panoply is an ETL-less, smart end-to-end data management system built for the cloud, which streamlines data from source to analysis. An end-to-end data management solution, Panoply provides the tools for data integration, connecting, transformation, warehousing, and more. The vendor claims Panoply delivers the world’s only unified, ELT and Smart Data Warehouse, expediting the journey of migrating raw data to analytics using machine learning and natural language processing.

Panoply is now owned and supported by Sqream, since the December 2021 acquisition.

Panoply Features

  • Supported: ETL-less Data Integration
  • Supported: Agile Modeling and Learning Algorithms
  • Supported: Storage Optimization Algorithms
  • Supported: Default Modeling Algorithms
  • Supported: Smart Data Infrastructure (Use Case, Query and Server Optimization)

Panoply Screenshots

Screenshot of Simply click to connect 100 data sources.

Panoply Video

The Data Management Problem and Why You Should Care

Panoply Technical Details

Deployment TypesSoftware as a Service (SaaS), Cloud, or Web-Based
Operating SystemsUnspecified
Mobile ApplicationNo
Supported CountriesGlobal
Supported LanguagesEnglish
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(12)

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

Panoply has garnered positive feedback from users who appreciate its intuitive and customizable platform for data analysis. With Panoply, users can easily collect and store marketing data from multiple sources, leading to better insights for clients. The software's user-friendly interface allows business users to quickly access and analyze data without the need for a Data Engineer or Software Developer. Additionally, Panoply proves valuable in analyzing geographical data with latitudes, longitudes, and variables, making it ideal for agencies working with location-based information. Users also find it useful for managing files, analyzing click-through rates on websites, gathering customer data for market research, and facilitating management reporting for retail businesses. Moreover, Panoply serves as a turnkey business intelligence solution for small businesses, eliminating the need for a dedicated data engineer or analyst. Overall, users appreciate the ease of use and recommend Panoply for data collection and analytics across various industries.

Easy-to-use platform: Users have consistently praised Panoply for being an easy-to-use platform. Many reviewers have stated that they found it straightforward to set up and manage their data pipelines. The intuitive user interface and customizable options were particularly appreciated, making the process of importing and connecting multiple data sources seamless.

Flexibility in connecting multiple data sources: Several users have highlighted the flexibility of Panoply in connecting various data sources, including non-standard ones. This feature has been commended for its ability to cater to diverse needs and enable users to consolidate their data from different systems into one central location. Reviewers have expressed satisfaction with Panoply's capability in handling a wide range of data sources.

Time-saving on data engineering: A significant number of users have emphasized how Panoply has saved them time on data engineering tasks. By automating processes and simplifying workflows, the platform has allowed users to focus more on analyzing and deriving insights from their data rather than spending valuable time on manual labor. The time-saving aspect has been highly valued by reviewers as it enhances productivity within organizations.

High Pricing: Many users have expressed concerns about Panoply's pricing models, particularly for Premium and Basic services. They feel that the prices are high compared to other data warehouse platforms and suggest that more cost flexibility should be provided, especially for small-scale and mid-scale companies.

Difficulties with Integration: Some users have found it difficult to integrate API sources directly into Panoply. They mention having to use a third-party tool for this integration, which adds complexity to their workflow.

Slow Support Response: The support team in Panoply has been occasionally slow to respond, especially for special requests. Users have mentioned dissatisfaction with the character limit for some tasks as well.

Users frequently recommend Panoply for its helpful sample video user guides, which are seen as a valuable resource. They also recommend the platform for data-driven business solutions and data warehousing, highlighting its ability to integrate multiple data sources effectively. Users believe that Panoply is a suitable choice for companies with large databases that require instant results, as well as for companies with numerous data sources and experiencing growth. Overall, users appreciate Panoply's ease of use, customer service, alignment with long-term objectives, and analytics capabilities. They suggest it as a data warehouse with easy integrations and the ability to create custom data sets. Panoply is highly recommended for small to medium-sized companies seeking insights from their data. Users are impressed with the user-friendly interface of Panoply and would suggest it to individuals involved in data collection and analytics. Additionally, users recommend Panoply as a robust and secure cloud data management solution for SME businesses. They find the pricing of Panoply convenient and consider it relatively easy to use, although having some understanding of SQL is beneficial. To evaluate its suitability before committing, users suggest trying the free trial version of Panoply. While Panoply is deemed suitable for non-technical users, it is recommended that basic knowledge of writing SQL queries be obtained prior to starting the free trial. In summary, users encourage exploring the value offered by Panoply through a trial period or implementation into existing workflows.

Attribute Ratings

Reviews

(1-4 of 4)
Companies can't remove reviews or game the system. Here's why
Score 10 out of 10
Vetted Review
Verified User
Incentivized
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.
  • data management
  • organization
  • search feature
Panoply is well suited for companies with large amounts of data that do not want all users of the company to see or view. It is appropriate for companies that have to store data for several years in case clients need the data. It is not made to constantly be downloading or looking at the documents.
  • offloading data
  • offload 80% of data from the past year
Panoply has much more storage and better organization tools for searching. There are better folders and tools for keeping documents secure and stored for a long period of time. It is better to offload data in mass than singular or Zip drive documents like you would do in Google Drive.
Score 10 out of 10
Vetted Review
Verified User
We used to run an old IBM database system for our media company. It wasn’t very efficient and used to bog things down, so we switched to Panoply. It’s much quicker and easier to work through.
  • It’s a good choice for building quick, multipurpose data stack for a variety of businesses needs.
  • The user interface could use some improvement for analytical tools. Apart from that, it’s great.
Love the support that we get from our dedicated data architect and the Panoply community. The Panoply team provides comprehensive documentation and online support to answer all our questions day or night.
  • The user interface could use some improvement for analytical tools. Apart from that, it’s great.
It’s a good choice for building quick, multipurpose data stack for a variety of businesses needs.
It’s a good choice for building a quick, multipurpose data stack for a variety of businesses needs.
Peter Weinberg | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
It's being used by the analysts in my organization. The organization isn't large enough to have departments, per se, but all the analysts in my organization use it. It's used to cut some of the work and fiddling out of data warehouse setup and use, because my organization's analysts want to spend more time working with the data rather than doing technical support
  • 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
  • I hate the chat bots
  • The automated data ingestion is great, but does sometimes make for weird columns
Great for setting up a data warehouse quickly and easily
Not as applicable for groups working with small data
  • 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
Score 10 out of 10
Vetted Review
Verified User
We use Panoply to consolidate our data from everything from our ad networks, to our CRM, to our web and application analytics, to our application data. Tying application usage data to acquisition data has helped us significantly improve our marketing effectiveness and cost efficiency. We no longer have to rely on tenuous application integrations to measure our marketing outcomes.
  • 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.
  • Needs more user control
Panoply is great for smaller organizations where analytics is critical, but it is unrealistic to hire a data engineer or build a data infrastructure. Panoply comes as a full data stack out of the box.
  • There is no question that Panoply is more affordable than many building and managing similar solutions
Panoply's time to value is much more rapid than Redshift, BigQuery, or Snowflake.
Return to navigation