We performed a comparison between Microsoft Power BI, QlikView, and Zoho Analytics based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Tableau, Oracle and others in Reporting."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."
"I like how the Query Editor lets me manipulate the data, and the available visuals are good. You can do everything using the UI."
"The Microsoft Power BI app is very good. It's also very flexible."
"Everything that's in M Query and DAX is the heart of Power BI because with these tools you can make up for a lot of other missing features."
"It's a straightforward setup."
"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."
"The product is intuitive and user-friendly."
"One of the most valuable aspects of this tool is its ease of use and the ability to easily share information with others."
"On the positive side, QlikView's scripting is a great asset as it functions as an ETL."
"The most valuable feature of QlikView is the integration with other third-party tools."
"A well designed app brings freedom of inquiry to meetings, allowing me to answer questions in real time and this has transformed progress and outputs of our monthly group meeting."
"E-T-L, The Extract, Transform, and Loading capabilities of QlikView make it a highly sophisticated self-service business intelligence tool for developers and analysts."
"It is useful to use a tool like this to have a view of data at a point in time. You can extract and create little data sets that you can store, and then over time, you can have a view for tracking changes. Especially when you work with a relational database or a database that's a production database, the data is dynamic, but if you use QlikView, you can take a snapshot of different datasets. In your own time, you can then get insights and report, build, analyze, and draw whatever you need from the data, which is quite useful."
"The language support is very good."
"We use QlikView for its cost-effectiveness and ease of integration with databases."
"The most useful feature of QlikView for me is the QVD concept."
"The front end of this solution including the graph generation using SQL has been most useful."
"The solution’s dashboard is very good."
"We use the solution for financial and sales analytics. It brings data from our IT incident management tool. Hence, we have three business use cases for IT support, sales and financials."
"The data source is the most valuable feature as it can perform any function."
"The initial setup is straightforward."
"I like the way I can share dashboards and embed dashboards. I normally use embedding. So, I create a dashboard, and I embed it into specific websites. Sharing of the dashboard is seamless, and it is easier than any other visualization platform, even Tableau."
"We really like that it's user friendly and has a lot of combinations and charts. They're good compared to other tools. We used a free Elastic product, comparatively, this solution is good because of their support, UI, and connecting to databases is very easy."
"It's a very strong analytics tool."
"Microsoft should offer additional features for visualization and have additional features for slicing and dicing that data."
"The integration with other solutions could be improved for reporting aspects."
"It's not really complicated, but I didn't find the things I was looking for. The ones I used to work with within Dash are more open, and there are more choices. But with Power BI, there are only limited types of plots that I can use. For example, when I wanted to put the plots in Power BI, there was no extendable space. You have a limited page where you can place a maximum of three plots in that, and you can't do more than that on a single page. You have to create a new page, a different page for that. That made it a bit annoying, and the filtering part is limited, with basic functions. If you want to make custom filtering or custom functions, you can't do that."
"The solution could be more customizable and you do not have too much freedom on the code."
"I would like for there to be some type of user manual that shows steps on how to navigate the solution."
"BI is scalable, but there are some problems with limited online storage."
"I would like to see a more user-friendly interface with Microsoft BI."
"It's quite difficult to learn how to use Power BI."
"It needs work with visualization."
"The solution should be mobile-responsive. It should also include drag-and-drop and slice-and-dice features."
"Better source data connectors."
"There is a lack of static PDF report generation and automatic resizing of the dashboard to fit the device."
"They could provide a user-friendly analysis process rather than specialized IT resource code."
"This solution would be improved with the inclusion of a feature that would allow us to add a common library of (our) commands used in load scripts and expressions, so with a keyword, we would get a drop down to select the command we are looking for, as opposed to the generic help."
"QlikView certainly lacks in its ability to share visualizations or create visualizations easily."
"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."
"The navigation on the interface is not intuitive."
"There is a limitation that we cannot create more than 300 columns in a worksheet on Zoho Analytics."
"The hourly pricing needs improvement."
"There should be more types of graphics available for use in the reports."
"The customer service and support for this solution could be improved by faster response times."
"In terms of improvement, they have a limited number of graphs available in their store. They should come up with more graph style forms. They should have more charts and at the same time, you can't create panels like with Microsoft BA."
"A higher degree of artificial intelligence could be included in this solution. The data and overall insights could be improved."
"I like the solution's Query Table feature which helps me write SQL queries. We can get data from different tables and then use it to create reports."