Introduction to Microsoft Power BI

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).

‍

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 -Visualizations

• 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

‍

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

‍

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.