category icon Data & AI, Productivity & Collaboration, Webinar

(Course fee €50.00)
Power BI is Microsoft’s most popular Power App. Data is the world’s most valuable resource and Power BI is a tool that helps your customers make sense of all the data their business generates – from customers, products, suppliers, and partners. In this Advanced course, we will teach you all you need to learn to sell Power BI. It is a prerequisite that you have built a Power BI Dashboard in advance. Please follow the self learning labs posted in the Dashboard in a Day Material in advance at this location


Learn how to: Power Query – Clean and Transform Data

Advanced Query Functionality, Append Queries, Merge Queries, UnPivot Data, Introduction to the “M” Query Language, Web Queries, Understand Direct Query vs Import


Data Model and DAX Calculations

Table Relationships, Custom Sort, Field Grouping: Managing Hierarchies, Groups and Bins, Calculated Columns (Related Data and Custom Columns – DAX), Aggregation Measures (DAX), Create Date Table (DAX Calendar Table), Time Intelligence Measures (DAX), Custom Text Measures for Titles / Key Indicators (DAX), Other DAX Functions for custom aggregation


Advanced Visualisations

Custom Themes (Colour Schemes), Conditional Formatting, Custom Tooltip Visuals, Custom Visuals, Bookmarks (“storytelling”), Other Visual Objects: Text Box, Shape, Image, Button, New Features and Preview/Optional Features


Power BI Service and Dashboards

Dashboards, Workspaces (for Sharing/Collaboration), Scheduled Refresh


Please register with your business email. This webinar is for MicroWarehouse trading CSP customers.

This course is now full. Please contact [email protected] to be added to the waiting list.