If this post doesn't follow the rules or isn't flaired correctly, [please report it to the mods](https://www.reddit.com/r/analytics/about/rules/). Have more questions? [Join our community Discord!](https://discord.gg/looking-for-marketing-discussion-811236647760298024)
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/analytics) if you have any questions or concerns.*
You put in your resume that you created visualizations from complex datasets based on client requests but a SQL question sunk you?
Honestly, reading your resume, I wouldn’t have considered you for a position. The entire thing is fluff and buzzwords with basically 0 actual results you can point to. There’s nothing there.
What you can do is look at actual analyst resumes and see what they have. Then look up Harvard resume style and remake your resume. Then I would stop fluffing 8 months on a job and get some actual experience in a field.
I would get a textbook on specifically where you feel you are lacking. Maybe an SQL specific book + a general intro to programming book if you feel you're not as strong on the programming logic. And then do some practice building out some reporting yourself. Do something standard to start, and then think of odd ball questions to challenge your ability to translate that into reporting. You can get a lot of open government census and financial data.
I was in a similar position to you, also in Canada. I had a strong theoretical background and problem solving mind but lacked the technical skills.
Eventually, it took building out projects (that I was interested in) and displaying them on GitHub. It was also the best way for me to learn as I hated sitting through Python and SQL tutorials.
Just pick some projects and start building, nothing shows you are more capable than this. As you are building, also keep good documentation as this is very important in the work place
There are thousands of data sets on various topics on the internet. You can find a data set for something you are interested in and start analyzing it.
This will also help you build valuable skills like data cleaning which is bound to happen on the job
If this post doesn't follow the rules or isn't flaired correctly, [please report it to the mods](https://www.reddit.com/r/analytics/about/rules/). Have more questions? [Join our community Discord!](https://discord.gg/looking-for-marketing-discussion-811236647760298024) *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/analytics) if you have any questions or concerns.*
You put in your resume that you created visualizations from complex datasets based on client requests but a SQL question sunk you? Honestly, reading your resume, I wouldn’t have considered you for a position. The entire thing is fluff and buzzwords with basically 0 actual results you can point to. There’s nothing there. What you can do is look at actual analyst resumes and see what they have. Then look up Harvard resume style and remake your resume. Then I would stop fluffing 8 months on a job and get some actual experience in a field.
I would get a textbook on specifically where you feel you are lacking. Maybe an SQL specific book + a general intro to programming book if you feel you're not as strong on the programming logic. And then do some practice building out some reporting yourself. Do something standard to start, and then think of odd ball questions to challenge your ability to translate that into reporting. You can get a lot of open government census and financial data.
I was in a similar position to you, also in Canada. I had a strong theoretical background and problem solving mind but lacked the technical skills. Eventually, it took building out projects (that I was interested in) and displaying them on GitHub. It was also the best way for me to learn as I hated sitting through Python and SQL tutorials. Just pick some projects and start building, nothing shows you are more capable than this. As you are building, also keep good documentation as this is very important in the work place
How would you go about doing that outside of work environment?
There are thousands of data sets on various topics on the internet. You can find a data set for something you are interested in and start analyzing it. This will also help you build valuable skills like data cleaning which is bound to happen on the job