Back to all courses

Microsoft Power BI Desktop Introduction

Power BI Desktop is a software application which allows you to create visual reports using data from a variety of sources. Discover what is important in your data through visuals and interactions. It is aimed at those who want to examine large amounts of related data and produce reports summarising the data.

Save to my Shortlist Save to shortlist Share Share

Certification:

College Certificated

Duration:

  • 1 day
  • 9.30 am - 4.30 pm
Enquire now

Who is this course for?

This course is for those currently, or seeking to, analyse large amounts of related data and produce reports summarising the data.

What qualifications will I gain?

Fife College Certificate of Attendance

What will I learn on the course?

Overview of Power BI Desktop

  • What is Power BI, Power Query and Power Pivot?
  • The Power BI Service
  • Power BI Report Server
  • Power BI Desktop
  • Understanding Dashboards, Reports and Datasets
  • Creating, editing & saving PBIX files

Importing Data into Power BI Desktop

  • Connecting to CSV Files, Excel Data
  • Other data sources
  • What are Table Relationships?
  • Creating Relationships
  • Cardinality
  • Working with a Date Table

Transforming and Combining Data

  • The Query Editor within Power BI
  • Applied Steps
  • Shaping Data
  • Formatting Data
  • Transforming Data

Visualising Data

  • Overview of Visualisations
  • Choosing the right visual
  • Changing visuals
  • Sorting and formatting
  • Edit Interactions
  • Slicers

Modelling Data

  • What is DAX?
  • DAX Syntax
  • DAX Aggregate Functions
  • Creating Measures

Application Information

What further course options are available?

  • Intermediate Power BI Desktop

How will this help my career?

This course enhances your proficiency within Microsoft Power BI which you can take back into your workplace activities to improve productivity.