- Power BI Foundations & Data Preparation
- Interactive Reporting & Dashboard Design
- Data Modelling & Multi-Source Analysis
- Advanced DAX & Power BI Publishing
- Speaker
- Additional information
Overview:
Build a strong foundation in Power BI by exploring the core tools, interface, and reporting workflow. In this hands-on session, participants will learn how to connect to data sources, import and clean data using Query Editor, and create their first interactive visuals. By the end of the session, attendees will understand the essential building blocks required to confidently start developing reports in Power BI.
This session covers:
· Brief overview of the tools (Power BI Service, Power BI Desktop, Power BI Mobile) and comparison with Power Query and Power Pivot
· Overview data importation
· Preview of the example report that will be created during the training
· Explore the desktop interface: Report, Data and Model views, Visualizations panel, etc
· Connect to single source data using Direct Query and importing
· Clean data using Query Editor: filter, remove rows, replace vales etc.
· Edit, rename and delete the applied steps – create calculated columns
· Creating simple visuals
Overview
Take your reporting skills further by learning how to design engaging and interactive Power BI dashboards. This session focuses on creating impactful visualisations, applying filters and slicers effectively, enabling drill-through analysis, and implementing best-practice report design techniques. Participants will also learn how to publish reports to the Power BI Service and share insights with others.
This session covers:
· More in depth overview of visuals - table and matrix visualisation – conditional formatting
· Overview of slicers vs filters
· Filters at visual level, page level and report level.
· Top N, generating drill through pages,
· Overview of visual interaction, grouping visualisations etc.
· Best practises for designing a report (e.g., Themes, illustrations, Filters and Slicers)
· Saving work in progress files and .pbix files
· Publishing simple report to Power BI workspace
Overview
Discover how to work with multiple datasets and unlock deeper business insights through effective data modelling. Participants will learn how to connect and relate data from different sources, create hierarchies, manage relationships, and use date tables to enhance reporting capabilities. This session provides the practical skills needed to build scalable and dynamic analytical reports.
This session covers:
· Connect to multiple sources of data creating relationships
· Clean data using Query Editor: filter, remove rows, replace vales, create and modify columns, calculation, date, merge text
· Working with hierarchies
· Build visuals from multiple data sources
· How filters and slicers work with 1 – many relationships
· Import a Date Table and link to date fields on other data sources
Overview
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.
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
The webinar handout material will be available on the webinar platform when you log in to view, 15 minutes before the live webinar start.
If you wish to view or download handout materials, before the day of the webinar, they will also be available through your document library on https://events.accaglobal.com.
Price
Price (excluding VAT) 396 GBP
Location
United Kingdom
Date & time
02 November 2026 - 02 December 2026, 10:00 - 16:30
Enquiries
Email enquiries UKCL@accaglobal.com
Delivered by