Ayrshire College homepage
Back to all courses

Microsoft Power BI - Connect & Present your Data

This course isn’t currently open for applications, but you can still register your interest.

  • Qualifications Other Programmes
  • SCQF Level SCQF Level 5
  • Study mode Professional Learning
  • Campus Ayr
  • Start date August 2025
More information

Attendance / Duration

1 Day (9:00am - 4:00pm)

Overview

On this 1 day course you learn how to create professional reports, perform data analysis, and effectively communicate insights using Microsoft Power BI Desktop.

Cost

£180

Enquiry

For further information or to be added to our waiting list for future course dates please email engage@ayrshire.ac.uk

What's Involved?

Power BI desktop enables you to take raw data from a data source, transform it into usable data and utilise it to make reports and informative graphics for data analysis. Information can be visualised through charts, graphs, KPIs, maps, etc. to gain valuable insights.

This course will use Power BI Desktop and not the Power BI Service. Power BI Desktop is a free application it includes tools for data visualisation, data preparation, data modelling, data cleansing and publishing reports to the Power BI Service.

Please Note: This course is suitable for those with an advanced knowledge of Excel. It is not suitable for those at beginner or intermediate level.

Prior to attending the course participants using their own device should ensure that they have Power BI desktop installed.

Course Content

This course will cover the following:

  • Navigating the Power BI desktop interface
  • Connecting to data sources
  • Transforming data prior to loading into Power BI Desktop
  • Creating a report with visualisations
  • Customising visualisations
  • Creating relationships between data tables
  • Using DAX expressions to create calculated columns and measures

By the end of this course participants will be equipped with the necessary skills to create professional reports, perform data analysis, and effectively communicate insights using Microsoft Power BI Desktop.