What skills do I need to become a Data Analyst with no experience? EP - 1

Main ideas / lessons

• To become a data analyst with no experience, you need to build strong competence in core analytics tools/languages.
• The speaker emphasizes learning each core tool to a good, advanced level (not just the basics).
• There are core tools (4) plus additional tools (at least one more is emphasized) depending on job descriptions and trends.
• There is no single correct learning order, but the speaker provides a suggested sequence.

Skills/tools mentioned (with details)

Core tools (4) — learn all to a strong/advanced level

1. Excel

   • Target: advanced level
   • Topics to master:
     • Pivot tables
     • Transformations
     • “Complete Excel” (general full coverage)

2. SQL

   • Target: advanced querying concepts, including:
     • Joins
     • (Mentioned as “whistles/windows functions” → likely “window functions”)
     • Window functions

3. Power BI

   • Target: good level
   • Main outcome: ability to create dashboards
   • Visualization tool choice:
     • Power BI (speaker’s choice)
     • Tableau (optional alternative, mentioned)

4. Python

   • Target: learn to a good level
   • Reassurance for beginners:
     • Don’t be afraid—Python learning is manageable
     • Don’t learn “more than necessary”; focus on essentials
   • Focus on four key libraries:
     • Pandas
     • NumPy
     • Matplotlib
     • Seaborn
   • Coding expectations:
     • Don’t worry about heavy coding
     • The speaker suggests doing very little coding
   • Interview/practice advice:
     • If you’re afraid for interviews: practice/prepare and “take the interview”
     • If you’re not afraid: still “read it carefully” (review materials/practice)

Additional / extra tools (recommended)

• Learn extra tools listed in job descriptions

  • Rationale: different companies use different tool stacks
  • Example:
    • A company uses Azure for data storage
    • The speaker learned Azure concepts such as:
      • Cubes
      • Pipelines
  • Guidance:
    • Check the job description for the role/company you want
    • If additional tools are listed, learn them to improve your chances of getting hired

• Microsoft Fabric (emphasized as important)

  • The speaker strongly encourages learning Microsoft Fabric in addition to the core plan:
    • “Learn five tools”
    • It is described as “the future”
  • Emphasis: do Microsoft Fabric at the end
  • A previous video is referenced for more detail

Suggested learning sequence (not mandatory)

• The speaker states there is no correct sequence, but suggests:

  1. Excel
  2. SQL
  3. Power BI
  4. Python
  5. Microsoft Fabric

• End goal statement: “Life is set” after completing these five.

Method / structure used in the video (meta)

• The answer is delivered:
  • without cuts or editing
  • in a raw manner
  • using a 3-minute timer
• Engagement guidance:
  • Ask questions in comments, not in the description
  • Future videos will be made based on those questions

Speakers / sources featured

• Mansi Unfiltered — the only person featured in the subtitles
• No other specific external sources are credited (beyond general mentions of tools/platforms like Excel, SQL, Power BI, Python, Tableau, Azure, and Microsoft Fabric)