Excel Level 6 BI Desktop Visualisations - 8/11/21 AM & 9/11/21 AM

A practical guide to using Desktop Power BI app to manipulate large data sets using DAX formulas, measures and calculated columns in Power Query.

Once data is in the correct format we will create Relationships to join tables from different sources and use this data to create interactive visualisations which may be published to the web and shared with colleagues.

Prepare Reports for import
Import files
Importing text files
Creating DAX formulas
=RELATED
Calculated columns
Fields for slicers
Creating Measures
Visualisations
Using Slicers to view data

Delegates MUST have completed our Excel Levels 1 - 4 courses or provide evidence that they are already competent to this level to book onto this course. The earlier courses provide foundations for the techniques we teach on this training event.

Delegates should be confident about their Excel skills before joining this class.

Delivery: Online (live)
Level: Expert
Certification:
Exam Required
Voucher Incuded
Accredited
Guaranteed Pass
Practice test
On-site exam
Course Dates : 8/11/21 AM & 9/11/21 AM
Day & Time:
Week Days
Weekend
Daytime
Evening
What is included:
VAT
Breakfast
Lunch
Refreshments
Digital courseware
Digital Recording
Printed courseware
Accommodation
Extra revision sessions
Training Instructor accredited by: Microsoft (MCT)
Style:
Authoritative
Challenging
Inspiring
Methodical
Starts: November 2021
Duration: 1 day or less

Public discussion (0)

You must log in to send a new comment.