Christine Jiang
Christine Jiang
  • 15
  • 121 131
5 Common Pitfalls of Aspiring Data Analysts (Columbia University Talk)
Free NYC workshop / meetup Tuesday 🙂 lu.ma/x8an77rf
Applications for the next cohort of the Analytics Accelerator are now open here! theanalyticsaccelerator.com/
THIS VIDEO
Last week I gave a talk to ~60 Columbia University grad students about the most common pitfalls of aspiring data professionals today, as well as ways to avoid and overcome them. We dive into topics like getting experience (without "experience"), portfolio projects, interview challenges, certifications, and sponsorships. If you're serious about transitioning into a data career, stick to the end for our live Q&A!
ABOUT ME
If we haven’t met yet - hi! I’m Christine, a former data director and hiring manager helping ambitious career transitioners and recent grads land their first job as a data analyst. I'll be sharing the insights and strategies that empowered over 70% of job-hunting students in the first cohort of my mentorship program landed their first data job within 6 months, in today's super-competitive job market.
If you want to become a standout data analyst through applied business skills, soft skills, and strategies for every part of the job hunt process - so that you can have confidence, professional leverage, and bring real impact to work - connect below for more insights and future workshops!
LINKS
- Get more tips in my newsletter - bit.ly/3LodfYs
- Powerful action verbs for resume / cover letter here - www.betterteam.com/action-verbs-for-resumes
- Apply to the next cohort - theanalyticsaccelerator.com/
- Follow on LinkedIn - linkedin.com/in/christine-jiang
- Instagram - cjiaang (my photography, because why not)
Timestamps:
0:00 - Introduction
2:04 - Start of Talk
4:50 - 5 Most Common Pitfalls
5:39 - Pitfall 1: Resume Before Experience
9:00 - Pitfall 2: Portfolio without Relevance
15:41 - Pitfall 3: Spraying and Praying
24:43 - Pitfall 4: Lost in Translation
29:23 - Pitfall 5: Over-focusing on Tech Skills
37:01 - Question 1: What should I focus on to land a US-based data job?
38:49 - Question 2: How do we stand out in the interview process?
41:56 - Question 3: How to handle questions about sponsorship?
43:04 - Question 4: How much does a referral from an employee help?
44:20 - Question 5: When is the best time to ask for a referral?
46:00 - Question 6: What are the most important certifications to have?
47:35 - Question 7: When is the best time to apply and not get lost in the resume hole?
48:49 - Question 8: How should I go about transitioning from engineering to product?
50:48 - Question 9: Should we include school projects in our resume?
51:47 - Question 10: What if I get an offer at a company while interviewing with a better company?
53:52 - Question 11: Common mistakes during interviews?
Video URL: th-cam.com/video/0UnvAVvnW6c/w-d-xo.html
มุมมอง: 1 232

วีดีโอ

Should data analysts write cover letters? Hiring Manager POV
มุมมอง 1.3Kวันที่ผ่านมา
Hosting a free workshop / meetup in Brooklyn, NYC on October 22nd! Would love to get together for an insightful discussion on breaking into the industry and answer your questions in person 🙂 lu.ma/x8an77rf THIS VIDEO Having a standout cover letter can make a big difference in today's competitive job market - it's also a helpful exercise in solidifying your narrative for how your previous experi...
Think like a Data Analyst: Data Cleaning Framework
มุมมอง 6K14 วันที่ผ่านมา
Hosting a free workshop / meetup in Brooklyn, NYC on October 22nd! Would love to get together for an insightful discussion on breaking into the industry and answer your questions in person 🙂 lu.ma/x8an77rf THIS VIDEO Data cleaning is more than just fixing errors-it's about applying a framework and mental model that can help you shine in job interviews and on the job. In this video, I’ll walk yo...
Create a Standout Project Write-Up | Data Analyst Insights
มุมมอง 7Kหลายเดือนก่อน
Hosting a free workshop / meetup in Brooklyn, NYC on October 22nd! Would love to get together for an insightful discussion on breaking into the industry and answer your questions in person 🙂 lu.ma/x8an77rf THIS VIDEO The GitHub ReadME of your portfolio projects is one of the most critical ways to make your work stand out to a hiring manager. In this video we talk about the overall structure, fo...
Hiring Manager Tips | Resume Bullet Rules for Data Analysts
มุมมอง 3.9Kหลายเดือนก่อน
Hosting a free workshop / meetup in Brooklyn, NYC on October 22nd! Would love to get together for an insightful discussion on breaking into the industry and answer your questions in person 🙂 lu.ma/x8an77rf THIS VIDEO Using "3D bullets" has helped many of my students significantly increase their resume conversion rate in today's competitive job market. In this video I show you concrete examples ...
Real Talk for Aspiring Data Analysts (From a Hiring Manager)
มุมมอง 8Kหลายเดือนก่อน
Hosting a free workshop / meetup in Brooklyn, NYC on October 22nd! Would love to get together for an insightful discussion on breaking into the industry and answer your questions in person 🙂 lu.ma/x8an77rf THIS VIDEO Since speaking 1:1 with 200 aspiring analysts in the last year, I've seen the same pitfalls repeated over and over. In today's video I wanted to share three key insights from my me...
Business Metrics for Data Analysts | Portfolio Project Q&A
มุมมอง 9Kหลายเดือนก่อน
Hosting a free workshop / meetup in Brooklyn, NYC on October 22nd! Would love to get together for an insightful discussion on breaking into the industry and answer your questions in person 🙂 lu.ma/x8an77rf THIS VIDEO I'm looking for a video editor to work with on a regular basis - if you're interested in working with me, please leave your info here (forms.gle/22RbW7S3QdkG5kMLA) - I'll be reachi...
Data Analyst Insights: Coding Interview Must Do's
มุมมอง 3.5K2 หลายเดือนก่อน
Hosting a free workshop / meetup in Brooklyn, NYC on October 22nd! Would love to get together for an insightful discussion on breaking into the industry and answer your questions in person 🙂 lu.ma/x8an77rf THIS VIDEO Not sure how to pass a live technical interview as an aspiring data analyst? Heads up - it's not about writing perfect code. In this video, I'll explain the step-by-step process fo...
Data Analyst on How to Turn Business Metrics to Insights
มุมมอง 4.6K2 หลายเดือนก่อน
Hosting a free workshop / meetup in Brooklyn, NYC on October 22nd! Would love to get together for an insightful discussion on breaking into the industry and answer your questions in person 🙂 lu.ma/x8an77rf THIS VIDEO One of the magic ingredients to standing out in the job hunt is knowing how to translate data to real insights. In this video I walk through a simple framework and example of going...
Hiring Manager Insights: Networking Tips for Data Analysts
มุมมอง 4.2K2 หลายเดือนก่อน
Hosting a free workshop / meetup in Brooklyn, NYC on October 22nd! Would love to get together for an insightful discussion on breaking into the industry and answer your questions in person 🙂 lu.ma/x8an77rf THIS VIDEO A lot of data analysts go about networking by sending out generic messages to hiring managers - and then don't hear back. In this vid I share the template that gets students interv...
Hiring Manager Explains: Speak Like a Data Analyst
มุมมอง 6K3 หลายเดือนก่อน
Hosting a free workshop / meetup in Brooklyn, NYC on October 22nd! Would love to get together for an insightful discussion on breaking into the industry and answer your questions in person 🙂 lu.ma/x8an77rf THIS VIDEO One way to stand out in the interview process is to speak like an experienced data analyst. What's the lingo we use on the day-to-day job, and how can you use this lingo to impress...
Hiring Manager Explains: Strategic Data Analyst Roadmap
มุมมอง 10K3 หลายเดือนก่อน
Hosting a free workshop / meetup in Brooklyn, NYC on October 22nd! Would love to get together for an insightful discussion on breaking into the industry and answer your questions in person 🙂 lu.ma/x8an77rf THIS VIDEO A lot of aspiring analysts feel the data job market is impossible to break into these days - but having the right roadmap can make all the difference. In this video I break down th...
Hiring Manager Explains: Interview Do's and Dont's for Data Analysts
มุมมอง 3.8K3 หลายเดือนก่อน
Hosting a free workshop / meetup in Brooklyn, NYC on October 22nd! Would love to get together for an insightful discussion on breaking into the industry and answer your questions in person 🙂 lu.ma/x8an77rf THIS VIDEO Interviews can be intimidating for early-career data analysts, especially if you're not sure what recruiters and companies are actually looking for. In this video I'll walk through...
Hiring Manager Explains: Data Portfolio Do’s and Don’ts
มุมมอง 46K4 หลายเดือนก่อน
Hosting a free workshop / meetup in Brooklyn, NYC on October 22nd! Would love to get together for an insightful discussion on breaking into the industry and answer your questions in person 🙂 lu.ma/x8an77rf THIS VIDEO Many aspiring analysts create a portfolio to demonstrate their technical skills. But as a former hiring manager, I often see data analyst portfolios that are missing the key elemen...
Hiring Manager Tips: Data Analyst Resume Do's and Don'ts
มุมมอง 7K4 หลายเดือนก่อน
Hosting a free workshop / meetup in Brooklyn, NYC on October 22nd! Would love to get together for an insightful discussion on breaking into the industry and answer your questions in person 🙂 lu.ma/x8an77rf THIS VIDEO Struggling to get past the data analyst resume wall? In this video, I walk through the MINDS framework, which is a strategy for creating a standout data analyst resume based on my ...

ความคิดเห็น

  • @onuigboonyinyechi5305
    @onuigboonyinyechi5305 13 ชั่วโมงที่ผ่านมา

    Thank you @christinejiangdata for this very impacful video tutorial. It presents a clear approach to data cleaning.

  • @sandydsa
    @sandydsa วันที่ผ่านมา

    This was excellent! Thank you!

  • @Deepakdev202
    @Deepakdev202 2 วันที่ผ่านมา

    Hi, I am trying to switch careers, and people says that` starting out with stats is important to actually know the data and what to do with it. I was doing a project and I did the basic stuff like cleaning, formatting the data types, and other things, after those steps, I really had no idea how to really analyze the data

    • @Deepakdev202
      @Deepakdev202 2 วันที่ผ่านมา

      hey, found the answer in one of your video " understanding the metrics"

  • @MrFly-r2n
    @MrFly-r2n 3 วันที่ผ่านมา

    ❤iamreallyimpressedwithyourintellectualcredentialsiwiikeepintouchperiodically

  • @jaspersomaek
    @jaspersomaek 3 วันที่ผ่านมา

    Thanks for sharing, always appreciate hearing your insights Christine

  • @cafeaulait69
    @cafeaulait69 3 วันที่ผ่านมา

    Can you reset the link to the lingo guide please

  • @wittsmei8742
    @wittsmei8742 4 วันที่ผ่านมา

    Thank you so much!

  • @williamaldridge485
    @williamaldridge485 4 วันที่ผ่านมา

    Is there any way to get the PowerPoint with links to the videos? I looked at the description and didn't see the brief

    • @christinejiangdata
      @christinejiangdata 4 วันที่ผ่านมา

      Good idea - here you go! It's watermarked with the Columbia club info but hopefully you can still read through :) bit.ly/48aHPPY

  • @Nabil-pg7ll
    @Nabil-pg7ll 4 วันที่ผ่านมา

    Thanks for your effort Christine !

  • @christinejiangdata
    @christinejiangdata 4 วันที่ผ่านมา

    Free NYC workshop / meetup Tuesday 🙂 lu.ma/x8an77rf Applications for the next cohort of the Analytics Accelerator are now open here! theanalyticsaccelerator.com/

  • @armandogutierrez2880
    @armandogutierrez2880 5 วันที่ผ่านมา

    Excellent Christine, you won a subscriber and also I will attend the meeting on Oct 22. thanks for sharing this valuable information. You help me a lot to identify this topics in the field and we need to practice everyday also.

  • @sulaimonabiodun1054
    @sulaimonabiodun1054 5 วันที่ผ่านมา

    Hi, Christine I am glad I came across your TH-cam channel. Your video on creating a portfolio really helped me a lot. I need clarification regarding how to write a cover letter as someone who has never worked in an organisation before

  • @Devodry
    @Devodry 5 วันที่ผ่านมา

    Another perfect example of why I am grateful I found her channel! Excellent content and advice!

  • @Devodry
    @Devodry 5 วันที่ผ่านมา

    Wow! Absolutely the information I need as a newcomer to data.

  • @lifeviz28568
    @lifeviz28568 6 วันที่ผ่านมา

    Hi Christine!! OMG your cover letter trick actually worked and it helped me move onto the next round for the BI Analyst role. Where it's now an online assessment testing on logic, math, and critical reasoning. Thank you, and for those thinking if this cover letter worked, YES, it did!! Give that a try! :)

    • @christinejiangdata
      @christinejiangdata 6 วันที่ผ่านมา

      woahhhh what a win!!! i'm SO happy for you - good luck on the interview! for rounds after the assessment, make sure to check out the interview tips in my other videos (speak like a data analyst and the interview do's and don'ts). let me know how it goes :)

  • @UltimateEscape438
    @UltimateEscape438 7 วันที่ผ่านมา

    hi im new to your channel:) Im not expert in communication how ever, i've notice you talk too fast and this will lead confusion to your viewer and listener. I suggest, try to speak more ease, your content is nice, good day.

  • @snehashekar1839
    @snehashekar1839 7 วันที่ผ่านมา

    So so helpful , This was a great video on data cleaning . Keep rocking

  • @GIBBUMLEE
    @GIBBUMLEE 7 วันที่ผ่านมา

    I'm your fan

  • @jenkinsade2111
    @jenkinsade2111 7 วันที่ผ่านมา

    Amazing, very insightful. Great video

  • @anand26shweta
    @anand26shweta 7 วันที่ผ่านมา

    SQL interview

  • @faacam
    @faacam 7 วันที่ผ่านมา

    the real data cleaning process that ive been looking for, thank u so much 🥹

  • @Bagheera19
    @Bagheera19 8 วันที่ผ่านมา

    Thank You for the way of your explanation. You see I am pretty new in this communication field. Can I use your way of explanation to address my data analytics finding

  • @sunnasavita
    @sunnasavita 8 วันที่ผ่านมา

    absolute legends!! thank you so much for sharing these strategy!

  • @ugonnaogueri8430
    @ugonnaogueri8430 9 วันที่ผ่านมา

    @christinejangdata for the win again 👏 👏 👏. Amazing video

  • @raefeismail2794
    @raefeismail2794 9 วันที่ผ่านมา

    this is soo great and soo helpful thnks soo much , but i cant get your data for analysis (zoom subcription )

  • @diraamanda1538
    @diraamanda1538 9 วันที่ผ่านมา

    Exactly what i have been looking for, thanks a lot 🫶

  • @reuelcazaubon
    @reuelcazaubon 9 วันที่ผ่านมา

    This must be the best video for data cleaning. The approach is sound.

  • @krisdelafuente887
    @krisdelafuente887 11 วันที่ผ่านมา

    Coming from CC Fraud Prevention backround, KPIs were our bread and butter. However, I am in the midst of a career pivot into Data Analyst and this was great info! Thank you for this. I am now following this channel 👍

  • @malavparekh123
    @malavparekh123 11 วันที่ผ่านมา

    Hi Christine, Thank you for the video, it was very inspirational. I took out 2 days and made something. I liked you idea about using GitHub but I don't have a lot of contributions on my personal GitHub repos. If a hiring manager were to see the contributions, do you think it would make a negative impact? In that case, do you think it is beneficial to spend a little more time and create a portfolio website?

  • @hamzayun
    @hamzayun 11 วันที่ผ่านมา

    very good video! Random opinion: I feel the "Identify critical vs non-critical" should comes first before "Identify measures and dimensions" , if I am classifying data with hundreds of columns, it does not make sense to start Identifying each column to know if its quantitative or qualitative, why not select the columns we want to work with first? This is just my opinion, does it make sense?

  • @Ifeoma_Rita_Ogbodo
    @Ifeoma_Rita_Ogbodo 11 วันที่ผ่านมา

    Hi, Christine. This video came at a really good time as I'm about to apply to a Junior Data Analyst role. I need clarification on something tho. Which would you prefer: a cover letter sent as a document to the recruiter's email or it should rather be in the email's body??

    • @christinejiangdata
      @christinejiangdata 6 วันที่ผ่านมา

      in most cases, the cover letter should be sent with the application through the job portal (linkedin or the company's site) - but if you're in direct contact with the recruiter, i would send the cover letter directly in the email body. it's the concept of everything being "one click away" - maximize the chance that someone will read the important stuff. just adjust the cover letter for the email format, i.e. Dear ____, Hope this email finds you well! [Transition into cover letter]. good luck with apps and lmk how it goes!

  • @christinejiangdata
    @christinejiangdata 11 วันที่ผ่านมา

    Hosting an in-person meetup NYC this month - just us here! lu.ma/x8an77rf Leave a comment with your thoughts / questions below 🙂

  • @esmailsayid2976
    @esmailsayid2976 12 วันที่ผ่านมา

    Thanks christine!

  • @carolynchan7401
    @carolynchan7401 13 วันที่ผ่านมา

    I hardly ever comment, but honestly, this is exactly what I needed during my job search as a recent grad trying to sound more professional without much industry experience! Thank you soooo much for this incredible content!

    • @christinejiangdata
      @christinejiangdata 13 วันที่ผ่านมา

      i'm SUPER happy to hear this!! you got it :)

  • @firzachandra4169
    @firzachandra4169 13 วันที่ผ่านมา

    so insightful! this is what i've been looking for all this time! thank you!

  • @smilingmahi1835
    @smilingmahi1835 14 วันที่ผ่านมา

    can u share best protfolio best websites , piz share them

  • @gamelikofijerome5829
    @gamelikofijerome5829 14 วันที่ผ่านมา

    As always, great video with practical steps and insights. Totally agree with you, as a Data Analyst you shouldn't shy away from data cleaning tasks as it's the first step to ensuring you come out with meaningful data-driven insights to your stakeholders on any level. Recently, I undertook a data cleaning and transformation task as part of the initial stages of a data analyst role for which I applied. Used pandas in jupyter notebooks for the task and made sure I numbered each stage of the process and provided comments on the functions and steps used. Thank you Christine 👍👌

  • @AKA-r1o
    @AKA-r1o 14 วันที่ผ่านมา

    Hi Christine! I have been a fan of your channel - great contents! I have 3 questions for you regarding this video: 1. Where should I include the data cleaning changelog table section in my portfolio project? (Like what section in the README document in Github?) 2. When you talked about asking questions and discussing about unsolvable data issues with a team member and let's say I have that option, who should that person be (data entry person, the salesperson who is in charge of that data, a data engineer, my manager, stakeholders) and what answer can I realistically expect to get from them (they will give me an updated database/data record or say that the correct data is not found or suggest me to clean the data in a certain way)? 3. From my own research, I see DA job interview questions about data collection as a data analyst. I just wonder if data collection and data cleaning are considered 2 different process, or data cleaning is a part of data collection or what their relationship is. Thank you! And I look forward to watching more of your videos!

  • @lifeviz28568
    @lifeviz28568 15 วันที่ผ่านมา

    Wow, wow, wow!! OMG, this is like having free industry-based data analyst personal coach by my side. A lot of the things you mentioned in this video were not taught when I was taking courses at college. I really appreciated it, it took me 1 hour to watch the vlog and take copious amounts of notes because I believe this will serve me well in my portfolio projects as I prepare to land my first data analyst job! Thank you so much, your videos are so helpful to a beginner data analyst like myself! ♥♥

    • @christinejiangdata
      @christinejiangdata 15 วันที่ผ่านมา

      very happy to hear this, thanks for the kind words :)

  • @onyedikachikanu9326
    @onyedikachikanu9326 16 วันที่ผ่านมา

    Happy teachers Day!

  • @dakshbhatnagar
    @dakshbhatnagar 16 วันที่ผ่านมา

    Ah, thats a nice little framework. Imma give it a try 🙂

  • @OneZxxscsc
    @OneZxxscsc 17 วันที่ผ่านมา

    Hi you’ll be my first TH-cam analytics mentor. I’m not disappointed yet 😂❤

  • @joyotiegbe1549
    @joyotiegbe1549 17 วันที่ผ่านมา

    Value-packed. Thanks for sharing.

  • @vaishnavitripathi307
    @vaishnavitripathi307 17 วันที่ผ่านมา

    Hey christine ...please do a video on how you can connect or gain access to companies databases /data ...like vpn and all ways ... because many people don't know how to gain access to companies data if you are working remote/ freelancing ...its a very small thing but most people have many doibts regarding it and find it little technical .

    • @christinejiangdata
      @christinejiangdata 16 วันที่ผ่านมา

      hey! interesting topic - this is more of an engineering / security task than analytics focus :)

  • @sourabhparmar4930
    @sourabhparmar4930 17 วันที่ผ่านมา

    hello mam my skills are python ,sql,numpy, pandas is these skills are enough to get a job in a data releated domain . i also created a project on data analysis

  • @divyaaa9956
    @divyaaa9956 18 วันที่ผ่านมา

    I live in India and I can't enroll into your program currently , please make it available for students in Asia . I really love you you tube videos as they are short and crisp , Thanks for all the efforts you put while making these informative stuff .

    • @muneebbolo
      @muneebbolo 18 วันที่ผ่านมา

      @@divyaaa9956 Agree with your comment.

    • @christinejiangdata
      @christinejiangdata 16 วันที่ผ่านมา

      i hear you. the reason why the cohort isn't available in asia is because the meeting times are often difficult for students in that time zone - but i do make exceptions for exceptionally ambitious applicants. if you're inclined, you can bypass the screening by picking a different country and continuing with the application there :)

  • @BillyT83
    @BillyT83 18 วันที่ผ่านมา

    I think this is the best video that I've seen so far concerning the Data Cleaning process. Decomposing data cleaning step by step and providing a detailed framework it is something that I have not seen on other TH-cam channels! Thank you for sharing Christine and looking forward to your next video!😄

    • @christinejiangdata
      @christinejiangdata 16 วันที่ผ่านมา

      awesome to hear! you got it - the thought process is just as important as the technical steps

  • @j.b.1342
    @j.b.1342 18 วันที่ผ่านมา

    Thanks for the great content! I feel learn more real-world-practical knowledge here than on other YT channels. Thanks!

  • @andresgutierrez3655
    @andresgutierrez3655 18 วันที่ผ่านมา

    Very detailed video, great info! Ty

  • @fatihahasus1069
    @fatihahasus1069 18 วันที่ผ่านมา

    I do hope u mase this video before i further my master a year ago😭