Tools you should know as a Data Analyst

Рет қаралды 49,628

Жыл бұрын

Coursera Plus (7-day free trial) 👉🏼 lukeb.co/CourseraPlus
Top course for aspiring Data Analysts 👉🏼 lukeb.co/GoogleCert
Course recommendations from the video:
Meta Database Engineer Certificate 👉🏼 lukeb.co/MetaDataEngineer
GCP Fundamentals 👉🏼 lukeb.co/GoogleCloud
AWS Fundamentals 👉🏼 lukeb.co/AWS
Azure Fundamentals 👉🏼 lukeb.co/Azure
Understanding ERPs 👉🏼 lukeb.co/ERPs
Data Analyst Core Skill Courses
==================================
📜 Google Data Analytics Certificate (START HERE) 👉🏼 lukeb.co/GoogleCert
💿 SQL for Data Science 👉🏼 lukeb.co/SQLdataScience
🧾 Excel Skills for Business 👉🏼 lukeb.co/ExcelBusinessAnalyst
🐍 Python for Everybody 👉🏼 lukeb.co/PythonForEverybody
📊 Data Visualization with Tableau 👉🏼 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 Science Must Read 👉🏼 geni.us/StorytellingWithData
📙 Tableau 👉🏼 geni.us/tableau
📘 Power BI 👉🏼 geni.us/powerbi
📕 Python 👉🏼 geni.us/pythontricks
Tech for Data Nerds
==================================
⚙️ Tech I use 👉🏼 kit.co/lukebarousse/computer-...
🪟Windows on a Mac (Parallels VM) 👉🏼 lukeb.co/ParallelsFreeTrial
👨🏼‍💻 M1 Macbook Air (Mac of choice) 👉🏼 geni.us/M1macAir8GB
💻 Dell XPS 13 (PC of choice) 👉🏼 geni.us/DellNewXPS13
💻 Asus Vivo Book (Lowest Cost PC) 👉🏼 geni.us/AsusVivoBook15
💻Lenovo IdeaPad (Best Value PC)👉🏼 geni.us/LenovoIdeaPad15
Social Media / Contact Me
======================
🙋🏼‍♂️Newsletter: www.lukebarousse.com/
🌄 Instagram: / lukebarousse
⏰ TikTok: / lukebarousse
📘 Facebook: / datavizbyluke
📥 Business Inquiries: luke@lukebarousse.com
As a member of the Amazon, Coursera, Hostinger, Parallels, Interview Query, and Data Camp Affiliate Programs, I earn a commission from qualifying purchases on the links above. It costs you nothing but helps me with content creation.
#datanerd #dataanalyst #datascience

Пікірлер: 129

@LukeBarousse Жыл бұрын

Data Nerds, I need your help!! I'm looking for fellow data nerds that landed their data jobs WITHOUT having ANY degree. 📜 If you (or someone you know) did this, fill out (or share) this form 👉🏼forms.gle/V5ENE9gUuAm6db5F6

@claudiakramer4516 Жыл бұрын

well give me some time. Not only don't I have no degree I started this process while in a homeless shelter and have no job and 2 years and 3 months to complete this before my government housing runs out.

@claudiakramer4516 Жыл бұрын

Is there is way I can get a list of those programs on your super Mario board?

@LukeBarousse Жыл бұрын

@@claudiakramer4516 I don't have a list typed out, so sorry for this

@tiffaninghs Жыл бұрын

My interview is tomorrow !! Hope to be able to fill out the form!!

@sebastianchiaramonte2688 Жыл бұрын

You don't need to master every single tool that is out there. Once you land a job, they will probably train you for a particular technology, programming language, etc. If you are good at the basics, and with a few projects to showcase your skills, that's more than enough to get a job. Also remember soft skills are extremely important. If you don't know how to communicate your findings from your analysis, do a right presentation, tell a simple but effective story to engage your audiance, then you are screwed.

@FSANCHEZog Жыл бұрын

Great content, thank you and keep the good work

@pavlosemeniuk Жыл бұрын

Thank you Luke, I’m trying to get into Data Analyst role and your videos help me going. Slow and steady. Keep it up!

@LukeBarousse Жыл бұрын

Keep up the studies, Pavlo!

@milaparwanitatsumi Жыл бұрын

Luke like always, such an amazing and informative video, thank you my dude 😎 for sharing all your knowledge with your data 🤓 community 🤘

@AlexTheAnalyst Жыл бұрын

It's an honor to be framed :D

@LukeBarousse Жыл бұрын

It's what gets me up in the morning! 😜

@josephcruz4736 Жыл бұрын

Welcome back @luke! We missed your videos! Please don't leave us hangin'! 😄

@LukeBarousse Жыл бұрын

Thanks Joseph!

@cjn211 10 ай бұрын

Hey Luke, I’m in the process of changing careers to be a data analyst. I’m currently taking Google’s Data analytics professional certificate course on coursera. I’m on module 7 of 8 and to be honest , feeling a bit overwhelmed, in that I don’t feel like I remember 1/2 the stuff I’ve already completed. The course structure of watching a 5 min video, take a quiz with a few questions and then have to go do it is hard for me. I’m the type that if I sat with you or another professional for a month and practicing, I’d be 10xs better than I am since starting this course on cousera. There’s not much repetition on there and that’s how I learn best- hands on and repetition . Was never a computer person, but I’m very analytical. Started on wall sr couple years after HS- No college degree- I know I can do this and I know once I know what I’m doing, I’ll crush it. Any feedback , advice, recommendations are greatly appreciated. Are there any sort of programs or courses for excel/sheets, SQL, tableau, R , python that are interactive where they give immediate feedback and also where I can get lots of reps? Again, thanks

@Seftehandle Жыл бұрын

I love the core skills u mentioned spreadsheet py xl sql and powerbi

@ZekeAizaSayZiaLeon Жыл бұрын

With these skills you can performed end to end process from etl to viz and even data warehousing. This is how we're one of the high paid salary.

@joaovitorpinheiroocker8343 Жыл бұрын

I liked the stranger things vibe of the video😅 I can confirm that the fundamentals are the basis for landing in data analyst job, as I did. I'm now learning tools and concepts that can help me in the transition to being an analytics engineer and after maybe a data engineer. With that in mind, I wonder if you could do a video of the tools/experience/concepts to transition in data jobs, I think this deserves a shot luke. Great content Luke🤘

@LukeBarousse Жыл бұрын

Let me see what I can do on that topic, thanks for suggesting this, João!

@j.pesquera Жыл бұрын

Ah, ha! I see a nice plug of the Fourier Series from the interval -L ≤ x ≤ L in that PowerPoint, which is probably one of the most valuable/applicable equations in Physics and Math.

@ebek4806 Жыл бұрын

Quality content as usual.

@LukeBarousse Жыл бұрын

What tools did you not expect to use as a data analyst?

@axel_r_ Жыл бұрын

So I just jumped off the Data Science education to Data Analytics. You better make this worth it!! 😂🤨😂

@LukeBarousse Жыл бұрын

😜 You won't be disappointed 🙌🏼

@kassiowifried Жыл бұрын

Good job.

@songfreakish7313 Жыл бұрын

Hey Luke. Love your presentations and depictions! Could you please do a video on Zoho analytics?

@LukeBarousse Жыл бұрын

Let me see what I can do on this!

@bouseuxlatache4140 Жыл бұрын

Thanks for the insighful video Luke! I wonder if you could share some experience on how you organise your skills and anticipate on the ones needed for your projects. Take care!

@LukeBarousse Жыл бұрын

I like this idea Bouseux, let me see what I can do on this topic!

@bouseuxlatache4140 Жыл бұрын

thanks Luke!

@its_RickyM Жыл бұрын

Came across this channel today. Thinking of becoming a fellow data nerd as well.

@LukeBarousse Жыл бұрын

Heck yeah! Love have a fellow data nerd join!

@BackpackersCompass Жыл бұрын

Im using Datacamp to learn and improve data analysis myself, and I just started as researcher at a highly-ranked university. Quantitavely its essential to learn and apply simular skills as data analysts! Funny thing though, is that I actually found your youtube channel though Datacamp...

@LukeBarousse Жыл бұрын

Yeah I made a couple Power Bi courses for them!

@davidmiller-td1sl Жыл бұрын

Ppt is the unsung hero of data nerds! It’s a pretty hefty tool!

@LukeBarousse Жыл бұрын

I bet Alex uses Google Slides... 😒

@alexanderknowles9449 Жыл бұрын

Omg - do you even data nerd?!?!? Slides all day every day

@monishmaha 8 ай бұрын

@luke given the developments recently. Does micorsoft fabric provides all the tools discussed in this video?

@hoangyenin5945 Жыл бұрын

Great content :3

@vectoralphaSec Жыл бұрын

Heres the thing Excel, Tableau and PowerBI are all paid and mostly for Windows. I have linux and am poor so i cant afford any of that. But i do know Python and SQL though. So do i still have to learn those skills and if so how if i cant get access to them? Or can i just do everything those tools can do in only Python/SQL?

@AbhiBubai Жыл бұрын

Hi, I am a recent MBA graduate wants to pursue a career in Analytics, but landed up in SAP. Although I still want Analytics, so started linking up SAP with Analytics like SAP Analytics cloud and Power BI. TBH I am damn confused now, do you think having knowledge of SAP, I will reach my destination. Please help me and guide me

@Major_Data Жыл бұрын

My life is complete! There has been a Luke sighting!

@LukeBarousse Жыл бұрын

A little bit of a hiatus, but it's good to be back, Al!

@Major_Data Жыл бұрын

@@LukeBarousse knowing you, you were working on something big. That, or you crashed your hang glider and were in a coma.

@LukeBarousse Жыл бұрын

@@Major_Data Let's go with the latter! 🤣🤣

@Numbermind Жыл бұрын

Hey @Luke Barousse, great video! However, I have one question for you: If you need to use Python to clean your data, how do you do to connect it with Tableau if you want your data to be "live"?

@LukeBarousse Жыл бұрын

Checkout TabPy, it's a library for python to integrate into Tableau

@Numbermind Жыл бұрын

@@LukeBarousse Thanks for the answer! This is actually a part left out for most of data KZfaqrs out there. Have you thought about making a video about this? For example "How do I connect Python, SQL and tableau together" or something similar? You could talk briefly about that package. Keep up the great work!

@georgesylas1149 Жыл бұрын

Hello Luke, you're doing a great job keep it up. Can you recommend a course on Apache Spark?

@LukeBarousse Жыл бұрын

Let me see what I can do on this my dude!

@tuckerstachitas4426 Жыл бұрын

Another funny and informative video! I loved the Dumb and Dumber reference. You sir, are a National Treasure!

@LukeBarousse Жыл бұрын

Aw Thank you shipmate!! 😍🙌🏼😘

@gaurangsingh9926 Жыл бұрын

hi luke, I'm new to your channel and still in school but I was wondering where I should start after completing school. (watched your "how I would be a data analyst" vid)

@LukeBarousse Жыл бұрын

I'd still recommend the same approach; just make sure you start looking for jobs now to not only start applying, but also getting familiar with the job requirements for what you need to know.

@daru5057 Жыл бұрын

Great Video as always, Luke. I just started learning data analyst in excel. Do you know any way to test how far my skills been improving? Like, do you know where I can find an example data to test myself?

@LukeBarousse Жыл бұрын

Have you checked out Kaggle? Plenty of data there to check out

@marcd316 Жыл бұрын

Love the Mario Landscape - is it some stock item with all the tools or did you create it :) ? Asking for a friend I think this is sth. you could use to pitch sth. to management

@LukeBarousse Жыл бұрын

Unfortunately I had to just print this from images I googled... come to think of it I know need to order a new color ink cartridge 😜

@bheem_sen_ Жыл бұрын

Well as a fresher i do have a cert in cloud. Azure 900

@MsBriLoo22 Жыл бұрын

Hi! I’ve been thinking about getting a certificate in Data Analysis and I wanted to know what it consists of specifically. I have a basic idea (sorta) of it but I’m still confused what it consists of and I could really use some advice! Thanks

@LukeBarousse Жыл бұрын

I have a few videos on this!

@tomsbondars Жыл бұрын

An unexpected Dumb and Dumber reference? LOVE IT!😄

@JasonEyestone Жыл бұрын

@5:04 nice music choice 🤙🏼

@LukeBarousse Жыл бұрын

Love that song!

@jak637 Жыл бұрын

Hey Luke, whats your thoughts on Masterschool data analytics? price-wise, content, value etc

@LukeBarousse Жыл бұрын

I looked into it a while back and looks promising

@Jbiralde Жыл бұрын

Can I get a full screenshot of your data pipeline? Love the theme and layout!

@fisnik394 Жыл бұрын

Agree!

@LukeBarousse Жыл бұрын

Aw thank you so much! A lot of printer ink went into making that, ha! Let me see what I can do about sharing a screenshot

@LukeBarousse Жыл бұрын

drive.google.com/file/d/12jYzNk3TBe8i6ow2uHJjdwW5RT7wpoIu/view?usp=sharing

@chrisblankenship9911 Жыл бұрын

Much appreciate you sharing the data pipeline screenshot - very helpful! former US Marine and thanks for your Naval service too!

@joshellis4966 Жыл бұрын

Hi Luke! Nice video! I am curious of your standard method(s) for data collection from SAP? SAP is my company's ERP system, however our business is challenged with analyzing that data outside of SAP or in any analytical tool. Unfortunately, the only method I am aware of is from the presentation layer, which isn't really ideal. There are transactions like SQVI, SQ01/02/03 that allow for query design in the presentation layer, but are quite limited. It feels odd that I have never actually written a SQL query via an editor to query our ERP data. These are just .txt or .xls extracts to a local machine, and that's about it. I want to know how to truly explore our ERP system with SQL. SAP is so expansive, so starting for scratch using it as a source for data collection just feels like situation of "You only know what you know", and there really isn't anyone who knows otherwise to learn from.

@LukeBarousse Жыл бұрын

When I had to use SAP, I was primarily using downloable excel files of the data I needed; so I don't know if i'm much help for a better option for yourself for this. So sorry

@joshellis4966 Жыл бұрын

@@LukeBarousse Thank you for your response, Luke. I suppose that validates my current methods haha!

@CPA1535 Жыл бұрын

I might be able to help you. I am a CPA who has used sap for three years. Try and export the data one month at a time as a flat file. It is called zrtr where I work. Import that file into a SQLite database and just build it out from there. I use my little SQLite database every day and love it. Hope that helps.

@YlmazDALKIRANscallion Жыл бұрын

A personal question: Have your ever played Silent Hunter IV Wolves of Pasific Pack?

@LukeBarousse Жыл бұрын

Nah I'm sorry I haven't

@YlmazDALKIRANscallion Жыл бұрын

@@LukeBarousse Alright =)

@mohammedziauddin9707 Жыл бұрын

Hey Luke, regarding the iron analyst competition , why didn't any one just use SQL and tableau. Wouldn't that be much easier and time saving??

@LukeBarousse Жыл бұрын

One of the contestants @Data with Zach, used Tableau. Very good option to use! Regarding SQL, the data was provided in CSVs, and we just needed to perform a one-time anlaysis; so SQL wasn't necessary. ALTHOUGH the data was pretty large and if I had to do it over again (and had more time); I would have stuck it into a sql database

@nontapattechopiyakul5323 Жыл бұрын

Can you make a video on how you use Python as data analyst? As a junior data analyst, I rarely use Python for the job (mostly use Excel, SQL, Tableau/Power BI).

@LukeBarousse Жыл бұрын

Heck yeah I can, plan on making it later this year!

@nontapattechopiyakul5323 Жыл бұрын

@@LukeBarousse Thanks a lot Luke, looking forward to it!

@tugrularslan542 Жыл бұрын

Hey Luke, i used currently after have see your video the trial month for cousera plus. But, it seem that the plus various haven' t enough course about Data Engineering or Software Engineering. In my opinion the basic variant have regading thus more. Why is that so or I'm blind :-) ?

@LukeBarousse Жыл бұрын

Yeah the Plus may not include those courses unfortunately; They have a large portion on Plus but it looks like you found some that weren't'

@tugrularslan542 Жыл бұрын

@@LukeBarousse Thanks for your response. What are you recommend. The Basic-Package or the Plus-Package? My region is Germany and i woultn't pay for both

@LukeBarousse Жыл бұрын

@@tugrularslan542 Really depends on how many courses you are taking and if they are in plus are not, to determine which is more cost effective. Sounds like a great problem to solve for a data analyst! 🤓

@tugrularslan542 Жыл бұрын

@@LukeBarousse Hey, i know. I work self as Data Eninner. The reason why is ask you is, I have still a subscription on udemy. And now i compare., what is bether for me and what is more effective ;-) I agree with you, we need for this a Data Enginner & Analyst

@moresunsetsplease3578 Жыл бұрын

Feels hopeless tbh. I got sql pretty much under my belt and know a little tableau but see job postings with 150+ applicants within 4 hours is discouraging.

@rasulnuriyev3346 Жыл бұрын

Hello. Hope you are doing well. I have got a question. I am a professional Document Controller with almost 12 years of experience. My excel knowledge is very good. And my study is a Bachelor degree in the construction engineering field. I am willing to change my profile to data analyst as it seems very attractive and I think that can handle it. What would you advise?

@LukeBarousse Жыл бұрын

I have a few beginner videos on my channels, I'd recommend starting here: kzfaq.info/get/bejne/ealmabWJyrrSj2g.html

@cherinemaartens8799 Жыл бұрын

Hi Luke, have been watching your informative videos thanks a lot. I am in the Radiology Medical domain in a 3rd world country. Qualified Radiographer and Mammographer not Radiologist. Would like to prepare for the next phase, who knows what that is? Considering the Coursera Data Analysis Course. Any ideas and guidance from your side will be much appreciated. Thx a mil.

@LukeBarousse Жыл бұрын

I'm not fully sure on this industry; but I'd recommend asking around to colleagues and those on Linkedin that work in that industry on how they've used Analytics. There usually is a use case

@falayeadeyinka168 Жыл бұрын

Hi, you are doing a job of heavy lifting. Anyway, does cousera offer award google data analytics certificate and how long? Do they offer certification courses in data pipelines ? Thank you.

@LukeBarousse Жыл бұрын

what do you mean with your first question? If you are referring to financial aid, coursera offers this for this course; For data pipelines; i'll have to look into this more; but the Meta database engineering certificate is looking promising for this.

@ambulance7049 Жыл бұрын

I took the Google Data Analytics Professional course for a bit. This specific course was split into 8 different modules focusing on each part of the Data Analysis Process. I had only completed 1 of 8 but it does reward you with a certificate after each module. For instance I was awarded with the "Foundations: Data, Data, Everywhere" module certificate, so it's safe to assume it is like that for every other course.

@syhusada1130 Жыл бұрын

Yeah, been trying to subscribe to coursera plus, but their paypal payment method is broken or something, so I can't apply.

@LukeBarousse Жыл бұрын

Really?!?! Thats not right, I'd reach out to Coursera via this link: www.coursera.support/s/learner-help-center-contact-us

@reidflood Жыл бұрын

Hey Luke! Love the videos. Didn’t realize that I wasn’t already subscribed to your channel, so…done! On another note, I’m really interested in how you’re pulling data out of SAP and automating that process. I’m trying to do a similar process and just want to compare notes. As far as I’ve experienced, there’s no good way to automate it. Thanks, dude!

@LukeBarousse Жыл бұрын

Yeah I never found a great way to do it... someone at my company developed a python script that automated data extraction and could be modified to fit our needs... but unfortunately I can't share that script.

@reidflood Жыл бұрын

@@LukeBarousse Got it, thanks! Yeah, I totally understand not being able share it. Just knowing that someone was able to get a workaround with some python was helpful. Thanks, again, Luke!

@shreyassarvade908 Жыл бұрын

😃👍 great

@saidurrahman9480 Жыл бұрын

Hey!! Take love 💕

@djb6496 Жыл бұрын

Upvoted. Gotta love Dumb n Dumber inspired jokes!

@LukeBarousse Жыл бұрын

😜 Heck yeah! You got the reference!

@enonoah8743 Жыл бұрын

Hi Luke, I'm inspired by your lovely contents on KZfaq and it has further strength my desire to learn data analytics but i need a MacBook to start learning and sadly it would take me years to buy one. Can you help out?

@LukeBarousse Жыл бұрын

I'd actually recommend starting with a Windows machine, much cheaper options!

@enonoah8743 Жыл бұрын

@@LukeBarousse thanks mate, I'll do just that 👍🏼

@DataFocusCloud Жыл бұрын

Hi Luke, I'm Dory from DataFocus Cloud. I found your youtube videos very useful and absolutely love them, and would like to cooperate with you.

@JoshBabin Жыл бұрын

Awesome video as always. Would have been cooler if you said you use Coursera to access OVER 9000 courses, but you'll know better next time ;-)

@LukeBarousse Жыл бұрын

Ha! Will include meme as well. 🤣

@JoshBabin Жыл бұрын

@@LukeBarousse perfect! On another note, it was nice hearing about Alteryx. Have used it and found it quite easy to automate data transformation activities

@EldhoseJoseph Жыл бұрын

Why the Alex (the analyst) photo frame there? I know he is good, but did he elevated to God mode? 😂 Hope Alex clarifies. :)

@LukeBarousse Жыл бұрын

Waiting also for Alex to clarify!

@AlexTheAnalyst Жыл бұрын

@@LukeBarousse I'm just happy to be here guys :D

@SeattleDataGuy Жыл бұрын

You had me at "I am a fan of SQL or Python"

@LukeBarousse Жыл бұрын

Gotta appease the Data Engineers!!! 😜

@KenJee_ds Жыл бұрын

The handshake 😂

@LukeBarousse Жыл бұрын

😜

@s.nikolic497 Жыл бұрын

That's a lot of tools

@alessandroardu1059 Жыл бұрын

7000 courses attended 😳😳😳😳

@GUARIVERA81 Жыл бұрын

Seems like these days Power Bi is more needed then Tableau or at least an equal.

@LukeBarousse Жыл бұрын

Yeah I'm with ya, I also think it really depends on the company and industry. I'm a big fan of Power BI and used it at my last company whereas others i've talked to used exclusively Tableau and feel it's more needed.