We performed a comparison between Microsoft Power BI and SQL Server 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 is stable enough. It has a lot of powerful functions. It can also be customized with the DAX language. It is also intuitive enough and incremental. You can start with something simple, and then step-by-step, you can increase the reports and dashboards according to your needs."
"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."
"Other people can access data much more easily than before. Its usability is the main advantage, people in the company are using it."
"I like the downloadable visualizations a lot. I think that they give the user a very nice starting point in creating awesome dashboards, with the right way to tell their data story."
"Implementation is very quick and the solution is very user-friendly."
"As it was my first time using Power BI, I can say that it was fairly easy to learn, especially if you already know BI-type tools."
"In the process of using data there is the Extract, Transform and Load (ETL). For extracting we are using another software, for transforming we are using our own coding in C#, and then we use Microsoft BI for loading the information. Microsoft BI displays information very well."
"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."
"The most valuable feature of the solution, compared to other RDBMS solutions, such as Oracle MySQL or IBM DB2, it is more user-friendly and has backward compatibility. For example, if you have an application that requires an old version of SQL Server and you have the latest version of the license, you are able to install and use it in backward compatibility mode. They keep supporting the existing legacy application."
"It is integrated with Microsoft tools."
"Very easy to use, and it's very democratic in the enterprise."
"I use the menu on the management view credit section to get information from the database."
"SQL Server has good performance. It is one of the best features."
"The most valuable feature is easy installation. It was very easy to install."
"The product has been on the market for over 25 or 30 years. It's an extremely mature solution."
"It works fine in terms of performance and stability."
"We did have some issues building the Microsoft blog."
"I would like for there to be some type of user manual that shows steps on how to navigate the solution."
"It could have more of a hold on big data. Manipulating big data on this solution complicates things. This needs to be improved."
"Microsoft needs to do some more research and development to make it more stable."
"One area for improvement in Microsoft Power BI is serviceability. Compared to one of its competitors: Tableau, there are a lot of things which you cannot do in this tool, that can be done in Tableau."
"The UI is the main improvement that could be made. Specifically, there is something called DAX, in Power BI, which is complicated compared to calculated fields used in Tableau."
"You need to purchase upgraded support separately."
"BI is scalable, but there are some problems with limited online storage."
"The interface of the tool has certain shortcomings, making it an area where improvements are required."
"The pricing could be more affordable."
"From a development perspective, the solution needs to be a lot easier to understand or it needs to be easier to implement API packages for connection pooling so we don't have connection interruptions when, let's say, a hundred people simultaneously access the network on a given system, utilizing a specific or single database."
"Indexing, as well as integration, are areas of this product that need improvement."
"SQL Server could improve by providing something similar to an interface or dashboard where a developer can do debugging, this would make a developer's work easier. Additionally, the optimization could be better. If there was an interface showing information needed for the optimization it would help because there can be some data loss making it difficult to optimize the SQL Server."
"Debugging from the debugger tool functionality should be enhanced."
"Due to the fact that I'm dealing with the product more as a data analyst, the SQL Server management studio is really relatively primitive compared to other more advanced tools."
"They could improve the solution by allowing more portability between on-premise and the cloud."
Microsoft Power BI is ranked 1st in BI (Business Intelligence) Tools with 297 reviews while SQL Server is ranked 1st in Relational Databases Tools with 260 reviews. Microsoft Power BI is rated 8.0, while SQL Server is rated 8.4. 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 SQL Server writes "Easy to use and provides good speed and data recovery". Microsoft Power BI is most compared with Tableau, Amazon QuickSight, KNIME, Domo and Oracle OBIEE, whereas SQL Server is most compared with MariaDB, SAP HANA, Oracle Database, LocalDB and IBM Db2 Database.
We monitor all BI (Business Intelligence) Tools 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.
