This 1 Day course builds on the skills gained from the Intro to Power BI course. Attendees will learn howto cleanse and manipulate data imported into Power BI using Power Query.  They will also work with DAX to create calculations and measures and how to use these to create beautifully customised dashboards and reports.

On completion of the course attendees will have cleansed data with Power Query, used Dax to analyse data and created advanced Power BI visualisations.

All attendees will receive useful course notes to refer to at any time and have a chance to engage in an informative Q &A on the day.

Prerequisites:

·        Attendees should have attended the Introduction to Power BI or are familiar with working with Power BI

·        PowerBI Desktop needs to be downloaded beforehand.

·        PowerBI Service is an add-on to an Office 365 license but can be accessed for a 60 day trial period here.

·        It is ESSENTIAL you ownlaptop/computer with the required software installed (Microsoft Excel 2013 orlater).

Course Content

Working With Data

 Power Query

·        Sorting and Filtering

·        Calculations

·        Splitting and Extracting

·        Handling Blanks, Errors, Duplicates

·        Getting Data from the Web

DAX Functions

·        Select Value

·        IF

·        Calculate

Bookmarks

·        Creating bookmarks

·        Working with the selection pane

·        Action Buttons

 Customising

·        Custom Visual Tooltips

·        Dynamic Titles and Conditional formatting

·        Adding Images

·        Create Groups

·        Create Hierarchies

Additional visuals

·        Word Cloud

·        Treemap

·        Funnel charts

·        Gauge Charts

Publishing

·        Creating Dashboards

·        Optimizing for Mobile

Exporting data to Excel

Who Should Attend

This PowerBI Intermediate course is applicable for people who have a basic knowledge of Power BI and want to further their skills and expertise to create fully customised interactive dashboards.  It is aimed at people wanting to explore the additional visualisation capability of Power BI and work with DAX to perform analysis on their data

Certification

On completion of this one-day training course, you will receive your Certificate of Attendance. Please note certificates are issued at the close of the training course to participants on completion of the course. Please check directly with your association or awarding body to see how many points they will award.

Cost

An ‘Early Bird’ discounted rate of €485 is currently available. This training course normal rate is €585. Places are limited and are allocated on a first come first served basis. PLEASE NOTE THE EARLY BIRD RATE CLOSES 3 WEEKS PRIOR TO COURSE DATE. The course cost includes all course documentation and certificate of attendance.