We performed a comparison between Google Data Studio and Microsoft BI 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.
"The solution is free so that is a good feature."
"I am impressed with the tool's scheduling mechanism, refresh mechanism, and different types of charts."
"Data Studio integrates seamlessly with other Google products, and we can use it with other APIs if we like."
"I like that I can use Power BI to upload data. That is very important for me. The visualization is also convenient and easy to use."
"Power BI allows you to create user defined charts which is really useful."
"I like all the tools in Microsoft BI because they all have different purposes. There are a lot of people using Microsoft BI, and everybody is using it. The users have adapted well to the technology."
"We have found the product very stable and reliable."
"What I like most is that I can do everything in Power BI that I can do in Excel."
"There are some great automation elements in the product."
"I like the fact that Power BI lets me use Excel data. At least 90% of my state data is in Excel spreadsheets. Having the ability to just attach a spreadsheet as a data source is very, very important. It's also good for training and teaching. Sometimes you don't always have access to a live production database, so having a spreadsheet with sample data is always nice."
"We have found the solution to be stable."
"When you physically install a product on one machine instead of the cloud, you have a better visibility, best icon quality, etc.. It's more of an issue with how we are adapting to the transition. We are still in the early moments of using this tool, and we need to go deeper to discover some improvements."
"Stability and scalability an be improved for a full ten."
"The tool should come up with data modeling layer features that are present in other products like Power BI."
"My main complaint is that the error messages need to be made more clear. Currently, they are either too generic or outright misleading, and finding the real problem is like searching for a needle in a haystack."
"The integration in Microsoft BI could improve for other solutions, such as Oracle DB and PostgresSQL. Additionally, the reporting from the databases to Microsoft BI should be in real-time and the overall performance could be better."
"I believe there is room for improvement in terms of authentication and certain functionalities in Power BI. For instance, adjusting the width of columns is not easily done, as there is only an option to enable or disable automatic adjustment. This can be a significant drawback for clients who desire more flexibility."
"Microsoft BI could improve by allowing large-size data sources. We have large data sources, and we have problems loading them in Microsoft BI."
"There are some other visuals that are available in the Microsoft marketplace, however, you need to use them via trial and error. There needs to be a write-up about how to use them with a quick guide describing the visual."
"It is not yet ready for enterprises. For a big enterprise data model, it is not so stable, and it also doesn't scale so well."
"The biggest thing with Microsoft right now is better support. There should be more timely support. We can do 90% of it ourselves by the same token. When we're into the 10%, we do not get timely support via Microsoft's support team."
"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."
Google Data Studio (beta) turns your data into informative dashboards and reports that are easy to read, easy to share, and fully customizable. Dashboarding allows you to tell great data stories to support better business decisions.
Microsoft BI is a business intelligence solution that connects to all your data sources and turns your data into insightful and useful business information that is relevant to all levels of the business, ensuring data accuracy, consistency, and security.
Microsoft BI combines familiar Microsoft tools - Office, SharePoint, and SQL server - with extra features for end-users, such as Power View and Power Pivot. This powerful product gives businesses a competitive advantage by allowing end users to better analyze their data, collaborate, and better present their data.
The BI platform empowers members of your organization to make data-driven decisions that drive strategic actions quickly by allowing them to work together easily on the same data, share insights, and collaborate on reports using other Microsoft Office applications.
Microsoft BI Benefits
Some of the benefits of using Microsoft BI include:
Reviews from Real Users
Microsoft BI stands out among its competitors for a number of reasons. Two major ones are its integration options and its data analytics capabilities.
Tariq R., an operations & BI analyst at American Hospital Dubai, writes, “Power BI is a complete ecosystem. It has an integrated ETL tool and good connectivity with applications such as Office 365 and SQL. 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. ”
Google Data Studio is ranked 14th in Reporting with 3 reviews while Microsoft BI is ranked 1st in Reporting with 102 reviews. Google Data Studio is rated 7.4, while Microsoft BI is rated 8.0. The top reviewer of Google Data Studio writes "The cloud environment makes it easier to use large volumes of data and collaborate with coworkers". On the other hand, the top reviewer of Microsoft BI writes "User friendly, easy to set up and great for analyzing data". Google Data Studio is most compared with Amazon QuickSight, Looker, Tableau, Databricks and RStudio Connect, whereas Microsoft BI is most compared with Amazon QuickSight, Tableau, KNIME, Domo and Oracle OBIEE. See our Google Data Studio vs. Microsoft BI 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.