Classroom Training
3-day intensive DAX and Power BI course
Classroom training course - online version also available
3 days
Our two-day DAX course assumes that you're already familiar with using Power BI, but what if this isn't the case? Normally we'd advise you to book onto our two-day Introduction to Power BI course first, but we recognise that there are a select band of people who have the ability to cover three days of intensive training without being fazed (and who would prefer to minimise the amount of time spent away from their desk), and so we've created this three-day fast-track course to give a general introduction to Power BI and a full grounding in DAX in three busy, busy days.
Course details
Possible locations:London, Manchester, Online
Next classroom course:Wed 13 October 2021
Time:10.00-16.30
Course Contents
This fast-track course combines topics from the following other Wise Owl courses:
Basic reports
- Getting data
- Basic visualisations
- Shapes, text boxes and images
Data sources
- SQL Server / databases
- Excel / text files
- Websites and web services
Formatting visualisations
- The formatting panes
- Conditional formatting
Charts
- Working with charts
- Specific chart type issues
- Grouping and binning
Other types of visualisation
- Working with matrices
- Working with cards
Dashboard visualisations
- Gauges
- Single-number visualisations
- KPIs
Query editor
- Filtering rows
- Manipulating columns
- Working with data types
More on query editor
- Creating new columns
- Introducing the M language
Multiple tables
- Relationships
- Filter directions
Filtering data
- Slicers
- Visualisation level filters
Drill-down
- Interactions
- "See records" feature
Drill-through filtering
- Adding drillthrough filters
- Back buttons
Publishing reports
- Power BI accounts
- Power BI files (PBIX)
Power BI Service
- Publishing
- Dashboards and tiles
- Sharing reports
Ways to edit DAX
- Power BI
- PowerPivot
- SSAS Tabular
- DAX Studio
Data model basics
- Linking to data
- Creating a data model
Calculated columns
- Creating calculated columns
- IF and SWITCH
- Showing RELATED data
- Dealing with blanks
Basic measures
- Creating measures
- Understanding filter context
- Using a measures table
- AggregateX functions
The CALCULATE function
- Filter context revisited
- Removing and replacing context
- Context transition
If time
The VALUES function
- The HASONEVALUE function
- Listing single values
- Parameter tables
If time
Dynamic measures
- The ISFILTERED function
- The ALLSELECTED FUNCTION
- Dynamic titles
If time
The FILTER function
- Row context
- Iterator functions
- Applying criteria
Variables
- Creating variables
- Using for debugging
Calendars and dates
- Creating a calendar
- Date-based functions
Advanced date functions
- Multiple relationships
- Moving averages
You'll get the most out of this course if you've already dabbled with Power BI, although no experience is essential. The course has a very ambitious timetable, and obviously our ability to cover all of the syllabus will depend on the ability of those attending!
Why Choose Us?
- No more than 5 people per class
- Proper restaurant lunch included
- 554 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
Sample customer feedback
Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).
Michael Eynon (Skills Development Scotland (SDS))
Murtaza Tirmazi (Cheshire Datasystems Ltd)
Michael Abson (Durham County Council)
Thomas Sanderson (Leeds Community Healthcare NHS Trust)
Mark Ingle (Ortho Solutions UK Ltd)
There are lots more where these came from (or just refresh this page to change the quotes shown).
Scheduled Fast track Power BI and DAX training dates
Here are the classroom Fast track Power BI and DAX courses we have scheduled for the next 3 months:
| Dates | Days | Venue | Price | Booking |
|---|---|---|---|---|
| Wed/Fri 13-15 October 2021 | 3 | Manchester | £1,095 | Book places |
| Mon/Wed 06-08 December 2021 | 3 | Manchester | £1,095 | Book places |
| Date(s) | Venue |
|---|---|
| 13/10 | Manchester |
| 06/12 | Manchester |
All prices exclude VAT. If you can't see the dates you want, ask us about running onsite Power BI training at your offices (we'll even provide and set up the computers).
Related Courses
Other Power BI training resources
Power BI exercises
We have lots of Power BI exercises on our website.
View Power BI Desktop, DAX or Power Apps exercises
Power BI videos
Have a look at the videos we've published showing how to use Power BI.
View Power BI videos
Power BI skills assessment
Take our test to see how good your Power BI skills are.
View Power BI skills skills assessment tests
Power BI blogs
Have a look at some of the Power BI blogs that we've published on our site.
View Power BI or Power Apps blogs