Back to all courses

Microsoft Power BI Desktop Introduction

This course is aimed at those who want to examine large amounts of related data and produce reports summarising the data. **There is a free course available to anyone living or working in the Tay Cities Region, with a focus on encouraging women to apply. This region covers the following areas - Angus, Dundee, North East Fife and Perth & Kinross. This will delivered on 4th and 5th March 2025 at Carnegie Conference Centre, Halbeath Campus, KY11 8DY.

Save to my Shortlist Save to shortlist Share Share

Certification:

College Certificated

Duration:

  • Two days
  • 9.30 am - 4.30 pm each day
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
  • Combining Data
  • Merging Data

Visualising Data

  • Overview of Visualisations
  • Choosing the right visual
  • Changing visuals
  • Sorting and formatting
  • Drilling down and filtering
  • Slicers

Modelling Data

  • What is DAX?
  • DAX Syntax
  • DAX Aggregate Functions
  • CALCULATE Function
  • Creating Measures
  • Debugging DAX Functions

Reports and Output Options

  • Report Elements and Options
  • Working with Pages
  • Refresh Data
  • Add Graphics and Text
  • Filter settings
  • Display for Mobile view
  • Performance – small files and fast calculations
  • Options for Sharing your data

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.