Course Outline - Microsoft Teams for End Users

    Microsoft Power BI Introduction

    Course Duration: One Day

    Target Audience:

    Aimed at experienced Microsoft Excel users who wish to use the Power BI interface to create their own reports and dashboards.

    Course Objectives:

    To develop a good working knowledge of Power BI which will enable participants to create interactive visualizations and business intelligence capabilities within their own organisations.

    Course Outline:

    Introduction to Power BI

    • Introducing Power BI
    • The Power BI Analytics Service
    • Creating a Power BI Dashboard

    Using Power BI

    • Using Excel as a Data Source for Power B
    • The Power BI Data Model
    • Databases as Data Source for Power B
    • Using the Power BI Analytics Service
    • Importing Data into Power BI
    • Getting Data
    • Data Structure for Q&A

    Shaping and Combining Data

    • Power BI Desktop Queries
    • Shaping Data
    • Combining Data

    Modelling Data

    • Introduction to Modelling
    • Setup and Manage Relationships
    • Cardinality and Cross Filtering
    • Default Summarization and Sort By
    • Creating a Calculated Column
    • Creating Quick Measures
    • Simple Calculations and Measurements

    Interactive Data Visualizations

    • Creating Visualisations
    • Setting Sort Order
    • Slicers, Timeline Slicers and Sync Slicers
    • Cross Filtering and Highlighting
    • Visual, Page and Report Level Filters
    • Drill Down and Drill Up
    • Hierarchies

    Power BI Desktop Visualizations

    • Tables, Matrices and Charts
    • Simple Map Visualization
    • Colour Formatting
    • Tooltips

    Publishing and Sharing

    • Sharing Options Overview
    • Publish from Power BI Desktop
    • Publish to Web
    • Share Dashboard with Power BI Service
    • Print or Save as PDF
    • Export Data from a Visualization
    • Publishing for Mobile Apps
    • Export to PowerPoint

    Direct Connectivity

    • Cloud Data
    • Connecting to Analysis Services

    Developer API

    • Using the Developer API

    Power BI Mobile App

    • Introduction to the Power BI Mobile App
    • Using the Power BI Mobile App
    • Power BI Embedded

    Course Summary and Review

    • Recap of Topics Covered
    • Question Time
    View Schedule
    Contact Us