"I like the ability to use workspaces with other colleagues because you can work together even without seeing the other team's job."
"Can cut across the entire ecosystem of open source technology to give an extra level of getting the transformatory process of the data."
"Databricks helps crunch petabytes of data in a very short period of time."
"Databricks is a scalable solution. It is the largest advantage of the solution."
"The time travel feature is the solution's most valuable aspect."
"The solution is very easy to use."
"The fast data loading process and data storage capabilities are great."
"The integration with Python and the notebooks really helps."
"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 product is easy to use and simple to navigate."
"The scalability is good. We have 20 people in my organization using this solution and plan to increase usage."
"It gives you an edge if you are on the Microsoft platform. If you have been using Microsoft products for a long time or if you have the Microsoft infrastructure, this is the right tool for you. It has seamless integration with Microsoft SQL Server and other sources, and you get the best of the three things (SSIS, SSAS, and SSRS) in one suite."
"It is easy to use. It has got a desktop where people can develop their own dashboards. Basically, we have figured out how to connect finance contracts and all programs for the government agency. So, they can see everything in a dashboard. So, it is very easy to use from a technical standpoint of view."
"In contrast to what we were using before I think that Power BI has given us more extensive results."
"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."
"The best thing about this solution is that it is very user friendly. It is interactive in terms of visualizations. It is very eye-catching, and it attracts users. There are a lot of options to visualize the data in different drafts and views. I have used different visualization tools, and I found Power BI to be more efficient in terms of performance, user-friendliness, and ease of use."
"Databricks requires writing code in Python or SQL, so if you're a good programmer then you can use Databricks."
"The initial setup is difficult."
"I would like to see more documentation in terms of how an end-user could use it, and users like me can easily try it and implement use cases."
"The integration of data could be a bit better."
"The solution could improve by providing better automation capabilities. For example, working together with more of a DevOps approach, such as continuous integration."
"Costs can quickly add up if you don't plan for it."
"Pricing is one of the things that could be improved."
"Instead of relying on a massive instance, the solution should offer micro partition levels. They're working on it, however, they need to implement it to help the solution run more effectively."
"Power BI's administration could use some work, and the user experience needs to improve because it is a client-based tool. If you want to generate a model or report, you need to use client tools, but client tools are limited for end-users who don't have enough hardware. For example, maybe a client lacks enough memory or CPU power for report generators. If you use a model that requires a massive amount of data, your client will face several problems."
"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 solution could improve by having more attractive graphical charts."
"I think that they can add more types of charts because the selection on the desktop version is limited."
"Anything they can do to improve enterprise collaboration is going to help people get set up and utilize the solution."
"It would be better if they had some video tutorials. Most people from an Excel background may struggle with measures in Microsoft BI."
"Defining a relationship was very confusing. There were circular directions for which I had to do a lot of adjustments in the data. They can do something to make it easier."
"When it comes to improvement, I would say there could be more tutorials for students in universities who are just learning it. And it wouldn't have to be just for students in universities. It might also be for the people who use it in the real world."
Databricks creates a Unified Analytics Platform that accelerates innovation by unifying data science, engineering, and business. It utilizes Apache Spark to help clients with cloud-based big data processing. It puts Spark on “autopilot” to significantly reduce operational complexity and management cost. The Databricks I/O module (DBIO) improves the read and write performance of Apache Spark in the cloud. An increase in productivity is ensured through Databricks’ collaborative workplace.
Microsoft BI is a business intelligence solution that turns data into insightful and useful business information that is relevant to all levels of the business.
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.
Databricks is ranked 2nd in Data Science Platforms with 23 reviews while Microsoft BI is ranked 1st in Business Intelligence (BI) Tools with 155 reviews. Databricks is rated 7.8, while Microsoft BI is rated 8.0. The top reviewer of Databricks writes "Has a good feature set but it needs samples and templates to help invite users to see results". On the other hand, the top reviewer of Microsoft 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)". Databricks is most compared with Microsoft Azure Machine Learning Studio, Amazon SageMaker, Azure Stream Analytics, Alteryx and Domino Data Science Platform, whereas Microsoft BI is most compared with Tableau, Oracle OBIEE, MicroStrategy, SAP BusinessObjects Business Intelligence Platform and QlikView.
We monitor all Data Science Platforms 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.