Course Outline - Microsoft Teams for End Users

    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