WA3313
Power BI for Administrators Training
This course covers Power BI administration-oriented topics related to Pro and Premium capacity features.
Course Details
Duration
2 days
Skills Gained
- Work with workspaces
- Create reusable artifacts with datasets, dataflows, and Datamarts
- Secure Power BI artifacts
- Perform tuning with performance analyzer, aggregations, hybrid & 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 with Power BI Apps and embedding in SharePoint/Web portals.
- Administer Power BI using PowerShell and Power BI CLI tools.
Course Outline
- Managing Workspaces
- Creating workspaces
- Understanding 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
Upcoming Course Dates