Messy data needs more than the basics
Advanced Power Query: merge and append queries, pivot and unpivot, group and aggregate, and add custom and conditional columns.
Microsoft Power BI
Further Power BI
Build more efficient, interactive and secure Power BI reports. Advanced transformations, DAX, custom slicer panels and row-level security, hands-on in one day.
£850at your premises, up to 10 delegates
Up to 6: £800 | Up to 3: £750
£800live online, up to 10 delegates
Up to 6: £750 | Up to 3: £700
1 day, per session, not per person. Smaller teams pay less. With a full group that is as little as £85 a person in person, or £80 online.
Problems this course fixes
Your calculations are not flexible enough
More complex DAX, and a clear understanding of when to use calculated columns and when to use measures.
Your report pages are cluttered with slicers
Create a show/hide slicer panel with bookmarks and buttons, and an active filters card so users can see what is applied.
Filters behave in confusing ways
Understand how slicers behave, sync them across pages, and use filters and bookmarks to guide your users.
Everyone sees everything
Row-level security shows each person only the data that is relevant to them, with roles you can apply and share.
Reports need someone to update them
Build dashboards from published reports and set up automatic refresh schedules.
What you will learn
You build interactive report features yourself, including a show/hide slicer panel, an active filters card, synced slicers and row-level security roles, and you finish with your own data.
Advanced Power Query
- Advanced data transformations
- Merging and appending queries
- Pivot, unpivot and group data
- Custom and conditional columns
- Grouping and aggregation
Data models and DAX
- Working with relationships
- Measures and further DAX measures
- Calculated columns versus measures
Interactive report design
- A show/hide slicer panel with bookmarks and buttons
- An active filters card
- Sync slicers
- Filters and bookmarks
- Formatting for a better user experience
Security
- Row-level security
- Applying and sharing roles
Sharing and automating
- Creating dashboards from published reports
- Automatic refresh schedules
- Working with your own data
How the day works
1 daytaught live by me, from start to finish
Up to 10delegates in the room or on screen
Your venueat your business in Nottingham, Derby, Leicester and Loughborough, or live online
Taught by me, Rachel
After 20 years in the workplace and 12 years teaching, I know what people actually need from Excel and Power BI.
Who it is for: Users who already have a solid understanding of Power BI and are ready to take their skills to the next level.
What you need: Power BI Desktop (free from Microsoft) on each computer. A free Power BI licence is enough to take the training. Get in touch if you have any questions about licences.
Before the course: your checklist
A few minutes of preparation means we spend the whole day learning. Tick things off as you go.
Organiser and IT
Each delegate
Keep going
Intro to Power BI
An Introduction to Power BI covers the building blocks this course assumes you know.
New to Power BI? See the courseSave with a bundle
The Complete Power BI Package is £1,275 in person or £1,190 online. All five Excel and Power BI courses together are £2,700 in person or £2,500 online. See all prices