Skip to content
    Laptop Screen and Graduation Mortarboard Hat icon image

    Microsoft Power BI Advanced

    Microsoft Power BI Advanced​ Course Duration: One Day

    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:

    To develop a comprehensive knowledge of Power BI which will enable participants to create sophisticated interactive visualizations, reports and dashboards

    Course Outline:

    Review of Power BI Introduction

    • Building Interactive Data Visualizations

    More Powerful Desktop Visualizations

    • Conditional Formatting
    • KPIs, Cards and Gauges
    • Advanced Map Visualizations
    • Managing and Arranging Drill Through
    • Custom Report Themes
    • Selection Pane, Bookmarks and Buttons
    • Community-Sourced Visualizations
    • R Visualizations
    • Custom Visualizations

    Data Transformation Components

    • Using the First Row as a Header
    • Splitting the Field or Concatenate Fields
    • Replacing Null Value with Blanks
    • Grouping Data
    • Pivoting Columns
    • Formatting Columns

    Power BI Data Analysis Expressions

    • What is Data Analysis Expressions (DAX)?
    • How Power BI DAX Works:
    • - Syntax
    • - Context
    • - Functions
    • Calculated Columns and Measures:
    • - Calculated Columns
    • - Measures
    • - Calculated Columns vs. Measures
    • Types of Functions in Power BI DAX:
    • - Aggregate Functions
    • - Count Functions
    • - Date and Time Functions
    • - Mathematical Functions
    • - Logical Functions
    • - Text Functions
    • - Information Functions
    • Creating Measures using Power BI DAX

    Advanced Data Visualizations

    • Bar Charts and Column Charts
    • Line Charts and Area Charts
    • Pie Charts and Donut Charts
    • Combo Charts
    • Bubble Charts, Scatter Charts and Play Axis
    • Gauge Charts and Funnel Charts
    • Waterfall Charts
    • Reference Lines and Constant Lines
    • Quick Insights
    • Segmentation and Cohort Analysis

    Advanced Data Connecting and Shaping

    • DirectQuery
    • Data Fetching with the R Connector
    • Data Shaping in Power Query with R

    Advanced Analytics

    • R Integration
    • Quick Insights Feature
    • Segmentation and Cohort Analysis
    • Data Grouping and Binning

    Publishing and Sharing

    • Publishing to the Web
    • Sharing:
    • - Grant or Revoke access to colleagues
    • Create Workspaces (Power BI Pro):
    • - Public or Private Groups
    • - Edit or View only Groups
    • Create Apps (Power BI Pro):
    • - Entire Organization
    • - Specific Individual or Groups
    • Row Level Security (Power BI Pro)

    Templates and Content Packs

    • Creating Templates
    • Creating Content Packs

    Discussion and Question Time

    View Schedule
    Contact Us

    Contact us today to enquire about all our courses, classroom and virtual training options. Follow us on Facebook and LinkedIn for latest updates.

    Let’s talk! Fill out the form below and we’ll get back to you.