Microsoft Power BI (business intelligence) is a powerful analytics tool that helps companies of all sizes analyse data and share insights.

This 1 Day course is an introduction to Microsoft Power BI and covers the essential skills needed to use the Power BI Desktop. On completion of this course, you will have a better understanding of how to connect to data sources, how to create dashboards, format visuals and how to edit interactions between visuals. You will learn more of the relationship between data, using AI visuals, and how to publish and share reports.

All attendees will receive useful course notes to refer to at any time and have a chance to engage in an informative Q&A on the day.

Course Content

Power BI Introduction

• Overview of Power BI
• Understanding the Power BI Environment

Connecting to Data Sources

• Connecting to Data Sources
• Loading Data to the Power BI Desktop

The Power BI Desktop - Visualisations

• Add Column, Pie, Bar, Line and Area Charts, Maps and Cards to the Canvas
• Formatting Visuals
• Create Slicers
• Editing Interactions between Visuals
• Filtering Visuals and Reports

Relationships / Data Model

• Introduction to the Data Model
• An overview of relationships

Additional Tools

• Using AI Visuals
• Customising Tooltips
• Using Drill Through

DAX

• Introduction to DAX Syntax
• Use basic Dax formula to create a new calculated column
• Create a measure

Share a Report

• Publishing a report
• Creating a Dashboard
• Design Principles

Prerequisites

• Attendees should have a solid Excel foundation e.g. be familiar with vlookups/pivot tables.

• PowerBI Desktop needs to be downloaded beforehand. It can be downloaded here

• PowerBI Service is an add-on to an Office 365 licence but can be accessed for a 60 day trial period here. You can get more information about this here

• It is ESSENTIAL you own laptop/computer with the required software installed (Microsoft Excel 2013 or later).

• Two Screens (ideally)

Who Should Attend

This Power BI course is applicable for people who want to understand how to use the Power BI tools and create customized visual reports. It is also suitable for BI and reporting professionals, data analysts, and professionals working with data in any sector.

Certification

On completion of this one-day training course, you will receive your Certificate of Attendance. Please note certificates are issued at the close of the training course to participants on completion of the course.

This course may qualify for CPD points. Please check directly with your association or awarding body to see how many points they will award.

Cost

An ‘Early Bird’ discounted rate of €485 is currently available. This training course normal rate is €585. Places are limited and are allocated on a first come first served basis. PLEASE NOTE THE EARLY BIRD RATE CLOSES 3 WEEKS PRIOR TO COURSE DATE. The course cost includes all course documentation and Certificate of Attendance.

Feedback from previous dates

"A really comprehensive course, well delivered" - Patricia Lawe, Teagasc

"First time using Power BI and found it all very beneficial and informative for my job role" - Hope Fleming Sweeney, Lakeland Dairies