Effective Digital Skills for Data Analytics – Power BI

Power%20Bi.jpeg

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.