Date and Time

7th April 2025

9:30am to 4:30pm

Programme Structure:

This course is virtually delivered via Zoom Virtual Classroom.

Programme Aim:

This course is designed to Introduce participants to the Power BI Desktop, covering the essential skills necessary to create and save interactive Visual reports. The course is ideal for those who work with large amounts of data, who need an introduction to Power BI from beginner level. It will cover key areas such as connecting to Data, introducing the Data Model and how to shape your data, how to build relationships, use Many to One Relationships, apply common DAX formula and functions and finally visualize your data with interactive reports, all within the Power BI Desktop.

Programme Objectives:

At the end of this course, participants will be able to create visually pleasing and informative reports using the Power BI Desktop. You will learn how to load raw data into the Power Query and Transform the same data into a Visual Report in Power BI. This course will cover a selection of Visuals such as composition, comparison and correlation, along with Cards, Slicers and Tables. You will also learn how to run Data Cleansing and apply common DAX formula covering some basic calculations and functions.

Prerequisites:

Participants should have a working knowledge of Excel and common Functions. Knowledge of Relational Database concepts would be advantageous. No prior knowledge of creating charts is required. An understanding of the need to process your information visually

Programme Outline:

What is Power BI?

• The Elements of Power BI
• Exploring the Power BI Desktop
• Importing Data Sources

Importing and Connecting to Data Sources

• Connecting to a Data Source in Excel / CSV Files

Transform and Shaping data

• Introduction to the Power Query Editor
• Data Types, Header Rows and Replace
• Values
• Remove Columns and Rows
• Splitting Columns
• Transforming Data – Number, Date and Text
• Specific Tools
• Adding Columns
• Applied Steps

Introduction to the Data Model & Relating Tables

• Introduction to the Data Model
• Create and Edit a Relationship
• Many to One Relationships

Visualising Data in a Report

• Create a Report in Power BI
• Use Visuals such as Column, Bar, Lineand Area Charts, Funnel, Cards,
• Tables and Matrix
• Customising Formats
• Using Slicers
• Editing Interactions between Visuals
• Filters
• Drill – Through Filters