Advanced Data Analysing and Visualization with Power BI for Power User

2 days

HRD Corp claimable

Runs in-house for your team

Overview

This programme is for Power BI users who can already clean data in Power Query and write simple DAX, and who want to build self-service business intelligence solutions with a Power BI Pro licence.

Participants build an auto rolling calendar in M, manage active and inactive relationships and filter direction, and write nested CALCULATE() measures plus year-to-date and rolling average calculations. Reports gain dynamic titles, conditional formatting, slicers, bookmarks, tooltip reports and the Q&A and Key Influencers AI visuals.

The last part covers app workspace roles, publishing and sharing reports, dashboards and apps, a dataflow as one true data source, and scheduled refresh through a data gateway. Practical exercises run alongside interactive lectures and discussion.

Module topics

  • Advanced M and an auto rolling calendar
  • Relationships and filter flow in depth
  • Nested CALCULATE() and filter functions
  • Time intelligence with TOTALYTD() and DATESINPERIOD()
  • Report View formatting and interactive tools
  • Q&A and Key Influencers AI visuals
  • App workspace administration and sharing
  • Data gateways, scheduled refresh and dataflows

Who runs this programme

Anne Hui San Teoh

Excel, Power Query and Copilot trainer

Shalina Hj Mohd Salleh

Power BI, Excel, Google Workspace and AI tools trainer

Subashkaran Perumalu

Excel, Power BI and programming trainer

At a glance

2 days

In-house at your premises or a venue you choose

HRD Corp claimable

Prefer to chat? WhatsApp us on 012-600 4488.

Ask about this programme

Tell us your team size and preferred dates. Our team will reply with the outline and a quotation.

Programme enquiry