logo
Home

Power BI Desktop for Technical Users

  • CMDBID 1246
  • Course Code QAPBIDESK
  • Duration 2 Days
Scroll

Microsoft PowerBI Course

course overview

download outline

Select Country and City to View dates & book now

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.

Target Audience

  • Anyone who will be creating Power BI Desktop models.
  • The course is aimed at both non-technical 'power users' and IT Professionals who will be creating models.

Please note - Delegates attending an Extended Classroom delivery will need access to a second monitor.

. Explore more Microsoft training here

Audience

IT professionals, system administrators, developers, analysts, architects and technical specialists responsible for implementing or supporting the technology covered in this course.

Skills Gained

By completing the Power BI Desktop for Technical Users QAPBIDESK course participants will gain practical knowledge, configuration skills, implementation techniques and best practice understanding relevant to real enterprise environments.

Prerequisites

No prior knowledge of Power BI Desktop is required, but knowledge of running queries in SQL Server would be useful

Outline

Module 1: Overview

This module provides essential background information Power BI Desktop such as connections with Power BI Service, Analysis Services and data warehouses.

Lab :

  • Installing Power BI Desktop

Module 2: Accessing data

This module describes the process of importing data into a Power BI Model. The sources used as demonstrations include CSV, Excel and Azure SQL Databases.

Lab :

  • Connecting to a live source
  • Importing Excel and CSV data

Module 3: Transforming Data

This module describes how you can transform the data from an imported source into a table. The module describes most of the options with the Power Query Editor and M language.

Lab :

  • Remove unwanted columns and rows
  • Cleansing data
  • Normalise datasets
  • Merging data
  • Importing multiple Excel files (M)

Module 4: Modelling Data

Once the data is imported into the model, the model can be enhanced by adding column and measure properties, calculations, hierarchies and relationships.

Lab :

  • Managing relationships
  • Customising fields view
  • Calculations

Module 5: Visualisation

This module how to create report pages using Power BI Desktop for consumption by others.

Lab :

  • Visualise tabular
  • Adding charts
  • Adding maps
  • Adding slicers
  • Drillthrough pages
  • Bookmarks, selections and buttons
  • Custom tooltips
. Explore more Microsoft training here

Certification

Some courses may support vendor certification exams or digital badges. Exam availability depends on the specific programme and vendor requirements.

What is the Power BI Desktop for Technical Users QAPBIDESK course about?

The Power BI Desktop for Technical Users QAPBIDESK course provides practical knowledge and skills used by professionals working with this technology or framework.

Who should attend the Power BI Desktop for Technical Users QAPBIDESK training course?

This course is designed for IT professionals, engineers, analysts, administrators and project teams who need hands-on knowledge.

Does the Power BI Desktop for Technical Users QAPBIDESK course include certification or an exam?

Many Power BI Desktop for Technical Users QAPBIDESK courses prepare participants for vendor certification exams or digital badges depending on the programme.

How can I enrol in the Power BI Desktop for Technical Users QAPBIDESK course?

Visit the course page or Explore more Microsoft training here

Talk to an expert

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. Its a cost effective option. One on one training can be delivered too, at reasonable rates.

Submit an enquiry from any page on this site and let us know you are interested in the requirements box, or simply mention it when we contact you.

All $ prices are in USD unless it’s a NZ or AU date

SPVC = Self Paced Virtual Class

LVC = Live Virtual Class

Please Note: All courses are availaible as Live Virtual Classes

Trusted by over 1/2 million students in 15 countries

Our clients have included prestigious national organisations such as Oxford University Press, multi-national private corporations such as JP Morgan and HSBC, as well as public sector institutions such as the Department of Defence and the Department of Health.