Panoply

4.0 (21)
Write a Review!
Data warehousing and transformation

About Panoply

Panoply streamlines data from source to analysis. As an all-in-one data management solution, Panoply helps business users sync, store, and leverage all of their data, without complicated code. Drive insights fast by building a single source of truth for all your reporting needs.


Key benefits of Panoply

  • 100+ data integrations

  • Automatic data management with machine learning and natural language processing

  • Unlimited queries and users

  • An ETL engine to create unlimited transformations of data

  • SQL workbench for data querying

  • Images

    Panoply Software - 1
    Panoply Software - 2
    Panoply Software - 3
    Panoply Software - 4
    Panoply Software - 5
    View 6 more
    Panoply video
    Panoply Software - 1
    Panoply Software - 2
    Panoply Software - 3
    Panoply Software - 4
    Panoply Software - 5

    Not sure about Panoply? Compare with a popular alternative

    Panoply

    4.0 (21)
    VS.
    Highly reviewed

    Starting Price

    US$199.00
    No pricing found

    Pricing Options

    Free version
    Free trial
    Free version
    Free trial

    Features

    26
    57

    Integrations

    39
    14

    Ease of Use

    4.2 (21)
    4.4 (89)

    Value for Money

    4.1 (21)
    4.5 (89)

    Customer Service

    4.3 (21)
    4.6 (89)
    Green rating bars show the winning product based on the average rating and number of reviews.

    Alternatives

    Mode

    4.6
    #1 Alternative to Panoply
    Mode is a cloud-based software that helps enterprises leverage business intelligence (BI) tools to extract data from...

    Looker

    4.6
    #2 Alternative to Panoply
    Looker, now part of Google Cloud, is a data platform that makes it simple for anyone to find, navigate and understand...

    SAP HANA Cloud

    4.5
    #3 Alternative to Panoply
    Cloud-based application development tools with database building and on premise systems integration allowing rapid...

    Snowflake

    4.7
    #4 Alternative to Panoply
    Snowflake is a cloud data platform that can enable critical data workloads and secure collaboration. This solution can...

    Reviews

    Overall rating

    4.0 /5
    (21)
    Value for Money
    4.1/5
    Features
    3.8/5
    Ease of Use
    4.2/5
    Customer Support
    4.3/5

    Already have Panoply?

    Software buyers need your help! Product reviews help the rest of us make great decisions.

    Showing 5 reviews of 21
    Nathan Patrick
    Nathan Patrick
    Overall rating
    • Industry: Health, Wellness & Fitness
    • Company size: 5,001–10,000 Employees
    • Used Weekly for 1-5 months
    • Review Source

    Overall rating

    • Value for Money
    • Ease of Use
    • Customer Support
    • Likelihood to recommend 10.0 /10

    Panoply gets the job done!

    Reviewed on 2020/04/30

    The support team behind Panoply is very helpful. We've used the on-site chat function to get...

    The support team behind Panoply is very helpful. We've used the on-site chat function to get immediate help. We've also submitted questions through traditional routes like email. All of which were answered quickly.

    Pros

    The speed to solution is a big win for us. We were able to get a full data pipeline up in running in less than half a day. That's with various data sources and incremental refresh. The UI is easy to use.

    Cons

    There aren't really any cons. The platform is in its infancy and I can tell that the team is listening to user feedback and already making updates.

    Alternatives Considered

    Looker, Mode and SAP HANA Cloud

    Reasons for Choosing Panoply

    Snowflake was too costly and still required in-depth coding and platform knowledge to quickly spin up a data pipeline.

    Switched From

    Snowflake

    Reasons for Switching to Panoply

    The price was perfect and the features met our needs.
    Julian
    Overall rating
    • Industry: Hospital & Health Care
    • Company size: 51–200 Employees
    • Used Daily for 1+ year
    • Review Source

    Overall rating

    • Value for Money
    • Ease of Use
    • Customer Support
    • Likelihood to recommend 8.0 /10

    Excellent starting option for data warehousing

    Reviewed on 2022/07/12

    Was the foundation of my last company's BI pipeline and served us very well. Now they are going...

    Was the foundation of my last company's BI pipeline and served us very well. Now they are going through a painful migration from the old Redshift servers to BigQuery and the cost has tripled. Before I left I was undergoing a migration to BigQuery natively and skipping Panoply as it began to add complexity for us rather than take it away.

    Pros

    Very simple to set up and manage. Still all the core functionality you need in a warehouse

    Cons

    The built in data connectors could be buggy. Particularly Google Analytics with multiple accounts. Integrating with Google Data Studio was also frustrating as we couldn't find a way to share dashboards within our workspace.

    Alternatives Considered

    Amazon Redshift, Google Cloud BigQuery and Snowflake

    Reasons for Switching to Panoply

    much more simple to set up and manage. Reliable monthly cost was easier to get buy in from management
    matt
    Overall rating
    • Industry: Computer Software
    • Company size: 2–10 Employees
    • Used Daily for 6-12 months
    • Review Source

    Overall rating

    • Value for Money
    • Ease of Use
    • Customer Support
    • Likelihood to recommend 2.0 /10

    Customer service is great until you cancel

    Reviewed on 2021/08/10

    Decent product, overpriced for it's function, the support team and customer service team need to...

    Decent product, overpriced for it's function, the support team and customer service team need to get their act together.

    Pros

    We used Panoply to ingest DynamoDB data and send it to the analytics platform for intellegence. The software worked and functioned fine, our we had a simple use case, but it never failed us.

    Cons

    The pricing was really steep for our simple use case and didn't bring the value that the price tag suggests. Ultimately we found a service that is 40% the cost that suites our needs. When I went to cancel there is no unsubscribe button, I had to hunt for a cancellation email address. After going back and forth with the director of customer service, I finally got it cancelled. However, they threw a 30-day notice clause at us causing us to pay an extra 50 days for a product we are not using. Really bad form in my opinion.

    Response from Panoply

    Hi Matt,

    Thank you for your review. We value feedback from all of our customers. I am glad that you had a good experience with our platform and that our platform allowed you to get some insights. I am sorry about your experience with the cancellation process. While we are disappointed when one of our customers leaves, we aim to make the process as simple as possible by following the terms of the signed contract. One of the terms is our requirement to provide 30 days' notice before the next renewal date. We state this in our terms and conditions but apologize for any misunderstanding, and we will work to make that part of the agreement clearer.

    We wish you all the best and hope that we can work together in the future.

    Saurav
    Saurav
    Overall rating
    • Industry: Environmental Services
    • Company size: 5,001–10,000 Employees
    • Used Weekly for 1+ year
    • Review Source

    Overall rating

    • Value for Money
    • Ease of Use
    • Likelihood to recommend 10.0 /10

    Helped me immensely with analyzing netcdf data files

    Reviewed on 2020/04/03

    I am working with Geographical data that has latitudes, longitudes and a variable I am trying to...

    I am working with Geographical data that has latitudes, longitudes and a variable I am trying to analyze. This is a great tool to have for such data structure.

    Pros

    I was introduced to Panoply by a colleague. I was trying to analyze a bunch of climate variables that were in netcdf format. Before I could write a code in Matlab to analyze the data, I needed to know the data structure. For this I have used a combination of F77 and Matlab in the past. However, I wanted to exclude Fortran and have a more convenient way of knowing the basic data structure. Matlab was more powerful with the actual analysis but not with the pre processing. This is where Panoply came in handy. All I had to do was upload the netcdf data file directly into panoply and boom. It gave me the basic structure that includes the number of data points, latitudes and longitudes of the data points and other essential details I needed.

    Cons

    I did not come across any problem in particular for the 2+ years I have used Panoply. Sometimes, It did take a little long to load it if the netcdf file I was working with was a large file but it was not a big deal. Panoply actually was immensely helpful in knowing the data structure of the variable type for which I followed a much more complex procedure in the past before I used Panoply.

    Adir
    Adir
    Overall rating
    • Used Daily for 2+ years
    • Review Source

    Overall rating

    • Value for Money
    • Ease of Use
    • Customer Support
    • Likelihood to recommend 10.0 /10

    A great service to connect all your data sources to and analyze them together

    Reviewed on 2018/05/23

    Pros

    It's really easy to start and add various data sources. You can then create connections between data sources and start building custom reports that show you insights and valuable data.

    Cons

    The biggest con I can think about is the lack of built-in visualization tools. At the moment if you want to see your data visually you must use an external software. Hoping they would get around to adding it soon!

    Showing 5 reviews of 21 Read all reviews

    Panoply FAQs

    Below are some frequently asked questions for Panoply.

    Panoply offers the following pricing plans:

    • Starting from: US$199.00
    • Free Trial: Available

    See the latest pricing at https://panoply.io/pricing/

    Panoply has the following typical customers:

    Self Employed, 2–10, 11–50, 51–200, 201–500, 501–1,000

    Panoply supports the following languages:

    English

    Panoply supports the following devices:

    Panoply integrates with the following applications:

    AdRoll, Airbrake, Amazon Cloud Search, Brightpearl, Buffer, Crashlytics, Criteo, Dropbox Business, Epicor Advanced MES, Flurry, Google Ads, Google Analytics 360, Google Drive, HubSpot Marketing Hub, Intercom, JIRA Service Management, Librato, Looker, Mailchimp, Marketo Engage, Meta for Business, Microsoft Excel, Mixpanel, NetSuite, Outreach, Quickbase, Salesforce Marketing Cloud Account Engagement, Salesforce Platform, Salesforce Sales Cloud, Shopify, Sisense, Stitch Labs, Stripe, Tableau, Trello, Twilio, Twitter/X, Typeform, Zendesk Suite

    Panoply offers the following support options:

    Email/Help Desk, FAQs/Forum, Phone Support, Chat

    Related categories

    See all software categories found for Panoply.