Microsoft Power BI Essentials

Price
295 per participant
Earn 6 CPD points for this course.
Book Now

€295for members

€395for non-members

09.30 – 16.30

1 Day

Online

This 1 Day course covers the essential skills needed to begin using the PowerBI Desktop to produce Visual Reports and learn how to bring data into the Power Query Editor to transform into Power BI.

See full course details Ask a question

This course covers the essential skills needed to begin using the PowerBI Desktop to produce Visual Reports and learn how to bring data into the Power Query Editor to transform into Power BI. 

The course will give a good overview of Power BI Desktop and is aimed at beginner level with no need for previous experience.  You will learn how to bring your data from an Excel file or CSV File into the Power Query Editor and then load into Power BI while discussing the essentials of Data Cleansing.  You will learn some basic Dax formula along with an understanding of the Data Model.  By the end of this course you will have learnt how to create great visuals in Power BI such as Composition and Comparison Charts, along with Cards, Tables and Images.

The course is for beginners and will focus mainly on the PowerBI Desktop with some time spent also in the Power Query Editor. The emphasis will be on the Visuals in the Desktop and will simply touch on publishing to the PowerBI Service at the end of the day but all learning will be completed in the Desktop.

A Basic knowledge of Microsoft Office and Excel would be advantageous.

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

Power BI introduction
  • How does the Power BI Desktop work?
  • Understanding the Power BI Environment
  • The Elements of Power BI
Connecting to Data Sources
  • Connecting to Data Sources
  • Loading Data to the PowerBI Desktop
  • Transforming Data to the Power Query
  • Data Types, First Row Headers
  • Remove & Split Columns & Rows
Introduction to DAX
  • Introduction to DAX Syntax
  • Use basic Dax formula to create a new calculated column
The Power BI Desktop -Visualizations
  • Add Column, Pie, Bar, Line and Area Charts, Maps and Cards to the Canvas
  • Working with Fields
  • Formatting Visuals
  • Create Slicers
  • Editing Interactions between Visuals
  • Filtering Visuals and Reports
Overview of the Data Model
  • Introduction to the Data Model
  • An overview of Many to One relationship
Share a Report
  • Quick overview of Publishing a Report to the Power BI Service

On completion of the course candidates will receive:

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

Upskill your employees with 4 Microsoft courses and receive a discounted rate. The courses include:

  • Excel Advanced
  • Data Visualisation for Excel
  • MS Project Management
  • Power BI

For All Enquiries or Course Bookings Contact:

Conor Greham: 01 4066031 / [email protected]

Robert Butler: 01 4066071 / [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