Microsoft Power BI Desktop Introduction | Live Instructor-led Course

Hey there! Join us for a fun and informative online session where we'll introduce you to Microsoft Power BI Desktop.

Unlock the Power of Data with Our Microsoft Power BI Desktop Introduction Course

Data is at the heart of modern business decision-making, and mastering it can give you a significant competitive edge. Join us for an empowering introduction to Microsoft Power BI Desktop, where you'll learn to turn data into actionable insights.

This beginner-friendly course is designed to guide you through the fundamentals of data visualisation, reporting, and business intelligence. Whether you're a business professional, analyst, or manager, this course will equip you with the tools you need to transform raw data into compelling visual stories that drive strategic decisions.

Enroll now and start your journey to becoming a data-driven leader in your field!

Course Aims:

On completion of this course, you will have learnt to use Power BI (Business Intelligence) Desktop to create report visuals. You will understand how the reports can interact with each other and the great level of interactivity the audience can use to drill, filter, sort and create simple calculations.

Course Pre-requisites:

Delegates who wish to attend this course must have an Intermediate knowledge of Excel or be competent at working with formulas using absolute cell references, use basic functions like Sum, Average, Count, be able to create a simple chart and use filters.

Course Objectives:

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

• Understand basic Power BI desktop concepts and features
• Connect to Excel data with Power BI desktop
• Be able to perform simple calculations using calculated columns
• Work with Power BI standard visuals
• Apply, remove, and edit conditional formatting to Table visuals

Course Content:

‍

Introduction and Objectives

Power BI Desktop Basics

• What is Power BI Desktop
• Getting started with Power BI Desktop
• Identify Report, Table and Model views
• Explanation of other tools available in Power BI

Getting Data

• Import an Excel file into Power BI

Working in Data View

• Sorting and Filtering data
• Formatting columns to currency, decimal places,and percentages

Calculations

• Create calculated column calculations in the data view using Addition,Subtraction, Division and Multiplication

‍

Working with Report Pages

• Rename, Insert, Move, Delete and Copy pages
• Format the page
• Inserting Text boxes and images

Working in Filters Pane

• Show and hide filters pane
• Filter on this page and on all pages

‍

Adding Visualisations to the Report Canvas

• Donut
• Pie
• Clustered Column and Bar Chart
• Slicers
• Card
• Table
• Matrix
• Line

Working with the Visuals

• Formatting, Editing, Moving, Copying and Deleting visuals
• Moving the fields around on the Visual
• Sorting data on the visuals
• Show data from the visual as a Table and as a Data point

‍

Conditional Formatting

• Applying and editing Conditional formatting to a Table visual
• Removing Conditional formatting

Hints and Tips

• Show and hide Gridlines

‍

Related Courses

• POWER BI DESKTOP INTERMEDIATE