View the dashboard here -> datastudio.google.com/reporting/03b3aed8-42e1-4423-bea9-e37b8e4e0f86 View the sheets and suggest an improvement-> docs.google.com/spreadsheets/d/1zx6fgkiircU-p9ghbc_ssjbboJXynvCN_peFPVXVmCY/edit?usp=sharing
I would possibly suggest adding two more rows for comparison: 1) Data modeling (data prep) coding effort level supported (no-code,low-code, medium-code,high-code) 2) Max data set size supported for data prep
Thank you - I agree with those and have added them to the Sheets. Please contribute if you have that information for any of the tools by leaving comments on the link below and I will integrate them: docs.google.com/spreadsheets/d/1zx6fgkiircU-p9ghbc_ssjbboJXynvCN_peFPVXVmCY/edit#gid=632026672
Great stuff ! Q : why would you think Thoughspot picking up pace ? Your comparison is great but I am not able to justify why people would use any other tool than power bi or tableau, so would be great if you can integrate a section for targeted use cases where each are market leaders or differentiators.
Great review and analysis 👏! You factored in "common use bias", "Web search bias", and market share ownership. Then went into price, os system compatability, cloud agnostic, and other actual best business fit factors.
I do believe that power bi is the most popular, even though the desktop version isn't supported by Mac or any other system than windows. Power bi is much more convenient than most of the tools in this analysis. But I still find Zoho analytics more flexible for me. The reason is that when it comes to data transformation, in Zoho analytics you can actually create tables using SQL functions from the row data you import whereas in power bi you can only use the join functionalities followed by filtering and standard data manipulation. Also changing themes and colours is really time consuming in power bi pivot tables or 'matrix'.
Great comparison. The only criticism I have is that Stackoverflow is probably the most useful source of social interaction for each BI tool, but it would be useful to see the graph in terms of % of each tool questions divided by total BI tool questions, not divided total questions on Stackoverflow.
Thank you for the comment and glad it is useful! Per the criticism - I think it's a matter of me just clarifying this better on the graph - the 0% ones are pretty much all non-existent tags, so you can't find anything about them on Stackoverflow.
@@projectexalia Ah I see, thanks. Yes that is useful info and clarifies things about the comparison. If you run the same script next year, and the year after, etc, the alternative graph will give you a better info of the change year to year.
Great comparison, but what do you think if we are not only compare the tools but also include the whole platform? like "AWS + QuickSight" or "Azure + Power BI" or "GCP + Google DA"
I think if someone has particular experience integrating these or multiple they can share theirs - my intuition is that there will almost always be some advantages that cloud providers will offer for using their own BI solution and connect it to their platform, but then you still want to consider that QuickSight and Data Studio are quite limited at the moment in comparison to Power BI, so it’s not exactly a substitutable situation if you have more complex use cases. I think few years down the line they might be more equivalent though in which case your logic would make sense
Hello! No offence, sorry if you think that's "too much" for a question, please, I understand if you won't answer. How much time did you spend on the whole analysis process? (excluding video recording) Thank you!
Personally, I hope that Google/Looker will be able to deliver a better solution than Power BI and I'd be keen to move to that if that happens. At the moment, I stick to Power BI due to the functionality, but I definitely dislike Microsoft's clunky products and poor UX/UI experiences.
Hi Gerald, it's a fair point - unfortunately 2021 is the latest versiont that has come out yet and it is considered one of the most reliable reports, so I decided to include it as another reference point. I will likely release a new version of this video every year to keep things up to date.
Great question! I need to do research on this, but I assume there would be more job opportunities and demand for people who use Power BI. Hard to say how that affects salary, but certainly helps with peace of mind.
It is a good comparison, thank you for your efforts! However, as a long-term QlikSense user and developer I find it is way to underrated in this comparison. Imho it is way better than tableau, PowerBI or Looker, but that is an image problem QlikSense has since a long time and which their bad marketing has to solve. It was the only tool that did have a question mark in your last row, indicating that you couldn't find something on it. Your last statement about only tools with cloud offerings being able to survive is correct (even though on-prem still is very important for some companies) but you make it sound like qlik does not offer Cloud Integration, which is incorrect.
Thank you for sharing your perspective on QlikSense! I find it valuable to learn about your experience and am sure it will also be valuable to other people viewing your comment. What I meant by the cloud offering is that customers, according to my research, are heavily biased to adopt BI tools that are owned by the cloud provider they already rely on heavily. This means people would be biased to adopt QuickSight if they use AWS or adopt Looker/Data Studio if they use GCP. Moreover, some cloud providers also throw in further deals to encourage that. In that regard, I believe tools like QlikSense would be hurt long-term unless they can really ace marketing and functionality (and not only they have to be better and more innovative, but cloud providers often have way more money to throw at their BI tools)
At the end of the day, it's how well the tool perform in day to day. and in no where this comparison is showing that. I have used both Power BI and Tableau for number of years and I make dashboard for a large company. Tableau is the best by far for developing advanced dashboards and sharing with large audiences within/ outside of your organization, who are either in or out of the Microsoft ecosystem. Tableau is just faster, easier, and more intuitive, it all thanks to the backend stuff they have developed since 2003, and i don't see power BI catching up to that any time soon.
Personally I think Power BI is so popular now because it's super cheap and its Microsoft users base. However just like most of the MS product it's buggy and slow once you need to deal with large volume of row and data modeling. Ours worked like elephants and it's prone to crash from time to time. Tableau seems to be better but in our company it's still waiting to be seen if rollout is as expected.
The browser version is heavily handicapped and can’t really be used as standalone You can’t really even create a dashboard directly on the browser, you have to create it on desktop first and publish it.