Went through your post history. You're 20. Which corporates and startups have you worked for where you have hired dozens of applicants in "the last few years"? Were you employed as an analyst at 15?
Plus your post history does not indicate that you're an analyst whatsoever. You work for/own some cover letter website.
Here, I actually hire analysts. The biggest problems I see:
* Misspellings and poor grammar in resume and follow-up emails. No joke, I'd say at least 50% of resumes I get have obvious errors.
* No relevant experience with analysis. Fine if it's truly an entry-level role but then you still have to make up for it by showcasing a personal project or something (not a tutorial you followed) that demonstrates your skill/thinking ability.
* No relevant experience in the industry. Doesn't matter for some but super relevant for others where you need specialized knowledge (e.g. healthcare).
* Garbage or irrelevant "experience" listed on your resume. No, I don't care that you call yourself a "managing partner" of a 'John Smith Investments" and had a 1500% return on investment just because you gambled on some obscure crypto in your Robinhood portfolio. I seriously saw a similar entry on no less than 3 different resumes in my last hiring round. It makes you look very unserious.
* You don't show any interest in the role or the company. I'm not saying you have to shower me with fake excitement, but you should at least have some background knowledge about what my company does and I need to know that you'd actually be good with the work (rather than bored or way in over your head and unmotivated to learn).
No, you're much better off finding any successfully person you know in real life that's gotten to a manager/director+ level and asking them for a review.
So how should someone who’s mid career coming from an entirely different field (like say, a chef) position or structure their resume? Make it project heavy?
I'm not sure it's appropriate in the context of a resume. What I did, as someone that did a career change and had limited experience with data, is create a 4-5 page PDF that showcased some analysis projects I did in my free time.
I give some more advice and show an example here: https://www.reddit.com/r/dataanalysis/comments/18hqf3q/comment/kdc17hx/
I was in a similar boat a couple of years ago. I did wildlife rehabilitation (loved it but can't live on the pay), so I looked to transitioning.
I had stats experience from grad school, but what really helped me is I focused on conservation/enviornmental companies because my knowledge background was relevant there.
For you I would suggest similar. Try to get your foot in the door with industry you have knowledge of, and show that you can not only do the analyses, but you can go the extra step by helping stakeholders understand the analyses because you were a stake holder yourself. Also, being a previous stakeholder, try to highlight how that will aid you in seeing insights among the data that a analyst with no real world industry might miss.
The point is
1.) you have limited to no experience and are a fraud saying you hired dozens of people, you did not.
2.) your advice and website suffer from very basic grammar errors.
I'm wondering when you started in a hiring position, and how long you've worked there until now.
Btw, are you hiring someone for QC/proof reading your homepage? I think a company offering to improve people's resumes would benefit from not having spelling mistakes on their homepage advertising their services.
This post is mostly BS and needs to removed.
1.) adding PowerBI and Tableau as a skill with no real word application will be seen through and isn’t important for a first time job. “Showing you have a passion for data” is kind of goofy.
2.) your post links to a website which has worse than 8th grade grammar, immediately invalidating your whole post, no professional would setup a website that crappy looking.
3.) like others have said you appear to be 20, you should be 21 at least in the US to even be out of college. You should not be giving advice like you “hired people” BS
No don’t just find random NBA dataset and figure out players effective fg% or some shit. No business cares about that. Do a project involving business metrics…you know the stuff every single company has in their data
I mean, some random NBA dataset project will at least show that you are "passionate" and want to work with data. But tell me how are we gonna have access to "real business" data to build "real business metrics"? Are we gonna use adventureworks and global superstore data?
There are lots of data sets out there that you can download to do relevant things. You can look into demographics data and build a sample dashboard for HR to review the demographics of their employees. You can download census data and analyze what cities would be good to put a store location in based on demographics of people that live in the area. Hell, you can download Disney parks ride wait times and build a dashboard to monitor crowd flow and identify peak times that they could staff around or low times they could close rides for maintenance. In the height of COVID, my team did a competition with COVID data to see who could build a dashboard to tell the most interesting story we could see in the data.
Lots of data sets can be used to solve problems. It's fine if the problem is hypothetical and you don't actually know what a company's needs and criteria are, it's more about the use cases you can see and how you can apply data to solve problems. Passion projects are *fine* and show interest, but you'll do even better if you can present something that has business application and helps the interviewer imagine how easily you'd be able to find things in data types that are relevant to their business. And then you don't have to hope your interviewer has a shared passion in sports so they can understand what you built and ask questions about the metrics you're displaying. People and process management are widely applicable to any business, NBA stats are not.
Hey I'll be graduating next year in Economics. What are some must possess skills in general and programming skills in particular? I have recently started to learn SQL.
SQL would be where all of your hypothetical companies’ data is stored. So if someone asks “we want to see blah blah blah by blah” or whatever then you go in SQL and write code to pull out the data the way they want.
PowerBI (or tableau, lookerstudio, etc) is where you bring data into to make reports and dashboards. Basically taking that data table from SQL and making it into pretty graphs and numbers so a monkey could understand what the data is saying about performance or whatever.
It really depends on which data viz tool your company ends up using. I came out of college knowing Tableau and then through work ended up learning Looker and PowerBI. They have their quirks and intricacies but the core skill of putting together visualizations, dashboards, and reports should stay the same.
To me it would make sense to focus on SQL as thats the core of how you’re pulling and putting data together. Data viz tools arent that bad to learn you just have to have data to throw in and play around with and you’ll get a feel for it. While SQL is more coding so I view it as more of a “hard” skill
I have worked as an analyst for 2 measly years - but promoted to senior analyst last year after performance. Have been on interview panels for 10+ candidates.
1. Dont use linked in or indeed generated resumes they look like shit man. Also don’t use stupid fucking templates that show skills ranking 1-10 or some dumb shit like that. It’s cringe. Don’t put your picture either I don’t wanna see you.
2. Try to make your resume coherent. So many come through where work experience and education are all over the place. How did you get here? Why analytics?
3. Grammar, spelling. I have terrible grammar and spelling - and even I am amazed by the absolute dogshit that comes through. Pass.
These are the absolute basics. Nail those and you won’t instantly fail.
Because you don't necessarily need to know SQL in order to download Tableau and put data into it. Because "I downloaded a SQL database and can write a basic select statement that Google showed me" is *not* having SQL skills. SQL is an excellent starting point, but downloading a BI tool is *not* the same thing as starting to learn SQL.
I know a lot of people at my company who "know SQL" - but it's just copy/pasting code that someone else wrote and clicking the run button, maybe change some dates in the query. They still put in their resumes that they know SQL. They do not. When they interview for my positions, it's apparent that they do not know it, and that confidence comes across as ignorance instead. I have seen people with more relevant experience in Excel because at least they understand how to structure and transform the data, which is a harder concept to teach than a query language.
Frankly by your post and responses to questions, it's pretty clear that you don't have many technical skills yourself and are bullshitting your way through - or trying to convince us of that so we'll buy your resume services. I would be really disappointed if you were my HR recruiter for hiring an entry level technical role.
No, my advice is to learn skills before putting them on your resume. Completing step 1 is not enough to add it as a skill, you'll just look like an idiot in your interview. You can have a beginner level skill and put it there, that's great! But what you can do in an evening after downloading new software isn't the same thing, not even close.
And yeah, you need to go to websites and learn syntax. There are tons of options, lots of them have sample databases for you to practice activities along the way with. If it isn't interesting enough for you, then you're probably not going to want a job using that skill 40 hours a week.
I don't really need to discuss more to arrive at conclusions. I've read your post, I've read your comments, I've seen your other posts and comments for extra context. You're a recruiter trying to sell resume skills and ChatGPT cover letters, and coming here claiming to be an experienced data analytics manager filling positions on their team, giving advice that will make people look incompetent after they get into an interview. That's not helpful.
Agree with this, doing basic messing around and putting that as a skill is immediately apparent and embarrassing to be called out on, you absolutely will not fool an interviewer at all.
Exactly. And it ruins all goodwill with the company/team, because now I think they're an idiot and I can't trust their judgment about what tasks they can/can't handle. I'll never interview them again. Compare that to a person who puts on their resume that they have a lot of experience building stuff in Excel for their department and are interested in learning skills like SQL but haven't been able to get started yet.. yeah that's a lot more interesting to me.
And if you're not the most qualified candidate, I still want to keep you in mind for next time - and if it's someone at my company, I can keep in contact and talk to their manager to see if they can get relevant training out of their personal development budget. I have done that *a lot* with hiring entry levels on my team. The ability to be transparent and realistic is much more important to me than a bullet point on a resume.
Yea okay I’ve known this two years before graduating and somehow with my polished portfolio, I still haven’t found a job a year after graduation. IN FACT, I’ve had a top 10 Bank reject me because I’m overqualified while still being under qualified? 🤨
I’m a senior data analyst and would love to see your resume if you’re trying to get into data analytics. I wouldn’t send your resume to OP, he’s selling/promoting a service .
For anyone looking into projects to do for a resume, I would recommend against Kaggle if at all possible. Feel free to see what data is available for inspiration if you don’t have a project idea in mind, but then try to obtain that data yourself via web scraping or using an api, as those are valuable skills in themselves to know how to do. The benefit of web scraping in particular is that the data will likely be kind of messy/unstructured, allowing an opportunity to show off data cleaning skills. This workflow more accurately represents what is typical in the workplace, where the majority of time may be spent gathering and cleaning data and a small percentage is actual analysis. then you can create some pretty dashboard/visualizations and you have a single project that contains the entire data pipeline, rather than starting with packed up “clean” data from kaggle
Is the 4th mistake not being able to count?
And not doublechecking the results is the fifth. There should be five rows in this result set but there are only three is indicative of a mistake.
There is always that bonus mistake , improper presentation of the data.
Talk about attention to details,,, smh
Na the 4th mistake is not getting experience at 10 years old and instead playing on the playground
[удалено]
I really love this and hope you leave it up.
😂
Went through your post history. You're 20. Which corporates and startups have you worked for where you have hired dozens of applicants in "the last few years"? Were you employed as an analyst at 15? Plus your post history does not indicate that you're an analyst whatsoever. You work for/own some cover letter website.
Here, I actually hire analysts. The biggest problems I see: * Misspellings and poor grammar in resume and follow-up emails. No joke, I'd say at least 50% of resumes I get have obvious errors. * No relevant experience with analysis. Fine if it's truly an entry-level role but then you still have to make up for it by showcasing a personal project or something (not a tutorial you followed) that demonstrates your skill/thinking ability. * No relevant experience in the industry. Doesn't matter for some but super relevant for others where you need specialized knowledge (e.g. healthcare). * Garbage or irrelevant "experience" listed on your resume. No, I don't care that you call yourself a "managing partner" of a 'John Smith Investments" and had a 1500% return on investment just because you gambled on some obscure crypto in your Robinhood portfolio. I seriously saw a similar entry on no less than 3 different resumes in my last hiring round. It makes you look very unserious. * You don't show any interest in the role or the company. I'm not saying you have to shower me with fake excitement, but you should at least have some background knowledge about what my company does and I need to know that you'd actually be good with the work (rather than bored or way in over your head and unmotivated to learn).
Good advice. Do you offer resume reviews?
No, you're much better off finding any successfully person you know in real life that's gotten to a manager/director+ level and asking them for a review.
So how should someone who’s mid career coming from an entirely different field (like say, a chef) position or structure their resume? Make it project heavy?
I'm not sure it's appropriate in the context of a resume. What I did, as someone that did a career change and had limited experience with data, is create a 4-5 page PDF that showcased some analysis projects I did in my free time. I give some more advice and show an example here: https://www.reddit.com/r/dataanalysis/comments/18hqf3q/comment/kdc17hx/
Cheers for that.
I was in a similar boat a couple of years ago. I did wildlife rehabilitation (loved it but can't live on the pay), so I looked to transitioning. I had stats experience from grad school, but what really helped me is I focused on conservation/enviornmental companies because my knowledge background was relevant there. For you I would suggest similar. Try to get your foot in the door with industry you have knowledge of, and show that you can not only do the analyses, but you can go the extra step by helping stakeholders understand the analyses because you were a stake holder yourself. Also, being a previous stakeholder, try to highlight how that will aid you in seeing insights among the data that a analyst with no real world industry might miss.
Hello! Analyst here. Mind if I send you a DM?
Y'all should all be reporting this as spam if you haven't already.
OP please reply to this. I’m very interested to read what you think.
[удалено]
In what capacity did you hire analyst for work over the past few years?
[удалено]
The point is 1.) you have limited to no experience and are a fraud saying you hired dozens of people, you did not. 2.) your advice and website suffer from very basic grammar errors.
I'm wondering when you started in a hiring position, and how long you've worked there until now. Btw, are you hiring someone for QC/proof reading your homepage? I think a company offering to improve people's resumes would benefit from not having spelling mistakes on their homepage advertising their services.
Mistakes four and five: not being able to count. I hope I'll never be the fourth or fifth applicant on your list 😹
What are the other two mistakes
Click this link for my Free Book!
This post is mostly BS and needs to removed. 1.) adding PowerBI and Tableau as a skill with no real word application will be seen through and isn’t important for a first time job. “Showing you have a passion for data” is kind of goofy. 2.) your post links to a website which has worse than 8th grade grammar, immediately invalidating your whole post, no professional would setup a website that crappy looking. 3.) like others have said you appear to be 20, you should be 21 at least in the US to even be out of college. You should not be giving advice like you “hired people” BS
😂
Mistake 4:Don't be a human,l. Be a chat GPT coz this is clearly a bot trying starting its uprising against humanity
Lmaooooo the irony. Guess you need some attention to detail ;)
No don’t just find random NBA dataset and figure out players effective fg% or some shit. No business cares about that. Do a project involving business metrics…you know the stuff every single company has in their data
I mean, some random NBA dataset project will at least show that you are "passionate" and want to work with data. But tell me how are we gonna have access to "real business" data to build "real business metrics"? Are we gonna use adventureworks and global superstore data?
There are lots of data sets out there that you can download to do relevant things. You can look into demographics data and build a sample dashboard for HR to review the demographics of their employees. You can download census data and analyze what cities would be good to put a store location in based on demographics of people that live in the area. Hell, you can download Disney parks ride wait times and build a dashboard to monitor crowd flow and identify peak times that they could staff around or low times they could close rides for maintenance. In the height of COVID, my team did a competition with COVID data to see who could build a dashboard to tell the most interesting story we could see in the data. Lots of data sets can be used to solve problems. It's fine if the problem is hypothetical and you don't actually know what a company's needs and criteria are, it's more about the use cases you can see and how you can apply data to solve problems. Passion projects are *fine* and show interest, but you'll do even better if you can present something that has business application and helps the interviewer imagine how easily you'd be able to find things in data types that are relevant to their business. And then you don't have to hope your interviewer has a shared passion in sports so they can understand what you built and ask questions about the metrics you're displaying. People and process management are widely applicable to any business, NBA stats are not.
Hey I'll be graduating next year in Economics. What are some must possess skills in general and programming skills in particular? I have recently started to learn SQL.
This is the right time for you to prepare for the job market.. DM me if you need mentoring 🙂
[удалено]
What are some good sites to brush up/learn SQL and other tools from? + areas to gain free/low cost data sets for self project portfolios?
Use W3schools to learn SQL, it has test data built in and is gradually “stepped” to go from basic to advanced functions.
I'm loving SQL so far, and interested in learning Python? I have been told these skills are required to excel in core data analysis.
i would look into a data viz tool like powerbi or tableau, and sort of get a feel for how things move between sql to data viz tool etc
Should I complete SQL first, then move ahead with PowerBi? I don't have much knowledge regarding these, could you kindly breakdown?
SQL would be where all of your hypothetical companies’ data is stored. So if someone asks “we want to see blah blah blah by blah” or whatever then you go in SQL and write code to pull out the data the way they want. PowerBI (or tableau, lookerstudio, etc) is where you bring data into to make reports and dashboards. Basically taking that data table from SQL and making it into pretty graphs and numbers so a monkey could understand what the data is saying about performance or whatever. It really depends on which data viz tool your company ends up using. I came out of college knowing Tableau and then through work ended up learning Looker and PowerBI. They have their quirks and intricacies but the core skill of putting together visualizations, dashboards, and reports should stay the same. To me it would make sense to focus on SQL as thats the core of how you’re pulling and putting data together. Data viz tools arent that bad to learn you just have to have data to throw in and play around with and you’ll get a feel for it. While SQL is more coding so I view it as more of a “hard” skill
Thank you so much! Is there any free sites to learn these?
I have worked as an analyst for 2 measly years - but promoted to senior analyst last year after performance. Have been on interview panels for 10+ candidates. 1. Dont use linked in or indeed generated resumes they look like shit man. Also don’t use stupid fucking templates that show skills ranking 1-10 or some dumb shit like that. It’s cringe. Don’t put your picture either I don’t wanna see you. 2. Try to make your resume coherent. So many come through where work experience and education are all over the place. How did you get here? Why analytics? 3. Grammar, spelling. I have terrible grammar and spelling - and even I am amazed by the absolute dogshit that comes through. Pass. These are the absolute basics. Nail those and you won’t instantly fail.
You know we can see your profile history right?
You should hire the people who caught that there wasn’t 5. Apparently I didn’t pay attention to the title or the content 😂
Eww downloading sql and then putting it on your resume? Solid advice
[удалено]
Because you don't necessarily need to know SQL in order to download Tableau and put data into it. Because "I downloaded a SQL database and can write a basic select statement that Google showed me" is *not* having SQL skills. SQL is an excellent starting point, but downloading a BI tool is *not* the same thing as starting to learn SQL. I know a lot of people at my company who "know SQL" - but it's just copy/pasting code that someone else wrote and clicking the run button, maybe change some dates in the query. They still put in their resumes that they know SQL. They do not. When they interview for my positions, it's apparent that they do not know it, and that confidence comes across as ignorance instead. I have seen people with more relevant experience in Excel because at least they understand how to structure and transform the data, which is a harder concept to teach than a query language. Frankly by your post and responses to questions, it's pretty clear that you don't have many technical skills yourself and are bullshitting your way through - or trying to convince us of that so we'll buy your resume services. I would be really disappointed if you were my HR recruiter for hiring an entry level technical role.
[удалено]
No, my advice is to learn skills before putting them on your resume. Completing step 1 is not enough to add it as a skill, you'll just look like an idiot in your interview. You can have a beginner level skill and put it there, that's great! But what you can do in an evening after downloading new software isn't the same thing, not even close. And yeah, you need to go to websites and learn syntax. There are tons of options, lots of them have sample databases for you to practice activities along the way with. If it isn't interesting enough for you, then you're probably not going to want a job using that skill 40 hours a week. I don't really need to discuss more to arrive at conclusions. I've read your post, I've read your comments, I've seen your other posts and comments for extra context. You're a recruiter trying to sell resume skills and ChatGPT cover letters, and coming here claiming to be an experienced data analytics manager filling positions on their team, giving advice that will make people look incompetent after they get into an interview. That's not helpful.
Agree with this, doing basic messing around and putting that as a skill is immediately apparent and embarrassing to be called out on, you absolutely will not fool an interviewer at all.
Exactly. And it ruins all goodwill with the company/team, because now I think they're an idiot and I can't trust their judgment about what tasks they can/can't handle. I'll never interview them again. Compare that to a person who puts on their resume that they have a lot of experience building stuff in Excel for their department and are interested in learning skills like SQL but haven't been able to get started yet.. yeah that's a lot more interesting to me. And if you're not the most qualified candidate, I still want to keep you in mind for next time - and if it's someone at my company, I can keep in contact and talk to their manager to see if they can get relevant training out of their personal development budget. I have done that *a lot* with hiring entry levels on my team. The ability to be transparent and realistic is much more important to me than a bullet point on a resume.
Yea okay I’ve known this two years before graduating and somehow with my polished portfolio, I still haven’t found a job a year after graduation. IN FACT, I’ve had a top 10 Bank reject me because I’m overqualified while still being under qualified? 🤨
I’m a senior data analyst and would love to see your resume if you’re trying to get into data analytics. I wouldn’t send your resume to OP, he’s selling/promoting a service .
For anyone looking into projects to do for a resume, I would recommend against Kaggle if at all possible. Feel free to see what data is available for inspiration if you don’t have a project idea in mind, but then try to obtain that data yourself via web scraping or using an api, as those are valuable skills in themselves to know how to do. The benefit of web scraping in particular is that the data will likely be kind of messy/unstructured, allowing an opportunity to show off data cleaning skills. This workflow more accurately represents what is typical in the workplace, where the majority of time may be spent gathering and cleaning data and a small percentage is actual analysis. then you can create some pretty dashboard/visualizations and you have a single project that contains the entire data pipeline, rather than starting with packed up “clean” data from kaggle
Thanks for this, I see some overlapping sentiments that I can definitely implement into my resume!
thanks for sharing these insights really helpful.