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 On-demand
More information

Attendance / Duration

2 Days (9:30am - 4:30pm)

Overview

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

Cost

£360

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.

Course Content

This course will cover the following:

  • Navigating the Power BI Desktop interface
  • Importing and cleaning data using Power Query
  • Creating interactive reports with the use of visuals
  • Customising visualisations
  • Combining data with the use of append and merge queries
  • Creating data models and building relationships between tables
  • Using drill down, filtering and hierarchies to analyse data
  • Using DAX Measures to create calculations to summarise your data

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.