As an industry analyst for a fortune 200 company, I use Excel and PowerBi/Tableau almost exclusively. I do use Alteryx for some data cleaning, but Prep from Tableau can handle the brunt of my transformations. Most big corporations aren’t doing anything fancy as enterprise-level adoptions of new tools is very slow…very. 😅 Great videos!
Financial analyst for a fortune 200 company here as well... I can sadly confirm what you are saying is true. I'm just amazed on how much we relay on the excel limitations
Aw this is such a comprehensive walk-through of apps for data analysts! Thanks for making this vid Luke! I didn't know about the CleanShot app, will give it a try next time - feel like it will make my ugly plots look prettier 😂. And yeah, I feel lazy AF as well as I get older 🙈
As always, a valuable source of knowledge from an expert. I'm finally starting down this path in IT and having a few tricks to make it easier always helps. Thanks Professor Luke :) :) I don't know, but, have you thought about talking about a pathway of courses from basic to advanced for those thinking of entering the underworld of Data Analysis or IT in general?Or by niches. Like a genealogical tree (I know you've already explained some but I don't think in that way) I'm not sure whether to take the Google or IBM courses, but I know that I want to go higher, and also into other specific courses. AND LAUNCH PUBLIC DISCORD SERVER 🤩🤩
Great video. I just started my google data analytics certification. I’m really interested in becoming a data analyst. I have some learning difficulties and slower processing speed. Im gonna give it a try. Do you think that this will be too hard for me? Is there something else I can do that’s easier?
Hello there! I took that course and it's very doable, especially if you take your time and supplement with UA-cam and ChatGPT. I watched the course on youtube on before committing to it 😅 There's a wealth of free information out there but the resources from the course are impressive The SQL module was the most confusing section for me, a bit of a difficulty spike after the slower and less technical parts
Great Question; I use a mac primarily for content creations (i.e. video editing) and so I just have to have workarounds to use it for analytics. If I wasn't a content creator, and only an analyst i'd go with a PC
Yeah. This Mac incompatibility with the tools of my trade has kept me from testing those machines. Currently using a gaming laptop for work due to its power, upgradeability (32gb ram and 4tb storage currently), cuda and software support.
I have a doubt which just prevents me from switching to MacBooks. Excel usage means lots of numbers being input. MacBooks lack a dedicated numpad on their keyboard. Does this limit the productivity or ease of use in some way?
Hey Luke love, Thanx for your valuable content, really appreciate it 💓, just a question as someone who is in the Field of supply chain and logistics do you recommend having a (CSCA) certificates in order to pursuite a career in that domain as a Data Analyst, just for record i come from an engineering background as a chemical engineer thanks in advance ❤
What about Azure Data Studio?, I'm using for 2 years to work with SQL, is like SQL Server Managment Studio but married with VS Code and there is Mac version to install
Hi Luke, put the cost aside, is working on Mac with Parallels really limiting comparing to a PC? I mean in terms of performance, compatibility etc. thanks!
Really depneds on how powerful of a mac that you have. I have an over-spec'd mac with 64gb of memory and windows apps works faster than they did on my PC (granted that machine had only 16gb RAM) I've tried this on macs with as little as 8gb of memory and it can get limiting so make sure you get enough memory if you decide to do this
@@LukeBaroussepeople often compare really expensive Mac configs with low powered Windows configs. I personally have ended up using a powerful gaming laptop for work.
My portfolio is kinda weak, but I have one certification from the python institute. Should I get the tableau desktop specialist cert or strengthen my portfolio first?
It really depends on the region. Here in Nordics Microsoft is really strong so Power BI is important here. SQL, Power BI, Excel & Python and projects done on those (combined preferably).
A company could potentially use Knime and interact with a database not using SQL... but IMO, SQL is a relativiely easy language to learn and also its beneficial to learn to understand how to analyze data better... so I'd still recommend learning SQL
As an industry analyst for a fortune 200 company, I use Excel and PowerBi/Tableau almost exclusively. I do use Alteryx for some data cleaning, but Prep from Tableau can handle the brunt of my transformations. Most big corporations aren’t doing anything fancy as enterprise-level adoptions of new tools is very slow…very. 😅
Great videos!
Financial analyst for a fortune 200 company here as well... I can sadly confirm what you are saying is true. I'm just amazed on how much we relay on the excel limitations
Awesome video🎉. DBeaver is where it's at for SQL.
Can't wait for a public server from Luke😮
Waiting for your Roadmap to become Data Analyst in 2024 sort of video!
Would be much appreciated if you could come up with this! :)
Public Server for Luke Please.
Aw this is such a comprehensive walk-through of apps for data analysts! Thanks for making this vid Luke! I didn't know about the CleanShot app, will give it a try next time - feel like it will make my ugly plots look prettier 😂. And yeah, I feel lazy AF as well as I get older 🙈
Yeah I think we’re all getting that way as we age 😂😜
This a pretty hefty list of notable applications!!!
Super hefty!
good and smooth explanation. That is my fav video that highly recommended all my data analytics begineer community. Thanks for video dear Luke)
Very informative and through ❤ the ultimate guide 😊 Thank you so much
Thanks so much for sharing all the info, great video
That's sounds weird but i like your combine also. It is really helpful to focus on your words and keep on your video. Great color choice.
Thanks for this detailed video.
As always, a valuable source of knowledge from an expert. I'm finally starting down this path in IT and having a few tricks to make it easier always helps. Thanks Professor Luke :) :)
I don't know, but, have you thought about talking about a pathway of courses from basic to advanced for those thinking of entering the underworld of Data Analysis or IT in general?Or by niches.
Like a genealogical tree (I know you've already explained some but I don't think in that way)
I'm not sure whether to take the Google or IBM courses, but I know that I want to go higher, and also into other specific courses.
AND LAUNCH PUBLIC DISCORD SERVER 🤩🤩
I’m still optimistic about the Google certificate and think it’s the best start for getting into this field.
Thanks for the video, I appreciate it very much. Pure knowledge and experience talking!
Great video.
I just started my google data analytics certification. I’m really interested in becoming a data analyst.
I have some learning difficulties and slower processing speed. Im gonna give it a try. Do you think that this will be too hard for me? Is there something else I can do that’s easier?
Hello there! I took that course and it's very doable, especially if you take your time and supplement with UA-cam and ChatGPT. I watched the course on youtube on before committing to it 😅 There's a wealth of free information out there but the resources from the course are impressive
The SQL module was the most confusing section for me, a bit of a difficulty spike after the slower and less technical parts
Very nice video, Interesting tools. I want to know why you are using a Mac and recommend a PC?
Great Question; I use a mac primarily for content creations (i.e. video editing) and so I just have to have workarounds to use it for analytics. If I wasn't a content creator, and only an analyst i'd go with a PC
Thanks a lot Luke.
Yeah. This Mac incompatibility with the tools of my trade has kept me from testing those machines. Currently using a gaming laptop for work due to its power, upgradeability (32gb ram and 4tb storage currently), cuda and software support.
Which is better to learn, Excel or Google Sheets ?
Excel on macOS is limited ? I have the yearly subscription for it on Mac and pc.
awesome, Thanks for the video
I've grown to like Numbers on Mac lol. Especially since it's free :)
🤔
So much thank you Luke! I also would like to know what app do you use for video editing and record for your UA-cam Videos?
final cut pro for video editing since i'm on a mac. Love it
Thanks Luke 👍🏾
I have a doubt which just prevents me from switching to MacBooks. Excel usage means lots of numbers being input. MacBooks lack a dedicated numpad on their keyboard. Does this limit the productivity or ease of use in some way?
Hey Luke love, Thanx for your valuable content, really appreciate it 💓, just a question as someone who is in the Field of supply chain and logistics do you recommend having a (CSCA) certificates in order to pursuite a career in that domain as a Data Analyst, just for record i come from an engineering background as a chemical engineer thanks in advance ❤
Great question but i'm not an expert in this field so I can't really say; so sorry for this
@@LukeBarousse indeed thanx for your reply, really appreciate ❤️♥️👍
What about Azure Data Studio?, I'm using for 2 years to work with SQL, is like SQL Server Managment Studio but married with VS Code and there is Mac version to install
yeah also seems like a good option; i've only tested it briefly
How do you take notes?
Nice Video!
Hi Luke, put the cost aside, is working on Mac with Parallels really limiting comparing to a PC? I mean in terms of performance, compatibility etc. thanks!
Really depneds on how powerful of a mac that you have. I have an over-spec'd mac with 64gb of memory and windows apps works faster than they did on my PC (granted that machine had only 16gb RAM)
I've tried this on macs with as little as 8gb of memory and it can get limiting so make sure you get enough memory if you decide to do this
@@LukeBaroussepeople often compare really expensive Mac configs with low powered Windows configs. I personally have ended up using a powerful gaming laptop for work.
awesome video.
My portfolio is kinda weak, but I have one certification from the python institute. Should I get the tableau desktop specialist cert or strengthen my portfolio first?
It really depends on the region. Here in Nordics Microsoft is really strong so Power BI is important here. SQL, Power BI, Excel & Python and projects done on those (combined preferably).
Awesome video..I religiously follow you and I m growing🎉🎉🎉
Awesome ❤
I got a MacBook for my data courses for school…hopefully my school offers me a way to use windows applications virtually if not Parallels it is lol
boot camp + Windows 10. They are free and works well on my MacBook Pro. You can easily find videos on this FYI. Good luck!
Great video as usual!
Just i think this is the first time I commented 😅
Can Knime replace SQL?
A company could potentially use Knime and interact with a database not using SQL... but IMO, SQL is a relativiely easy language to learn and also its beneficial to learn to understand how to analyze data better... so I'd still recommend learning SQL
@@LukeBarousse
We are using KNIME to process data in our company.
Thanks for letting me know about the rationale for using SQL
Where to find interesting data sets?
I got a free one: lukeb.co/freedata
Kaggle
discord title is wrong
first !
Top comment for absolutely no reason
first )