Danny, it's good that you are spending your winter break to learn a new skill -- that is very productive.
You are right that each firm will have their own choice of software or way of doing things, so it would be wise to have some general skills that you can use in most kinds of analytical work. Even within AT&T, we don't use the same things in all departments -- in my previous AT&T role I used some Access/VBA and Cognos/EBP; now I use more SAS and Tableau)!
However, there are some several things that I find ubiquitous:
Excel (or a spreadsheet program)
SQL (or a way to extract data from databases)
Powerpoint/Word (or a program where you show your findings)
BONUS: Tableau/PowerBI/Microstratgy (or a program that allows you to generate faster insights)
If you are spending some time working on SQL, keep at it -- it is the foundation of most of the more advanced tools out there, and if you can get to an intermediate-level understanding of it, everything else will be MUCH easier to understand. To augment this self-study, I would recommend taking a Statistics, or Applied Statistics/Research Methods class so that you have a way to apply what you have learned.
I know you are eager to learn lots, but focus on doing a project (whether it's in the context of college coursework or not) and applying what you have learned so that you have the general experience of what being a market analyst does in real life. At the end of the day, you will have more time to learn specific tools when you graduate (some companies have training) -- but you have to have an understanding of the basics, and the tenacity to execute analytical projects to be successful.
Ross recommends the following next steps:
- Find a practice dataset to practice your SQL on.
- Create a list of questions that your dataset may be able to answer; then use your analytical skills to answer them
- Present your work to a teacher or mentor for review.