Power BI

Power BI
Course Outline:



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
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
  • Direct Query 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 Visualizations
  • Creating Visualizations
  • 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
  • Drill through
  • Custom Report Themes
  • Grouping and Binning
  • Selection Pane, Bookmarks & Buttons
  • Recap and What's Next
Module 5: Publishing and Sharing
  • Introduction
  • Sharing Options Overview
  • Publish from Power BI Desktop
  • 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 6: Refreshing Datasets
  • Understanding Data Refresh
  • Replacing a Dataset
  • Troubleshooting Refreshing
Module 7: 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