Back to all courses

Microsoft Power BI Desktop Intermediate

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, visualise and discover what is important, and share that with anyone or everyone you want.This course is aimed at those who want to expand on their knowledge of Power BI Desktop through data visualisation, DAX and data and report management.

Save to my Shortlist Save to shortlist Share Share

Certification:

College Certificated

Duration:

  • 2 days
  • 9.30 am - 4.30 pm
Enquire now

Who is this course for?

This course is for those who have completed the Introduction to Power BI desktop course and wish to widen their proficiency.

What qualifications will I gain?

Fife College Certificate of Attendance

What will I learn on the course?

You will complete the below outcomes.

Themes

  • Apply a theme to a report
  • Create a custom theme
  • Create a template with a theme and standard pages

Visualising Data

  • Additional Visuals
  • Hierarchies
  • Format Pane
  • Conditional Formatting
  • Sparklines
  • Edit Interactions

Further DAX

  • What if Analysis using DAX logic
  • Time Intelligence Functions
  • Quick measures
  • Debugging DAX Functions
  • Using Variables
  • Formatting DAX measures
  • SUMX Function

Data Management

  • Import vs Direct Query
  • Setting up a Schema
  • Creating a single set of values
  • Different ways to create a Date Table
  • Measures v Calculated Columns
  • Publish Reports with Power BI Service (requires Power BI service licence)
  • Implementing Row Level Security
  • Define roles and rules
  • Publish report to Power BI Service
  • Create Dashboards
  • Add tiles to Dashboards
  • Add other data to a Dashboard
  • Using Insights
  • Sharing Dashboards

Report Management (requires Power BI service licence)

  • Implementing Row Level Security
  • Define roles and rules
  • Manage security in Power BI Service

Application Information

What further course options are available?

  • Microsoft Power BI Desktop Advanced

Please explore our range of training courses available on our website.

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.

Related courses

View 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.