We performed a comparison between Informatica PowerCenter and Pyramid Analytics based on real PeerSpot user reviews.
Find out in this report how the two Data Visualization solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."We use Informatica PowerCenter to transfer the transitional database to and from the data warehouse. This is very efficient as it enables us to quickly find our data reports and the data, so we can build AI models."
"Once you figure it out, it is a powerful and simple ETL tool. Its stability has been very satisfactory."
"It has a Data Catalog that uses the Model repository."
"The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand."
"The reliability of the product and the way of orchestration of different services is valuable to us."
"Informatica PowerCenter is a very good ETL tool."
"What I like most about Informatica PowerCenter is that it's the best tool in the market for data integration. Currently, I work in L'Oréal, where a new system from SAP is used. Informatica PowerCenter integration with SAP is very, very fast and very, very simple, so you have the server flow from SAP, and through Informatica PowerCenter, you can ingest the data and make that data available for the business more quickly."
"I like the completeness of the way I can build ETL workflows."
"It proved to be a very powerful and useful tool due to its breakdown capabilities, easy reporting features, flexibility in building custom calculations, and the ability to integrate them into reports."
"The features I find most valuable are 'Discover,' 'Formulate,' and 'Model.' I use them regularly to build logic and create reports for my job."
"It offers a wide range of analytics options including statistics and visualizations, as well as prediction capabilities, allowing users to make forecasts based on the latest data."
"Pyramid has a wide level of uses, as it's a complete ETL process and has a good level of connecting to a lot of data sources."
"The most valuable feature of Pyramid Analytics, outshining even top-tier platforms like Power BI, is its robust support for DAX queries."
"It seems quite performant in analyzing multi-dimensional information sets and presenting them."
"The on-premise version has quite good scalability."
"I think the most valuable Pyramid Analytics feature is the solution's ability to drill down and dice in the loop. I think it is better than InExcel or Power BI."
"We need another tool for monitoring. It would be easier if all the features were consolidated into one tool."
"The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"Now they are migrating to a new version, and they have something that is called Informatica Developer. Previously, they just had PowerCenter. Now, when they move everything to Informatica Developer it's not as good or stable like it was when it was PowerCenter, though it has some nice features. This Developer tool could be better."
"An issue which should be addressed is that the solution only allows us to do structured, as opposed to unstructured, data processing."
"The solution can improve by providing more connectivity by having native ODBC or JDBC connections available. It will be easier and more people could start using it."
"Informatica PowerCenter could improve on the documentation for the implementation. The documents provided are not very good for a new user."
"Informatica PowerCenter could improve by having a single interface because half of the system is still in the legacy interface and many other elements are moved to the developer client. It would be good if there was a single interface for the end user and developers."
"What I didn't like about it is that the platform itself is not great at distributed processing. When you need high parallel processing, it has some inherent issues. We had to use Java transformation, and it did not go very well. I have heard that it is going to the cloud, but we haven't tried that."
"I find that this is quite a heavy, time-consuming tool for developers."
"Even though the solution has a functionality for every step, it's not so well- defined. That needs to be improved."
"There is room for improvement in terms of documentation and examples, especially for newcomers like me who are learning both business intelligence and Pyramid."
"The general amount of negative comments that I am hearing from my team makes me very wary."
"I think the graphic number of charts and components could be higher, at least comparable to Brain Power BI."
"It would be desirable to have the possibility to generate a data dictionary, detailing the original physical tables, renamed fields, and derived fields."
"Pyramid Analytics could improve by speeding up data refresh, especially for large datasets."
"There is room for improvement in terms of the user interface, particularly when it comes to modifying connections between filters and visual components in a dashboard."
Informatica PowerCenter is ranked 5th in Data Visualization with 78 reviews while Pyramid Analytics is ranked 13th in Data Visualization with 8 reviews. Informatica PowerCenter is rated 8.0, while Pyramid Analytics is rated 7.6. The top reviewer of Informatica PowerCenter writes "Stable, provides good support, and integrating it with other systems is very fast, but its pricing is expensive". On the other hand, the top reviewer of Pyramid Analytics writes "A comprehensive and user-friendly business intelligence for enhanced data insight". Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and AWS Glue, whereas Pyramid Analytics is most compared with Microsoft Power BI, Tableau, Alteryx, Qlik Sense and Databricks. See our Informatica PowerCenter vs. Pyramid Analytics report.
See our list of best Data Visualization vendors.
We monitor all Data Visualization reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.