What other questions about working in data do you have? Leave a comment below and I'll share some thoughts! Feel free to send to friends if you found this video helpful!
Hi Christine, I'd like to ask about recent college graduates who are landing their first job as a data analyst, without prior experience or internships. Do you have any advice for them?
Hi Christine, Thanks for the insightful video! I’m interested in how you would adjust this framework for a business analyst path if at all. From the job postings I’ve seen, it seems like aspiring business analyst should focus heavily on a BI tool and less on SQL or Excel. What are your thoughts?
Are there books you recommend as supplementary materials to this roadmap, or one more high-level that puts the data analyst role into full business and tech context?
@@claytonp23 theyre very similar roadmaps / skillsets overall, but a business analyst typically works more directly with stakeholders and requires more emphasis on soft skills like presentations, leading meetings, project management. business analysts should focus more on Excel, SQL will be a plus, and domain knowledge will be even more of a plus.
This is a prime example of domain knowledge . Your knowledge truly shines through and differentiates you from many other channels I have come across within the same realm. Thank you for the realistic insights. I'm 40 years old and have decided to get into tech after many many years of banking. It truly is intimidating but I have faith that I can find my way. People like you offer the much needed guidance. Thank you
i'm really happy to hear this. your banking experience may lend itself well to the transition, so see it moreso as a move that uses your banking experience (customer service, financial understanding, data mindset, any work with technology or excel) to become an even better analyst in tech.
I've watched so many of these roadmaps, and this one tops them all. So much information here that I hadn't found elsewhere. Thanks for straying right into my feed.
thank you! it comes from a lot of close conversation and reflections from students as well - combining my experience + their experience + my network. more to come :)
Thank you very much for the video! I really like your channel! Could you please make a video about technical and behavioral interviews? What are the basics and what needs to stand out during the interview for Data Analyst? Advice on networking would be great too
i got you! check out my most recent videos on networking, standout interview responses, and how to speak like a data analyst - those will help you stand out during the interviews. next week i'll be uploading a video on nailing the technical interview, so you're right on time :)
I wasn't really paying attention to portfolio projects or interviews before feeling comfortable with my technical skills first. But knowing the roadmap of what I'm doing, how I use the technical skills I learn as you mentioned in some videos , and why I chose certain things over others will actually add more value to my effort while learning Thanks alot for you Videos
30?!? man don't tell me i'm old! i wouldn't be looking at people's age, i would be looking at their experience, motivation, and soft skills. that matters much more
Do you have any good resources for beginners trying to learn the most common business metrics and how to calculate them? For example, I didn't know what profit ratio was, and even when I was given the formula for it I still had to learn the difference between profit/sales and sum(profit)/sum(sales) and how that affects your output. I'd love to learn the common metrics for certain industries. Like, what is click-through-rate?
great question - i'll do more videos on this since i don't see a lot of content about business metrics and the actual application of technical tools to understand these metrics. check out this blog by castordoc, which has articles on the top 10 metrics by industry and how they're calculated. www.castordoc.com/blog-category/data-for-business-people
Thank you Christine for the great video! (Im gradating next year from college stressing over jobs binge-watching ur videos at 5am hehe 😅your content is so helpful!! Look forward to seeing more! Keep up the good work
Thank you I am transitioning into tech from marketing and this was so helpful, I just use tech term where data terms where even tho SQL will help me also and the steps ❤
Have you had students from other countries that got a job in the US, Canada or Europe? I'm from Brazil and salaries here are very low, so I'd like to apply to jobs abroad.
Your Roadmaps and strategies have developed more confidence but, Can you suggest some tips for the freshers who are applying for the Data Analyst Roles because there will be too much difference between the resume of Fresher Engineer and an Experienced one.
i'll do some videos about more detailed resumes soon, but overall the actual structure of the resume is not actually that different between the two. check out my resume video to see examples of the kinds of bullets and bios you should include - and pay attention to the level of detail used, which is applicable to both recent grads and working professionals.
application slots this week are full, but check back next week! and i'll release new application slots on my newsletter. the next cohort starts september 21st
You are seriously doing a great job.and i really appreciate your work . hey can you make a video on kpi,and which kpi are imp for data analysis.and in this video you mention business metrices.(can you explain this term).
Hi Christine thanks for sharing the insightful information! I’m based in the UK at the moment and want to look for some voluntary projects for the organisation in the Europe. By any chance, do you have any recommendations for projects for EU based orgs? Thank you in advance!
hello! i can ask my students based in the UK for more info, but my mentees in London have had good luck with catchafire. Even though it's based in the US, the volunteer opportunities are remote, and one of them was able to work with Google Analytics data through this experience which helped his job search.
Hello Christine! Thank you for such amazing videos, all of them are insightful and practical. Can you please help with the most confusing question for a fresher - Tell me about your project? As it is a make-or-break question in an interview, how can we answer it in a way that will help us to land a job?
good question! i answer this in my interview video (third video) where i talk through the most common questions asked :) it is indeed a make-or-break question
thanks for the video! as for the impact aspect of projects, would using econometric modelling techniques be an example of both showing domain knowledge (economics) and also assessing impact of x on y/providing business insights?
There's a problem with having business metrics on portfolio projects, without working on the project and rather trying to simulate it how can one show that these are the business metrics we have improved?
not all metrics have to be "improved ____ by X%". metrics are anything quantitative that help someone understand the technical aspects and rigor of the project: - dataset of 100K rows - maintained model of 20 data inputs - coordinated across 10 construction clients - worked with 5 senior stakeholders for portfolio projects, this means mentioning insights and their values: "discovered dip in sales by 20% over winter months because of ___"
for data science much is the same, but the kinds of projects you do need to be more geared towards technically advanced techniques and python, and less on business stakeholders
@@christinejiangdata oh because I decided to ask. Thanks Quick one, do you think something like a fraud detection can be suitable for a CV showing thingy? Kinda lost in btwn for learning for my personal growth or for showcase, hopefully you understand what I mean
On the quest to land an interview before 2026 (from your previous video haha). - Any tips on where to find company published datasets? - I'm already overhauling my portfolio based on your previous videos, but I feel like I have already been doing the other stuff you mentioned, but absolutely pathetic results in the last two years. I'm hoping the newer projects will help. - Regarding industries, I have prior data science experience at a healthcare company, consulting in medical devices, and currently doing freelance data projects (very hard to find and extremely rare). I'm trying to get into something like fintech. will relevant projects help? Because I don't see any way of getting fintech experience without getting a job in fintech. Thanks for these videos! Will be sure to post an update if your methods work for me!
these questions require more in-depth answers than i can give in text, but are questions i'll be answering in future live Q&A sessions (so stay tuned on my linkedin). short answer: relevant projects will help if they give you experience working with relevant fintech metrics so you can speak about them more knowledgably in interviews. data work in healthcare could very reasonable translate to data work at a finance company or a tech company, and then study fintech metrics to fill lin the gaps
Can you talk about freelancing as a Data Analyst?, i recently finished the Google Data Analyst certificate, also i enjoy using Excel & SQL, can i start a data analyst career out of these two skills?.
freelancing can be tricky because you typically need to show a portfolio of experience already to get clients. but you can ease into by first doing some smaller projects (volunteer work, event doing unpaid work for acquaintences / secondary network) so you can build that portfolio
What other questions about working in data do you have? Leave a comment below and I'll share some thoughts! Feel free to send to friends if you found this video helpful!
Hi Christine! Thank you for this video, it was really insightful.
I can't find the link for your data lingo dictionary in your bio though
Hi Christine, I'd like to ask about recent college graduates who are landing their first job as a data analyst, without prior experience or internships. Do you have any advice for them?
Hi Christine,
Thanks for the insightful video! I’m interested in how you would adjust this framework for a business analyst path if at all. From the job postings I’ve seen, it seems like aspiring business analyst should focus heavily on a BI tool and less on SQL or Excel. What are your thoughts?
Are there books you recommend as supplementary materials to this roadmap, or one more high-level that puts the data analyst role into full business and tech context?
@@claytonp23 theyre very similar roadmaps / skillsets overall, but a business analyst typically works more directly with stakeholders and requires more emphasis on soft skills like presentations, leading meetings, project management. business analysts should focus more on Excel, SQL will be a plus, and domain knowledge will be even more of a plus.
This is a prime example of domain knowledge . Your knowledge truly shines through and differentiates you from many other channels I have come across within the same realm. Thank you for the realistic insights. I'm 40 years old and have decided to get into tech after many many years of banking. It truly is intimidating but I have faith that I can find my way. People like you offer the much needed guidance. Thank you
i'm really happy to hear this. your banking experience may lend itself well to the transition, so see it moreso as a move that uses your banking experience (customer service, financial understanding, data mindset, any work with technology or excel) to become an even better analyst in tech.
Never seen such clear content. This is amazing, thank you
I've watched so many of these roadmaps, and this one tops them all. So much information here that I hadn't found elsewhere. Thanks for straying right into my feed.
thank you! it comes from a lot of close conversation and reflections from students as well - combining my experience + their experience + my network. more to come :)
@@christinejiangdata you add so much substance to this corner of youtube. Looking forward to them. ^^
Literally amazing, tops all the content i saw on data analyst, definitely subscribing to get more actual useful content!
thanks so much anushka!
Thank you very much we will be patiently waiting.
Thank you very much for the video! I really like your channel! Could you please make a video about technical and behavioral interviews? What are the basics and what needs to stand out during the interview for Data Analyst? Advice on networking would be great too
i got you!
check out my most recent videos on networking, standout interview responses, and how to speak like a data analyst - those will help you stand out during the interviews.
next week i'll be uploading a video on nailing the technical interview, so you're right on time :)
So insightful! Also helps not just hearing but also hearing success stories of people with similar backgrounds. Thanks!
glad you enjoyed it!
Amazing video! Thank you!!!
Glad you liked it!
Appreciate the insights. Looking forward to using these to help in my knowledge gaps.
looking forward to that as well :)
I wasn't really paying attention to portfolio projects or interviews before feeling comfortable with my technical skills first. But knowing the roadmap of what I'm doing, how I use the technical skills I learn as you mentioned in some videos , and why I chose certain things over others will actually add more value to my effort while learning
Thanks alot for you Videos
that's right, if you're going to apply a ton of effort, might as well apply it in the right direction
@@christinejiangdata Thanks and still waiting For more Helpful videos as always
Thank you so much it was very interesting and informative its a pityfrica
The accelerator programme is not available for the African region
i'm working on something for you guys in africa (and other regions, like asia). hang tight!
Great video as always! What are your views on ageism while hiring data analysts. Are people over 30 at a disadvantage?
30?!? man don't tell me i'm old!
i wouldn't be looking at people's age, i would be looking at their experience, motivation, and soft skills. that matters much more
@@christinejiangdata 👍 Thank you for replying, means a lot
Do you have any good resources for beginners trying to learn the most common business metrics and how to calculate them? For example, I didn't know what profit ratio was, and even when I was given the formula for it I still had to learn the difference between profit/sales and sum(profit)/sum(sales) and how that affects your output. I'd love to learn the common metrics for certain industries. Like, what is click-through-rate?
great question - i'll do more videos on this since i don't see a lot of content about business metrics and the actual application of technical tools to understand these metrics. check out this blog by castordoc, which has articles on the top 10 metrics by industry and how they're calculated. www.castordoc.com/blog-category/data-for-business-people
@@christinejiangdata Thanks so much!
Bro you can take help from chatgpt also.
Thank you Christine for the great video! (Im gradating next year from college stressing over jobs binge-watching ur videos at 5am hehe 😅your content is so helpful!! Look forward to seeing more! Keep up the good work
really appreciate it, you can just consider 5am a really early and productive wake-up time :)
This is great, thank you! Lots of new information here as well as verification I'm headed in the right direction with my own strategy
very nice!
Thank you I am transitioning into tech from marketing and this was so helpful, I just use tech term where data terms where even tho SQL will help me also and the steps ❤
marketing is a great transitioning field! excited for you
This video was literally perfect , thankyou
thank you! getting better
Have you had students from other countries that got a job in the US, Canada or Europe? I'm from Brazil and salaries here are very low, so I'd like to apply to jobs abroad.
Hi Christine, thank you for this video! Its very helpful
i'm glad!!
Your Roadmaps and strategies have developed more confidence but, Can you suggest some tips for the freshers who are applying for the Data Analyst Roles because there will be too much difference between the resume of Fresher Engineer and an Experienced one.
i'll do some videos about more detailed resumes soon, but overall the actual structure of the resume is not actually that different between the two. check out my resume video to see examples of the kinds of bullets and bios you should include - and pay attention to the level of detail used, which is applicable to both recent grads and working professionals.
Is the application for the fall mentoring program closed? i am very keen to know more about it and looking forward to discuss more
application slots this week are full, but check back next week! and i'll release new application slots on my newsletter. the next cohort starts september 21st
Thank you for the tips!! Could you make a video about how we can use some network techniques to get an interview?
100%, this is on the list! thanks for mentioning
Aug 5,2024:I am still struggling with learning SQL,I know as a data analyst,it is needful pls what is the best method to learn SQL
You are seriously doing a great job.and i really appreciate your work .
hey can you make a video on kpi,and which kpi are imp for data analysis.and in this video you mention business metrices.(can you explain this term).
oooh love this topic! so vids on business metrics / KPIs and how they relate to the day-to-day of a data analyst. adding this to my list :)
My new favourite guru by miles
oof that means a lot :)
Hi, I'm from philippines, thank you for this,subcribed!!
hello to you in the philippines!
Hi Christine thanks for sharing the insightful information! I’m based in the UK at the moment and want to look for some voluntary projects for the organisation in the Europe. By any chance, do you have any recommendations for projects for EU based orgs? Thank you in advance!
hello! i can ask my students based in the UK for more info, but my mentees in London have had good luck with catchafire. Even though it's based in the US, the volunteer opportunities are remote, and one of them was able to work with Google Analytics data through this experience which helped his job search.
Hello Christine! Thank you for such amazing videos, all of them are insightful and practical.
Can you please help with the most confusing question for a fresher - Tell me about your project?
As it is a make-or-break question in an interview, how can we answer it in a way that will help us to land a job?
good question! i answer this in my interview video (third video) where i talk through the most common questions asked :) it is indeed a make-or-break question
I have a BA in Applied Mathematics is that something that will stand out to HMs and Recruiters?
for working professionals, it's always more about experience / applied projects than about the degree
I made an account with datakind to find volunteer data analysis projects to build my portfolio and experience. Wish me luck
nice, you got this! try www.catchafire.org/ too. many students have gotten opportunities here
thanks for the video! as for the impact aspect of projects, would using econometric modelling techniques be an example of both showing domain knowledge (economics) and also assessing impact of x on y/providing business insights?
as long as the results (insights and recommendations) of these techniques are well explained, yes
There's a problem with having business metrics on portfolio projects, without working on the project and rather trying to simulate it how can one show that these are the business metrics we have improved?
I mean to say, we cannot mimic the business in a portfolio project, how can we show metrics that may be improved by doing that specific project
not all metrics have to be "improved ____ by X%". metrics are anything quantitative that help someone understand the technical aspects and rigor of the project:
- dataset of 100K rows
- maintained model of 20 data inputs
- coordinated across 10 construction clients
- worked with 5 senior stakeholders
for portfolio projects, this means mentioning insights and their values: "discovered dip in sales by 20% over winter months because of ___"
is PowerBI fine instead of Tableau?
depends on company, industry, and country. research job postings to get a sense of what's popular in the jobs you're looking at
Can we get your portfolio project link?
Hello, a quick one, im currently mid on my road map to data science, idk if u could make a related video on that. Thanks
for data science much is the same, but the kinds of projects you do need to be more geared towards technically advanced techniques and python, and less on business stakeholders
@@christinejiangdata oh because I decided to ask. Thanks
Quick one, do you think something like a fraud detection can be suitable for a CV showing thingy? Kinda lost in btwn for learning for my personal growth or for showcase, hopefully you understand what I mean
On the quest to land an interview before 2026 (from your previous video haha).
- Any tips on where to find company published datasets?
- I'm already overhauling my portfolio based on your previous videos, but I feel like I have already been doing the other stuff you mentioned, but absolutely pathetic results in the last two years. I'm hoping the newer projects will help.
- Regarding industries, I have prior data science experience at a healthcare company, consulting in medical devices, and currently doing freelance data projects (very hard to find and extremely rare). I'm trying to get into something like fintech. will relevant projects help? Because I don't see any way of getting fintech experience without getting a job in fintech.
Thanks for these videos! Will be sure to post an update if your methods work for me!
these questions require more in-depth answers than i can give in text, but are questions i'll be answering in future live Q&A sessions (so stay tuned on my linkedin). short answer: relevant projects will help if they give you experience working with relevant fintech metrics so you can speak about them more knowledgably in interviews. data work in healthcare could very reasonable translate to data work at a finance company or a tech company, and then study fintech metrics to fill lin the gaps
Can you talk about freelancing as a Data Analyst?, i recently finished the Google Data Analyst certificate,
also i enjoy using Excel & SQL, can i start a data analyst career out of these two skills?.
freelancing can be tricky because you typically need to show a portfolio of experience already to get clients. but you can ease into by first doing some smaller projects (volunteer work, event doing unpaid work for acquaintences / secondary network) so you can build that portfolio
The schedule filled up, can I still chat?
will be releasing more application spots in mid august!
Hey christine ...loved your content..I was willing to work with you as a thumbnail designer/editor. Where can I reach out to you?😇
hey! can you send me a message on linkedin? www.linkedin.com/in/christine-jiang/
Hello dear
Are you looking for a attractive youtube thumbnail designer and youtube video SEO expert.?
When do you reckon your next cohort will be? Great video btw!
next cohort will be starting this fall, around september