Course Duration
2 Days

Microsoft
Authorized Training

IT

Course cost:
was £1,725
£1,232

IT Certification Overview

This course will provide you with the basic knowledge and skills to import / ingest data, create a model and create visualisations using Power BI Desktop.

Newto Training Reviews

What Our Happy Alumni Say About Us

Prerequisites

  • Basic understanding of data concepts, such as tables, spreadsheets, and common visualization types.
  • Familiarity with basic statistical concepts, such as averages and sums.
  • Some experience with Excel functions like pivot tables, charts, and formulas is advantageous.
  • Ability to navigate and use software applications comfortably.
  • Familiarity with Power BI Desktop is beneficial but not mandatory.

Target audience

Anyone who will be creating Power BI Desktop semantic models and reports.

The course is aimed at both non-technical 'power users' and IT Professionals who will be creating semantic models and reports.

v

Learning Objectives

By the end of this course, learners will be able to:

  • Import and Ingest Data: Connect to various data sources, including CSV files, Excel spreadsheets, and SQL Databases, and import data into Power BI Desktop.
  • Transform Data: Utilize the Power Query Editor to cleanse and transform imported data, such as removing unnecessary columns and rows, normalizing datasets, and merging data.
  • Model Data: Enhance data models by managing relationships, customizing fields, creating calculations, and establishing hierarchies to facilitate accurate data analysis.
  • Create Visualisations: Develop interactive reports and dashboards by adding various visual elements, including tables, charts, maps, slicers, and custom tooltips, to effectively provide data insights.

Power BI Desktop for Technical Users Course Content

Module 1: Introduction to Power BI

  • Overview of the processes involved in creating a Power BI report.

Module 2: Accessing data

  • Importing source data from flat files
  • Connecting to Microsoft SQL Server

Module 3: Transforming data in Power Query

  • Applied steps
  • Naming rules
  • Reducing the dataset
  • Working with columns
  • Calculated columns
  • Changing the structure of data
  • Merging and appending datasets

Module 4: Modelling data

  • Relationships
  • Enhancing columns
  • Sorting data
  • Formatting data
  • Data categories
  • Default summarization
  • Hiding fields and queries
  • Data groups
  • Hierarchies
  • Calculations using DAX
  • Default context filters
  • Aggregation
  • Calculations with filters
  • Logical functions
  • Filter information
  • Relational functions
  • Time intelligence

Module 5: Visualization

  • Report design layout
  • Report design
  • Built-in, code, and custom visualizations
  • Visual interactions
  • Decoration
  • Tabular and textual visualizations
  • Charts and graphics
  • Maps
  • Slicers
  • Custom page tooltips

Exams and assessments

There are no formal exams included in this course.

Hands-on learning

This course includes:

  • Hands-on labs to apply key concepts in a real-world environment.

Power BI Desktop for Technical Users Dates

Next 4 available training dates for this course

OFFER!

VIRTUAL

QA On-Line Virtual Centre
2 DAYS | ALL DAY
Thu 04 Jun 2026
AVAILABLE
was £1,725
£1,232
BOOK NOW
OFFER!

VIRTUAL

QA On-Line Virtual Centre
2 DAYS | ALL DAY
Mon 03 Aug 2026
AVAILABLE
was £1,725
£1,232
BOOK NOW
OFFER!

VIRTUAL

QA On-Line Virtual Centre
2 DAYS | ALL DAY
Thu 01 Oct 2026
AVAILABLE
was £1,725
£1,232
BOOK NOW
OFFER!

VIRTUAL

QA On-Line Virtual Centre
2 DAYS | ALL DAY
Mon 07 Dec 2026
AVAILABLE
was £1,725
£1,232
BOOK NOW

Advance Your Career with Power BI Desktop for Technical Users

Gain the skills you need to succeed. Enrol in Power BI Desktop for Technical Users with Newto Training today.