We compared Microsoft BI and Tableau based on our users reviews in six parameters. After reading the collected data, you can find our conclusion below:
Users generally find the initial setup for Microsoft BI to be simple and effortless, requiring minimal time and effort. In comparison, Tableau's setup process can range from uncomplicated to more intricate, depending on specific circumstances and requirements.
Microsoft BI is highly regarded for its impressive capabilities and adaptability, as well as its capacity to retrieve data from diverse origins and create personalized visuals. On the other hand, Tableau is commended for its ease of use, intuitive design, and proficiency in managing substantial volumes of data.
Both Microsoft BI and Tableau have areas where they can improve. Microsoft BI could enhance its user-friendliness, support, graphical and analytical features, cost, performance, integration, metadata management, visualization capabilities, stability, security, compatibility, data management process, support for product management and customer services, and documentation. On the other hand, Tableau could focus on improving its compatibility, performance, memory data concept, architecture, charting and calculations, modeling techniques, visualization options, integration, customization process, report creation, forecast instrument, GIS features, support for business insights and trend analysis, interface, licensing options, automation, write-back capabilities, drill-down functionality, security measures, workflow, and data modules.
Microsoft BI has a potentially high setup cost, particularly for enterprise-level usage. While some users find the pricing reasonable for desktop use, it becomes costly for larger-scale implementations. In contrast, Tableau's pricing is diverse, with opinions ranging from expensive to cheap. Some users perceive Tableau as expensive, especially for smaller firms, while other tools like Power BI are seen as more affordable. Generally, there is a consensus that Tableau's pricing could be enhanced to maintain competitiveness.
Microsoft BI has been highly praised for its return on investment, with users giving it a perfect rating. It is projected to generate substantial revenue growth and achieve breakeven in a relatively short period of 2-3 years. In contrast, Tableau's specific ROI is uncertain, but it is presumed to be impressive based on existing data. Customers have observed a return on investment within a quicker timeframe of 5-6 months.
The opinions on customer service for Microsoft BI are divided, with some users finding it satisfactory while others believe it needs improvement. On the other hand, Tableau's customer service has had a range of experiences, with some customers having positive ratings and others encountering limitations and difficulties in contacting the right people.
Comparison Results
Microsoft BI is praised for its ease of setup and powerful features, but users find it difficult to learn and use, with weaker graphical and analytical features compared to Tableau. The cost is considered high, and users desire better support, a more user-friendly interface, and improved performance. On the other hand, Tableau's setup can range from simple to complex, but it is highly valued for its user-friendliness and customization options. However, Tableau lacks compatibility with certain tools, has performance issues with large data, and needs improvement in visualization options and integration capabilities. Pricing is also a mixed opinion, with some finding it expensive. Customer support for both products has mixed reviews.
"The capability to add custom visuals and create Power BI apps. You can package datasets, synchronization details, and dashboards into a single app."
"It's a straightforward setup."
"I like having the ability to connect Excel files as data inputs."
"We have found that the reporting and publishing are great."
"The standard BI visualization capabilities are great."
"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."
"Most of the clients I am interacting with are looking towards Power BI because of the cost and simplicities. It provides an entire feature set and a complete solution. It has tight integration with Office 365, Dynamics 365, Microsoft Technology Stack, and datatypes like R and Python."
"I like data modeling. You can connect with your database, which is quite useful for me. It is a good tool if you have a large amount of data and you want to gather different data and interconnect it. The Power Query functionality is quite an interesting feature. If you have a query in Excel, you can also copy your query and run it in Power BI. Its dashboard is also very nice and not complicated. You don't need to be a developer to be able to use it. I am not an IT guy, and it is quite easy to use for somebody who is not an IT person."
"I consider Tableau to be the best analytical tool available. It's really handy to use and can be used by non-technical people."
"The most valuable feature is the ease of use."
"It has a shallow learning curve and so you can go to market very, very, very quickly."
"Tableau's most valuable features are user-friendliness and have a connection between multiple source systems. You can publish a report by using Tableau Public and there you can make your data online, not only batches of data, you can use it as an online analytical tool."
"There are already connectors to almost every single major database and service that you can possibly think of."
"Scheduled extract and the multiple connectors are fantastic!"
"From the data science point of view, we use it for model building purposes. For example, if we are using it for a bank and we want to understand how much loan the bank can provide, we can use visualization to show the educational qualification, salary, gender, and city of a customer, and by using this information, we can arrive at the loan amount that this person is eligible for. I can also use it to view all prospective customers, so essentially, this is going to help me in model building as well as in understanding and segmenting customers and doing forecasting and predictive analytics. We use model widgets, and we can create thousands of visualizations, such as motion charts and bubble charts. We can also create animated versions of the graphs and view the data from multiple dimensions. These are the features that we typically use and like."
"I really like the interactivity of the dashboards."
"I am a SAP user and I would like this tool to have more connectors - and to more easily connect to - the ERP or SAP environment."
"If you are having millions of rows of data or you have a large database, Microsoft BI's performance depends upon how powerful your hardware is. When I am handling large amounts of data I do not use Microsoft BI or Tableau because of this, I use D3."
"You do need to do some hard coding for certain things in Microsoft BI."
"SQL Server Reporting Services (SSRS) is not user friendly."
"They can improve it in terms of rule-based security. Currently, it has very limited rules."
"Its performance and stability can be improved. It takes time to load, and sometimes, it also breaks down for the whole region. Its usability could also be better, and it could also have more connections with different data sources."
"The dashboard could be simplified."
"The licensing needs improvement. There needs to be a middle option between Pro and Premium versions."
"Lacks machine learning algorithms that you can implement using R, SPSS Modeler, and Python."
"The pricing is a bit higher than the competition. They'll need to lower it to stay competitive."
"With Tableau, there is a gap in its ability to handle very large-scale data."
"We would like a report model, because currently there is no schema that we can create in the tool."
"An advanced type of visualization is a bit tricky to create. It has something called a Calculated field, and that sometimes gets a bit difficult to use when you want to create an advanced type of visualization."
"Formatting controls could use some improvement."
"Provide additional enhancements in any business process: Operations, Marketing and Sales, Finance, Human Resources, Logistics, etc."
"When it comes to visualizations, Tableau has a limitation as compared to Power BI. It has a limited set of visualizations. Power BI has the entire marketplace, so you can connect and import many visualizations and use them, whereas Tableau has only 10 or 15 visualizations. There should be more visualizations, and there should also be data integration with more cloud providers."
Microsoft Power BI is ranked 1st in Reporting with 297 reviews while Tableau is ranked 2nd in Reporting with 290 reviews. Microsoft Power BI is rated 8.0, while Tableau 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 Tableau writes "Provides fast data access with in-memory extracts, makes it easy to create visualizations, and saves time". Microsoft Power BI is most compared with Amazon QuickSight, KNIME, Domo, Oracle OBIEE and MicroStrategy, whereas Tableau is most compared with Amazon QuickSight, Domo, SAS Visual Analytics, Databricks and SAP Analytics Cloud. See our Microsoft Power BI vs. Tableau report.
See our list of best Reporting vendors and best BI (Business Intelligence) Tools 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.
Sorry to hear you have to move to Report Builder. Tableau is superior by a long shot! Find another gig. Don't go backwards. Move forward with Tableau !
Tableau is more suitable for somebody that is not developer and it's very easy to use and to create great visual presentation. For developers Report Builder would be more domestic.
It is really the outcome and target goals that are achieved with the right set of BI solutions,people using it to add more efficiency and productivity at all fronts is the kind of result you want to see. Tools include human and technology bonded together to produce results, After all it is the function of both parties to work together, collaborate and share resources together. In the human perspective we look at the training and how best we can create solutions . With the BI solution it is the way we distinguish between the existing solutions that will to the best of its capability serve our business interests and requirements.
Current business leadership include the VP of Finance, so determining a business case was and is a problem for him and those directly under him. So is a no my problem.
Thanks,
Rich
Rich- What is it that current leadership perceives as lacking in the current reporting tool set?
Why change if the only benefit is features or a products capabilities?
Can the products features and capabilities be exploited?
By who and when?
How does that make money for the company?
Increased profit?
Cost reduction?
Increased resource utilization?
Fewer days for order to cash?
Reduced collections?
Better on time shipping?
Faster production?
Increased gross margin?
Reduced inventory?
You get the picture. It's the people that make the difference. Not the tool!
What is it that we need to know to grow our business constantly and continuously?
Every tool mentioned can do really great "stuff".
But what "stuff" does your company need?
To answer the initial question: Every change is difficult without buy-in from the stakeholders.
People love change. What they don't like is change without benefit. Perceived or real.
I hope this helps you a little to better meet the challenges you're facing.
I wish you the best.
Reading through the responses from all you knowledgeable persons out there is so very enlightening. It's like sitting in a room and getting your experiences on these tools first hand. Thanks a lot for your inputs, which will help in putting pros and cons for the company to make a trade off and choose over the two.
Rich- What is it that current leadership perceives as lacking in the current reporting tool set?
Why change if the only benefit is features or a products capabilities?
Can the products features and capabilities be exploited?
By who and when?
How does that make money for the company?
Increased profit?
Cost reduction?
Increased resource utilization?
Fewer days for order to cash?
Reduced collections?
Better on time shipping?
Faster production?
Increased gross margin?
Reduced inventory?
You get the picture. It's the people that make the difference. Not the tool!
What is it that we need to know to grow our business constantly and continuously?
Every tool mentioned can do really great "stuff".
But what "stuff" does your company need?
To answer the initial question: Every change is difficult without buy-in from the stakeholders.
People love change. What they don't like is change without benefit. Perceived or real.
I hope this helps you a little to better meet the challenges you're facing.
I wish you the best.
I wouldn't feel too sorry, it is a very good group to work with. After a lot of years working in IT both in the US and Europe one of the things I find interesting is that Americans in business, especially with regard to software, feel they must have the latest, greatest and most feature rich everything when very often being a little behind the bleeding edge gets the job done and costs less. The real issue is to look at the problem being solved and find good enough while keeping an eye on where you are going.
Having said that took a brief look at the link you indicated and I like the fact that it runs on Linux. Thumbs up on that aspect.
Thanks,
Rich