PLAN-101 Career OS
All Levels Estimated: 12 Weeks 12 Topics

BI Analyst Roadmap

Comprehensive 4-phase roadmap for BI Analyst covering 12 key topics with practical deliverables.

Curriculum Syllabus & Milestones

Phase 1: Foundations

Focus area covering 3 core topics in Foundations.

  1. Business Fundamentals

    Learn how finance, marketing, sales and ops define and use KPIs.

    • Study primary concepts for: Business Fundamentals
    • Actionable guide: Learn how finance, marketing, sales and ops define and use KPIs.
    • Build or test a practical mini-project applying Business Fundamentals.
  2. SQL for BI

    Practice joins, aggregations and window functions against a warehouse-style dataset.

    • Study primary concepts for: SQL for BI
    • Actionable guide: Practice joins, aggregations and window functions against a warehouse-style dataset.
    • Build or test a practical mini-project applying SQL for BI.
  3. Statistics Basics

    Understand descriptive stats, correlation and basic hypothesis testing.

    • Study primary concepts for: Statistics Basics
    • Actionable guide: Understand descriptive stats, correlation and basic hypothesis testing.
    • Build or test a practical mini-project applying Statistics Basics.

Phase 2: Core Skills

Focus area covering 3 core topics in Core Skills.

  1. Data Modeling

    Learn star vs snowflake schema and build a simple fact/dimension model.

    • Study primary concepts for: Data Modeling
    • Actionable guide: Learn star vs snowflake schema and build a simple fact/dimension model.
    • Build or test a practical mini-project applying Data Modeling.
  2. BI Tool Mastery

    Build calculated fields, measures and relationships in Power BI or Tableau.

    • Study primary concepts for: BI Tool Mastery
    • Actionable guide: Build calculated fields, measures and relationships in Power BI or Tableau.
    • Build or test a practical mini-project applying BI Tool Mastery.
  3. Dashboard Design

    Design one dashboard following visualization and accessibility best practices.

    • Study primary concepts for: Dashboard Design
    • Actionable guide: Design one dashboard following visualization and accessibility best practices.
    • Build or test a practical mini-project applying Dashboard Design.

Phase 3: Applied Practice

Focus area covering 3 core topics in Applied Practice.

  1. ETL Basics

    Build a simple pipeline (dbt or scripts) to clean and load data for your dashboard.

    • Study primary concepts for: ETL Basics
    • Actionable guide: Build a simple pipeline (dbt or scripts) to clean and load data for your dashboard.
    • Build or test a practical mini-project applying ETL Basics.
  2. Cloud Data Warehouse

    Query a cloud warehouse (BigQuery/Snowflake free tier) with SQL.

    • Study primary concepts for: Cloud Data Warehouse
    • Actionable guide: Query a cloud warehouse (BigQuery/Snowflake free tier) with SQL.
    • Build or test a practical mini-project applying Cloud Data Warehouse.
  3. Executive Storytelling

    Present a dashboard finding as a 5-slide business narrative.

    • Study primary concepts for: Executive Storytelling
    • Actionable guide: Present a dashboard finding as a 5-slide business narrative.
    • Build or test a practical mini-project applying Executive Storytelling.

Phase 4: Career

Focus area covering 3 core topics in Career.

  1. Data Governance Basics

    Review data quality, privacy (GDPR) and lineage concepts.

    • Study primary concepts for: Data Governance Basics
    • Actionable guide: Review data quality, privacy (GDPR) and lineage concepts.
    • Build or test a practical mini-project applying Data Governance Basics.
  2. Forecasting Basics

    Apply a simple time-series or trend forecast to real data.

    • Study primary concepts for: Forecasting Basics
    • Actionable guide: Apply a simple time-series or trend forecast to real data.
    • Build or test a practical mini-project applying Forecasting Basics.
  3. Portfolio Project

    Publish a full BI case study: business question to dashboard to recommendation.

    • Study primary concepts for: Portfolio Project
    • Actionable guide: Publish a full BI case study: business question to dashboard to recommendation.
    • Build or test a practical mini-project applying Portfolio Project.

Related Career Paths & Cross-Skill Roadmaps

Expand your engineering versatility by exploring interconnected role roadmaps:

3-Year CSE Roadmap → Frontend Developer → Backend Developer → Full-Stack Developer →

Track Your BI Analyst Roadmap Progress

Sign in with Google to check off completed topics, save code notes, and monitor your placement readiness score.

Start Tracking Roadmap