5 answers
1
Question
Asked
420 views
What should I work on this summer if I want to be a data analyst?
If I want to become a data analyst, are there any skills I should work on, technical skills I should learn, and/or books I should read to learn more about this field?
Login to comment
5 answers
Updated
Lisa’s Answer
Hi Ying!
As you prepare for a career as a data analyst, I would highly recommend building some foundational knowledge of how to use Microsoft Excel/Google Sheets. Those tools hold a lot of power!! It would be wise to know how to write and use some basic formulas, such as vlookup, importrange, if, countifs, and how to use pivot tables.
Here is an article from Indeed that goes over some of those basic formulas: https://www.indeed.com/career-advice/career-development/google-sheets-formulas
This is also a good Youtube video on Google Sheets basics: https://www.youtube.com/watch?v=_bvRa7T-59U
As you prepare for a career as a data analyst, I would highly recommend building some foundational knowledge of how to use Microsoft Excel/Google Sheets. Those tools hold a lot of power!! It would be wise to know how to write and use some basic formulas, such as vlookup, importrange, if, countifs, and how to use pivot tables.
Here is an article from Indeed that goes over some of those basic formulas: https://www.indeed.com/career-advice/career-development/google-sheets-formulas
This is also a good Youtube video on Google Sheets basics: https://www.youtube.com/watch?v=_bvRa7T-59U
Updated
Jennifer’s Answer
Hello there! I strongly encourage you to dive into learning SQL and Excel/Google Sheets. They're incredibly useful tools. Additionally, you might find Teradata and Tableau to be extremely beneficial, as they've been of great help to me.
Don't worry about the cost, there's a wealth of free training resources available online, as well as informative books on Amazon to guide your learning journey. I would also urge you to explore training on data storytelling and Google Slides. The ability to transform data into insightful stories is a truly valuable skill to possess. So, go ahead and embrace the learning adventure!
Don't worry about the cost, there's a wealth of free training resources available online, as well as informative books on Amazon to guide your learning journey. I would also urge you to explore training on data storytelling and Google Slides. The ability to transform data into insightful stories is a truly valuable skill to possess. So, go ahead and embrace the learning adventure!
Updated
Rachel’s Answer
I'm excited to share these helpful resources with you, which I believe will guide and inspire you on your journey:
https://www.youtube.com/watch?v=CUBfrdDwznQ
https://www.youtube.com/watch?v=I1XeDS-GLbg
https://www.youtube.com/watch?v=d_2fGS6QVDo
https://www.youtube.com/watch?v=aqRxZSrJLEc
https://www.youtube.com/watch?v=PTfssYLJoks
https://www.coursera.org/articles/how-to-become-a-data-analyst
https://www.indeed.com/career-advice/career-development/how-to-become-data-analyst
Dive in and enjoy exploring these sources, as they're designed to support and motivate you in your pursuit of success!
https://www.youtube.com/watch?v=CUBfrdDwznQ
https://www.youtube.com/watch?v=I1XeDS-GLbg
https://www.youtube.com/watch?v=d_2fGS6QVDo
https://www.youtube.com/watch?v=aqRxZSrJLEc
https://www.youtube.com/watch?v=PTfssYLJoks
https://www.coursera.org/articles/how-to-become-a-data-analyst
https://www.indeed.com/career-advice/career-development/how-to-become-data-analyst
Dive in and enjoy exploring these sources, as they're designed to support and motivate you in your pursuit of success!
Thank you so much for the linked resources, Rachel! I'll look into these as a starting point.
Ying Lin
Updated
Margaret’s Answer
There are plenty of skills required to be a successful data analyst from project management to communication to analytical understanding. But starting with the technical side will make you a competitive applicant.
I'd suggest starting by learning SQL which is very versatile and common across many companies. It's also easier to pick up and can be used within other languages such as R, SAS, or Python. The other advantage to SQL is there are a lot of free ways to learn it. Check out a book from the library if you are more inclined towards books but I'd recommend checking out Coursera or Codecademy which have plenty of free tutorials that allow you to practice along.
I'd suggest starting by learning SQL which is very versatile and common across many companies. It's also easier to pick up and can be used within other languages such as R, SAS, or Python. The other advantage to SQL is there are a lot of free ways to learn it. Check out a book from the library if you are more inclined towards books but I'd recommend checking out Coursera or Codecademy which have plenty of free tutorials that allow you to practice along.
Thank you so much, Margaret! I'll work on learning SQL this summer.
Ying Lin
Updated
Joseph’s Answer
I wholeheartedly agree with both colleagues who have responded to your inquiry, and I believe Rachel is heading in the right direction—inspiration is key.
With that in mind, I absolutely adore my job! Sure, there are days when it feels like trudging through thick mud, but uncovering a hidden pattern within the data can truly brighten your day. Never hesitate to question why or to declare, "This doesn't make sense."
Now, allow me to pose a question: What if delving into data analytics is actually putting the "cart before the horse"? For example, suppose you're considering a career as an anthropologist. Surprisingly, exploring whether you want to become an anthropologist can teach you data analytics.
So, my suggestion is to concentrate on an alternative career path, and if it ultimately leads you back to data analytics, you'll know for certain that it's the right profession for you.
With that in mind, I absolutely adore my job! Sure, there are days when it feels like trudging through thick mud, but uncovering a hidden pattern within the data can truly brighten your day. Never hesitate to question why or to declare, "This doesn't make sense."
Now, allow me to pose a question: What if delving into data analytics is actually putting the "cart before the horse"? For example, suppose you're considering a career as an anthropologist. Surprisingly, exploring whether you want to become an anthropologist can teach you data analytics.
So, my suggestion is to concentrate on an alternative career path, and if it ultimately leads you back to data analytics, you'll know for certain that it's the right profession for you.
Thank you for the advice.
Ying Lin