Microsoft Certified: Power BI Data Analyst Associate

Training provider:
Iungo Solutions

Duration:
TBC

Awarding body:
Microsoft

Delivery:
Instructor-led virtual or face to face

Overview

Unlock the full potential of your organisation’s data with the highly sought-after Microsoft Certified Power BI Data Analyst certification. You’ll master everything from connecting to various data sources and building robust data models, to creating dynamic dashboards and visual reports that drive smarter business decisions. Elevate your analytical capabilities, gain instant credibility with employers, and position yourself as a crucial asset in any data-driven team, turning complex information into clear, strategic advantages. Become a certified Power BI expert and lead the charge in data literacy.

What will I learn?

  • Account creation
  • What is business intelligence?
  • Importing data
  • Charts and graphs
  • Functions
  • Data blending
  • Joining data sets
  • What are parameters?
  • Level of detail expressions
  • Building a dashboard
  • Creating data APIs

Key information

Funding eligibility criteria

  • Aged 19+
  • Living in Wales

Plus, one of the following:

  • Employed (inc. agency & zero hour contracts),
  • Self-employed,
  • Full-time carer,
  • Prisoner on day release

Entry requirements

Candidates should ideally hold the Microsoft Azure Data Fundamentals Certification.

Candidates applying to undertake this programme should possess a reasonable level of data literacy and be comfortable interpreting charts and graphs.

If applicants intend to complete any part of this programme online they should ensure that they have a device that is capable of downloading and running the latest desktop version of Microsoft Power BI. The device should

  • Minimum Processor: Intel i3 or AMD Ryzen 3
  • Minimum RAM: 8GB
  • Maximum Age: 5 years

Laptops can be provided to participants who attend the programme in-person.

Assessment

Exam lasting 100 minutes.

Career progression

Participants who complete this programme will be able to undertake further Microsoft Certifications after achieving their Microsoft Power BI Data Analyst certification. Alternatively they could complete an advanced visualisation programme in Python or R.

Course dates will be discussed directly with the training provider upon successful completion of funding application. Any course dates arranged with the training provider prior to funding being secured may not be honoured – Course dates will only be confirmed once funding has been approved.

Training provider:
Aspire 2Be

Duration:
3 days

Awarding body:
Microsoft

Delivery:
Tutor-led online

Overview

The Microsoft Certified: Power BI Data Analyst Associate certification is designed to validate the skills necessary to enable businesses to maximise the value of their data assets using Microsoft Power BI. This certification focuses on transforming raw data into meaningful insights through the creation of interactive dashboards and reports.

What will I learn?

The Power BI Data Analyst Associate certification is based on key competencies required to effectively analyse data with Power BI. The course covers four key content domains:

  • Prepare the Data: Connecting to data sources, cleaning and transforming data, and managing data storage.
  • Model the Data: Designing and developing a data model, optimising the model for performance, and creating calculated columns and measures.
  • Visualize and Analyse the Data: Creating reports and dashboards, enhancing reports with advanced visualisations, and analysing data using Power BI features.
  • Deploy and Maintain Assets: Deploying and sharing reports and dashboards, managing workspaces, and implementing security standards.

Key information

Funding eligibility criteria

  • Aged 19+
  • Living in Wales

Plus, one of the following:

  • Employed (inc. agency & zero hour contracts),
  • Self-employed,
  • Full-time carer,
  • Prisoner on day release

Entry requirements

This course is designed for aspiring data professionals and analysts who want to develop advanced skills in data modelling, visualisation, and business intelligence using Microsoft Power BI. It is not suitable for general end users or those seeking basic Power BI report navigation.

Assessment

Exam lasting 60 minutes.

Career progression

  • Data analysts and business intelligence professionals
  • Professionals responsible for designing and building scalable data models
  • Individuals looking to advance their skills in data visualisation and analysis
  • IT professionals who need to create reports and dashboards for their organisation

Course dates will be discussed directly with the training provider upon successful completion of funding application. Any course dates arranged with the training provider prior to funding being secured may not be honoured – Course dates will only be confirmed once funding has been approved.

Training provider:
NILC

Duration:
4 days

Awarding body:
Microsoft

Delivery:
Tutor-led online

Overview

The Microsoft Certified: Power BI Data Analyst Associate certification is designed for professionals who want to demonstrate their ability to model, visualize, and analyse data using Microsoft Power BI. This course equips learners with the skills to transform raw data into meaningful insights that align with business and technical requirements. Participants will learn how to prepare data, build semantic models, create compelling reports, and apply advanced analytics. The course also introduces Microsoft Fabric and AI-powered tools like Copilot to enhance reporting and analysis capabilities. 

What will I learn?

After completing this course, learners will be able to ingest, clean, and transform data; model data for performance and scalability; design and create reports for data analysis; apply and perform advanced report analytics; and manage and share report assets. They will also gain experience with DAX functions, row-level security, workspace management, and dashboard creation. The course includes modules on optimizing model performance, implementing semantic models, and using Copilot for Power BI to generate summaries and visuals. 

Key information

Funding eligibility criteria

  • Aged 19+
  • Living in Wales

Plus, one of the following:

  • Employed (inc. agency & zero hour contracts),
  • Self-employed,
  • Full-time carer,
  • Prisoner on day release

Entry requirements

There are no strict prerequisites for this course, but learners are encouraged to have a basic understanding of data analysis concepts, including data tables, relationships, and common visualization types. Familiarity with Microsoft Excel functions such as pivot tables and formulas is advantageous. Experience with data sources like SQL databases or Excel files, and general IT knowledge including file systems and networking, will support success. Prior exposure to Power BI Desktop and Power BI Service is helpful but not mandatory. 

Assessment

The PL-300 exam is a proctored certification assessment that lasts approximately 100 minutes. It includes interactive components and requires a minimum score of 700 out of 1000 to pass. The exam evaluates skills in preparing data, modelling data, visualizing and analysing data, and managing and securing Power BI environments 

Career progression

Professionals who earn this certification can pursue roles such as Power BI Analyst, Business Intelligence Developer, or Data Visualization Specialist. With further experience and certifications like Microsoft Certified: Fabric Analytics Engineer Associate or Azure Data Engineer Associate, career paths may lead to senior roles such as BI Manager, Data Analytics Lead, or Head of Business Intelligence/

Course dates will be discussed directly with the training provider upon successful completion of funding application. Any course dates arranged with the training provider prior to funding being secured may not be honoured – Course dates will only be confirmed once funding has been approved.

Aberdare

Wellington Street
Aberdare
Rhondda Cynon Taff
CF44 8EN

01685 887500

Nantgarw

Heol y Coleg
Parc Nantgarw
Cardiff
CF15 7QY

01443 662800

Rhondda

Llwynypia
Tonypandy
Rhondda Cynon Taff
CF40 2TQ

01443 663202

Ystrad Mynach

Twyn Road
Ystrad Mynach
Hengoed
CF82 7XR

01443 816888
  • Associate
  • Associate
  • Associate
  • Associate
  • Associate
  • Associate
  • Associate
  • Associate
  • Associate
  • Associate
  • Associate
  • Associate
  • Associate
  • Associate
  • Associate
  • Associate
  • Associate
Link takes you to our YouTube page Link takes you to our Instagram page Accessibility
Staff / Student Portal College App News ALN Careers