Microsoft Power BI

    Power BI Topic 8: Advanced Data Transformations, Analytics & Publishing

    Course Duration: 90 Minutes

    Target Audience:

    Aimed at experienced Microsoft Power BI users who wish to use more advanced features and functions to create reports and dashboards.

    Course Objectives:

    Power BI is a Microsoft product that allows for the creation of powerful, interactive visualizations using business intelligence. This session will show how to use the more advanced data transformations, analytics & publishing features.

    Course Outline:

    Course Introduction

    Data Transformation Components

    • Using the First Row as a Header
    • Splitting a Column and Concatenating Columns
    • Replacing Null Values with Blanks
    • Grouping Data
    • Pivoting Columns and Formatting Columns
    • Creating Conditional Columns

    Data Transformation Components

    • Creating Power BI Templates
    • Using Power BI Content Packs

    Advanced Analytics

    • Data Grouping and Binning
    • The Get Insights Feature
    • Segmentation and Cohort Analysis

    Publishing and Sharing

    • Publishing to the Cloud
    • Sharing - Granting and Revoking Access
    • Creating Workspaces - Public or Private Groups
    • Creating Workspaces - Edit or View-Only Groups
    • Creating Apps

    Discussion and Question Time

    View Schedule
    Contact Us