Sheaf Digital Training

Microsoft Power BI Courses


The start date for the course below is flexible - you choose when you want the course to run.

The course lasts for 1 day.

Microsoft Power BI - Working with DAX (Intermediate) SDPBI3

This is an intermediate level course that is more focused on DAX, the Power BI query/expression language. A good grasp of DAX is essential if you want to extend your data analysis skills and get maximum value from measures in Power BI.

Starts: Flexible start date

Duration: 1 day

Venue - To be arranged

Microsoft Power BI

#powerbi #dax #data #businessintelligence #datadashboards #training

Summary

This is an intermediate level course that is more focused on DAX, the Power BI query/expression language.

A good grasp of DAX is essential if you want to extend your data analysis skills and get maximum value from measures in Power BI.

The course is built around Power BI Desktop - you need your own copy (free from Microsoft). Like all our Power BI courses, we put a lot of emphasis on practical, hands-on activities in Power BI Desktop.

Course content includes:

  1. What is DAX?
  2. Functions in DAX
  3. Calculated Columns
  4. Measures (including Quick Measures)
  5. DAX Context - understanding row and filter context
  6. Writing DAX in Power BI

The course is designed so that you become confident in DAX.

Prerequisites

To get maximum value from the course you need to have reasonable MS Excel skills and have some experience with Microsoft Power BI Desktop. You should know how to:

  1. Import data tables from Excel
  2. Build basic reports with visualisations like slicers, line charts, bar and column charts and the matric chart.
  3. Enhance your data model with basic calculated columns and simple measures
  4. Export your report to the online Power BI service

It also helps if attendees do some thinking about the kinds of problems they would like to solve with Power BI. Course activities are more impactful when they can be linked to real life problems/examples.

Can I bespoke the course?

The best way to bespoke the course is to ask us to build around your own data. We can replace our own course sample data with some of your spreadsheets. That way at the course you have a working, fully interactive report built in Power BI Desktop that you can use and share with colleagues.

Online training requirements

You will need:

  • A good internet connection
  • Webcam & audio
  • MS Windows PC with Power BI Desktop (download is free from Microsoft).

Payment

We invoice for payment before the course starts.


Outcomes

At the end of the Microsoft Power BI - Working with DAX course you should be able to:

  1. Use DAX expressions to solve basic data analysis problems.
  2. Create measure formulas
  3. Know when to use functions like SUM, SUMX and CALCULATE
  4. Understand why context is important in DAX - the difference between row context and filter context.
Fees:
£550.00
-
Full cost, first delegate for 1 day (ex VAT)
£75.00
-
Each additional delegate (ex VAT)



Find out more about this course.
Tell Your Friends