Live instructor-led training
Power BI Desktop for Technical Users
- CMDBID 1246
- Course Code MPBIDESK
- Duration 2 Days
Scroll
Course content
What you will learn
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 hereAudience
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
Certification
Some courses may support vendor certification exams or digital badges. Exam availability depends on the specific programme and vendor requirements.
Is Power BI Desktop for Technical Users QAPBIDESK right for me?
This course is for learners who want structured, expert-led training in professional development with practical workplace outcomes.
What will I learn on Power BI Desktop for Technical Users QAPBIDESK?
You will build practical professional development skills, understand key concepts and apply the course outcomes in real workplace scenarios.
Does Power BI Desktop for Technical Users QAPBIDESK include exam preparation?
Yes, this course supports certification or exam preparation where included in the selected delivery option.
What should I do after Power BI Desktop for Technical Users QAPBIDESK?
Compare related CourseMonster courses and follow-on pathways to choose the best next step for your role or team.
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.
