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."It's a powerful platform."
"Its data visualization provides the user the ability to quickly look at data and focus on relevant information, allowing them to make an immediate decision."
"Microsoft B's beneficial features are that it is a Microsoft product and it is well known by the staff here in the company. It suited the available skills."
"You can learn a lot of things quickly using resources like ChatGPT or Microsoft's own solutions, which are very helpful within the Microsoft ecosystem."
"With Power BI, you're able to store your data within spreadsheets and SharePoints, and then have Power BI pull the data out and report on it. So we actually saved a ton of money not needing to load the data into databases, which is a big prerequisite for many other reporting tools."
"Its connectivity with other Office applications, mostly with Excel, and the ability to deploy it very easily are the most valuable features. It comes sort of bundled with the cloud, so you don't need to set up a server and a standalone infrastructure. So, getting into the system or building something that you can deploy is very easy and very cheap. With other systems, you need to have a server, and you need to have a license for the server. The initial setup is very costly."
"Premium features that used to cost $5,000 per company per month recently became a lot more accessible. Microsoft recently implemented a per user feature in Power BI Premium; it's $20 per month."
"It integrates better with other Microsoft products. It is very easy to use and has very powerful visualizations. It has also got a lot of development going on."
"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 features I find most valuable are 'Discover,' 'Formulate,' and 'Model.' I use them regularly to build logic and create reports for my job."
"The on-premise version has quite good scalability."
"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."
"It seems quite performant in analyzing multi-dimensional information sets and presenting them."
"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."
"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."
"The most valuable feature of QlikView is the integration with other third-party tools."
"If you correctly use the product for your use cases, it provides value for money."
"Its ability to build, very quickly, very complicated models."
"This solution has simplified getting to and understanding our data, no matter where it is housed."
"Data transforming with scripting, and the associative model that lets users browse data in an easy way, are the most valuable features."
"On the positive side, QlikView's scripting is a great asset as it functions as an ETL."
"The integration with Salesforce has helped us gain access to crucial sales data in real-time."
"The user interface and dashboards are very good."
"Not having to login again after a mobile app upgrade. A simple login on mobile would be great."
"The initial setup is a little bit technical."
"There needs to be improved guidance and documentation for the initial setup of Power BI as it currently remains complex."
"It has limited performance capabilities in terms of connecting to large transactional databases, but it is fine for simple and quick queries from Excel spreadsheets or one table. The premium level is going to be more applicable for the higher transaction-level databases."
"Microsoft needs to provide more drivers to connect other data sources in a native way."
"It is kept very current, and there is an update literally every month. However, the interface changes quite randomly with no documentation, which is difficult at the domain and architectural level where you're planning things and engaging the business. Things change frequently, and you wonder where has the button for the new report gone. They should provide better documentation on interface changes. It should be better optimized. It is supposed to be a data integration tool, but it is doing relatively simple queries. It has its limitations. For example, you can only pull a number of columns. So, there is room for optimization on its ability to integrate multiple data sources. The desktop tool is very memory-intensive, and again, this is not documented clearly. It requires a heavy CPU and memory use, and it causes your operating systems to become unstable. I would like to see the ability to create datasets within Power BI. Microsoft is promoting Azure as a cloud solution, but it is dependent upon a desktop component, which seems a little bit deceptive. Data set is the basic element that you report from, but it has to be created on the desktop and then published to the cloud. So, you're in the cloud, and you create a data structure or the data flow, but you can't report from that. You have to leave the cloud, go to your desktop, create the data set on your desktop, and publish it to the cloud. You go back to the cloud and create your report by using that published data set, which is very non-intuitive. If you go to the Microsoft Power BI community, this is a common complaint across the entire community."
"The maps in Power BI could be improved. You deal with many maps over the years, like maps of America and Saudi Arabia. The maps aren't detailed enough, and there aren't enough visualization tools. Whenever I want to use a map, I struggle with choosing the right visualization."
"If you need data in real-time, it's not an ideal solution."
"I find that this is quite a heavy, time-consuming tool for developers."
"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."
"It would be desirable to have the possibility to generate a data dictionary, detailing the original physical tables, renamed fields, and derived fields."
"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 the user interface, particularly when it comes to modifying connections between filters and visual components in a dashboard."
"I think the graphic number of charts and components could be higher, at least comparable to Brain Power BI."
"Pyramid Analytics could improve by speeding up data refresh, especially for large datasets."
"I really wish the application was easier to use in the development phase."
"Installation and deployment could be made easier and quicker."
"They could provide a user-friendly analysis process rather than specialized IT resource code."
"QlikView certainly lacks in its ability to share visualizations or create visualizations easily."
"Although Qliktech's road map clearly states that QlikView has a long way to go, most of the R&D effort seems to be benefiting Qlik Sense."
"The solution should be mobile-responsive. It should also include drag-and-drop and slice-and-dice features."
"Improvements are required in the hide and unhide functionality that falls under the layout container feature that has been used in my company in recent times."
"Enhancing user-friendliness would be highly beneficial."