Tableau vs Power BI
ฝัง
- เผยแพร่เมื่อ 18 พ.ค. 2020
- TABLEAU VS POWER BI // Tableau and Power BI have a lot of similarities when you look at them. But if you’re looking for a tool to implement in your business or want to learn data visualization, you might not be sure which one to pick. We’ll look at Tableau vs Power BI so you can understand how they compare.
Data visualization is rapidly growing in popularity and with it has come multiple platforms to make analysis easy even in the absence of knowing a programming language.
Let’s look at the similarities and differences of Tableau vs Power BI. We’re going to look at 6 criteria in this comparison. These are:
• availability / use
• ease of learning & using
• quality of data visualizations
• performance - or how does it handle large datasets
• data sources
• cost / ease of setup
💡 RESOURCES FROM JEN
• Tableau training: thecareerforce.com/products/t...
• Become a Data Analyst eBook: thecareerforce.com/DA-book
• Become a Business Analyst eBook: thecareerforce.com/BA-book
• Think Like an Analyst training: thecareerforce.com/TLAA
• Build a great resume: thecareerforce.com/TCFResume
• Analytics career coaching: thecareerforce.com/coaching
• FREE analytics career quiz: bit.ly/TCFCareerQuiz
🧰 OTHER RESOURCES:
Tools*: www.amazon.com/shop/thecareer...
DataCamp*: thecareerforce.com/DataCamp
edx*: thecareerforce.com/edX
Coursera: thecareerforce.com/coursera
💬 CONNECT WITH ME:
thecareerforce.com
/ the-career-force
/ thecareerforce
/ thecareerforce
#dataanalyst #datascience
• Tableau vs Power BI
* This is an affiliate link. At no additional cost to you, I will earn a commission if you decide to make a purchase after clicking through the link. I only promote products I have investigated and feel deliver value. - วิทยาศาสตร์และเทคโนโลยี
![[TH] VCT Pacific Stage 2 - Week 4 Day 3 // GEN vs TS | PRX vs ZETA](http://i.ytimg.com/vi/nspkjQuZve0/mqdefault.jpg)
Which do you use?
I am doing data analyst with python on DataCamp
Is it required to do one of these ?
SHUBHANKAR CHAMNIKAR I am about to finish the same course. I love DataCamp, but I believe they just have 1 introductory course on Tableau (which is not part of the data analyst with pythin course). They use Matplotlib/Seaborn more for data viz. Depending on your business environment, you will be able to do a lot with Excel, and Power BI/Tableau or you will need to go further with Python
@@drrogue Thank you!
After completing python
I will grab some knowledge on Tableau/Power BI.
I'll joining college this year. It will take 3-4 years to complete college degree. After 3-4 years. Do you this data analyst will still be in demand after 3-4 years?
@@shubhankarchamnikar3314 I am a current reporting and data analyst. I have subscription for both DataCamp and DataQuest to enhance my knowledge for SQL and Python. Base on my experience, it depends on the project that you work on. My project deals with sensitive data and they dont want anyone to use Python because of fear of third party app's leakage. My PM does not believe much in technology. Most of the time I use Excel to store and organize data. Tableau comes in handy for data transformation for visualization. Its funny that I am the only understand the relational data concept in the project. I have a chance to talk to a FTE of the biggest social media. he told me that excel is still being used heavily in his team and they try to move on to SQL. The process is not easy because not everyone have the basic understanding. In the end, the employer hires you to get the job done so Its better to start with popular tool so you can communicate with the team. Anything more advanced like SQL or Python will add more value to the table later on. Its my two cents
I am not sure if you are right here.
Power BI can handle much more data and Tableau takes way more time to load the data so I dont know where you are coming from when you say power BI cant handle large data.
I am using 100 million rows in my reports on power bi
Totally agreed. I’ve done the same like you and I think the comparison lacks one important aspect, the data model.
I think the author is referring to visualization side, how the viz can handle massive amount of data points. PBI can still struggle here.
@@marshal115 excel can handle all that with power query and power pivot.
I know it too cuz I'm a regular user of excel and powerbi 😆
I think it is correct to say that Tableau can handle more data in the application itself - you can store/save/have access to larger data sets but it is true that PowerBI may have more options for connections to certain Microsoft house products that allow for integration of more data. I think this video was focusing on these platforms as visualization tools and ultimately Tableau is really much better on that front.
@@exploringme4918 I am not sure if you are right here!
Correct me if I am wrong but Tableau cannot even load the data faster than power bi
I regularly work on 100 million rows with around 25 columns and fairly high cardinality in power bi, its very responsive
I mostly use a folders as a data source with multiple CSV files in the folders. Power BI effortlessly connects to the folder and combines the files. I just haven’t found another BI tool that does this so well.
Thank you Jenn for that overview. I'm a master's student currently learning data visualization using Tableau. I will definitely take a look at Power BI Desktop as well since it has earned a lot of popularity.
Very skewed towards Tableau. Power BI is for small businesses? Really? It can process billions of rows of data with no sweat.
I think on the visualization front, Tableau is just the best tool. Tableau can easily produce much more aesthetically pleasing and useful visualizations that make for a seamless user experience when integrated into Dashboards - PowerBI is clunky and not comparable in this way.
I agree with tou here, Kirill. The beautiful integration with MS teams is also very nice. Tableau makes nicer visuals, sure, but they are harder to share and cost 6x power bi and don’t embed as well.
I completely disagree with her assumption as well. There are many ways to optimize the vertipaq engine in Power BI to handle billions of rows. For real-time data the direct query import mode will write queries back to the data source, which will be fast or slow depending on the data storage latency. You can also aggregate fact tables by different data granularities to reduce the size of the model. Overall the vertipaq engine in Power BI does a good job at compressing rows of data, but depending on the number of columns it can slow the model. As long as you only include columns used in the model and your data source connections fit the business case, Power BI is a very powerful tool for big data.
Thank you for this, more then 2 years ago I chose Power BI. It was the right tool for me. The first thing for me was Power BI did not cost anything to have on the Desktop to learn. Tableau on the other hand wanted $$$ to download and learn. Paying for a tool to be able to learn it just does not make sense to me. After companies are moving from Excel to Power BI. Microsoft is doing a great job with Power BI. So for me, Power BI is the winner and with the Power BI Online service and all the different data source connectors it’s a great tool and getting better every single month with each update.
can you tell me a good learning sources of Power BI?
Power bi is better with data modelling and data clean up which are indespensible I think
We have tableau prep
Wrong!!! I guess next you'll say it performs better? Joke!
Yes sorry tableau prep is relatively new so I forgot about the product, I shouldnt have said that. Tableau is better for visualisations for sure
Thanks for the clarification about these two tools
real impressed by your continous speech without voice breaking
Very good information.
I started using Tableau a couple years ago and found it very easy to start using off the bat. About 5 months ago I started working with Power BI as well. At first, I found it a little clunky compared to the elegance of Tableau. Both have great features. After using Power BI, I think I honestly like it a little better than Tableau now. To me, the DAX language it uses is more robust and expansive than what is included in Tableau. When I started working with Power BI, I found myself thinking, 'well it doesn't have this feature or ability like Tableau' only to find that it does in fact.
I do agree with the sizes of datasets that each can handle - Tableau can work with hundreds of thousands or even millions of records with aplomb. However, Power BI is able to have a live connection to SharePoint list data, something that still requires using an Extract in Tableau.
Bro, can u pls tell me abt row limit and columm limit, and importing data from multiple data limit, for both license, can u define pls
Hey Jenn! Loving the content! I mostly use Power BI as it's easier & faster to build and share reports! Keep the videos coming!
I’d love an update on this since Microsoft made changes to handle more data and sources.
Amazing insight, thanks!
I like your clear explanation. Thank you!
Very clear video. Thank you!
Thank you for the insights dear Jenn, Keep up the great work 👍🔥
This is deep and quite an insight , thanks for these info. Cheers
could you turn CC on?
You definitely helped with my decision with this video..thank you so much...
Thank you so very much Ms. Jen!
Lovely presentation. Great 👍🏼
Very helpful work.
very helpful am trying to learn now
Great video! I'm leaning towards Power BI. However, Tableau sounds great for those wanting to work for big companies.
Very superficial and misleading review of both products. As someone who has used both products, I can surely say that this video has a ton of misinformation. Particularly with respect to performance of PBI, no mentioning of hundreds of free additional visuals available from Microsoft AppSource for PBI to begin with. Why create a video about something that you don't really have experience with?
Hi!
Your video is so cool. Can you prepare a video explaining how building "First Pass Yield" chart?
Great analysis. ..👍
Thank you
Trying to switch from power BI to Tableau but just realize that Tableau is fairly limited when it comes to connection to CUBE. Basically only live connection is possible and no ETL, so I gave up since I don’t want to work with the whole database all the time, and also working with multiple database and trying to combine them with more advanced way would not be possible.
Always great content!
This was very informative. Thanks for sharing
I am not to qualified to say which tool is better but I am DAX heavy user and can resolve pretty much any business problem and visualize it. With XMLA end points Power BI tool capabilities become almost unlimited.
Does Tableau have row limitations upon importing? When importing data from Salesforce into Power BI it has a 2000 row limit.
No it doesn't! I think this is on of the major benefits of Tableau over PowerBI.
This is actually the limit if you connect to a Salesforce Report. If you connect to the object, you get all the data (and I believe the 2000 row limit for reports is a SF limitation, not a Power BI one)
How about a caparison between Google Data Studio vs Power BI ❓
Good review and fair representation of the tools. Tableau fantastic visualization the Apple Mac of visualization. Power BI is the PC flavor, widespread especially if its a Microsoft centric org. Tableau if you are a SalesForce shop. For data sharing, embedding and availability of third party tools Power BI. Also don't discount Microsoft who are masters at constant improvement and adding new features each new release.
What do you think about Microstrategies?
I don't know enough about them to give an opinion. There are dozens - likely hundreds or thousands - of similar smaller operators offering more boutique solutions like they offer. Some are great and some aren't. I rarely recommend something that niche be a primary focus to learn unless you know the industry or company you're in/want to be in uses it.
Tableau is probably easier to use right off the bat for a non-technical user who wants to create some data visualizations. I work with both. Tableau, now owned by Salesforce, is an expensive product. Power BI on the other hand is free, and you don't need to have a subscription to use the Desktop version of the software. Power BI is much more powerful than Tableau from my perspective, because the DAX language is much richer and extensive than Tableau. I used to think there were certain features in Tableau that simply didn't exist in Power BI, such as LOD expressions. But there are; they are just called something different and coded slightly differently. As far as Tableau vs. Power BI in visualization choices, I have to disagree Jenn. For example, the clunky way to have to create a simple donut chart in Tableau is insane. Whereas Power BI includes both pie and donut charts. Plus, you can easily download additional visualizations, whereas with Tableau you're pretty much stuck with what you have, unless you're willing to pay.
I use Power Bi ... because it was easy to pick up, but in the near future I looking forward to learn Tableau
Jenn, I almost signed up for the IBM Cognos Analytics course but I see that Tableau and Power BI are also great tools. Have you used Cognos, if so, what are your thoughts? Which tool would you recommend to someone transitioning into Data Analytics? Thank you.
I'm familiar with cognos but haven't used it myself. There are plenty of companies that use cognos though. One of the biggest differentiators between cognos and tableau or power BI is the entry cost for a company to set up cognos is usually much higher. So in general, you're more likely to see it in larger, established organizations that tend to have a lot of money to spend on their IT infrastructure. If that sounds like the type of industries that you'd like to be in, stick with cognos. Once you learn an interactive tool like this, other ones tend to be easy to pick up on so you could add on tableau or power BI skills later on.
@@TheCareerForce Jenn, you are awesome!
I'll joining college this year. It will take 3-4 years to complete college degree. After 3-4 years. Do you this data analyst will still be in demand after 3-4 years?
@@enock4142 thank you ma'am
yes, don't give it a second thought. Tools will change but if you pick Tableau or PBI to learn you are good. Add python to that and you will have more than enough skills coming out of the university to get employed if you have access to a first world market
@@SV-Flying-Tigress thanks a lot ✨
Do I need to go for masters as well?
I do not agree with Tableau being better than Power BI for large data sets. When the connection is live vs import, it depends on how the underlying DB or datalake is implemented, how fast is that to query. But when it comes to import I found that Power BI is snappier, any filtering and slicing applied on the dashboard results in quick change to the visualizations.
I'm BI app agnostic, However, I'm curious about the comment Power BI is slower and less able to handle data sets in the millions of row range. For me, this would be a key differentiating factor, and ultimately why businesses would prefer one system over another. But, it's not what I have experienced. I Import tables that are hundreds of millions of rows and have DAX queries which operate over these tables that take less than a few seconds. Further, from what I've experienced, Power BI, meets performance requirements, has a more diverse and integrated eco-system (Power Query, Power BI Online, Power Automate, PowerApps, SharePoint, Teams, Office365) and costs less.
And yes, Tableau's visuals are better but, when clients want data in a table or, export to Excel, then visualization is not as high a factor as some would have us believe.
I think if we are talking solely on the visualization front, Tableau is objectively better. It looks better, it has a more seamless user experience for Dashboards. If your company is already a Microsoft house in terms of data storage than you may have an easier time integrating on that front.
I stopped watching once i heard Power BI cannot handle million of row..... excuse me
Which specialized data set you are saying power bi doesn’t support and tableau does
A bit skewed towards Tableau. I would add that Power BI integrates with Many Microsoft tools, likes Power Apps, Power Automate, Azure Machine Learning, etc.
Yeah if your company is already a Microsoft house then PowerBI will be easier to integrate into your business but on the visualization side alone, Tableau really can't be beat.
i am very comfort with Tableau
which is mostly used in healthcare domain
Power Bi is not so easy & its sophisticated tool & tableau is lack of many things
It is simple if you have a MacBook/Apple you cannot use Microsoft PowerBI unless you do Bootcamp which is an extra step, so keep that in mind.
That's a great point. You can use Power BI online on a Mac with more limited features, but to get the full experience you need to also use Bootcamp or set up a virtual machine (which has drawbacks as well).
I learned Power
BI on my Mac using Virtualbox. It’s better then a real PC.
I use my mac exclusively for PowerBI..I just RDP to the PC and use it as if it were a mac native app...also it lets me dedicate all the resources of the PC to PBI exclusively..... and PBI likes RAM...make sure you have plenty. That, for me, is a better solution than having PBI native and I don't have to switch to a windows :P desktop.
I never knew Power BI is for small businesses. Really strange opinion. Also I disagree that advanced excel users find Power BI easier for use. Getting familiar with data modeling and DAX is way more challenging than mashing tables with index and match, or vlookup, so you can visualize them...
I must say the description about Performance of Power BI is quite misleading because Power BI can handle trillion of rows if the data model has been properly set. Tableau is trying hard on handling larger data sets, aka the transition from single data table to Data Modeling, relational database, while power BI has been the emperor of this field for decades. If the performance of Power BI is slow for let’s say, 10M rows, then it should either be attributed to wrong design of Data Model or poor DAX syntax, the Power BI language, written by the beginners. After all, it’s all about the cardinality of the dataset that defines the performance of the model.
The credibility of this talk depends on the no. of years of experience the presenter should have. Probably does not understand the technological landscape of both tools. As both tools have in memory columnar database in built, they would both perform same. The additional benefit of using Power BI is that it is easy to move from self service to corporate BI, Data Lake Integration, Semantic Modelling etc. well supported in PBI. Overall, Power BI Data Models can be accessible in other tools as well like Tableau, Qlik, Excel etc.
great video, for my company i believe power BI would be a good fit!
Outstanding review. Probably the best comparison Ive heard.
Power query makes the difference for me so yea power bi for me
Very subjective analysis supporting Tableau. PowerBI can handle million of rows as well.
This video could actually be misleading. Powerbi can easily handle billions of rows of data. You need to have good grips on data modeling skills.
Tableau for life
Tableau id obsolete created 14 years ago with technology of 14 years ago and no upgrades, to build one visulaiztion with 30 elements with Power Bi needs only one page, Tableau needs 35 pages to build one Tableau dashboard.
think you should take down this video. it is completely misleading. Powerbi can handle billions of rows, you should ask questions before passing judgements on what you know little about. Plus why would you limit powerbi visuals to the default visuals when powerbi has a very rich visual market place and support custom visuals in both python and r.
Millions of rows of data? ... Try billions
Cásate conmigo,