Video summary

Fastest way to become a self taught data analyst and get a job

Main summary

Key takeaways

Educational

Main ideas, concepts, and lessons

  • Goal: Learn the skills for a data analyst job as fast as possible, and create a job application strategy that improves your chances of landing roles.
  • Core principle: Data analysis is easier to learn and improve when you build strong foundations.
  • Learn tools and techniques that are widely used in the industry first, then progress.
  • Build a portfolio that clearly communicates what you built and why, not just raw code.
  • Treat job searching like a measurable process: track outcomes, test variations, and find patterns.

Detailed methodology / instruction list

1) Build strong technical foundations (fastest learning path)

  • Master core technical skills:

    • Excel

      • Learn how to clean, manipulate, and analyze data using:
        • Excel formulas
        • Pivot tables
        • Pivot charts
      • Aim to reach the level where you can build an interactive Excel dashboard (described as “pretty advanced”).

    • SQL

      • Learn SQL querying for databases.
      • The specific SQL dialect doesn’t matter much (it’s similar across systems).
      • Suggested options (one of the common dialects is fine):
        • PostgreSQL (preferred by the speaker)
        • MySQL
        • Microsoft SQL Server

    • Data visualization tool (choose one)

      • Do not master both Tableau and Power BI at the same time.
      • Choose based on where your target employers are most likely using them:
        • If companies use Tableau → focus on Tableau
        • If companies use Power BI → focus on Power BI
      • Rationale: the tools are fundamentally different, and learning one doesn’t transfer easily to the other.

    • Programming language

      • Prefer Python over R (speaker’s preference).
      • Use Python libraries for:
        • cleaning, manipulating, analyzing, and visualizing data
      • Mentioned libraries:
        • Pandas
        • NumPy
        • Matplotlib
        • Seaborn

2) Use structured learning resources to move faster

  • Recommended learning track: “Data Analyst in Python” career track on DataCamp

    • Features emphasized:
      • Bite-sized, hands-on learning
      • 9 courses and 7 hands-on projects
      • Tools provided in the browser (no need to download Python or manage environments)

  • Certification recommendation:

    • Take the DataCamp Data Analyst certification
    • Purpose:
      • Industry-recognized credential
      • Adds professional credibility
      • Provides proof you can do what you claim

3) Build a portfolio that gets attention

  • Portfolio goal: Demonstrate abilities to hiring managers/recruiters.

  • Why portfolios get ignored (3 main reasons):

    1. Employers can’t tell what you built
    2. No indication of what tool you used and why
    3. No clear next steps (unclear how to view/use your work or what you want)

  • What your portfolio should include:

    • Projects that solve real-world problems using data analysis.

  • Add a walkthrough video (recommended fix):

    • Create a short walkthrough video showing what your portfolio contains.
    • Example approach: record with Loom.
    • Keep messaging clear and the video short.

  • Test the portfolio with a non-expert:

    • Show it to a non-data friend (someone who doesn’t understand data analysis).
    • Ask: “Did you understand what you saw?”
      • If yes → communication is clear
      • If no → improve presentation/messaging

  • Explicit warning:

    “300 lines of code with no context or explanation” is not a portfolio—it’s just code.

4) Strategize job applications (and measure results)

  • Resume approach:

    • Create one generic resume, but tailor it for each job.
    • If job descriptions mention SQL or Tableau:
      • ensure your resume includes those skills
      • add relevant past experiences showing you used the tools successfully
    • Purpose of tailoring keywords:
      • improve likelihood of passing ATS scanning
      • make it easier for human recruiters to find skills quickly

  • AB testing resume versions:

    • Apply to 10–20 jobs with Resume A, modifying one section (examples mentioned):
      • summary
      • skills
      • work experience
    • Apply to another 10–20 jobs with Resume B
    • Compare outcomes

  • Track everything in a simple spreadsheet:

    • Use Google Sheets or Excel to create a tracker (about 5 minutes).
    • Log:
      • roles applied to
      • ghosted applications
      • rejections
      • interview calls
    • Use patterns in the data to improve application effectiveness.

  • Key lesson:

    “Hope is not a strategy.” Without tracking application → interview rate, you can’t optimize your process.

  • Call to action:

    • Implement at least one action from the video.
    • Consider posting/accounting publicly via the comment section.

Speakers / sources featured

  • Speaker: Mo Chan (host; “working with complex big data in finance for over six years,” currently a data and analytics manager)
  • Sponsored/featured source: DataCamp
    • References:
      • “Data analyst in Python” career track
      • DataCamp Data Analyst certification
  • Tools/resources mentioned:
    • Excel
    • SQL (dialect examples: PostgreSQL, MySQL, Microsoft SQL Server)
    • Tableau
    • Power BI
    • Python (libraries: Pandas, NumPy, Matplotlib, Seaborn)
    • Loom (portfolio walkthrough recording)
    • Google Sheets / Excel (application tracking)

Original video