This is just what I needed. I’m at step zero of my data analyst journey and am overwhelmed already. As to not wasting time what do u recommend as a starter for learning analysis. I’ve just subscribed to the google analysts certificate course assuming it must be the best one right? What would you do if u were me right now? Love the video will subscribe
You're welcome! I think the best place to start is to look at open jobs for entry-level data analyst or analyst roles with data responsibilities, even if it's just working with Excel. Looking at all of these open job descriptions and requirements will give you an idea of what you need to learn. Based on this, you can find a pattern of skills you need to meet the bare minimum for not getting filtered out. List out the most common skills and software needed for these jobs then use ChatGPT to help craft a learning plan based on your schedule and how much time you can devote to learning. If you're in school, I recommend getting an internship or just getting a job in the industry you want to work in so you can start building the experience that you need. If you already have a job, I have a new video coming out on how to leverage your existing job and start applying the data skills you're learning now. Doesn't have to be big projects just apply what you're learning in small ways till you have learned enough to make bigger changes. My guess is part of the reason you're feeling overwhelmed is because you are looking at how much you need to complete and then having thoughts that spiral because of the amount of work then those thoughts build on each other till you're overwhelmed. It helps to break up the goal of becoming a data analyst into smaller achievable pieces that aren't as stressful. Learn to mediate to help reduce the overwhelm so it's easier for you to take action. Again, ChatGPT is a great resource not only to help craft your plan but to help you navigate the overwhelm. Treat ChatGPT like a mentor that will help you navigate becoming a data analyst, but also as a therapist to help you talk through the overwhelm. It's been working for me tremendously in a wide variety of uses. I hope this helps! I'll create a future video to expand on my advice here if that helps!
@@GetaDataJob without doxxing myself I currently work at at market research center regarding mainly foodstuff, we do other stuff of course but that’s our bulk focus. I can’t wait for this new video you’ve mentioned. I’m sure it will be enlightening. Thanks again for commenting back.
SQL plus the ability to work within Office 365 (Excel / Access ) has made me an automation expert. - VBA (coding within Excel/MS-Access). - SQL (work with any ANSI database --> Oracle, Sql Server, Snowflake, DB2, etc).
Yes, working with VBA has helped me become invaluable to my department. I wished I learned Python earlier and focused more on building in SSMS instead of only working within Office 365. There's still great demand, but heading into a data scientist role, I need to upskill more.
@smrcreative23 Which 20 sec part and where are you now in your journey? For how long I made it this far without SQL, I used Microsoft Access to build databases and tools so for awhile so I didn't need to know advanced SQL. For awhile I just built the SQL statements in Access then translated it to SQL Server. In my career, I became more of a data analyst that did more Excel and Access VBA developing than reporting. And when I say SQL, it's not that I don't how to write SQL. I'm fine writing immediate level statements and complex joins. It's more that I don't know SQL Server to an immediate to advanced level. I can query and clean the data I need in SSMS, but things are just easier for me in Access using it as a front-end tool. But that's been the focus recently is converting all the old tools to a SQL Server backend and keeping Access as the front-end. Then learning to become more of an advanced user.
Data Analyst and data science in general. I wish I prepped my learning towards becoming a data scientist or Quant. I didn't realize the various roles that I'd want to potentially become till later. The tips also apply to full stack development.
Thank you for sharing your experience!!
My pleasure!
This is just what I needed. I’m at step zero of my data analyst journey and am overwhelmed already.
As to not wasting time what do u recommend as a starter for learning analysis. I’ve just subscribed to the google analysts certificate course assuming it must be the best one right? What would you do if u were me right now?
Love the video will subscribe
How do I not waste time when I don’t know how to measure?
You're welcome! I think the best place to start is to look at open jobs for entry-level data analyst or analyst roles with data responsibilities, even if it's just working with Excel. Looking at all of these open job descriptions and requirements will give you an idea of what you need to learn.
Based on this, you can find a pattern of skills you need to meet the bare minimum for not getting filtered out. List out the most common skills and software needed for these jobs then use ChatGPT to help craft a learning plan based on your schedule and how much time you can devote to learning.
If you're in school, I recommend getting an internship or just getting a job in the industry you want to work in so you can start building the experience that you need.
If you already have a job, I have a new video coming out on how to leverage your existing job and start applying the data skills you're learning now. Doesn't have to be big projects just apply what you're learning in small ways till you have learned enough to make bigger changes.
My guess is part of the reason you're feeling overwhelmed is because you are looking at how much you need to complete and then having thoughts that spiral because of the amount of work then those thoughts build on each other till you're overwhelmed.
It helps to break up the goal of becoming a data analyst into smaller achievable pieces that aren't as stressful. Learn to mediate to help reduce the overwhelm so it's easier for you to take action.
Again, ChatGPT is a great resource not only to help craft your plan but to help you navigate the overwhelm. Treat ChatGPT like a mentor that will help you navigate becoming a data analyst, but also as a therapist to help you talk through the overwhelm. It's been working for me tremendously in a wide variety of uses.
I hope this helps! I'll create a future video to expand on my advice here if that helps!
@@GetaDataJob without doxxing myself I currently work at at market research center regarding mainly foodstuff, we do other stuff of course but that’s our bulk focus. I can’t wait for this new video you’ve mentioned. I’m sure it will be enlightening. Thanks again for commenting back.
SQL plus the ability to work within Office 365 (Excel / Access ) has made me an automation expert.
- VBA (coding within Excel/MS-Access).
- SQL (work with any ANSI database --> Oracle, Sql Server, Snowflake, DB2, etc).
Yes, working with VBA has helped me become invaluable to my department. I wished I learned Python earlier and focused more on building in SSMS instead of only working within Office 365. There's still great demand, but heading into a data scientist role, I need to upskill more.
The first 20 sec is where I am now. Also, how did you make it this long without SQL?
@smrcreative23 Which 20 sec part and where are you now in your journey?
For how long I made it this far without SQL, I used Microsoft Access to build databases and tools so for awhile so I didn't need to know advanced SQL.
For awhile I just built the SQL statements in Access then translated it to SQL Server.
In my career, I became more of a data analyst that did more Excel and Access VBA developing than reporting.
And when I say SQL, it's not that I don't how to write SQL.
I'm fine writing immediate level statements and complex joins.
It's more that I don't know SQL Server to an immediate to advanced level.
I can query and clean the data I need in SSMS, but things are just easier for me in Access using it as a front-end tool.
But that's been the focus recently is converting all the old tools to a SQL Server backend and keeping Access as the front-end. Then learning to become more of an advanced user.
Data analyst or full stack development?
Data Analyst and data science in general. I wish I prepped my learning towards becoming a data scientist or Quant. I didn't realize the various roles that I'd want to potentially become till later. The tips also apply to full stack development.
@GetaDataJob Thank you sir 🙂
You're welcome! 😁