To provide attendees with the skills required to very effectively analyse data and create visualisations using Microsoft Power BI Desktop & Microsoft Power BI Server. Course Duration 2 days. Trainees must attend both days.
Description
Day 1
Who should attend?
New or existing users of Microsoft Power BI, who want to analyse data effectively using Microsoft Power BI Desktop.
Assumed Knowledge:
A working knowledge of Microsoft Excel is assumed, gained from the workplace or by prior attendance on an IT course.
Objectives:
To provide attendees with the skills required to very effectively analyse data and create visualisations using Microsoft Power BI Desktop.
Course Content
- Creating a visualisation and setting up Slicers to filter Data.
- The desktop Interface.
- Getting data from various sources.
- Interaction between Visualisations.
- Aggregation.
- Transforming and correcting data.
- Creating custom columns and Appending data.
- Creating visualization by asking questions.
- Linking tables.
- Relationship types.
- Getting data from the web.
- Visualisations.
- Hierarchies.
- Sort and Filter.
Day 2
Who should attend?
Existing users of Microsoft Power BI Desktop, who want to analyse data online effectively using Microsoft Power BI Server and develop formulas.
Assumed Knowledge:
A working knowledge of Power BI Desktop is assumed, gained from the workplace or by prior attendance on an IT course.
Objectives:
To provide attendees with the skills required to very effectively analyse data and create visualisations using Microsoft Power BI Server.
Course Content
- Creating a visualisation and setting up Slicers to filter Data.
- The desktop Interface.
- Getting data from various sources.
- Interaction between Visualisations.
- Aggregation.
- Transforming and correcting data.
- Creating custom columns and Appending data.
- Creating visualization by asking questions.
- Linking tables.
- Relationship types.
- Getting data from the web.
- Visualisations.
- Hierarchies.
- Sort and Filter.
