PathTailor
FRSign inBuild my path
PathTailor
Build my pathSign inLire en français

Become a Power BI analyst

The catalogue prepares you for the Power BI analyst role with a path of 13 courses (65 lessons, 209 exercises, about 26 hours), from “SQL Fundamentals (SELECT, Filters, Aggregates)” to “Power BI Service: Publishing, Sharing and RLS Security”. 27 catalogue courses list this job among their outcomes.

  1. SQL Fundamentals (SELECT, Filters, Aggregates)
  2. Intermediate SQL (joins, subqueries)
  3. Database Modeling
  4. Descriptive Statistics
  5. Business Metrics and KPIs
  6. Getting Started with Power BI Desktop
  7. Power Query: Import and Transform
  8. Star Schema Modeling
  9. DAX Fundamentals
  10. Advanced DAX (Context, Time Intelligence)
  11. Data Storytelling and Presenting Results
  12. Designing Reports and Dashboards
  13. Power BI Service: Publishing, Sharing and RLS Security
Build my pathSee the 13 courses in order

The steps of the path

  1. SQL

  2. Statistics

  3. Data analysis

  4. Power BI

  5. Data analysis

  6. Power BI

Skills practised

SQL24

SELECT and FROMWHERE clauseORDER BYDISTINCTCOUNT, SUM, AVG, MIN, MAXGROUP BYHAVINGTesting NULL with IS NULLINNER JOINLEFT JOINAnti-joinSelf-joinSous requetesExists

10 more skills

CASE WHENUNION and UNION ALLCREATE TABLENOT NULL, UNIQUE, CHECK, DEFAULTFOREIGN KEY / REFERENCESCardinalities1NF, 2NF, 3NFStar schemaViewsSchema migrations

Statistics10

Variable typesCounts and frequenciesMeanMedianVarianceStandard deviationQuantilesOutliersPearson correlationPandas

Data analysis19

KPI definitionMetric treeAverage order valueConversion rateChurnCustomer lifetime valueChangeContribution to growthGross marginROAS and ROIAudience analysisKey messageChart selectionDecluttering

5 more skills

Action titleAnnotationRecommendationCommunicating uncertaintyMatplotlib

Power BI55

Power BI Desktop interfaceData importBasic visualsSlicersFilters paneVisual formattingPower Query editorM languageData cleaningCustom columnMerge queriesAppend queriesUnpivotPower Query best practices

41 more skills

Facts and dimensionsGrainStar schemaRelationshipsCardinalityDate tableMultiple fact tablesStorage modesMeasuresCalculated columnsIteratorsLogical functionsDIVIDECALCULATEVariablesFILTER, VALUES and DAX queriesContext transitionALLSELECTEDKEEPFILTERSTime intelligenceMoving averageRANKX and TOPNCalculation groupsDAX performanceChoosing a visualLayoutUse of colorDrillthroughBookmarks and buttonsConditional formattingField parametersAccessibilityPublishingWorkspacesScheduled refreshData gatewayPower BI appsRow-level securityDynamic RLSDeployment pipelinesGovernance

Courses that mention this job

Frequently asked questions

How long does the Power BI analyst path take?

The base path is about 26 hours of lessons and exercises, across 13 courses and 65 lessons. You go at your own pace, lesson by lesson.

Do I need any prior knowledge to start?

No. The path starts with “SQL Fundamentals (SELECT, Filters, Aggregates)”, a course with no prerequisites.

Which domains does the path cover?

In order: SQL, Statistics, Data analysis, Power BI. The last course is “Power BI Service: Publishing, Sharing and RLS Security”.

Does the path lead to a certification?

Not at this stage. The platform does not issue certifications yet, and claims no RNCP registration, no Qualiopi certification and no CPF eligibility.

Other careers

  • Become a data analyst

    17 courses · 87 lessons · about 47 h
    1. Programming Basics and Algorithms
    2. Coding with an AI Assistant (Prompts, Code Review)
    3. SQL Fundamentals (SELECT, Filters, Aggregates)
    4. Intermediate SQL (joins, subqueries)
    5. Descriptive Statistics
    6. Python Fundamentals
    7. Data Analysis with pandas and NumPy
    8. Data Cleaning and Preparation
    9. Visualization (Matplotlib, Seaborn, Plotly)
    10. Probability and Inferential Statistics
    11. Exploratory Data Analysis
    12. Business Metrics and KPIs
    13. Advanced SQL (CTEs, window functions)
    14. Data Storytelling and Presenting Results
    15. Automate with Python (Files, Excel, APIs)
    16. A/B Testing and Experimentation
    17. Simple ETL Pipelines
    • Foundations
    • SQL
    • Statistics
    • Python
    • Data analysis

  • Become a data scientist

    27 courses · 139 lessons · about 83 h
    1. Programming Basics and Algorithms
    2. Terminal and Command Line
    3. Git and GitHub
    4. Coding with an AI Assistant (Prompts, Code Review)
    5. SQL Fundamentals (SELECT, Filters, Aggregates)
    6. Intermediate SQL (joins, subqueries)
    7. Advanced SQL (CTEs, window functions)
    8. Descriptive Statistics
    9. Probability and Inferential Statistics
    10. Python Fundamentals
    11. Intermediate Python (Functions, Modules, OOP)
    12. Data Analysis with pandas and NumPy
    13. Data Cleaning and Preparation
    14. Visualization (Matplotlib, Seaborn, Plotly)
    15. Exploratory Data Analysis
    16. Introduction to Machine Learning (scikit-learn)
    17. Supervised Learning: Regression and Classification
    18. Unsupervised Learning: Clustering and Dimensionality Reduction
    19. Model Evaluation and Validation
    20. Feature Engineering
    21. Time Series and Forecasting
    22. HTTP and REST APIs
    23. APIs with FastAPI
    24. Deep Learning with PyTorch
    25. Natural Language Processing (NLP) and LLMs
    26. Deploying a Model (API, MLOps Basics)
    27. Docker and Deployment
    • Foundations
    • SQL
    • Statistics
    • Python
    • Data analysis
    • Data science
    • Back-end
    • Python for the web

  • Become a JavaScript web developer

    24 courses · 127 lessons · about 75 h
    1. Programming Basics and Algorithms
    2. Terminal and Command Line
    3. Git and GitHub
    4. Coding with an AI Assistant (Prompts, Code Review)
    5. HTML Fundamentals
    6. CSS Fundamentals
    7. Responsive Layout (Flexbox, Grid)
    8. JavaScript Fundamentals
    9. DOM and Events
    10. Asynchronous JavaScript (Promises, fetch, APIs)
    11. Accessibility and SEO
    12. Data Structures and Complexity
    13. TypeScript
    14. React
    15. SQL Fundamentals (SELECT, Filters, Aggregates)
    16. Intermediate SQL (joins, subqueries)
    17. Database Modeling
    18. HTTP and REST APIs
    19. Node.js Fundamentals
    20. API with Express
    21. Automated Testing
    22. Authentication and Web Security (OWASP)
    23. Full-Stack React + Node Application
    24. Docker and Deployment
    • Foundations
    • Front-end
    • SQL
    • Back-end
    • Server-side JavaScript

  • Become a Python web developer

    22 courses · 115 lessons · about 70 h
    1. Programming Basics and Algorithms
    2. Terminal and Command Line
    3. Git and GitHub
    4. Coding with an AI Assistant (Prompts, Code Review)
    5. Python Fundamentals
    6. Intermediate Python (Functions, Modules, OOP)
    7. HTML Fundamentals
    8. CSS Fundamentals
    9. Responsive Layout (Flexbox, Grid)
    10. JavaScript Fundamentals
    11. DOM and Events
    12. Asynchronous JavaScript (Promises, fetch, APIs)
    13. SQL Fundamentals (SELECT, Filters, Aggregates)
    14. Intermediate SQL (joins, subqueries)
    15. Database Modeling
    16. HTTP and REST APIs
    17. APIs with FastAPI
    18. Django Fundamentals
    19. Automated Testing
    20. Authentication and Web Security (OWASP)
    21. Complete Application with Django
    22. Docker and Deployment
    • Foundations
    • Python
    • Front-end
    • SQL
    • Back-end
    • Python for the web

  • Become a PHP web developer

    22 courses · 116 lessons · about 68 h
    1. Programming Basics and Algorithms
    2. Terminal and Command Line
    3. Git and GitHub
    4. Coding with an AI Assistant (Prompts, Code Review)
    5. HTML Fundamentals
    6. CSS Fundamentals
    7. Responsive Layout (Flexbox, Grid)
    8. JavaScript Fundamentals
    9. DOM and Events
    10. Asynchronous JavaScript (Promises, fetch, APIs)
    11. SQL Fundamentals (SELECT, Filters, Aggregates)
    12. Intermediate SQL (joins, subqueries)
    13. Database Modeling
    14. PHP Fundamentals
    15. Object-Oriented PHP and Composer
    16. PHP and Databases (PDO)
    17. HTTP and REST APIs
    18. Laravel Fundamentals
    19. Automated Testing
    20. Authentication and Web Security (OWASP)
    21. Advanced Laravel (API, Queues, Tests)
    22. Docker and Deployment
    • Foundations
    • Front-end
    • SQL
    • PHP
    • Back-end

  • Become a Java web developer

    23 courses · 121 lessons · about 70 h
    1. Programming Basics and Algorithms
    2. Terminal and Command Line
    3. Git and GitHub
    4. Coding with an AI Assistant (Prompts, Code Review)
    5. Data Structures and Complexity
    6. HTML Fundamentals
    7. CSS Fundamentals
    8. Responsive Layout (Flexbox, Grid)
    9. JavaScript Fundamentals
    10. DOM and Events
    11. Asynchronous JavaScript (Promises, fetch, APIs)
    12. SQL Fundamentals (SELECT, Filters, Aggregates)
    13. Intermediate SQL (joins, subqueries)
    14. Database Modeling
    15. Java Fundamentals
    16. Object-Oriented Java
    17. Collections, Streams, and Exceptions
    18. Testing with JUnit
    19. HTTP and REST APIs
    20. Spring Boot: REST API
    21. Persistence with JPA and Hibernate
    22. Authentication and Web Security (OWASP)
    23. Docker and Deployment
    • Foundations
    • Front-end
    • SQL
    • Java
    • Back-end

  • Become an AI developer

    12 courses · 61 lessons · about 28 h
    1. Programming Basics and Algorithms
    2. Python Fundamentals
    3. Intermediate Python (Functions, Modules, OOP)
    4. Git and GitHub
    5. Using Generative AI at Work
    6. HTTP and REST APIs
    7. Integrating an LLM into an Application
    8. RAG in Production
    9. AI Agents and Automation
    10. Evaluating and Monitoring an AI System
    11. Docker and Deployment
    12. Self-Hosting AI Models Locally
    • Foundations
    • Python
    • Generative AI
    • Back-end

  • Become a data engineer

    18 courses · 91 lessons · about 43 h
    1. Terminal and Command Line
    2. Git and GitHub
    3. SQL Fundamentals (SELECT, Filters, Aggregates)
    4. Intermediate SQL (joins, subqueries)
    5. Advanced SQL (CTEs, window functions)
    6. Database Modeling
    7. Python Fundamentals
    8. Intermediate Python (Functions, Modules, OOP)
    9. Data Analysis with pandas and NumPy
    10. Data Warehouses and Analytical Modeling
    11. Data Quality and Governance
    12. Transforming Data with dbt
    13. Orchestrating Pipelines with Airflow
    14. Distributed Processing with Spark
    15. PostgreSQL in Practice (indexes, performance)
    16. Docker and Deployment
    17. Cloud Fundamentals
    18. Deploying an Application to the Cloud
    • Foundations
    • SQL
    • Python
    • Data engineering
    • Back-end
    • Cloud and DevOps

  • Become a marketing analyst

    9 courses · 45 lessons · about 19 h
    1. SQL Fundamentals (SELECT, Filters, Aggregates)
    2. Intermediate SQL (joins, subqueries)
    3. Descriptive Statistics
    4. Business Metrics and KPIs
    5. Marketing Analytics
    6. E-commerce Analytics
    7. Data Storytelling and Presenting Results
    8. A/B Testing and Experimentation
    9. Local SEO and Online Presence
    • SQL
    • Statistics
    • Data analysis
    • Business analytics
    • Websites and CMS

  • Become a cloud and DevOps engineer

    10 courses · 50 lessons · about 20 h
    1. Terminal and Command Line
    2. Git and GitHub
    3. Linux for Developers
    4. Docker and Deployment
    5. Continuous Integration and Deployment
    6. Cloud Fundamentals
    7. Deploying an Application to the Cloud
    8. Kubernetes
    9. Infrastructure as Code with Terraform
    10. Cybersecurity: The Basics for Everyone
    • Foundations
    • Cloud and DevOps
    • Back-end
    • Cross-functional skills

  • Become a mobile developer

    10 courses · 53 lessons · about 28 h
    1. Programming Basics and Algorithms
    2. Git and GitHub
    3. JavaScript Fundamentals
    4. DOM and Events
    5. Asynchronous JavaScript (Promises, fetch, APIs)
    6. TypeScript
    7. React
    8. HTTP and REST APIs
    9. Mobile Apps with React Native
    10. Mobile Apps with Flutter
    • Foundations
    • Front-end
    • Back-end
    • Mobile

  • Become a digital project manager

    7 courses · 35 lessons · about 12 h
    1. Using Generative AI at Work
    2. Agile Project Management
    3. Business Analysis: From Needs to Specifications
    4. UX Design and Mockups
    5. GDPR for Data and Product Teams
    6. SQL Fundamentals (SELECT, Filters, Aggregates)
    7. Business Metrics and KPIs
    • Generative AI
    • Cross-functional skills
    • SQL
    • Data analysis

  • Become an Excel and reporting expert

    8 courses · 40 lessons · about 12 h
    1. Excel Fundamentals
    2. Excel: Lookup and Logical Functions
    3. Excel: PivotTables
    4. Build and Safeguard a Reliable Excel Workbook
    5. Using Generative AI at Work
    6. Power Query and Power Pivot in Excel
    7. Automating Excel (VBA and Office Scripts)
    8. Power Automate: Automate Your Tasks
    • Excel
    • Generative AI
    • Power Platform

Say what you want to be able to do, we build your path

Your path is assembled from the catalogue courses. With the Pro plan, every lesson is told with examples from your job.

The preview is free, and you can take the courses one at a time without paying. The path only contains lessons from the catalogue.