Visualizations and report design
- Choose the right visual for the question
- Create cards, charts and matrices
- Apply consistent themes and formatting
- Use interactions between visuals
- Create readable, well-structured pages
- Apply accessibility principles
Microsoft Power BI — Intermediate
Microsoft Power BI — Intermediate
Private Microsoft Power BI intermediate training for businesses across Canada: 4 three-hour modules and a customizable plan.
Program
Modules in this level
Essential DAX measures
- Understand calculated columns versus measures
- Create SUM, COUNT and DISTINCTCOUNT measures
- Use DIVIDE for ratios
- Understand CALCULATE at a practical level
- Create KPIs and percentages
- Organize and name measures clearly
Filters, slicers and interactive navigation
- Create effective slicers
- Manage visual, page and report filters
- Use drill-down and drill-through
- Create useful tooltips
- Use bookmarks and buttons
- Build a clear navigation experience
Time, trends and performance indicators
- Work with dates and periods
- Compare current and previous periods
- Create monthly or yearly trends
- Build targets and variances
- Display KPIs with context
- Validate time-based calculations
Outcomes
Directly observable outcomes
✓
Choose the right visual for the question
Practised in an exercise or work case.
✓
Create cards, charts and matrices
Practised in an exercise or work case.
✓
Understand calculated columns versus measures
Practised in an exercise or work case.
✓
Create SUM, COUNT and DISTINCTCOUNT measures
Practised in an exercise or work case.
✓
Create effective slicers
Practised in an exercise or work case.
✓
Manage visual, page and report filters
Practised in an exercise or work case.
✓
Work with dates and periods
Practised in an exercise or work case.
✓
Compare current and previous periods
Practised in an exercise or work case.
FAQ
Prepare the right pathway
Can we choose only certain modules?
Yes. The builder lets you create a plan from the 10 Microsoft Power BI modules.
Is the training suitable for beginners?
Yes. Modules 01 to 03 form the 9-hour beginner path.
Can we work with our own files?
Yes, when the files can be shared and doing so complies with your organization’s confidentiality rules.
Do we need a license?
Comfort with Excel tables and business data is recommended. The course does not require Python, R or advanced programming.
JFL Media
Ready to build your plan?
Select modules from this level and add other topics as needed.