Most Important Skills For A Data Analyst At Fortune 100 Tech Company
Dennis, a data analyst, highlights Excel navigation and SQL query writing as crucial technical skills, noting that even basic "select statements" and "join queries" are valuable. The ability to learn independently, driven by "curiosity," is equally important, as demonstrated by their self-taught expertise.
Data Analysis, SQL, Excel, Python, Problem-solving
Advizer Information
Name
Job Title
Company
Undergrad
Grad Programs
Majors
Industries
Job Functions
Traits
Dennis Pham
Data Analyst
Fortune 100 Tech Company
San Diego State University 2009
None
Business Management & Admin
Technology
Data and Analytics
Pell Grant Recipient, Took Out Loans, Worked 20+ Hours in School
Video Highlights
1. Proficiency in Excel is crucial, focusing on problem-solving and efficient navigation rather than memorizing every formula.
2. SQL skills are essential, including basic select statements and join queries.
3. Python is a highly valuable skill, and self-learning and curiosity are key attributes for success in this field.
Transcript
What sort of skills are most important for a job like yours?
I would say definitely being very familiar with Excel. That's not to say you need to know every single formula; I definitely do not. But it's about being able to problem-solve and figure out the best way to navigate through Excel.
SQL is also very important. That has been very useful in my career. Being able to write some queries, sometimes basic select statements, and sometimes you'll need join queries, is really helpful.
From what I've seen, Python is also very helpful. That's something on my list to learn. I'm self-taught in everything, so if you don't know something now, that's okay.
As long as you have curiosity and are willing to learn on your own and figure things out, those technical skills would be really important. But in general, just the curiosity to be able to figure out how to do something is really important.
Advizer Personal Links
No