Classroom Training
3-day intensive Power BI/DAX training course
Available as classroom training course only
3 days
There is a LOT to learn in Power BI, which is why we've split our Power BI training into three two-day courses (an introduction to Power BI, showing how to write measures in DAX and showing some more advanced Power BI features). However, we've had a few clients who want to accelerate this process, squeezing nearly 6 days of learning into an intensive three-day fast track course. This isn't for everyone, which is why it's only available for single company courses.
Our fast-track courses are only available as tailored training, either at your premises or at either our London or Manchester venues (here's why).
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
If time
Overview of maps
- The types of map
- Geo-location
- Introduction to ArcGIS
Calculated columns
- Adding columns
- IF and SWITCH
- The RELATED function
Publishing reports
- Power BI accounts
- Power BI files (PBIX)
Power BI Service
- Publishing
- Dashboards and tiles
- Sharing reports
App workspaces
- Creating app workspaces
- Publishing apps
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
If time
Understanding EARLIER
- How it works
- Banding using EARLIER
- Ranking using EARLIER
Variables
- Creating variables
- Using for debugging
Calendars and dates
- Creating a calendar
- Date-based functions
Advanced date functions
- Multiple relationships
- Moving averages
If time
Parent-child hierarchies
- The PATH functions
- Displaying different levels
- Making the results neater
Tooltips
- Tooltip backgrounds
- Dynamic report tooltips
- Visual header tooltips
Quick measures
- Showing selected items
- Filtering columns
Bookmarks
- Creating bookmarks
- Data and display properties
- Spotlighting and hiding visuals
If time
Bookmark case studies
- Dynamic chart axes
- Dynamic page titles
Report themes
- Applying themes
- Creating custom themes
- A suggested standard theme
Power BI Templates
- Creating templates
- Including themes
- Using parameters
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
- 519 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).
Clare Hill (Hertfordshire Constabulary)
James Young (Ministry of Housing, Communities and Local Government)
Richard Moon (AQA Education Limited)
Tashan Jackson (Partners for Improvement in Islington Ltd)
Steve Pilkington (Department for Education)
There are lots more where these came from (or just refresh this page to change the quotes shown).
Related Courses
Other Power BI training resources
Power BI exercises
We have lots of Power BI exercises on our website.
View Power BI Desktop or DAX 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 blogs