Walnut DataTech
Create account

Power BI analyst certification

Shape data with Power Query, model it as a star schema, write correct DAX and publish secure reports in the Power BI service.

No reviews yetTaught by Walnut Jobs course team
Level
Intermediate
Language
English
Duration
20 hours
Lessons
12

Last updated 22 Oct 2026

What you'll learn.

  • Connect to files, databases and SharePoint and shape data with Power Query.
  • Build a star-schema model with correct relationships and a dedicated date table.
  • Write DAX measures that respect filter context, including CALCULATE and time intelligence.
  • Design report pages that answer a clear question and meet accessibility basics.
  • Publish to the Power BI service, schedule refresh and apply row-level security.
  • Explain when to use Import, DirectQuery and Direct Lake storage modes.

How this course is taught.

Every module comes to you in four parts, so you can watch, read, discuss and check what you have learned.

  1. Quadrant I

    e-Tutorial

    Watch a short video lecture for each module, with full text notes beside it so you can review or translate at your own pace.

  2. Quadrant II

    e-Content

    Download or print the reading material for each module, with key terms, case studies and links to further resources.

  3. Quadrant III

    Discussion forum

    Ask questions and clear your doubts with other learners. The course team guides the discussion and answers questions.

  4. Quadrant IV

    Assessment

    Check your understanding with quizzes, short and long-answer practice and FAQs, then take the final test.

Curriculum.

4 modules · 12 lessons
1Getting and shaping data3 lessons · 47 mine-Content (notes)2Assessment1
  • Note: Power BI in the analyst's toolkit15 min
  • Note: Shaping data with Power Query and M22 min
  • Quiz: Module 1 quiz10 min
2Modelling for analysis3 lessons · 47 mine-Content (notes)2Assessment1
  • Note: Star schemas and relationships20 min
  • Note: Date tables and model hygiene15 min
  • Quiz: Module 2 quiz12 min
3DAX for analysts3 lessons · 56 mine-Content (notes)2Assessment1
  • Note: Measures, columns and filter context22 min
  • Note: CALCULATE and time intelligence22 min
  • Quiz: Module 3 quiz12 min
4Reports, sharing and governance3 lessons · 58 mine-Content (notes)2Final test1
  • Note: Designing report pages people use18 min
  • Note: Publishing, refresh and row-level security20 min
  • Final test: Final assessment20 min

Your certificate.

This is the certificate you receive when you complete the course and pass its final test.

Certificate No.

WDT-WJPBA-2026-000000

Certificate of completion

Power BI Analyst Certification

This is to certify that

Learner Name

has successfully completed the course and passed its assessment, and is recognised as a

Power BI analyst certification

4 modules12 lessons20 hours of learningOnline, on Walnut LMS

DD Month YYYY

Date of issue

Noida, India

Authorised Signatory

Walnut DataTech Private Limited

Verify this certificate at walnutdatatech.com/verify-certificate with certificate number WDT-WJPBA-2026-000000. Issued on Walnut LMS.

Specimen — not a valid certificate
Power BI analyst certificationView full size

What you need to receive it.

Complete every lesson and pass the final assessment with at least 70%.

Every certificate carries its own number that anyone can check on the verification page.

About this course.

Power BI is the reporting standard in thousands of organisations that run on Microsoft 365, from European banks to Gulf energy companies. Employers want analysts who can do more than drag visuals onto a canvas: they need clean models, correct measures and reports that are secure and refresh on time.

This course follows the skills measured in Microsoft's PL-300 Power BI Data Analyst exam: prepare the data, model the data, visualise and analyse the data, and deploy and maintain assets. It also shows how your Excel knowledge carries across.

Who this is for

  • Excel power users moving to governed self-service reporting
  • Analysts preparing for the PL-300 exam
  • Finance and operations teams who own management reporting
  • Candidates applying to roles that list Power BI and data modelling

Skills this certificate proves: Power BI (Proficient), Excel (Proficient), Data modelling (Proficient).

Linked to Walnut Jobs: complete this course to earn the certificate employers ask for.

Your instructor.

Walnut Jobs course teamJob-ready courses designed with hiring companies

Learner reviews.

No reviews yet

No reviews yet. Learners can review a course after completing half of it.

Questions about enrolling.

Is this course really free?

Yes. Create an account and enrol with one click. There's no payment step.

How long can I access this course?

You keep access for as long as the course is offered on Walnut LMS.

Do I get a certificate?

Yes. The certificate section above shows the certificate and sets out what you need to receive it.

Data and AI