Skip to main content
RAZAK MAJID

C · Artificial Intelligence & Digital Transformation

Power BI Data Analysis & Dashboards: Competency Certificate

Bahasa Melayu title: Analisis Data & Papan Pemuka Power BI: Sijil Kompetensi

Programme overview

Many organisations still build monthly reports by copying figures between spreadsheets, so the numbers arrive late and rarely agree. This certificate programme builds practical Power BI capability for turning everyday data into reliable, interactive dashboards. Participants connect to Excel and other common sources, clean and shape data with Power Query, build a simple data model with relationships, write essential DAX measures, design clear report pages and learn how reports are shared securely. The emphasis is on reports that answer management questions, not on decorative charts. Participants who complete an assessed dashboard project, marked against a written rubric, earn the Competency Certificate.

How do you know this programme suits your organisation?

It is likely to be a good fit if several of these situations sound familiar:

  • Monthly reports are built by copying figures between spreadsheets, and it takes days.
  • Different departments report different numbers for the same measure.
  • Management wants to filter and drill into the figures, but reports are static.
  • Staff have Power BI available but have never been trained to use it properly.

Target participants

  • Executives and officers who prepare management reports
  • Finance, HR, sales and operations analysts
  • Managers who want to read and question dashboards
  • Public-sector and corporate data and reporting teams

Learning outcomes

By the end of the programme, participants will be able to:

  • Connect to Excel, CSV and other common data sources in Power BI Desktop
  • Clean, transform and combine data with Power Query
  • Build a data model with relationships and a date table suited to reporting
  • Write essential DAX measures for totals, ratios and time comparisons
  • Design clear, interactive report pages that answer management questions
  • Explain how reports are published, refreshed and shared securely in the Power BI service

Key modules

  1. 01

    Power BI Foundations

    Power BI Desktop and the Power BI service, the reporting workflow, and planning a report around the questions management needs answered.

  2. 02

    Preparing Data with Power Query

    Connecting to sources; cleaning, transforming and combining data; and setting it up to refresh without repeating the work.

  3. 03

    Modelling the Data

    Fact and dimension tables, relationships, a date table, and why model design affects every report built on it.

  4. 04

    DAX Essentials

    Calculated columns versus measures, CALCULATE, common aggregations and time comparisons such as month-on-month and year-to-date.

  5. 05

    Visualising and Analysing Data

    Choosing the right visuals, slicers, drill-through and page design that a manager can read at a glance.

  6. 06

    Sharing, Security and the Assessed Project

    Publishing and sharing in the Power BI service, workspaces, scheduled refresh and row-level security basics, and the Competency Certificate project brief.

Certificate options

Choose the level that fits your goal.

Competency Certificate

2 days of training + an assessed practical project

For participants who also prove they can do the work: a real practical project, assessed against a written rubric.

Requirements

  • Everything required for the Professional Certificate
  • A practical project submitted after the training
  • A pass in the assessment, marked against a written rubric

Assessed for the Competency Certificate

  • A report plan for a real or demo dataset: the management questions, measures and pages
  • A cleaned and modelled dataset (Power Query steps and relationships)
  • A Power BI report with at least five DAX measures and two interactive pages
  • A short presentation of three insights and recommendations from the dashboard

Official certification (optional)

This programme also prepares you for:

Exam PL-300: Microsoft Power BI Data Analyst (Microsoft Learn, paid exam; the fee is set by the provider)

Participants register for and sit the official exam directly with the provider. The programme prepares you for it; a pass is not guaranteed.

Official information: Microsoft Learn

Trainer credential: The trainer holds Google professional certificates in data analytics and advanced data analytics.

Certificates are issued by Y5Data Integrated Network and signed by Ts. Abdul Razak b. Abdul Majid.

These certificates are not official Google, Meta or Microsoft certifications and are not Sijil Kemahiran Malaysia (SKM) or JPK accreditation. Google, Google Ads and Google Analytics are trademarks of Google LLC; Meta is a trademark of Meta Platforms, Inc.; Microsoft and Power BI are trademarks of the Microsoft group of companies. These programmes are independent and are not affiliated with or endorsed by Google, Meta or Microsoft.

How our certificates work →

Training methodology

  • Hands-on work in Power BI Desktop with sample datasets, or the participant's own data with personal details removed
  • Guided exercises after every module
  • Reporting scenarios drawn from typical sales, finance, HR and operations data
  • Participants need a Windows laptop with Power BI Desktop installed
  • Assessed dashboard project for the Competency Certificate

Practical deliverables participants take away

  • Report planning template (questions, measures, visuals)
  • Power Query data-cleaning checklist
  • Starter set of DAX measures
  • Dashboard design checklist
  • A completed Power BI report file

Suitable organisational use cases

  • Replacing manual spreadsheet reports with refreshable dashboards
  • Management reporting in agencies, GLCs and companies
  • Upskilling officers and analysts who prepare monthly reports

Adaptable to your organisation

Content, examples, duration and language can be adapted to your sector, objectives and participant profile. Share your requirements to receive a recommendation on the most suitable format.

Frequently asked questions

How long is this programme?

This programme leads to the Competency Certificate (2 days of training + an assessed practical project). In-house sessions can be scheduled to suit your organisation.

Can it be delivered online or in Bahasa Melayu?

It can be delivered in person, online or in a hybrid format, in English, Bahasa Melayu or bilingually.

Who issues the certificate?

Certificates are issued by Y5Data Integrated Network and signed by Ts. Abdul Razak b. Abdul Majid.

Is this an official Google, Meta or Microsoft certification?

No. The certificate is issued by Y5Data Integrated Network. Where an official exam exists, the programme helps you prepare for it, and you register and sit that exam directly with the provider.

How much does this programme cost?

Fees are provided by quotation, based on participant numbers, customisation, delivery mode and location.

How do we book this programme for our team?

Request a quotation or proposal through the enquiry form. You will receive a written proposal and quotation, and dates are confirmed once your organisation approves.

Interested in this programme?

Tell me about your participants and objectives, and I will prepare a tailored proposal and quotation.

Related programmes

  • C|AI & Digital

    Generative AI for Workplace Productivity

    Generative AI is quickly becoming a standard workplace tool, yet many employees either avoid it or use it without clear guidance. This programme gives participants a practical, responsible foundation for using generative AI in…

    1–2 hrsHalf day1 dayCustom

    Request quotation

    View programme
  • C|AI & Digital

    Practical ChatGPT for Business and Professionals

    ChatGPT is often the first generative AI tool professionals encounter, yet most users only scratch the surface of what it can do. This programme provides structured, hands-on training in using ChatGPT effectively for business and…

    Half day1 day

    Request quotation

    View programme
  • C|AI & Digital

    AI Tools for Entrepreneurs and SMEs

    Small businesses can now access AI capabilities that were once available only to large companies with dedicated teams. This programme introduces practical, affordable AI tools that help entrepreneurs and SMEs save time and…

    1–2 hrsHalf day1 day

    Request quotation

    View programme

Power BI Data Analysis & Dashboards: Competency Certificate

Request Quotation