Power BI vs Tableau - Best BI Tool

[@LukeBarousse]

Which tool is your favorite? Tableau or Power BI?

[@thejonath]

I find that with every update coming out on these products, the gap between their features is growing smaller and smaller. I prefer PowerBI only because I find the direct support my organisation gets from my Microsoft is far superior to what we had from salesforce.

[@MrTustri]

Is Power BI free?

[@LukeBarousse]

@@MrTustri yeah the desktop version is.

[@MrTustri]

@@LukeBarousse thanks

[@matthiask4602]

Power BI. Because of the much more vivid Community. It´s the people that matter. :-)

[@awer45t]

This is probably THE ONLY video on youtube which actually does meaningfully compare these two tools.

[@LukeBarousse]

Aw thanks for this Boris!! 🙌🏼

[@John-el5sv]

I've not used Tableau, but for Power BI, I think it is especially better for those who have experience with Power Query, database relationship management and Pivot Charts, since basically Power BI runs on these 3 concepts mainly. For me, Power BI basically a more advanced Pivot Chart which can link multiple tables together through relationships, something you can't do in Excel, since Excel's Pivot Charts require a single Pivot Table to work with. Also, the cross-filter options and drilldown, drillthrough, bookmark etc. features are great improvements over Pivot Charts. Edit on 18/6/21: I've learnt Tableau, and here are my thoughts on Tableau vs Power BI: 1) Tableau is better in some areas, such as the customisation of charts, like using of the colors and tooltips cards to show more details, which is definitely an edge over Power BI. It also comes with more features such as the page pane and stories function, which Power BI does not have. In fact, Tableau uses a more tiered way of worksheet -> dashboard -> story, while Power BI only has dashboard. However, all of the charts in Tableau are interconnected so it might be a good idea to make all of them the same size, or else a change in a dashboard can mess up your chart in the worksheet, for example. 2) Tableau's style of organising its data pane is more aesthetically pleasing and intuitive than Power BI, since it organises table columns into dimensions and measures, and color codes them, you can even switch a measure into dimension and vice-versa for different purposes. Generally I find that this makes Tableau easier to use, especially for people who have not used Pivot Tables and Pivot Charts previously. 3) Power BI is better in more areas than I imagined, however. For a first, I can't really figure out how to explore and clean data effectively in Tableau, whereas Power BI is integrated with Power Query, an excellent tool for handling small to mid-sized databases. It also makes exploring and cleaning data easy. And for the data modelling, Power BI follows SQL's style of listing by table names and columns, while Tableau only lists the table names. So yea, I feel that Power BI is much better in fine-tuning the data before data visualisation, while for Tableau it's a good idea to do the fine-tuning somewhere else first, not that you can't, but it's harder to and less useful imo. But Tableau has data blending, though that has its own caveats as well. 4) I find Power BI easier to use while I'm creating my first visualization, and here's why. Power BI has cross-filtration and chart syncing automatically activated, while Tableau's default is that they are not activated, and you need to activate them chart by chart, which is tedious. In fact, an issue I had with Excel dashboards is the non-automatic syncing of slicers (filters). Also, I can't find a way to clear all applied filters using one button in Tableau, while in Power BI I used a workaround involving Bookmarks (not in Tableau). So sometimes I'm not sure if I have accidentally activated multiple filters when I only want one activated. And also, the parameters don't seem to have a "return to default" function. 5) Speaking of filters in Tableau, it is a nightmare to distinguish between the different types, which are filters, sets, highlighters and parameters, since they have different functions and options. And not differentiated that well in the filter pane. But of course, they add to the customizability in Tableau as well, whereas in Power BI I recall a filter is a filter with different functions that you can play with. For example, Tableau's set + parameter can give you Top N, something Power BI's Top N function can achieve. Of course, the customizability is different. 6) One huge difference between the 2 is that Power BI offers nearly the full package for free (other than publishing it online and using its store, from what I know), while Tableau Public (its free version) requires all datasets and visualizations to only be available online. So here's the main difference: for free versions, Power BI only offers offline use, while Tableau only offers online use. The problem though, is that if you are handling confidential or sensitive info, you would definitely not want to use Tableau Public since everything, especially the datasets, would be exposed to... the public. In conclusion, Tableau is better for very customizable visualizations, while Power BI is a more complete package that needs more expertise to make good visualizations. If you are using free versions only for sensitive information, Power BI is your only feasible solution.

[@LukeBarousse]

Very much agree with this, thanks for sharing this insight Ho! Overall, a lot more performance enhancements over Excel that I prefer as well!

[@txreal2]

On 3) Good detail comparison. We do a lot of small data repeated cleaning every month which we don’t have control over. And Power Query saves a lot of time. Therefore we stick with Power BI.

[@johnreyrayala724]

Have you used tableau prep builder it a good software to clean data before visualization. It does help me a lot on cleaning my data

[@John-el5sv]

@@johnreyrayala724 yes I've heard of it and seen some of its capabilities, though the company which I worked for has tableau but not tableau prep, I heard that it is a separate package so they didn't get it. Thus we did pre-processing in Excel first. This is unlike in PowerBI where it comes bundled with Power Query.

[@noohinaaz8448]

Luke, when I typed 'PowerBI or Tableau' on KZbin search bar, I already knew I was gonna watch multiple videos but trust me after watching this video everything has become crystal clear for me. Thank you so much for detailed comparison.

[@wayne8797]

Been using excel for many many years and just last week, I dove into power BI. In 3 days I have already encountered several limitations but at the same time, I was able to find workarounds via some ingenious tricks. It’s been a blast creating that dashboard which was surprisingly well received. Will definitely be using it more in the future.

[@j8cobr41]

I have been using Tableau since 2015. I have a degree in Mathematics so at first it was a daunting technology to learn. I actually went back to school and took some programing classes to help me with the logic with creating formulas and data structure. It really is an amazing tool. I was concerned when Salesforce bought them. Although they are efficient with their dashboards, they are very limited in creating & displaying them. Tableau is almost like a data art book. And I am glad Salesforce didn’t make Tableau conform. Thank you for your videos, just recently discovered your KZbin page and I have been watching your videos on my free time. I’ve actually grabbed a few Udemy classes because of your videos. Just recently grabbed a Power BI class to learn what it’s about. Thank you and look forward to learning more.

[@LukeBarousse]

Heck yeah! Thanks for sharing this on Tableau and I think it’s always good to know another tool like Power BI! Keep up the studies.

[@JamesDeanStudiesLanguage]

Where do you do your schooling and where do you take classes?

[@JamesDeanStudiesLanguage]

Also, what programming languages did you learn?

[@JamesDeanStudiesLanguage]

@@theeanonymouscollector2932 Thanks. This helps amazingly. I learn best in a structured program. What would you suggest to learn Python, then SQL, then tableau. Also, should I master excel first before I jump into a programming language? I just started learning excel in my finance 101 class. Also what learning programs would you recommend? How is Coursera?

[@vpnath75]

My organization uses Tableau as our Enterprise BI solution so most of my experience has been with it. We don't use Tableau prep but instead create our data-model in SQL server. Each dashboard gets its own customized SQL-view as its datasource. We do have access to PowerBI though and I've started playing around with it but still prefer Tableau.

[@LukeBarousse]

Thanks for sharing this perspective Vamsi! Always interesting to hear how others are getting their data

[@Adam_harrison666]

If you have a background as an Excel whizz who’s comfortable with the Power Query / Power Pivot add-on’s, transitioning to Power BI should be quite straightforward, even DAX shares a similar logic to excel formulas in a way in how they are structured I personally am in the Microsoft camp, really like how it integrates with a SQL / Azure backend and Power Apps / Power Automate

[@LukeBarousse]

Very much can agree with this Adam! thanks for sharing this insight! Very much easier to pick up PowerBI for Microsoft users

[@paulanthonylake]

Good video Luke, one reason I favour Tableau over PowerBi is the ease at which I can analyse/interrogate the larger volumes of data (100m+ rows).

[@LukeBarousse]

Thanks for sharing this Paul!

[@bobvape7492]

Actually when combining sql-server with powerbi it comes extremely useful. Also when automating some stuff with powershell. I did most of the modeling on the Sql server as dwh. Tableau is ridiculously overpriced for me and no to intuitive for. When compared with big data Elasticsearch and Kibana does the Work. Kafka integration etc 😬

[@LukeBarousse]

Thanks for sharing this Bob!!

[@hrvojegabelica4336]

I worked with Tabelau for 9 years and difference between Tableau and other tools is not feature wise but ideology that comes with it. Tableau is about exploring the data, discussion around the data and asking new questions to get insights since majority of reports answer to what question plus creativity which comes with it. In other tools you are given development tool for dashboards and modelling and it is not for business users. Most companies are not mature yet so they choose Powerbi since it is free

[@LukeBarousse]

Thanks for this Hrvoje!

[@DookyButter]

Definitely a fair video of the two platforms. The self-help portion is so accurate. I always have trouble finding specific answers to my Tableau problems because the documentation, while good, is too generalizable, whereas I can usually find a forum with the specific issue I'm having in Power BI. Also, I'd add to your recommendation section. If anyone is thinking of working in the public sector, I would highly recommend Power BI. The public sector seems to be overwhelmingly choosing Power BI. I would guess because most of them are already on a Microsoft environment.

[@LukeBarousse]

Thanks for sharing this, C! Yes I've seen a split of people selecting tableau or power bi, BUT i've seen novices are more inclined to choose Power BI as, like you stated, it fits well in the Microsoft environment.

[@RyanReynolds89]

your username is just C??? amazing haha

[@andreslfr]

I like Tableau the most since it simplifies the calculated fields construction and it allows much more personalization on the dahsboard. Power BI is better for data preparation and blending because of Power Query and table relationships, but if you know how to build and clean the data before importing, this is not needed at all. I'd choose Power BI over Tableau only because of the costs. Thank you for this amazing video and for not giving any biased opinion.

[@PeterKontogeorgis]

Not a single mention of DAX, which is probably power bi’s greatest strength. Having worked with both, tableau allows for some nicer visuals but I think the gap has closed and you can recreate most styles in power bi now. The modelling and calculations are extremely limited however. Power BI modelling is fantastic and DAX lets you create pretty much any measure you could ever conceive.

[@LukeBarousse]

This is a good point, DAX is very much a strength of Power BI

[@_xcelpro]

I totally agree with this point. I was using Power BI heavily and since I switched jobs I am required to learn Tableau, however I find that in regards to data modeling, Power BI is offering Dax as a really strong solution. In tableu the data must be prepared beforehand, so those who do not have a SQL/Programming background might be in trouble when it comes to data processing.

[@karelvancamp4807]

​@@LukeBarousse And also its main weakness. I find as good as all pbix that have extensive use of DAX & PowerQuery prime examples of spaghetti code. Easy to learn for simple tasks, paved road to hell for more complex stuff. Tableau does make a cleaner distinction between data modelling and ad-hoc metrics. Similar how at Qlik, they got rid of Set Syntax (functional equivalent of DAX statements) as they found it was root cause of many customer troubles (f.e. bugtracing/maintainability, excessive system requirements).

[@1sefirot9]

@@karelvancamp4807 spaghetti code is developer's fault, not DAX'. There are easy solutions for maintaining a complex model in Power BI. Any self respecting developer will know and use Tabular Editor, I have models with half a thousand measures that are neatly organized and easily maintainable. All the measures must be in a separate Measures table, organized into Display Folders, annotated, commented and formatted (the latter can be fully automated). I can use Tabular Editor as an IDE for code authoring and maintenance, DAX Studio for interactive querying, testing and performance tuning, and/or Analyze in Excel for Unit Testing (automated after initial development), there simply does not exist such tooling within the Tableau eco-system. Heck, with Tabular Editor I can even build code that would automatically generate hundreds of measures for me based on csv/txt/excel inputs with parameters.

[@alno1]

This is the first video I see of you and you are very thorough and clear. Instant sub!

[@LukeBarousse]

Awe thanks for the kind words my dude!

[@wazy1852]

@@LukeBarousse same

[@LukeBarousse]

@@wazy1852 Awe thanks my dude!

[@Xsessive182]

Great video but I would add that you should weigh in the interoperability of power bi with power platform like power automate and power apps, these were the reasons we pivoted from tableau to power bi as they offer a layer compatibility that's just not available in tableau

[@LukeBarousse]

Thats a great point, I very much agree with this!

[@mambo0018]

Agreed. This was primarily the reason i switched my focus to PBI. For more seamless automation of some data workflow, like refresh & publish so on. Also predict it will have tighter integration and more interactive features in future, with.Sharepoint (now my organisation's main enterprise platform)

[@martinakovacikova3306]

the best comparison I've seen so far, thank you! I started with PBI and now I am learning tableau, I think both have pros and cons, but I've got the impression that people prefer this tool which they started to learn at first, so it is in my case :)

[@LukeBarousse]

I do see that a lot, ha! But both are such powerful tools so can’t go wrong with either. Thanks for sharing this Martina!

[@bmasseybrannen]

Had to switch to Google Data Studio, gotta say I like that I can share with anyone in our org without needing a license to just view a dashboard

[@LukeBarousse]

Yeah I've been using google data studio too recently. It's been really convenient with how easy it is to share. My MAIN problem though is know that I know the capabilities of softwares (like tableau and Power BI) I get mad when google data studio can't do the same things... but hey it's free.

[@bmasseybrannen]

@@LukeBarousse Yes exactly! I agree with that 100% haha

[@milaparwanitatsumi]

Thanks Luke for this amazing video, I just recently started a new job as a healthcare data analyst, I am super excited as this is my first job in analytics while I am getting my master's in DS, so I really appreciate you, you always take the time to make amazing content. Take you sooo much for this amazing channel 💙💙

[@LukeBarousse]

Heck yeah!!! Congrats on this Sharmila!!

[@rohannagshiva5971]

Hey what all skills helped u in getting healthcare data analyst job , it will be really helpful if you guide me , btw I have taken masters in DS too!!!

[@mimsy5750]

Great video, I'm transitioning into a new role using Power BI after previously exclusively using Tableau so this was a good watch

[@LukeBarousse]

Heck yeah, good luck with the transition.

[@RyanReynolds89]

What are your thoughts on the transition thus far - biggest hurdles, deficiencies, upgrades, etc?

[@mimsy5750]

@@RyanReynolds89 Power BI seems to have a lot more variety in the types of visualizations and graphics you can display. From a functionality and UI standpoint, I prefer tableau. Power BI feels a bit all over the place and less organized. I will say I use them differently…in my old company with tableau I aggregated and created KPIs within tableau using the imported dataset. Now with PBI, I do all my aggregation in SQL before pulling it in. Just a FYI that may alter my comparison of the two

[@RyanReynolds89]

@@mimsy5750 Thanks, appreciate the insight. I’ve only used Power BI thus far. You have to learn a little DAX before you can do significant aggregations & KPIs, which can be challenging, but it’s very dynamic for building re-usable data models after that.

[@joaogabrieloliveira9364]

Luke, can you talk about Google Data Studio ? For someone who is beginning in BI but also from a organizational perspective

[@LukeBarousse]

Hey Joao, yeah let me see what I can do. It's def a popular alternative option (although not as popular as the two above). Let me see if I can make a video on it in the future. Overall, I think its a great solution along with being free. My one complaint is it is limited in your ability to customize and its better if you are working in the Google (G-suite) ecosystem.

[@georgetosounidis5545]

@@LukeBarousse Yes, definitely for the G-suite it's awesome, as it has "native connectors". For general use, it's still good, but you could certainly go with something else. Could you do a video for Knime?

[@LukeBarousse]

@@georgetosounidis5545 I'lll see what I can do. I've only worked with this tool briefly but feel its a pretty powerful option,

[@chelseasnedden2870]

Thank you for this really good overview, I have an interview today with a Fortune 500 company and only had experience in one of these tools, but I feel like I walked away with a good grasp on the other.

[@andriamicunovic3334]

Hey Luke, thank you for the video and all the content that you produce. I think that DAX plays an important difference for an advanced users. But on the other side we can’t argue that Tableau looks better. Not sure why Microsoft keeps neglecting the visual aspect.

[@LukeBarousse]

Yes, very much agree about this. I tried not to go into too much detail about DAX (Power BI) and Tableau (Calculated Fields) because I just wanted to stay high level. But very much agree with what you are saying here!

[@s77lom49]

Tableau is for beginners. Power BI is for more advanced users that need more intricate control over their data through DAX. Also, power query is something you cannot live without once you get used to it. Tabluea prep is not the same at all, and does not follow through all the prep stages upon each refresh of data. So for me, there is only Power Bi.

[@parvelinho]

Hi Luka, i have used both of these tools including Qlik (sense) and its by far the strongest of all 3 in all categories you can imagine, give Qlik sometime and you will see the difference aswerll :)

[@geraldgrogan]

Cognos v11.2 can do anything Qlik can do and do it without any coding required. You won't need your army of Qlik coders if you switch to Cognos.

[@TTV5]

I feel like this is a fairly well-kept secret, but Metabase is open-source (meaning, free if you can host it yourself), and an extremely good BI tool. My favorite, for sure.

[@LukeBarousse]

I've heard A LOT of good things of Metabase. I'm going to look into this more, but I'm hearing many positive things about this tool

[@RSKfilmes]

@@LukeBarousse aaaand?

[@LukeBarousse]

@@RSKfilmes I got distracted! ha, still lintending to look into this!

[@Kooshad1]

@@LukeBarousse aaaaaand?

[@muhammadsalmansanaullah102]

Remarkably laid out overview! Very simple, step by step approach and a very user friendly presentation. Truly appreciate your effort!!

[@LukeBarousse]

Thanks so much for the kind words Muhammad!

[@miguelbenito7992]

Thanks Luke. I didn´t find you in Twitter. I´m here though from now on / I´ve been working with PowerBI but I feel like starting with Tableu as well. NIce video to have a good start. Thanks again

[@LukeBarousse]

Hey Miquel, i'm not on Twitter, but may join in the future!

[@DarkGT]

13:07 PowerBi offers the same ideology, you can use Direct Query instead of importing all of your data, you can SQL queries to "clean" the data before you import it. There is a ton of useful tools to remigrate the high memory usage. I think you are more familiar with Tableau (which I'm not at all), thus you favor the Tableau more in this video.

[@LukeBarousse]

Very good point, also I think you're referring to Power Query. I'm actually more familiar with Power BI and I favor this tool more. BUT from what i've found online for data analysts, is that Tableau seems to be a more popular tool at the moment.

[@DarkGT]

@@LukeBarousse Hi Luke. No I did mean the Direct Query. Here is definition I found online. "As its name suggests, DirectQuery is a method of retrieving data, that pulls the data directly from the data source, at the query time! The last part of the sentence holds the key - while Import mode stores the snapshot of your data in-memory - DirectQuery (DQ) doesn’t store any data. For every single request, it goes straight to the data source". This works with the date at where the data is stored. So you can write your SQL query and the compute resource impact will be at where the data is stored not your PC. So you can reduce the memory usage this way.

[@LukeBarousse]

@@DarkGT Oh awesome! I see what you are referring to now. My apologies. Overall, this video was meant to be high level and I wanted to focus on PowerQuery. I agree though that Direct Query is very powerful.

[@DarkGT]

@@LukeBarousse No need to apologies. I'm glad to add up some info into the debate PowerBI VS Tableau. It have being really long time since I touched PowerBI, glad to warm up my knowledge.

[@rajarshiparmar1990]

Best explanation. Hope i could have saw it 2 weeks ago when we were making a decision regarding this.

[@LukeBarousse]

Thank you Rajarshi! Appreciate the kind words!!

[@riteshbhatt9476]

what did you end up choosing then

[@ValamiDaniel]

Thanks Luke. Very informative as usual. How much math do you really need to know for data science/data analyst?

[@LukeBarousse]

Ha! I use math everyday! But its nothing you can't google! I would say I rarely use complex math beyond basic algebra. If I do have something more complex I just look it up.

[@RohitSingh-ml9zb]

Hi Luke, Thank you for your informative videos-they've been really helpful! As a data analyst, I’m curious to know if, in 2024, we can now download and use Power BI directly on a MacBook. Or do we still need to use Parallels to run it? I’d appreciate it if you could create a video on this topic!

[@oiciruamlau4795]

Hey Luke what's your data processing like? i.e get data using SQL => clean it, manipulate it, and analyze it using Pandas => Illustrate it using Tableau?

[@LukeBarousse]

It really changes based on the team i'm working on. I've worked on some that Used Alteryx for data cleaning to feed into Tableau. Then others where I had to manually clean with python/pandas to then feed into Power BI. Both processing tools could also be used for the other BI tool as well... just FYI. Anyway, I guess this is to say I don't have a standard approach but have tried many

[@nigeltufnel4031]

SQL server -> SSAS/Tabular -> Power BI works for me

[@ezekiel0606]

one note for Power BI Pro, it comes with Office 365 E5. many large organizations already have it. it's free to publish and view

[@TLaliashvili]

Great video, Luke! Always wanted to know the difference since I am using Power BI due to eco system. On option 5 I would say that creativity is down to creator and the needs you are aiming. I wouldn’t have problem to re-create examples in power bi.

[@LukeBarousse]

Very true point, I agree with what you are saying!

[@dingaroo2003]

I feel out of the box, Tableau has better visualisations but I last used it in 2019. For past 2 years, I been working with Power BI and I find DAX and Power Query is good for data manipulation.

[@LukeBarousse]

Agree with Power BI have some significant power with DAX and Power Query

[@AljIsHere128]

Good comparison and contrast of both products. I have done training mostly on Power BI than Tableau. I still want to learn Tableau as well. Excellent video!

[@LukeBarousse]

Thank you!

[@tanviikhar8655]

All the points are explained very nicely and in detail. Thank you so much for this.

[@TarvetImala]

Interesting video. I suggest to add another aspect to it. Performance. When you need visualize hundreds of GBs or TBs of data, that is a important topic. Although then there are some other options how to manage that data load, still it would be interesting to see the comparison

[@LukeBarousse]

This is a great point and actually considered before making the video. Overall, in my experience they are VERY similiar when it comes to handling millions of rows of data and haven't seen much difference. Because of this I decided not to cover this. But this isn't to say that there isn't a difference in performance. Maybe something for me to consider in a future video.

[@MonsieurSchue]

​@@LukeBarousse very very surprised to hear that. For us even with a good few thousand rows of data with a few "joined" table relatinship on top of system connection (such as salesforce) the whole power bi is heavy and slow. Personally power query is indeed a more stable version of excel but you can only do so much with Microsoft; and just like excel, once the file gets big (i.e more data, more visualization, more tabs, more measures..), it's slow like hell.

[@Adam_harrison666]

@@MonsieurSchue Could that not be mitigated via native query folding? I try and have the SQL / Azure backend do all the hard transformation work before switching to the Power Query only normalisation actions, improves performance significantly Not used Salesforce before however so not sure if it works there

[@eric.nosabo]

@mrschue sounds like you need Alteryx!

[@MonsieurSchue]

@@eric.nosabo Haha we do just get into Alteryx this year. It's amazing and truly makes one wonder why we didn't get on it much earlier. But it doesn't seem to be covered in this channel so I didn't mention it. We're also actually moving away from PBI. In general we feel MS is a company that's cheap so everyone is using it (low entry barriers) but once when you move into more complexed and advanced area the performance really start to show.

[@pocha9172]

Could you please give a comparison between MicroStrategy vs looker vs power bi?

[@JonRuhnke]

Excellent comparison video, very much appreciated!

[@Smile8924]

This is not a good review of the two products. - to summarise - PowerBI is cheaper, easier to use and better integrated into the already existing eco system (who is not integrated into MS Ecosystem?). Tableau is more expensive, less intuitive and 3rd party. also having data 'ready' before using in the application is just good BI practise. and I think you'll find PBI will also respond better to clearer already structured datasets... - having been a user of both products for the past 6 years - I much prefer PowerBI. You can make PowerBI unique - you can design your own visualisations in PBI but have not touched on that as a pro - R/Python can also be incorporated into the service.

[@LukeBarousse]

🤣😂 Thanks Jamie! Well I think you just gave a great review, so thank you for that!

[@peterM20]

Thank you. I am still struggling to understand how anyone who has used both power BI and Tableau would ever pick Tableau. I am new at my current job (3 months) I am begging my director to commit to Power BI because we are using it minimally and Tableau mostly and yet we are using powerapps, power automate etc and all I could say is 🤦🏿‍♂️🤦🏿‍♂️🤦🏿‍♂️🤦🏿‍♂️🤦🏿‍♂️

[@fernandotorres9006]

Ty very much for this comment...it was very helpful as well as the video.

[@peterskottt7150]

Visualizatuon is about visuals guys. Tableau report looks way better with mich less effort and that is what counts. The endnproduct is lovely, sexy, then users will like it. PowerBI is behind on this field.

[@mohamedimranakhil3619]

I am confused about data warehousing, what is the best way to get data sources with power bi? creating data warehouse then bringing in power bi? or using data modeling in power bi directly?

[@LukeBarousse]

It depends on where you data is and how clean it is. When I worked for my last company we had a sql database I could connect to with power bi and bring all the data I needed in... sometimes i'd have to clean that data up for my need and that's when I'd use power query to better model the data.

[@RomainCombs]

Thank you. I was able to get a second interview.

[@LukeBarousse]

Heck yeah!!

[@karansethi8496]

Is SQL knowledge required to learn power bi or we can learn it without SQL knowledge?? please help 🙏🙏

[@ImperialArmour]

Both are pretty similar, in terms of calculated fields, i found Tableau to be simpler than DAX used in PowerBI. PowerBI is a lot more straightforward to get started with, Tableau takes around 2 weeks to self-learn. Both are entirely unsuitable for large datasets, once the row count goes over 2 billion(around 2gb workbook size), even with extracts it can take up to a few minutes to load a view. You'll need to live query from an OLAP database, or break your physical tables down specifically for each view.

[@LukeBarousse]

This is good to know on the large row count! I've typically worked on data sets under this so haven't encountered this issue. Also very much agree on how calculated fields and DAX can be similar.

[@half_way_expert]

I believe if you have rows on the billion level, you need to do something (aggregate or sum) before you import the data, otherwise, you're doing it wrong. I worked with a couple million rows and it take forever to create a custom column in Power BI, I can only imagine a billion rows.

[@rarigon]

At the moment, I'm learning about Microsoft Power BI because it's the BI plataform where I work. I'm improving my knowledge in statistics too. I studied statistics in my degree but I didn't learn enough. By the way, I'm employee at an IT public company in Brazil. Thank you for this video.

[@LukeBarousse]

Good luck on your Data Science journey with Power BI, Rafael!

[@dareemmanuel6079]

Can you please tell me what statistics topic to learn or link me to a good course for statistics for data analysts?

[@rarigon]

@@dareemmanuel6079 First I think it's important to evaluate how much do you know about the subject.

[@LukeBarousse]

@@dareemmanuel6079 I think all the data analytic certificates I've been recommending recenlty are good starting options. You don't need more than that IMO to start. From there you can dive deeper depending on your intrests.

[@colabwork1910]

@Luke Barousse , which one is better to learn as a beginner?

[@LukeBarousse]

Neither is better. Each has their pro's and cons. You should look to see which tool your goal employer uses and learn that one.

[@colabwork1910]

@@LukeBarousse Thank you. your reply solve my biggest confusion :)

[@LukeBarousse]

@@colabwork1910 Thanks my friend!

[@suleb1]

I’ve been watching your videos for weeks now and only just realized I wasn’t subscribed. Sorry! Love your work ❤️

[@LukeBarousse]

Awe thank you so much and thank you for subbing!! No worries at all. TBH I care more about the views than the subs... so its NBD 😉

[@malcorub]

My last job was a combo of SQL Server, Power BI and SSRS. My new job uses SAS, SQL Server and Tableau. I am still trying to figure Tableau, the visualizations sure are nicer but it doesn't feel as intuitive to learn as you stated.

[@LukeBarousse]

Yep, can agree with this as well. Good luck with learning tableau 🙌🏼

[@KarthikeshwarSathya]

Just check Gartner 😊

[@LukeBarousse]

Nice!

[@thierhappy]

The first Google Trends graph might be a little biais since Tableau means "whiteboard" , "a painting", "drawing" in french thus these search keywords in french might be included and raising tableau's index

[@LukeBarousse]

I actually limited the search to software only... so it excluded those items. I also compared to other sources and they were very similiar.

[@yupity]

which one is more secured?

[@LukeBarousse]

What do you mean by secured

[@vladislavkorobeinikov1407]

Yet I need to check how power BI works (I'm a noob data geek still 😅... Trying to get it tho!), what I know I had the possibility and challenge to use Tableau to do a dashboard for a selection process, and even if I was in the mids of my final degree paper work (so extreeeemely stressed out) , I gotta admit using tableau was like a breath of fresh air! All those colors, interaction with data, was difficult to understand at the beginning but I had such great fun in doing the dashboard, and really was great to see the artistic side of data analysis, something what I really missed at uni while working with data! Also thank you very much for all the information you're sharing 🙏🏻 as I said I'm trying to get into this world after another job and after finishing my degree in statistics, you really pushed me to dig further into learning better excel, SQL, bought 3 of the books you recommended for python, Tableau and Power BI... really enjoying the learning process while looking actively for a job 🙏🏻

[@LukeBarousse]

heck yeah!! Thanks for for sharing this Vladislav, I like your passion for learning new skills! Keep up the hard work

[@Scam-mh5tl]

Hey, I want to be a UI/UX designer which one is best for me ???

[@LukeBarousse]

I'm a data analyst... i'm not to sure

[@Scam-mh5tl]

@@LukeBarousse okay np... thanks for replying 😊

[@syedasim6813]

Thank you for sharing

[@Awknfd3285]

Currently in school learning about both. My professor said Power BI was only compatible with windows however so I’m confused how you showed us Power BI on your MacBook Pro 😅

[@LukeBarousse]

Virtual Machine! Specifically, I use Parallels lukeb.co/ParallelsFreeTrial

[@shermin2o9]

Great video. Which of these two tools do you think is better to learn and add to a resume for prospective jobs? My current organization has neither (we use Excel), and I would like to say on my resume I know how to use one of them.

[@LukeBarousse]

it really depends. no tool is better and will depend on what your goal employer. if your company uses microsoft my bet is on power bi

[@fatcat3513]

Just learn both🎉

[@MasterCamus]

So is it true to say that Tableau should be connecting mostly to flat tables when comparing to Power BI?

[@LukeBarousse]

I feel in general yes. Tableau prefers cleaner data, where Power BI has power query to better shape the data.

[@michaellillyjr.3044]

Hey Luke, what about the "hybrid" option, of getting a basic working knowledge of both platforms to start with, and then doubling down on the platform you expect to be used at wherever you are interviewing? As in, is it a good idea to have a Tableau AND a PowerBI version of any project you build for your portfolio, or is that kinda overkill and overthinking things?

[@LukeBarousse]

Potentially, yeah I think you will increase your odds of landing a role by having this. But a lot of times companies want to see that you are a master of one of theese tools and can start working in them now

[@chijiokeochubili7279]

If one is into sports data analytics, which do you recommend?

[@LukeBarousse]

I think either is fine. Although if you go to Tableau public I’m sure you can find a lot of inspiration for sports analytics there.

[@manasdatta8037]

I've only ever had experience building with Tableau. In my current job, we're a PowerBI company, but using the tool for prototyping (I don't do any technical work now). What i seem to come up against is that with PowerBI, calculated measures, especially with moderately sized datasets, seem to make PowerBI dashboards really slow, especially when you've got a direct data connection to SQL Server! I never faced this issue with our previous Tableau/Redshift stack. The volume of data we're dealing with isn't gargantuan. Our team needs to go down the back-end route to solve certain issues because making a calculated measure would just make the dashboards slow. Am I being biased? Or is Tableau the more suitable tool in this situation?

[@LukeBarousse]

Power BI can be extremely slow when dealing with large datasets and more complicated models and measures. I don't think you are bias at all, as I have experienced similar issues as well. Unfortunately, I don't have a solution for this at the moment

[@ruslansuleimanov9441]

Awesome video, hope your content gets more attention in the future!

[@LukeBarousse]

Thanks Ruslan! I hope so too!

[@ericadenison6923]

I like power bi to make nice to look at charts quick and easy, just upload excel data, create any kind of chart I need to display data in easy to understand way.

[@aditpandey6422]

As a power bi developer myself, this is an amazing video. Do you recommend learning tableau alongside power bi? I am not sure how big of a difference in development approach there is between the two.

[@LukeBarousse]

Unless you are going to use it, then I don't see a need. I had to use both in my job so I learned both, but I wouldn't recommend it unless you are trying to level up your skills for a future job (Then in that case yes). Both are such similiar tools and but once you know one its pretty easy to pick up the other.

[@galatemalate1256]

If you are used to use DAX, you will miss PBI a lot, this is happening to me. Try to calculate a custom FYTD $NSV where we exclude product N and should not be affected by Table X context when filtered in the report sheet in Tableau.

[@LukeBarousse]

@@galatemalate1256 Ha I feel your pain Francisco!

[@raghaveshukla7373]

Which one of these expose management api's if we wish to access the data post transformation

[@LukeBarousse]

Both have numerous options for accessing various forms of data sources

[@dissolved88]

Hi Luke, it would be great if you could make a video an your approach when you get a new project in Power BI - how do you structure your work? I‘m struggling so much with my workflow, it always ends in some kind of chaos and I get a feeling I need soo much time to create one report - do you have any advice for me? ☺️ and also thanks a lot for your great content! Regards Patrycja

[@LukeBarousse]

Hey Patrycja! I'm working on some content now around this. I too often struggle with this so I understand your pain and hope I can help with solving it. Stay tuned!

[@gusar3766]

Luke, thank you for your videos, they're all interesting, I'm a big fan :) By the way, if we compare Tableau and Qlik Sense, what is the best option?

[@LukeBarousse]

I havne't used Qlik as much... in general Tableau is more popular

[@fernando_dominguez]

You're the man thanks for sharing your knowledge!

[@bouseuxlatache4140]

thanks Luke, great video. do you think it is worth learning dash for python to add to the first two?

[@LukeBarousse]

Thanks for the kind words Bouseux! Plotly/Dash is very much a popular option right now. I can't really comment on if it worth learning as in my (corporate) day job I primarily get pulled to build dashboards in one of these two solutions. I haven't used this solution at all in my day job However, if a client wants a lower cost dashboard solution (basically free, besides server costs) you could code something up in dash. Really it depends on the clients needs at that point.

[@bouseuxlatache4140]

@@LukeBarousse thanks Luke!

[@wissambalaa2573]

Hi Luke, loved your video, I am sure we can dig into each topic separately. I have a question, since we have invested in MS CRM D365 and MS AX 2012, does it make sense to stick with MS Power BI, and the consumption is only for 10 users max. Thank you

[@LukeBarousse]

I’m not as familiar with Microsoft Dynamics. But if you’re using the office suite then I think it’s an easy method of adaptation with powerbi. Especially if paired with the power bi service

[@SomeLad12]

I’ve tried to learn Power BI and find it so difficult. Used Tableau for nearly 3 years now and it seems like something I could do easily in Tableau is way too complicated to replicate in PowerBI.

[@adeel-videoeditor]

Thank you Mr. Luke!

[@annatsybenko6120]

Thanks for your video:) I am glad that I found your channel. What courses or books can you recommend for studying Power BI?

[@LukeBarousse]

This course is how I learned it: lukeb.co/PowerBIDataCamp

[@annatsybenko6120]

@@LukeBarousse thank you very much:)

[@minhtrungdang1853]

What skill is more popular for job market?

[@LukeBarousse]

Depends on your goal employer. Overall it's hard to say between these two and whats demanded on the job market.

[@Suzume900]

I saw in your description to ask a question to just comment in any video, so I was curious, is an accredited Business Analytics degree going to help me learn stuff like this and help to get me into this type of career? Or is there a different degree for this?

[@LukeBarousse]

A degree def helps, have you checked out my video from a few months ago about those that got data analyst degrees without a degree?

[@Suzume900]

@@LukeBarousse I have not, I'll check it out right now! I was more worried that a Business Analytics degree wouldn't qualify me as well as a more specially Data Analytics degree.

[@AshishSingh-753]

Both are good but I choose tableau to learn first after I get my first paycheck then I also learn Power BI I like your method Learn it then use it

[@LukeBarousse]

Heck yeah! Glad you like my learning method and awesome to hear about your learning path!

[@SteveFarrand]

Thank you Luke. Very useful.

[@LukeBarousse]

No problem at all!

[@sajalshrivastava2202]

Hey guys I just graduated engineering im learning Power BI and SSAS is dis good for job or should I learn More tools?

[@LukeBarousse]

I mean it all depends on what job you're trying to puruse! If it's data analyst I highly recommend checking out other tools like Excel and SQL.

[@sajalshrivastava2202]

@@LukeBarousse oh ok thanx ......so power bi n ssas is enough ? Actually it will take my 1 n half of months and i need job thats why im asking

[@LukeBarousse]

@@sajalshrivastava2202 I mean maybe? it all depends on what job you're trying to puruse? I'd start looking on linkedin to see if employers are requesting people with your skill set. I can only speak for skills of data analyst and for that you need to priortize Excel and SQL to meet the requirments of most jobs

[@klaton4819]

Comment on Price.. This vid is new enough that a mention introduction of Power BI Premium Per User license (March/April 2021) would be good. From the small company / home user perspective the cost dynamic switches with the intro of $20 per month per user PowerBI premium per user vs the Tableau per user cost.

[@LukeBarousse]

Yeah as far as cost, for small user groups it seems that Power BI may offer a lower price point. Depending on how you use the tool (and what services you use) can complicate thigns and make pricing complicated. Maybe will update with pricing comparison in the future.

[@rajkumarbharathi3139]

much easier to learn power bi, since it is free for non commercial. but for bigger data sets, since tableau is using a separate prep software, can be faster.

[@LukeBarousse]

These are great points.

[@noobwow2009]

Subscribed. Good to see your information I am getting into data analysis field 😀

[@LukeBarousse]

Heck yeah! Good luck in your data analytics journey!

[@lucjanooo]

Thanks Luke, very useful. What would be good is to include the bi magic quadrant from Gartner for comparing the 2 products

[@LukeBarousse]

I'll check this out, thanks for sharing Lucjan!

[@mohmmedyaseen5858]

Hi Luke .... I am learning Data analysis from coursera certification offered by Google... Can you suggest me some tips to become successful in data analysis field

[@LukeBarousse]

More content on this coming soon!

[@eth6706]

You forgot to mention PBIRS! This makes Power BI the clear winner when you account for cost on the enterprise level.

[@LukeBarousse]

Also a good option!

[@simonlacey70]

Very helpful! Thank you!

[@MohannadAlhariri]

Thank you for the video Luke!! I'm also partial to power bi even tableau looks nice, but I am stuck in DAX, how can I master it ??

[@LukeBarousse]

For learning DAX I recommend this course (I may be partial, but I helped build it!): lukeb.co/DAXpowerBI

[@MohannadAlhariri]

@@LukeBarousse thank you Luke ! You saved me :)

[@xidxid8228]

Well I would recommend experimenting with functions and exercise thinking, implementing various ideas and logics. DAX is very easy I have used it for 5 days and I think I have good command over the tool.

[@shiv7219]

Great explanation ever. Can you please suggest which one is best for a Bussines Analyst.

[@LukeBarousse]

I wouldn't say there is a better option, but I would say that if you are targeting a certain company (to work for) and you know they use a particular BI tool, it would be beneficial to learn that tool as a Business Analyst. In general though, knowing one over the other want get you much further.

[@geraldgrogan]

Cognos Analytics v11.2 is my preferred Business Analytics tool.

[@FacelookHK]

It really depends on what the company is using. If the company is using Microsoft 365, it makes sense to use Power BI.

[@theshosher]

When making nice surface level raports tableau is fine. But my clients have entire algorithms and systems to implement. Somehow I'm much more able to make this in powerbi DAx

[@LukeBarousse]

Yeah I do feel DAX has its strong suit. Caluclations in Tableau can be done, but not near as complex as DAX

[@theshosher]

@@LukeBarousse but its a buggy pile of dirt just like the rest of powerbi

[@LukeBarousse]

@@theshosher I don't kjnow about that... I don't find it buggy..

[@theshosher]

@@LukeBarousse well you havent tried loading 40 gb of data into it have you now :P again. its fine for the most part, but damn will it seize up on you and destroy whole dashboards if you aren't careful. it also doenst really enjoy when your datamodel has more than 20 tables. Again. poweruser

[@nickvledder]

@@theshosher Would Business Objects or Cognos be a good option?

[@prathameshdinkar2966]

Nice Video! Can you also make a video on tableau prep as not much is available for it...

[@LukeBarousse]

Let me see what I can do. I haven't had much use with tableau prep before, but let me see

[@RanjeetKumar-tk6yx]

is it both tools are Freeware/open source?

[@LukeBarousse]

both have free options to download

[@arjunharidaas8822]

Hello Luke, I recently started out on learning data analytics and I'm simultaneously charting my learning process going forward. My aim is to set up a remote work environment as a freelancer. Data visualization is where I'm stuck right now. Most of everything that I'm learning uses software that is almost entirely free or open source. I can't seem to find a way to go around the payment barrier entirely, which is totally fine since I feel either of these softwares will prove to be worth the money. My main concern is regarding their subscription model. As you mentioned Power BI has the Pro and Premium with pro account only allowing sharing with other pro users and unrestricted sort of sharing capability for Premium. But how does the creator subscription work exactly for tableau? Is it like the adobe creative cloud subscription wherein you can do multiple commercial projects for different clients with that account , implying that the creator can create different dashboards for different clients using a single creator subscription and making it available for the client using multiple instances of Tableau online or server via maybe explorer accounts? Or is it like the creator account can actively make and host only one dashboard for one particular client and another project would mean another tableau creator license?

[@LukeBarousse]

Hey Arjun, Have you looked into Google Data Studio before? It's not as powerful as either of these options but it allows you to deliver visualizations to your clients without having to worry about a subscription. For Power BI and Tableau, I feel they are more designed with cost models for businesses and large corporations. This allows them to control access via accounts and distribute. With being a freelancer, it is possible to use these services in this manner, but you'd have to set up accounts for all your stakeholders that need access. Whereas with google data studio you can just publish this to the web and then control access via an email address. Hope this helps.

[@arjunharidaas8822]

@@LukeBarousse Hey Luke, It makes sense to go with data studio. Seems like a good place to start the visualisation process.

[@LukeBarousse]

@@arjunharidaas8822 Heck yeah, let me know how it goes for you!

[@arjunharidaas8822]

@@LukeBarousse Will do.

[@FiscalRangersFlorida]

Outstanding overview. I used to develop.BI reports with Lotus Notes. However IBM bought them and killed them to move customers to WebSphere. How do both work with a school district that uses chromebooks and Google docs?

[@FiscalRangersFlorida]

BI...

[@LukeBarousse]

Both of these work best with Windows. Unfortunately, I don't think chromebooks support these apps

[@geraldgrogan]

You should give Cognos Analytics v11.2 a try. They have a free trial available at the IBM website.

[@BuildVisions4Africa1]

You are a great teacher!

[@LukeBarousse]

Thanks you so much for this!!

[@fikrirama5969]

How about ZOHO for data visualization?

[@LukeBarousse]

I haven't tried this yet... i''ll have to check it out

[@michelchaghoury870]

Great content can you please make a video about a start to end project that is a real world scenerio like how you planned, prepared and cleaned the data and how you visualize it in e simple and proper way, no need how a huge large project, just a demo so se can see how a data analyst works on a project in real life and maybe we can add thing to it and add it to our portfolio please pleaseeee and thank you for your help and support

[@LukeBarousse]

Heck yeah, loving all these great video ideas Michel. Let me see what I can do on this one!

[@aumen1980]

Luke, Do you any recommendations on courses to learn SQL and power bi? Thank you

[@LukeBarousse]

Here's a SQL course I recommend... I don't have one for Power BI currently I'm still looking into this SQL 👉🏼 kzbin.info?event=video_description&redir_token=QUFFLUhqa05EZGlySkdCRXZ0bWNyaWVNQ2I0TlYzX0pOd3xBQ3Jtc0tuanFFUmJFLUpqS3M4UEkzZmZRRDNXWlhSYVdIWFNkWWR6TVc0OGJRaTJlVlI5dl8zN3BEaHNoaDV3U3dKdnFsUXpjN0ZIcU15UEVXd041cHZscjZoQ2tnczBtT0R5Um9pbGxXMVU2R2xkRFYyTlJSTQ&q=https%3A%2F%2Fclick.linksynergy.com%2Fdeeplink%3Fid%3D9Dai7v38Rms%26mid%3D40328%26murl%3Dhttps%253A%252F%252Fwww.coursera.org%252Fspecializations%252Fpostgresql-for-everybody

[@markfitzpatrick7186]

Very well organized. Nice overview with up to date info. Would be a good idea to get out of that up-talking habit - annoying af.

[@LukeBarousse]

haha, trying to work on that! 🤣 Didn't realize I did that until recently.