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 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 ❤
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
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.
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
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).
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?
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.
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
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
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
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 ___"