Top Apps I Use as a Data Analyst
Vložit
- čas přidán 11. 06. 2024
- Apps mentioned in this video 📱
⦷ Parallels lukeb.co/Parallels
🦫 DBeaver dbeaver.io/
🐍 Anaconda www.anaconda.com/download
💻 Visual Studio Code code.visualstudio.com/
👾 Github Copilot github.com/features/copilot
🏴☠️R & RStudio posit.co/download/rstudio-des...
📈 Tableau Public www.tableau.com/products/publ...
📊 Power BI powerbi.microsoft.com/en-us/d...
📝 Notion lukeb.co/Notion
📑 Grammarly lukeb.co/Grammarly
📸 CleanShot lukeb.co/CleanShot
NOTE: Some of the links above are affiliate links
Courses for Data Nerds
==================================
📜 Google Data Analytics Certificate 👉🏼 lukeb.co/GoogleCert
🐍 Python for Everybody 👉🏼 lukeb.co/PythonForEverybody
💿 SQL for Data Science 👉🏼 lukeb.co/SQLdataScience
🧾 Excel Skills for Business 👉🏼 lukeb.co/ExcelBusinessAnalyst
📈 PowerBI for Data Viz 👉🏼 lukeb.co/PowerBI
📊 Tableau for Data Viz 👉🏼 lukeb.co/Tableau_UCDavis
🏴☠️ Data Science: Foundations using R 👉🏼 lukeb.co/RforDataScienceJH
➕ Coursera Plus Subscription (7-day free trial) 👉🏼 lukeb.co/CourseraPlus
👨🏼🏫 All courses 👉🏼 kit.co/lukebarousse/data-anal...
Books for Data Nerds
==================================
📚 Books I’ve read 👉🏼 kit.co/lukebarousse/book-reco...
📗 Data Analyst Must Read 👉🏼 geni.us/StorytellingWithData
Tech for Data Nerds
==================================
⚙️ Tech I use 👉🏼 kit.co/lukebarousse/computer-...
🪟Windows Virtual Machine for Mac (Parallels) 👉🏼 lukeb.co/ParallelsFreeTrial
Social Media / Contact Me
======================
📫Newsletter: www.lukebarousse.com/
👨🏼💼 Linkedin: / luke-b
🅧 X/Twitter: / lukebarousse
🌄 Instagram: / lukebarousse
⏰ TikTok: / lukebarousse
As an Amazon, Coursera, and Parallels Affiliate Programs member, I earn a commission from qualifying purchases on the links above. It costs you nothing but helps me with content creation.
0:00 Intro
0:27 MS Excel
2:01 Virtual Machine - Parallels
2:50 SQL Apps
5:29 Python
7:20 R - Programming Language
8:12 Tableau
9:54 Power BI
10:41 ChatGPT
12:10 Notion
12:23 Discord
14:12 Terminal
14:46 GitHub Desktop
15:08 Grammarly
15:43 CleanShot X
#datanerd #dataanalyst #datascience - Věda a technologie
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😮
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 😂😜
Public Server for Luke Please.
Very informative and through ❤ the ultimate guide 😊 Thank you so much
good and smooth explanation. That is my fav video that highly recommended all my data analytics begineer community. Thanks for video dear Luke)
Thanks so much for sharing all the info, great video
Thanks for this detailed video.
Thanks for the video, I appreciate it very much. Pure knowledge and experience talking!
This a pretty hefty list of notable applications!!!
Super hefty!
Thanks a lot Luke.
Thanks 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! :)
awesome, Thanks for the 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.
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.
So much thank you Luke! I also would like to know what app do you use for video editing and record for your CZcams Videos?
final cut pro for video editing since i'm on a mac. Love it
Nice Video!
awesome video.
Awesome ❤
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
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 CZcams 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
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 ❤️♥️👍
Excel on macOS is limited ? I have the yearly subscription for it on Mac and 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.
Which is better to learn, Excel or Google Sheets ?
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
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.
How do you take notes?
Great video as usual!
Just i think this is the first time I commented 😅
Awesome video..I religiously follow you and I m growing🎉🎉🎉
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).
I've grown to like Numbers on Mac lol. Especially since it's free :)
🤔
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!
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 )
first !
Top comment for absolutely no reason