The Complete Data Analyst Roadmap!

Main ideas and concepts (complete roadmap)

The video presents a 6-step roadmap to become a data analyst, emphasizing a sequence of:

• foundational courses
• hands-on practice
• personal differentiation
• an ATS-friendly resume
• a correct job application strategy
• additional credentials/skills to stand out

It also promotes the creator’s mentoring/counseling, workshops, and playlists/resources, and includes Coursera sponsorship/discount messaging.

---

Step-by-step methodology (detailed)

Step 1: Build the foundation through courses

• Study two courses end-to-end to build strong technical foundations.

Course 1 (Coursera): Google Data Analytics Professional Certificate

• Covers:
  • Spreadsheets
  • SQL (Sequel)
  • Data Visualization
  • R
  • Python (also mentioned)
• Includes some Tableau to clear the basics.
• Starts with understanding:
  • what a data analyst does
  • the overall work involved
• Positioning benefit:
  • especially helpful for non-tech backgrounds
  • adds value to your resume

Course 2: 365 Data Science Data Analytics Career Pathway

• Purpose:
  • covers what the Google course may miss, specifically mentioning Excel

Do both courses or choose based on budget

• If budget is limited → do Google course only
• If you can afford both → doing both makes you more interview-ready (a stronger combination)

Coursera offer mentioned

• If you enroll in the Google Career Certificate for a limited time, you may get Google AI Pro for free for 3 months (with multiple AI tools).
• There are other Coursera discounts (links in description).

---

Step 2: Build a practice project (during/after courses)

• Can be done in two ways:
  • Option A: complete both courses first, then build practice projects
  • Option B: practice while studying (possible)

Practice project structure

• Identify four main skills:
  • Excel
  • SQL
  • Power BI (referred to as “Pago/BI”)
  • Python
• For each skill, create two practice projects → total: 8 practice projects

Learning approach analogy

• Like learning math: formulas first, then exercises in class, then homework afterward. Practice projects are the structured “exercise/homework” phase.

Important rule

• Do NOT put practice projects on your resume.
• Don’t present them as if they’re fully “yours” if they aren’t—hiring managers can detect templated/copied work.

Recommended learning resources

• The creator provides:
  • a playlist of projects to learn from (link in description)
  • a guided Power BI project (“Airbi NB dashboard”) designed as a resource that’s not widely found on YouTube, with real-life knowledge

---

Step 3: Build a personal project (what differentiates you)

Purpose

• Stand out because many people copy/download projects from YouTube and then get stuck when they’re not shortlisted.

Process

• Choose a domain you’re interested in (data analytics has multiple domains).
• Build projects within that chosen domain.

Use AI ethically

• The creator recommends a separate video about using AI to create personal projects properly and ethically.
• Warning:
  • interviewers quickly detect if a project was taken from someone else or if AI output was used incorrectly.

Git requirement

• Upload all projects (practice + personal) to Git so interviewers can see your effort and progress.

---

Step 4: Create an ATS-friendly resume

Resume importance

• Don’t ignore it—this video claims to provide a “perfect resume” process.

Key instruction

• After your projects are ready, add three strong/best projects to your resume.

Resume content details

• Follow guidance on:
  • headlines
  • project descriptions
  • summaries
  • other formatting elements

Emphasis

• The resume should be ATS-friendly and free from mistakes.

Rationale

• The creator stresses the process is logically reasoned and not “surface-level,” referencing other related videos.

---

Step 5: Apply for jobs using an effective strategy (not “placement support”)

Placement support skepticism

• The creator claims placement support is a myth and recommends applying correctly yourself.

Recommended application workflow (3 steps)

1. Resume customization
   • Use AI with a tool (“Prop” is mentioned) to customize resumes.
2. Get referrals
   • Watch another video on how to ask for referrals (including what to do if you don’t “know anyone”).
   • Includes referral message advice.
3. Track everything
   • Use a tracker (downloaded from the referenced video description).
   • Track in an Excel sheet:
     • companies applied to
     • which resume version you used
     • who you contacted for referrals

Cost warning

• Don’t waste money on expensive unrelated courses—follow the creator’s provided resources/videos instead.

Confidence guarantee

• Claims the roadmap is logical and results-driven from years of experience, including off-campus job examples and referral journeys.

---

Step 6: Stand out from the crowd (optional but recommended)

The creator says many stop after resume + applying, but extra steps improve chances.

Options mentioned

• Achieve PL-300 certification

  • Presented as a high-value certification for data analysts.
  • Creator points to videos on what it is, how to do it, and how to clear on the first attempt.

• Acquire extra skills beyond the four main ones (Excel/SQL/Power BI/Python):

  1. Microsoft Fabric
     • Recommended because companies using Power BI may also use Fabric.
     • Creator offers a free Fabric series (aimed even at beginners), including learning and projects.
  2. Cloud skills
     • Choose one cloud: AWS, Azure, or Google Cloud.
     • Reason: large companies store/host much data in the cloud, so you’ll need cloud-related access/skills.
     • Creator provides a cloud roadmap video.

Optionality statement

• Doing all six steps is optional.
• If you want faster outcomes and can study extra → do Step 6.
• Otherwise, the first five steps are said to be sufficient.

---

Speakers / sources featured

• Mansi (main speaker)
  • data analyst for 2+ years
  • hosts workshops
  • provides counseling sessions
  • creator of the roadmap and related videos/playlists
• Coursera (video sponsor)
  • platform referenced for course enrollment/discounts
• Google (referenced as course provider)
  • also cited as the source of “Google AI Pro” within the Coursera offer
• Hiring managers / HRs
  • mentioned as sources of interviewer behavior/feedback (not specific individuals)
• LinkedIn profile
  • mentioned as a place to verify course proof (not a specific person)