How Much SQL, Python, Excel & Tableau Is Enough? | Realistic Expectations

How do you know if the skills you have are enough for the job?

🤌 SO WHAT
In this video I'll show you ALL YOU NEED to know about the 4 most popular data analytics tools so that you will have an idea on your level of preparation for each

🤝 JOIN THE FREE DATA LAB COMMUNITY

✨ GET ALL OF MY FREE RESOURCES (Resume Template, SQL Cheat Sheet, Data Portfolio Template and more!)

🚀 MY DATA ANALYTICS MASTERCOURSE IS LIVE!!

🤝 LET ME BE YOUR MENTOR - BOOK A CALL WITH ME

📸 SOCIAL
Instagram and TikTok - @Loresowhat

📩 Get in touch:

🔎 CONTENT
0:00 Intro
0:13 How much SQL for Data Analytics
3:16 How much Python for Data Analytics
4:38 How much Excel for Data Analytics
6:13 How much Tableau for Data Analytics

#dataanalytics #skills

[ranjitn]

I really love how you don't bullshit and just come to straight to the point and convey them. Liked and subscribed just for that!

[teukuario]

However, once you can use Power Query and Power Pivot, you’re ready to work with Power BI, which is definitely worth learning. In finance, we don’t often work extensively with SQL or databases. But if the monthly expense data from SAP amounts to about 1 million rows, what tools can we use within a typical finance environment? The answer is Excel and Power Query, as they can handle millions of rows, which is incredibly helpful for managing such data.

[robertpearce]

I'd also say Power BI is an excellent alternative to Tableau - And it also makes Power Query more relevant, as Power Query is used by both Excel and Power BI.

[ELFBDS]

1. I use Python first web scrapping the database with the help of AI assistant.
2. Once I get the csv files of my database I start next with Spreadsheet to create, clean, organize the tables.
3. I jump to SQL for the sake of learning how to query (here I should be focusing more now that I watch Loreeenzo's video).
4. I post & publish my datasets on Kaggle playing with some coding their helps learn more about the data I collected.
5. Finally on Tableau, I try to create some worksheet vizzes as best as I can but I've noticed that at this level most of the time I have to go back to the 1st or 2nd step to update or even add new missing data so I can complete the visualization I'm working on.
6. Once I'm more comfortable I will rework the same projects on Power BI ...

[apamwamba]

I generally agree but please excel is usually the starting point because its used by billions of people around the planet. DO NOT skip the basics of Power Query [optionally basic M Language features like when merging excel or csv files] and Power Pivot [Including basic DAX] and basic data modelling [Star Schema]. You can easily move on to POWER BI [or Tableau]. SQL and basic data modelling including basic database building and modelling must then be your next step. This will cater for up to 90%. Good to consider certification in SQL and BI tools to attract the attention of employers and credibility but a first degree in anything is usually a good starting point but on the side lines make sure to learn the basic data analytics skills mentioned above as you study for your degree. If you can squeeze in basic statstics / research in your degree the better.... NOW if you can expand on your Python / R + Statistics knowledge as an advanced step. Consider GIS also.. Then you will be good to go. Lastly if you want to work in international organisations, a Masters is becoming a minimum requirement..

[norilyngamara]

I'm just starting to learn SQL, thanks so much for this!

[elverrivera]

The best video I have seen, straight to the point. Very helpful information to the people that wants to initiate in data analytics.

[VinPal]

This is very helpful. I have watched so lany videos similar to yours. However you literally come straight to the point and state everything we must learn in a short summary.

[gilbertchirinze]

You nailed it as it is. I can spend the whole day listening to it. It’s a thorough coverage and relevant literature. You inspired me to consider doing all of them.

[gidosman]

I learn all these tools SQL, Excel, Tableau, R and Python last year in my Master degree and Google data analytics certificate, however I feel no limit of learning to say I mastered them.

[moumou]

to be honest one of the best mentor keep going

[hotchipps]

I am currently working on a personal project - MS Excel. If it goes well, will try and see if I can replicate it with SQL and Tableau too. Not sure about the rest, but I can say this about Excel, that knowing advance features and formulas in Excel does change the way we look at data.

It is indeed difficult for a non technical person to switch to a technical mindset. I guess I will have to be patient and take it slow for the transition to be impactful.

[oneirosmorpheus]

This is the best video for inspiring future Data Analysts. I will be taking these courses soon at my community college. Thank you so much.

[amandabraz]

The way you explained this made it so easy to understand. 🧠

[AzeezulGani]

I now have a clarity on how I will use whatever I learned now.
Thank You, the video was really good and informative!

[tummalapallikarthikeya]

This video really helps a lot for beginners to prevent mislead learning. Thank you so much ❤

[Idarasunshine]

I’m starting to learn these so I’m excited thank you!

[mrfazul]

To be honest this is an amazing video straight to the point

[SojibMiah-tu]

The way you capture moments is so beautiful. 😍

[OMOELENIYAN]

THE MOST HONEST ROADMAP, THANKS CHAMP💪