Discussions
Explore the latest discussions related to this domain.
Is data analysis considered a "tech" job?
Main Post:
I've been telling people I'm changing career to data analysis and the reaction I keep getting is "tech people are all getting laid off." I always felt that although similar it's not the same thing. I know in a recession almost all jobs are at risk but is there a correlation between tech layoffs and the state of data analysis jobs? P.S. would be a great data project!
Top Comment:
Large tech companies are doing massive layoffs. Data analysis is an in-demand job across most industries. Everyone has dirty data and needs reports.
Teacher to Tech?
Main Post:
I'm currently an elementary ESL teacher and looking to get into data analysis. I'm taking the Google DA course and also following up with projects from Alex the Analyst. I have a BA in Global Language/Culture and an MA in Teaching ESL. My thesis was in the field of corpus linguistics which is basically database inquiry searching for different grammatical forms and their frequency using query language similar to SQL. I know my soft skills from teaching would transfer well, but I have very few contacts in the data field and wondered if there is any actual possibility of landing an entry level job.
Top Comment:
I was a high school math teacher and I transitioned into Data Analytics. You can definitely do it. What helped me was doing a production app for the school I was working at. I learned way more than I did from “learning projects” and it made my portfolio stand out.
Landing your first job will be hard. You’ll probably have to apply to A LOT of jobs. But eventually you’ll be able to find someone who will give you a chance.
As far as tech goes. Learn SQL. You’ve gotta be sharp with SQL. Learning a scripting language is also a good idea (python is a pretty good choice for this field).
Good luck!
Cognizant multiple choice tech assessment
Main Post:
Has anyone taken the cognizant mc tech assessment for the healthcare data analyst position? What kind of questions can I expect?
Top Comment:
How did it go?
I want to go from my tech support job to data analytics. Advice?
Main Post:
I have an BS in IT and have been working tech support for about a year and a half now. I honestly hate it. I know that a year an a half should be good time to pivot myself into entry level data analytics work, but I spent most of that time trying to feel out what I wanted. Only more recently have I decided to fully back pursuing data analytics as a career.
So there is a really good community college nearby so I decided to take some classes there. First semester only taking one class and its over SAS. Which I've heard might be a waste of my time. I've done a little studying of SQL and python in the past and this class kind of feels like a waste. But maybe Im wrong and its good to learn?
Overall Im wondering if I even should continue taking classes. Instead I could focus on the google data analytics cert and focus on other online learning. I just was thinking it would be good to have connections through the school and have something to put on my resume.
But idk. I find this class not very engaging.
Other question
Is there anything different I could be doing for work that would be good to help me get experience? I am not really qualified at the time for data analytcs and I'm also really really really tired of tech support and my OT bleeds in my life. My current job is very stressful and I've been wondering what else I could do while I work on picking up the skills needed.
Top Comment:
I find it interesting you guys find SAS to be a waste. I worked for the govt and now moving to a bank, both times as a data analyst, and SAS was necessary in both roles. I think learning SAS as my first language eased me into SQL quite nicely, since you’re able to write SQL in SAS under PROC SQL.
Best of luck to you, OP. You could take online courses for many Data Analyst languages and programs (Power-BI, Tableau, Python, etc) and as long as you know your stuff and look for offers and opportunities in LinkedIn, you should be alright.
SQL Tech interview
Main Post: SQL Tech interview
Top Comment:
I've taken a few recently, they are pretty similar across companies. Typically they will look for
- Joining 3 or more tables
- aggregations
- Filtering
- Window function or two
- They wont ask for it but you will want to have your code easy to read. This means use CTEs, don't let your SELECT clause be a paragraph, and name your aggregations accurately. Maybe even add a few short comments in the code
I've never heard of an interview using more advanced stuff like a recursive query or PIVOTs.
Best way to go from Ad Tech to Data Analyst?
Main Post:
Currently I my job is in media operations/ad tech. Basically I put together media campaigns according to our media buyers, traffick out ads to vendors (sites the advertiser wants to show ads on), and troubleshoot with vendors. I use a lot of Campaign Manager 360, and have some experience with Google Tag Manager and Google Analytics. I have medium Excel skills (regularly do Pivot Tables and V-lookups for example).
I know Data Analytics not only makes more money, but I’ve always been a more analytical person. I’m not sure how to break into the field though, as all jobs I see require some experience.
Is my best bet some lateral move in my company? Maybe to a job like Marketing Analyst? I’m not sure what similarities/differences there are between Marketing Analyst and Data Analyst. I also have a bachelors in Biology and MBA.
Top Comment:
merciful retire grab swim clumsy fertile sable wakeful encouraging rhythm
This post was mass deleted and anonymized with Redact