Back to all courses

Microsoft Power BI Desktop Introduction

Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data might be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources, visualize and discover what's important, and share that with anyone or everyone you want.It is aimed at those who want to examine large amounts of related data and produce reports summarising the data.

Course information

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.