Power BI Desktop, data and first report
- Understand Desktop, Service and workflow
- Connect to Excel and common sources
- Understand tables, fields and data types
- Create basic visuals
- Use the Filters pane
- Save a first PBIX file
Microsoft Power BI — Beginner
Microsoft Power BI — Beginner
Private Microsoft Power BI beginner training for businesses across Canada: 3 three-hour modules and a customizable plan.
Program
Modules in this level
Power Query and data preparation
- Open and read Power Query steps
- Clean columns and values
- Change data types
- Split, merge and replace values
- Append or merge queries
- Create repeatable preparation without advanced code
Data model and relationships
- Understand fact and dimension tables
- Create and verify relationships
- Understand cardinality and filter direction
- Build a simple star schema
- Create a date table when needed
- Avoid ambiguous or overly complex models
Outcomes
Directly observable outcomes
✓
Understand Desktop, Service and workflow
Practised in an exercise or work case.
✓
Connect to Excel and common sources
Practised in an exercise or work case.
✓
Open and read Power Query steps
Practised in an exercise or work case.
✓
Clean columns and values
Practised in an exercise or work case.
✓
Understand fact and dimension tables
Practised in an exercise or work case.
✓
Create and verify relationships
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.