Introduction to Power BI Desktop

Price
395 per participant
Earn 12 CPD points for this course.
Book Now

€395for members

€495for non-members

09.30 – 16.30

2 Days

Online

This 2 day course is designed to Introduce users to the PowerBI Desktop, covering the essential skills you need to create and save interactive Visual reports. The course is aimed at data analysts, 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 PowerBI Desktop.

See full course details Ask a question

This 2 day course is designed to Introduce users to the PowerBI Desktop, covering the essential skills you need to create and save interactive Visual reports. The course is aimed at data analysts, 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 PowerBI Desktop.

By the end of this course, delegates should be able to create Visually pleasing and informative Reports using the PowerBI Desktop. You will learn how to load raw data into the Power Query and Transform the same data into a Visual Report in PowerBI. 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.

The is a 2 Day Programme delivered from 09.30hrs – 16.30hrs.

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
• Data Groups and Group BY
• Add Conditional & Index Columns
• Applied Steps

Introduction to the Data Model & Relating Tables
• Introduction to the Data Model
• Create and Edit a Relationship
• Many to One Relationships
• Filter Flow Introduction to DAX
• Introduction to DAX Syntax
• Add a Calculated Column to a Dataset
• Using Count and Distinct Count Functions
• Create a Measure to be used in the Values Field of your Visuals

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

Publish Report to Power BI Service
• Overview on Publishing a Report to the Power BI Service
• Add Tiles to a Dashboard
• Q&A Question Box

On completion of the course candidates will receive:

  • CIF Power BI Essentials CPD Certificate of Attendance
  • 6 CPD Points
  • Member Rate: €395.00
  • Non-member Rate: €495.00

For All Enquiries or Course Bookings Contact:

Conor Greham: 01 4066031 / [email protected]

The CIF can deliver this programme in house and may be tailored to your companies requirements.

In terms of programme delivery, the CIF can facilitate learning by virtual means (online via Zoom), or in classroom format (at your premises), subject to criteria. Please get in touch to discuss your requirements.

Need help or have a question?

Send us a message and we will be back to you as soon as possible.


See full course details

Booking information

Please inform the details for your booking.

Clear
Number of Participants:
This field can't be Empty
This field can't be Empty
Email field can't be Empty