TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    pganalyze

    Score9 out of 10
    Small Businesses (1-50 employees)
    Founded in 2012, pganalyze provides actionable insights into Postgres. Specializing in PostgreSQL database monitoring and optimization, pganalyze gives automatic insights into Postgres query plans, helps improve Postgres query performance with its Index Advisor and VACUUM Advisor, and lets the user perform query drill-down analysis, observe per-query statistics and conduct trend analysis in a platform that integrates with both self-managed Postgres servers as…

    $149

    per month per database server

    QlikView

    Score8.4 out of 10
    N/AQlikView® is Qlik®’s original BI offering designed primarily for shared business intelligence reports and data visualizations. It offers guided exploration and discovery, collaborative analytics for sharing insight, and agile development and deployment.N/A
    Pricing
    pganalyzeQlikView
    Editions & Modules
    Production
    $149
    per month for 1 database server
    Scale
    $399
    per month for up to 4 database servers ($100/mo for each additional billable server)
    Enterprise Cloud
    Contact us
    per year per database server
    Enterprise Server
    Contact us
    per year per database server
    QlikView
    Custom
    per user
    Offerings
    Pricing Offerings
    pganalyzeQlikView
    Free Trial
    YesYes
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    NoYes
    Entry-level Setup FeeNo setup feeOptional
    Additional DetailsScale plan offers additional database servers at a cost of $100/month for each additional billable server. In general, each 1 Postgres server that is running (i.e. one parent postgres process) is considered 1 billable server. In the case of cloud providers these are often called "instances". Depending on the subscription plan you are on, you may have a special price for replica servers (also called "readers", or "followers"), which is implemented by multiplying the replica count with a multiplier (e.g. 0.5), with the total rounded up. Annual plans are available and come at a discount compared to the monthly plans Contact us for custom requirementsOn an perpetual license basis, based on server plus number of users. Contact vendor for pricing.
    More Pricing Information
    Community Pulse
    pganalyzeQlikView
    Considered Both Products
    pganalyze
    No answer on this topic
    Qlik
    No answer on this topic
    Key User Insights
    Would buy again
    No answers on this topic
    93%
    Would buy again
    13 Answers
    Delivers good value for the price
    No answers on this topic
    100%
    Delivers good value for the price
    14 Answers
    Happy with the feature set
    No answers on this topic
    100%
    Happy with the feature set
    14 Answers
    Lived up to sales and marketing promises
    No answers on this topic
    89%
    Lived up to sales and marketing promises
    8 Answers
    Implementation went as expected
    No answers on this topic
    88%
    Implementation went as expected
    7 Answers
    Features
    pganalyzeQlikView
    BI Standard Reporting
    Comparison of BI Standard Reporting features of pganalyze and QlikView
    Feature
    pganalyze
    -
    Ratings
    QlikView
    8.6
    68 Ratings
    5% above category average
    Pixel Perfect reports00 Ratings8.050 Ratings
    Customizable dashboards00 Ratings9.766 Ratings
    Report Formatting Templates00 Ratings8.060 Ratings
    Ad-hoc Reporting
    Comparison of Ad-hoc Reporting features of pganalyze and QlikView
    Feature
    pganalyze
    -
    Ratings
    QlikView
    8.1
    67 Ratings
    1% above category average
    Drill-down analysis00 Ratings8.266 Ratings
    Formatting capabilities00 Ratings7.867 Ratings
    Integration with R or other statistical packages00 Ratings8.336 Ratings
    Report sharing and collaboration00 Ratings8.162 Ratings
    Report Output and Scheduling
    Comparison of Report Output and Scheduling features of pganalyze and QlikView
    Feature
    pganalyze
    -
    Ratings
    QlikView
    8.6
    62 Ratings
    5% above category average
    Publish to Web00 Ratings8.049 Ratings
    Publish to PDF00 Ratings9.056 Ratings
    Report Versioning00 Ratings7.542 Ratings
    Report Delivery Scheduling00 Ratings10.048 Ratings
    Data Discovery and Visualization
    Comparison of Data Discovery and Visualization features of pganalyze and QlikView
    Feature
    pganalyze
    -
    Ratings
    QlikView
    7.4
    58 Ratings
    8% below category average
    Pre-built visualization formats (heatmaps, scatter plots etc.)00 Ratings8.055 Ratings
    Location Analytics / Geographic Visualization00 Ratings7.546 Ratings
    Predictive Analytics00 Ratings6.85 Ratings
    Access Control and Security
    Comparison of Access Control and Security features of pganalyze and QlikView
    Feature
    pganalyze
    -
    Ratings
    QlikView
    6.7
    60 Ratings
    23% below category average
    Multi-User Support (named login)00 Ratings8.159 Ratings
    Role-Based Security Model00 Ratings5.355 Ratings
    Multiple Access Permission Levels (Create, Read, Delete)00 Ratings5.555 Ratings
    Report-Level Access Control00 Ratings8.13 Ratings
    Mobile Capabilities
    Comparison of Mobile Capabilities features of pganalyze and QlikView
    Feature
    pganalyze
    -
    Ratings
    QlikView
    8.0
    47 Ratings
    3% above category average
    Responsive Design for Web Access00 Ratings8.044 Ratings
    Mobile Application00 Ratings9.028 Ratings
    Dashboard / Report / Visualization Interactivity on Mobile00 Ratings8.038 Ratings
    Best Alternatives
    pganalyzeQlikView
    Small Businesses
    No answers on this topic
    Cyfe
    Score4 out of 10
    Medium-sized Companies
    SolarWinds Database Performance Analyzer
    Score5.6 out of 10
    Qlik Cloud Analytics (Qlik Sense)
    Score8.1 out of 10
    Enterprises
    Foglight
    Score10 out of 10
    Jaspersoft Community Edition
    Score7 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    pganalyzeQlikView
    Likelihood to Recommend
    9.0
    (1 ratings)
    7.6
    (88 ratings)
    Likelihood to Renew
    -
    (0 ratings)
    8.8
    (29 ratings)
    Usability
    -
    (0 ratings)
    8.0
    (15 ratings)
    Availability
    -
    (0 ratings)
    9.8
    (4 ratings)
    Performance
    -
    (0 ratings)
    8.6
    (4 ratings)
    Support Rating
    -
    (0 ratings)
    3.3
    (15 ratings)
    Online Training
    -
    (0 ratings)
    8.0
    (3 ratings)
    Implementation Rating
    -
    (0 ratings)
    7.4
    (13 ratings)
    Data Sharing and Collaboration
    -
    (0 ratings)
    7.8
    (43 ratings)
    Data Sources
    -
    (0 ratings)
    7.8
    (43 ratings)
    Product Scalability
    -
    (0 ratings)
    8.9
    (2 ratings)
    User Testimonials
    pganalyzeQlikView
    Likelihood to Recommend
    pganalyze
    pganalyze works great with the postgresql and gives a good alternatives to the existing producsts available out there like Slick or basic as microsoft SQL server manaagement studio. We have used in our projects of data migration and integration of enterprise data warehouseing and reporting . And it has provides us satisfactory results.
    Incentivized
    Read full review
    Qlik
    Sales data validations have helped manage our justifications in the past, especially with regard to new product development and new business introduction. It has also been helpful in identifying trends with business impact and direction specific to quarter and monthly sales from ERP data as well as decisions to purchase equipment of staffing based on run rates and product demand.
    One thing that can get out of hand is data output - if you aren't careful in your query, you may be overloaded with data dumps and drown in the amount of info you have to filter through. This is a user caution, not a comment on the software itself.
    Incentivized
    Read full review
    Pros
    pganalyze
    • User and role setup
    • Performance tuning
    • Tracking of queries
    Incentivized
    Read full review
    Qlik
    • QlikView has a simple, relational data model that's REALLY fast. Filtering and changing data is dead simple results are almost immediately available.
    • The free version of Qlikview is almost completely featured, so you roll a pro-level product out to an entire department for really cheap.
    • QlikView is really flexible--if you can imagine it, you can build it.
    Incentivized
    Read full review
    Cons
    pganalyze
    • Visualization
    • Database insights
    Incentivized
    Read full review
    Qlik
    • We found that QlikView can be a bit slow in supporting some forms of encryption. It is web-based and we needed to upgrade all of our server to not support the older SSL and TLS 1 protocols, only support TLS 1.2 and TLS 1.3. However, QlikView could not run with TLS 1.2 and TLS 1.3. We had to wait over six months to get a version that would handle the newer TLS versions.
    • There are so many options with QlikView that you can get lost when developing a visualization. There are still items I have not yet figured out, such as labeling a graph with the name of a selected detail item.
    • QlikView works by pulling the data it is going to use for visualization into its database. I am a security reviewer and I need to make certain that PII and PHI is not pulled by QlikView for a visualization, otherwise this could become a reportable indecent.
    Incentivized
    Read full review
    Likelihood to Renew
    pganalyze
    No answers on this topic
    Qlik
    Ease of use, ability to load from pretty much any data source. today I created an application that loaded time sheets from excel that are not in a table format. With Qlik's "enable transformation steps" I was able to automate loads of multiple spreadsheets and multiple tabs easily. Could not do that with any other tool.
    Incentivized
    Read full review
    Usability
    pganalyze
    No answers on this topic
    Qlik
    QlikView is very easy to implement. The installation is very straight forward. QlikView has several different data connectors that can connect to different data sources very smoothly. The user interface to build the reports is very easy to understand. This helps to have a smaller learning curve. Something very helpful is that QlikView is a browser application for the end users. So, you don't need to install any applications on the user's computer.
    Incentivized
    Read full review
    Reliability and Availability
    pganalyze
    No answers on this topic
    Qlik
    We have not had any downtime issues with the product nor uncovered any significant bugs
    Read full review
    Performance
    pganalyze
    No answers on this topic
    Qlik
    It is not a SAAS product.
    Read full review
    Support Rating
    pganalyze
    No answers on this topic
    Qlik
    My experience with the Qlik support team has been somewhat limited, but every interaction I have had with them has been very professional and I received a response quickly. Typically if there is a technical issue, our IT team will follow up. My inquiries are specific to product functionality, and Qlik has been very helpful in clarifying any questions I might have.
    Incentivized
    Read full review
    In-Person Training
    pganalyze
    No answers on this topic
    Qlik
    My team attended, but I cannot myself rate, but I think it was good as they've successfully launched a training program at our company themselves for users. It was 3-4 day training.
    Read full review
    Online Training
    pganalyze
    No answers on this topic
    Qlik
    Training was as expected. The demo environments tend to be more fully featured that our own environment, but the training was clear and well delivered.
    Read full review
    Implementation Rating
    pganalyze
    No answers on this topic
    Qlik
    "Implementation" can mean a few things... so I'm not sure that this is the answer you want.... but here it goes: To me, implementation means: "Is the user interface intuitive and can I produce meaningful reports with ease?" On that score, I'd say YES. The amount of training required was minimal and the results were powerful. The desktop implementation is a simple, "blank" interface just waiting for your creativity. The pre-populated templates give you a reasonable start to any project -- and a good set of objects to "play around with" if you're just getting started. Finally, note that the "implementation" I used was baked into QuickBooks 2016 Enterprise -- called "Advanced Reporting"..... That integration makes it ultra useful and simple.
    Incentivized
    Read full review
    Alternatives Considered
    pganalyze
    It is better in terms of results provided. We were using Microsoft SQL Server Management Studio so far and relying only on that but some one recommend to us to use pganalyze to do the query analysis and we started using it for one project and we liked it much that we have started recomended to all projects teams ..
    Incentivized
    Read full review
    Qlik
    The only other vendor product that I have worked with that provides a similar experience to Qlikview is Tableau. I would recommend Tableau if your use case is to build a fixed dashboard. You can share reports for free without needing to buy additional licenses. I would recommend Qlikview if your users are looking for a more interactive experience. They can create new objects to represent the data which can't be accomplished as easily in Tableau
    Incentivized
    Read full review
    Return on Investment
    pganalyze
    • Efficient product
    • Good value for money
    • You dont have to depend on external services
    Incentivized
    Read full review
    Qlik
    • You can use the free desktop version to do a lot of reporting and analysis work more quickly so the ROI is huge
    • QlikView is great at finding outliers such as data entry errors
    • QlikView is great at helping you quickly discover new insights about your business that can prompt you to take action that can immediately affect your cash flow.
    Incentivized
    Read full review
    ScreenShots

    pganalyze Screenshots

    Screenshot of Query Performance Overview: pganalyze provides access to historic query data and provides tools to help with optimizing and performance tuning of Postgres databases, including trend analysis, and config tuning recommendations.Screenshot of Query Details Page: Displays detailed statistics on a per-query basis so users can learn what to focus on. pganalyze can also be used to perform query drill-down analysis and observe per-query statistics.Screenshot of pganalyze Index Advisor: pganalyze automatically validates that existing indexes are useful, gives index recommendations to improve performance, and helps reduce load on the database.Screenshot of pganalyze EXPLAIN Insights: pganalyze automatically collects EXPLAIN plans with auto_explain, provides visualizations and gives meaningful insights into Postgres Queries.Screenshot of pganalyze Log Insights: PostgreSQL logs often contain critical details about whats going on in an associated database. pganalyze Log Insights automatically extracts the logs into structured data, and filters any sensitive information.Screenshot of pganalyze VACUUM Advisor: pganalyze helps optimize table bloat, freezing and VACUUM performance - ensuring ideal performance, stability, and efficiency for  databases.

    QlikView Screenshots

    Screenshot of QlikView Sales DashboardScreenshot of QlikView on all devicesScreenshot of QlikView using mobile touch screen