Microsoft Power BI Desktop Intermediate | Live Instructor-led Course

Take your skills to the next level with our Microsoft Power BI Desktop Intermediate course.

Welcome to the Microsoft Power BI Desktop Intermediate | Live Instructor-led Course!

Are you ready to take your Power BI skills to the next level? Join us for this online event starting on Mon Mar 31 2025 at 09:30 AM BST. Our expert instructors will guide you through advanced techniques and features in Power BI Desktop, helping you become a pro at creating insightful data visualizations and reports.

During this course, you will learn how to work with complex data sets, create interactive dashboards, and utilize advanced functions to analyze your data effectively. Whether you're a business professional, data analyst, or IT specialist, this course is perfect for anyone looking to enhance their Power BI skills.

Don't miss out on this opportunity to expand your knowledge and excel in Power BI! Sign up now and take your data analysis skills to the next level.

Course Aims:

This Microsoft Power BI Desktop Intermediate training course is aimed at anyone looking to use this powerful, flexible, and accessible business intelligence tool to connect with and shape / transform data, build models, use DAX functions, and craft structured report visuals,which can then be shared with users.

‍

Course Pre-requisites

Delegates should have attended the Introduction course or have previously use Power Bi and created and formatted Report Visuals.

‍

Course Objectives:

On completion of this course, delegates will be able to:

• Import data into Power BI using Excel and CSV files
• Transform Data in Power Query Editor
• Working with themes
• Create relationships between the tables
• Create Formulas using DAX Functions
• Build Report Visuals

‍

Course Content:

‍

Importing Data Sources

• Excel and CSV

Power BI Query Editor (PQE)

• Explain the PQE Interface
• Extract and Load data
• Shape and Transform Data e.g. Rename, Reorder and Remove columns
• Change Data Types
• Remove and Filter Rows
• Merge Columns
• Replacing values
• Formatting text e.g. Uppercase,Lowercase and First letter Capital
• Remove and replace top row
• Applied Steps (Delete)

Data Modelling

• Creating, editing and detecting relationships
• One to Many relationships

Themes

• What is a Theme?
• How to edit and save themes
• How to reuse saved themes

‍

Power BI Visualisations

• Adding visuals to Report Canvas e.g.,Slicer, Multi Card, KPI, Matrix, Gauge, Map, Q&A
• Use Small Multiples on Visuals
• Use of Hierarchies
• Adding further analysis to the Visual

‍

‍Introducing Data Analysis Expressions (DAX)

• Create Formulas using Calculated columns and Measures e.g.
• Aggregation and iteration Functions (SUM, COUNT, MIN, MAX, AVERAGE, COUNTROWS, DISTINCTCOUNT)
• Text Functions (LEFT, UPPER, LOWER, CONCATENATE)
• Logical Functions (IF, NESTED IFS)
• Filter Functions (CALCULATE)
• Math and Trig Functions (DIVIDE, FORMAT)
• Date Functions (TODAY, WEEKDAY)
• Zoom in / out of calculations
• Adding comments to calculations
• Indenting calculations

Advanced Conditional Formatting

• Applying and Editing Conditional Formatting rules to visuals
• Applying and removing Data bars

‍

Working with Report Pages

• Working with buttons and Page Navigation

‍

Hints and Tips

• Working with Bookmarks
• Applying Data Category properties to columns
• Synchronize Slicers