Overview:
Our Power BI Masterclass provides practical, hands-on training to help delegates build professional reports, dashboards, and data models using Microsoft Power BI.
The programme is delivered across four focused workshops, covering everything from data preparation and visualisation to advanced DAX and publishing techniques.
Book the individual sessions to match your learning needs or enrol on the full course at a discounted rate for a complete end-to-end Power BI learning experience.
To book the full Power BI masterclass course, please click here
Power BI masterclass session 4: Advanced DAX & Power BI Publishing
Master the advanced features that bring Power BI reports to life. This session introduces key DAX concepts including calculated columns, measures, and time intelligence functions such as YTD and MTD calculations. Participants will also explore advanced report functionality including bookmarks and customised views, before learning how to publish, share, and export professional reports for business users.
This session covers:
- Overview of Calculated columns vs Measures
- Introduce DAX functions for manipulating Dates – YTD, MTD, etc
- Aggregate functions – SUM, SUMX, CALCULATE, RELATED, RELATEDTABLE, SELECTED VALUE
- Overview of Bookmarks, customised views
- Publish to Power BI workspaces, save as PDF.
Speaker
Celia Henderson

Experienced learning and development professional providing a comprehensive package of training and support services in the private and public sectors – health, financial, legal, banking, investment, education, land-based, automotive and commercial. Contracts require me to be involved in all stages of the training process, from identifying training needs through to collection and analysis of delegate and manager post-training feedback. Friendly and approachable with a love of learning and sharing knowledge and skills.
Celia describes herself as a competent, conscientious and energetic trainer; an experienced learning and development professional with a natural ability and enthusiasm to assimilate and disseminate new technologies and soft skills. Committed to delivering first class training enabling learners and clients to meet and exceed their expectations. A confident decision maker who communicates effectively and works well with individuals and teams at all levels. Celia owned and ran her own Recruitment and Training company in West Sussex for 15 years employing full time staff and managing a team of 200 temporary staff. She has worked in Learning and Development since 1995