POWER BI

Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards. It is part of the Microsoft Power Platform.

Instructor Zybeak Technologies

Updated December 23, 2021

Overview
Curriculum
Instructor

CERTIFIED INFORMATION SYSTEMS AUDITOR

COURSE MODULES:

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
• 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: Power BI Service Visualization 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