Panoply Reviews

Panoply makes it's so easy and efficient to manage your data from multiple sources and transform it for Power BI. On top of that, the entire team from wo to go is so helpful and supportive and always on call to troubleshoot any issues that may occur.

There is literally nothing I dislike about Panoply.

It's enabling me to display insights that are otherwise difficult for my consulting clients to obtain.

The team are fantastic - support is quick and effective, with issues and questions being resolved quickly. One of the key value points for us is the ability to request custom connectors, built by the Panoply team - this means I don't need to resource this requirement and can focus my team on delivering insights, not developing data pipelines

I haven't found anything I've disliked about Panoply. The solution overall is fantastic and has helped us achieve key business objectives around reporting and insights at a relatively low cost and in a much shorter timescale than we thought possible.

We're using Panoply to consolidate multiple business data sources without having to build or maintain data pipelines or associated infrastructure. We've been able to build out a fully-fledged reporting and insights capability for our business in a matter of months - using Panoply, we were able to go from data loading to insights in just a couple of hours.

- Ease of Use - Easy to use platform enabled us to get to a proof of concept on our data pipeline in a single day. We were connecting several data sources, some of which were non standard. The platform was able to pull in the data we needed flawlessly for all of the commonly used data sources

- Removed Human Error - The automated system appears well designed and eliminated any human error in our reporting process

- Informed, Effective Customer Service - They had BI Analysts /Data Scientists on staff who were able to jump in and create custom connections to some of our nonstandard data sources. They even offered to help with some of the data blending that we were doing. This effectively lowered the bar and shortened the time to value for our organization

Have very little bad to say about the product and team. Their product is a bit on the expensive side but it is certainly worth the cost to have professionals able to trouble shoot any issues that may arise

Panoply enabled us to set up a data pipeline in days so that we could focus on pulling insights out of our data and not managing and coding up connections to several data sources.

Panoply reduced our reliance on manual input by a very wide margin. In turn, this increased our confidence in data by cleanly aggregating and storing multiple datasets from multiple tenets, removing user-errors and greatly reducing the associated need for time-intensive Q&A of manual inputs. The end result is that Panoply freed up team resources to focus on what they do best - provide meaningful insights to promote change and decision-making both internally and with our clients.

Their customer service has improved since our onboarding considerably. It's clear they've made strategic investment here. Our reps were hands-on and very communicative as our data needs changed and shifted with company scale, both up and down.

Our databases are now stored in the cloud more safely intelligently, and we're leveraging ETL in a more automated way across a wide variety of datasets, both digitally and measurements of real-world impact. We have more time and resources to solving more complex data challenges at the source, rather than downstream.

Panoply has been a very straight-forward and simple-to-use solution to bring together our data. Because of its ease-of-use, we don't spend much time maintaining it or worrying about it. It doesn't get "in the way". Instead, it helps us.

You have to pay attention to whether you really want a particular set or, really subset, of data in Panoply. You have to have a good strategy for that, or you end up consuming too much of your storage and can run the risk of over-running. Basically, you do have to pay attention.

Panoply makes it easy for us to quickly analyze our data regardless of the source and it does so for people who are not necessarily data experts in their normal roles. It somewhat democratizes access to data.

Ease of use, scheduling options, and admin tasks they perform on RedShift

Not much - perhaps an enhanced dashboard (or API access to underlying data) to see job history / run-time / failures / rows written, etc. The data is available to view and we do get noticed when a job fails, but a better dashboard would be a nice addition

They do a very good job. There are more robust "Transformation" like solutions and other solutions which may have more bells and whistles re: interface or job frequency every XX minutes, but you have to ask yourself several questions: 1) do you really need all of that functionality or is it a nice to have, 2) do you want a system is dependable and easy to use, 3) does your exisiting system have a very easy learning curve, what would you do if a key employee left (your data migration admin, for example), 4) do you want to pay by the amount of rows you move (Panoply does not charge that way) or the datawarehouse capacity you have. We have looked at a number of others over the years but could not justify the incremental cost (both to migrate and then recurring costs) .

Mass data transport on varying schedules from source systems in different formats (csv, xlsx, Google Sheets, SQL, Postrgres, SAAS applications and the like) to a platform in which we can transform and ultimately build datawarehouse. We follow ELT and not ETL.

Speed, Easy

No need for a DB Admin

Good support

Good connections with existing tech stack

When deleting existing tables, 'view dependences' is not always clear on the prompt. Need to run a separate view dependencies query to extract dependent views.

Reporting platform (Power BI) not designed for table manipulation, and ingesting large amounts of data. Panoply creates simple, repeatable tables/views as source of truth.

Those tables are then fed into other systems, such as commissions management to process commissions. Because table manipulations are done in panoply, there is little need to manipulate data in commissions software.

That ways, both power bi and commissions sw are on the page always.

The platform is *extremely* easy to set up with reliable data ingestion from lots of commonly needed data sources, and where they're missing, the customer support team's work has exceeded our expectations.

Documentation is lacking in certain places, though that's made up for by customer support.

As a fashion business, we use Panoply to bring together our scattered data under one platform. From Panoply, various stakeholders can extract and analyze the data in their own preferred way but still speak the same numbers across teams.

I don't have to worry about the day to day care and feeding of the database.

The number of data sources can be better, but they are very responsive when requesting adding new ones. Also, their generic connector they developed is working well.

Data is more and more important to be able to answer questions and act on facts not feelings. Panoply helps make that a reality for companies that need to centralize their data and report from it.

Enables us to focus less on maintaining the necessary data infrastructure and spend more time on strategic initiatives and projects.

Some of the data integrations can take some initial troubleshooting.

Has saved us loads of time in data engineering efforts by providing a managed data warehouse (Redshift) and data connections/integrations, allowing us to focus on more business-facing intiatives.