We performed a comparison between Microsoft Power BI and QlikView based on real PeerSpot user reviews.
Find out in this report how the two Reporting solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Its seamless integration with Microsoft products, such as Microsoft SQL Server or Microsoft Excel, is the most valuable."
"It ingegrates nicely with Office 365."
"The interface is very fluid."
"Provides good data flow related to the container and control flow."
"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."
"There is a lot of variety in Power BI. In particular, the visuals are quite rich and the feature set has been growing rapidly in the last two years. Possibly the best part for me is that there are a lot of ways to connect with data sources."
"It is useful for bringing visualization to data. It calculates counts, ratios, etc."
"It integrates with all of the Microsoft tools."
"One of the good thing is that you can integrate different data source technologies. So you can model your environment without having any of our views running."
"Data transforming with scripting, and the associative model that lets users browse data in an easy way, are the most valuable features."
"I had the option to prepare data myself instead of always having to depend on the data team."
"The initial setup is not very complex."
"The search feature: ability to see the related data."
"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."
"You can switch views easily."
"QlikView is one of the strongest tools, I would say. Also, it has a very vast capability to process the data"
"I have a little problem with Synapse Analytics because it's very new. It's a product that has many capabilities, but it is not very well developed. I have to see the list of permissions from one object. I can't do this in Synapse. I have to search on the web for a solution because I don't have the tool for it."
"Right now, their premium pricing is keeping us out of the premium market. The premium price per user just doesn't make sense for us, but we haven't reached the limit of 500 users to justify the premium."
"I would prefer that the solution not be shared. I'm concerned that if we make a mistake we could reveal information to people who shouldn't see it. I would like to have my own on-prem server, to buy my own server and have my own infrastructure for Microsoft BI, with only with my data."
"I'm not overly technical, and so I can't really speak to any shortcomings from a technical standpoint."
"Microsoft should offer additional features for visualization and have additional features for slicing and dicing that data."
"It is getting better but still, there are opportunity areas in some aspects, especially the Windows OS dependency."
"Integrating it with the physics build model or the engineering model should be included."
"Microsoft BI typically connects to a database, often SQL Server, but it's also capable of connecting to multiple databases, pulling data from them, and allowing for data consolidation. You can then aggregate and generate dashboards and reports from this combined data. Personally, I wouldn't claim to have the expertise to suggest significant changes or additional features, as it functions quite well as is."
"If a user wanted to see something not included in the application the new object had to be created by a power user or developer because Qlik view's scripting has somewhat of a learning curve."
"Enhancing user-friendliness would be highly beneficial."
"There is a lack of static PDF report generation and automatic resizing of the dashboard to fit the device."
"The user interface is old."
"QlikView certainly lacks in its ability to share visualizations or create visualizations easily."
"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."
"The only thing I would improve about it is the fact that it refreshes all the time, and when it does that, it just deletes all the options you had, all the filters that you had selected, so you need to select them from the beginning."
"I would want them to have more options as a user. It would be nice for them to create their own dashboards and add fields."
Microsoft Power BI is ranked 1st in Reporting with 297 reviews while QlikView is ranked 5th in Reporting with 158 reviews. Microsoft Power BI is rated 8.0, while QlikView is rated 8.2. The top reviewer of Microsoft Power BI writes "A complete ecosystem with an builtin ETL tool, good integrations with python and R, and support of DAX and Power Query (M languages)". On the other hand, the top reviewer of QlikView writes "Useful for data visualization and business intelligence". Microsoft Power BI is most compared with Tableau, Amazon QuickSight, KNIME, Domo and Oracle OBIEE, whereas QlikView is most compared with Tableau, Amazon QuickSight, SQL Server, TIBCO Spotfire and IBM Cognos. See our Microsoft Power BI vs. QlikView report.
See our list of best Reporting vendors.
We monitor all Reporting 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.