Power BI Desktop Intermediate
€295for members
€395for non-members
09.30 – 16.30
1 Day
Online
Microsoft Power BI has been a game changer in terms of making data analysis, reporting and visualisation more accessible using native Microsoft Office products, eliminating the need to invest in proprietary third-party software and enabling everyone at every level in an organisation to make confident decisions using up-to-the-minute analytics.
See full course details Ask a questionThis 1-day course is designed as a follow-on from the Day 1 Introduction Course. This is a hands-on practical course using PowerBI Desktop. You will begin by exploring connections to Power BI and transforming your data in the PowerQuery Editor. You will learn how to Cleanse Data using a variety of Transform Tools and also how to merge/append and pivot your data. Users will gain an understanding of using Errors and how to manage and fix an error. You will also learn some DAX expressions and using Logical and Date Functions.
This course will cover a variety of Visuals such as composition, comparison and correlation charts, along with Cards, Slicers, Matrix & Tables and Gauge. Learn how to conditionally format and filter the Visuals and understand how the Visuals Interact with each other. This course concentrates on the PowerBI Desktop – we will not cover managing Dashboards in the Power BI Service but you will learn how to publish your report.
Power Query Editor
• Connect to Data Sources
• Applied Steps
• Use Transform Tools
• Split /Add Columns
• Working with Data Types
• Conditional & Custom Columns
Introduction to Errors
• Understanding Errors
• Cell and Step Errors
Pivot, Merge & Append
• Pivot and Unpivot Data
• Merging Tables
• Appending Tables
Filters & Interactions
• Bookmarks
• Filters
• Drill-down and Drill Through
• Hierarchies
• Sorting by different Columns
• Interactions
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
• Date Functions
Visuals
• Treemaps, Matrix & Tables
• Funnel Charts
• Q & A and Smart Narratives
• Conditional Formatting
• Logical Functions
• Calculate and Selected Value Functions
• create a Measure to be used in the Values Field of your Visuals
Publish Report to Power BI Service
• How to Publish a Report from the PowerBI Desktop to the Power BI Service
Analysts who want to learn how to use Power Query Editor and understand how to Cleanse Data, use DAX and apply further visuals such as Matrix, Treemaps, Gauge and more.
A working knowledge of Excel is recommended and an introductory level knowledge of Power BI is essential. Knowledge of relational databases and common functions would be advantageous but not necessary.
On completion of the course candidates will receive:
- CIF Power BI Desktop Intermediate CPD Certificate of Attendance
- 6 CPD Points
- Member Rate: €295.00
- Non-member Rate: €395.00
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.