MicroSoft Power BI

Reading Time: 2 minutes

MicroSoft Power BI

    Module 1: Quick Start Power BI Service

    • Get Power BI Tools
    • Introduction to Tools and Terminology
    • Dashboard in Minutes
    • Refreshing Power BI Service Data
    • Interacting with your Dashboards
    • Sharing Dashboards and Reports
    • Recap and What’s Next

    Module 2: Getting and Transforming Data with Power BI Desktop

    • Introduction to Power BI Desktop
    • Getting Data: Excel vs Power BI Desktop & Service
    • Data Structure for Q&A
    • DirectQuery vs Import Data
    • Recap and What’s Next

    Module 3: Modeling with Power BI

    • Introduction to Modeling
    • Setup and Manage Relationships
    • Cardinality and Cross Filtering
    • Default Summarization & Sort by
    • Creating Calculated Columns
    • Creating Measures & Quick Measures
    • Recap and What’s Next

    Module 4: Power BI Desktop Visualisations

    • Creating Visualisations
    • Color Formatting
    • Setting Sort Order
    • Scatter & Bubble Charts & Play Axis
    • Tooltips
    • Slicers, Timeline Slicers & Sync Slicers
    • Cross Filtering and Highlighting
    • Visual, Page and Report Level Filters
    • Drill Down/Up
    • Hierarchies
    • Reference/Constant Lines
    • Tables, Matrices & Conditional Formatting
    • KPI’s, Cards & Gauges
    • Map Visualizations
    • Custom Visuals
    • Managing and Arranging
    • Drillthrough
    • Custom Report Themes
    • Grouping and Binning
    • Selection Pane, Bookmarks & Buttons
    • Recap and What’s Next

    Module 5: Power BI Service Visualisation Tools

    • Introduction
    • Standalone Tiles
    • Data Driven Alerts
    • Quick and Related Insights
    • Custom Q&A questions

    Module 6: Publishing and Sharing

    • Introduction
    • Sharing Options Overview
    • Publish from Power BI Desktop x
    • Publish to Web
    • Share Dashboard with Power BI Service
    • Workspaces and Apps (Power BI Pro)
    • Content Packs (Power BI Pro)
    • Print or Save as PDF
    • Row Level Security (Power BI Pro)
    • Export Data from a Visualization
    • Publishing for Mobile Apps
    • Export to PowerPoint
    • Sharing Options Summary

    Module 7: Refreshing Datasets

    • Understanding Data Refresh
    • Personal Gateway (Power BI Pro and 64-bit Windows)
    • Replacing a Dataset
    • Troubleshooting Refreshing

    Module 8: Power BI and Excel Together

    • Options for Publishing from Excel
    • Pin Excel Elements to Power BI
    • Connect to Data using Power BI Publisher/Analyze in Excel
    • Excel 2016 Publish: Upload and Export to Power BI
    • Sharing Published Excel Dashboards