We performed a comparison between Microsoft Power BI, Pyramid Analytics, and QlikView based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Tableau, Oracle and others in BI (Business Intelligence) Tools."Power BI is a complete ecosystem. It has an integrated ETL tool and good connectivity with applications such as Office 365 and SQL. There are also solutions for RPA, such as Microsoft Power Automate and Microsoft Power Apps. Power BI now has integration with Power Query, which has an AI feature for text analytics. Text analytics is a very good feature. This feature is also there in Tableau, but I like it in Power BI because you can write something like, "What is the total sale in the Eastern region?", and it will give you the answer. For example, when you have different types of user opinions, you just run one algorithm and you will have the output that provides the number of positive and negative responses. You can even have a dashboard with positive remarks. This feature has been introduced recently. Power BI supports the DAX and Power Query M languages. These languages are making Power BI very strong in data analytics, and you can do many types of analysis."
"Its ease of use is most valuable."
"Considering that it's Microsoft, it can be integrated with the Power Platform, which is also Microsoft-based, like SharePoint, Power apps, Power Automate, and Power BI, which is the most user-friendly."
"The product is easy to use and simple to navigate."
"We have a lot of servers and applications from which we want reports, and it allows us to create reports from an SQL source or some other source."
"Easy to use. End-users can make changes to the graphics."
"Ease of development and maintenance."
"Good reporting and data analysis tool that's user-friendly, easy to deploy, stable, and scalable."
"It seems quite performant in analyzing multi-dimensional information sets and presenting them."
"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."
"The most valuable feature of Pyramid Analytics, outshining even top-tier platforms like Power BI, is its robust support for DAX queries."
"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."
"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."
"The on-premise version has quite good scalability."
"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 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."
"Easy to analyze data by click-through."
"QlikView is a scalable solution that multiple users can easily use."
"The scalability is there."
"The search feature: ability to see the related data."
"If you correctly use the product for your use cases, it provides value for money."
"It's incredibly fast and can handle large volumes of data without slowing down our operations."
"The integration with Salesforce has helped us gain access to crucial sales data in real-time."
"The solution is fast."
"The product’s on-premise reporting servers could support real-time data refreshing capabilities like its on-cloud version."
"There are some limitations in Power BI; you have to work in the Power BI base. However, if you want something not out-of-the-box and you want something custom, you have to do a lot of work."
"It's not user-friendly; more tutorials, training, and better documentation would be helpful."
"Adding paginated reports to this tool could be of great help for users who want to move away from SSRS."
"If you look at the new tool, even though they promised that you could do data modeling, that you could do everything from the Power BI side, if your data is really large in volume, sometimes it doesn't work on the Power BI. More feature testing from their side would certainly help users."
"Microsoft should offer additional features for visualization and have additional features for slicing and dicing that data."
"We would like it if they added more Python libraries in the Power BI service. For Power BI service right now, you can use Python, but it is limited to a few libraries or a few packages from Python."
"A few features available in Tableau are not available in Power BI. For example. Tableau has the ability to make up the physical layer and all other stuff at runtime. In Power BI, we have to develop a proper physical layer to connect it. The limitation that we normally face is related to the direct query mode. When it comes to the direct query mode, most of the functionality is not working, which is an issue for us. We have to use the direct query mode frequently because the client needs real-time data. They should work on this limitation. There are a lot of other technical things that need to be improved. I am also following the Power BI platform and Microsoft Support Center platform on the web where users have put their requirements. Microsoft is also working on improving this solution. In every update, they add new features to this solution."
"It would be desirable to have the possibility to generate a data dictionary, detailing the original physical tables, renamed fields, and derived fields."
"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."
"Pyramid Analytics could improve by speeding up data refresh, especially for large datasets."
"The general amount of negative comments that I am hearing from my team makes me very wary."
"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."
"There is room for improvement in terms of documentation and examples, especially for newcomers like me who are learning both business intelligence and Pyramid."
"I think the graphic number of charts and components could be higher, at least comparable to Brain Power BI."
"Sometimes the filters are disappearing, and I'm not sure why this is happening."
"Enhancing user-friendliness would be highly beneficial."
"It is really old. We are moving towards converting everything into a Power BI environment. We want to have a self-service type of BI environment where different levels of users in organizations can log onto a portal and retrieve the data they need or get the necessary insights for decision-making that's important for them or their business unit. They have built a new version of QlikView called QlikSense, which probably competes with newer BI tools, such as Power BI, but they are far behind. That's why we are moving towards a newer tool that's easier to use and has more visualizations to represent the data."
"For me, it is important to have a mix, what is the "view" and what is the "sense", Qlik Sense. They have two tools, but for me it is important to have only one tool, which combines the functions that we have from one side and the other side."
"They should offer the capability to directly access data from SaaS environments, as it would simplify the migration process, and while it may seem like a minor enhancement, it would be beneficial to our clients."
"The pricing is high."
"I would like to see more advanced features from Qlik Sense integrated into QlikView to keep it competitive and up-to-date."
"Scalability really depends on the size of your data and QlikView server architecture. For the biggest data sets, it could become an issue at some point."