Power BI Administration Training Overview
This Power BI for Administrators training course teaches attendees how to use the administrative features of Pro and Premium Power BI. Participants learn how to manage workspaces, create reusable artifacts, share reports, implement security, use CLI tools like PowerShell, and more.
Location and Pricing
Accelebrate offers instructor-led enterprise training for groups of 3 or more online or at your site. Most Accelebrate classes can be flexibly scheduled for your group, including delivery in half-day segments across a week or set of weeks. To receive a customized proposal and price quote for private corporate training on-site or online, please contact us.
In addition, some courses are available as live, instructor-led training from one of our partners.
Objectives
- Manage workspaces
- Create reusable artifacts with datasets, dataflows, and Datamarts
- Secure Power BI artifacts
- Implement performance tuning with performance analyzer, aggregations, hybrid, and dual store
- Connect to on-premises environment using Power BI Data Gateway
- Create Deployment Pipeline to implement dev, test, and prod environments
- Share reports and dashboards by using Power BI apps and embedding them in SharePoint/Web portals
- Administer Power BI using PowerShell and Power BI CLI tools
Prerequisites
All students must have some experience with Power BI.
Outline
Expand All | Collapse All
Managing Workspaces
- Creating workspaces
- Understanding the differences between Pro and Premium
- Understanding the differences between Power BI Desktop and Power BI Online report creation
- View usage metrics
- View lineage
Creating Reusable Artifacts using Datasets, Dataflows, and Datamarts
- Understanding Datasets
- Understanding Dataflows
- Understanding Datamarts
- Deciding when to use datasets, dataflows, and datamarts
- Configuring Endorsement and Sensitivity
Security
- Configuring permissions in Workspace
- Working with Row-level Security (RLS)
- Working with Object-level Security (OLS)
Performance Tuning
- Using Performance Analyzer
- Using Storage Modes: DirectQuery, Import, and Composite/Hybrid modes
- Using Aggregations
Integrating with On-Prem Data
- Configuring Power BI Data Gateway
- Connecting to on-prem SQL Server and File Share
Deployment Pipeline
- Understanding Deployment Pipeline
- Managing multiple environments, e.g., Dev, Test, and Prod
- Implementing Power BI Lifecycle using Deployment Pipelines
- Configuring security in environments
Sharing Power BI Reports
- Apps in Power BI
- Configuring the navigation structure/sitemap
- Publishing to Web
- Embed and link in Portals (SharePoint)
- Configuring security in Apps
Power BI Administration Using the CLI Tools
- Using PowerShell to administer Power BI
- Using Power BI CLI to interact with Power BI Service
- Using PowerShell and Power BI CLI to implement commonly used scenarios
- List all workspaces and artifacts
- List permissions for all users
- List My Workspaces, artifacts in each My Workspace, and delete artifacts
- List AD Group details for users
Conclusion
Training Materials
All Power BI Admin training students receive comprehensive courseware.
Software Requirements
- A recent version of Windows (Windows 10 or later) with at least 8 GB of RAM
- Microsoft Office installed (especially Excel)
- Power BI Desktop installed
- PowerShell installed with permissions to install different modules
