Highlights
- Secure, publish, and share data in Power BI
- Learn Share and use reports in Power BI
- Create and manage workspaces in Power BI
- Manage datasets in Power BI
- Integrate Power BI in Microsoft Teams and SharePoint
- Facilitate collaboration and sharing in Power BI
- Create and manage scalable Power BI dataflows
- Establish a data access infrastructure in Power BI
- Explore Microsoft Power BI cmdlets for Windows PowerShell and PowerShell core
- Explore REST API - Power BI service
-
Learn Microsoft Power BI cmdlets for Windows PowerShell and PowerShell core
Course Details
Secure, publish, and share data in Power BI
-
Share and use reports in Power BI
-
Row-level security
-
Publish a report to a Power BI workspace
-
Share reports and user experience
-
Protect data in Power BI
-
Data refresh and alerts
Create and manage workspaces in Power BI
-
Distribute a report or dashboard
-
Monitor usage and performance
-
Recommend a development life cycle strategy
-
Troubleshoot data by viewing its lineage
-
Configure data protection
Manage datasets in Power BI
-
Create dynamic reports with parameters
-
Create what-if parameters
-
Use a Power BI gateway to connect to on-premises data sources
-
Configure a dataset scheduled refresh
-
Configure incremental refresh settings
-
Manage and promote datasets
-
Troubleshoot service connectivity
-
Boost performance with query caching (Premium)
Integrate Power BI in Microsoft Teams and SharePoint
-
Power BI together with Microsoft Teams15 min
-
Power BI together with SharePoint Online5 min
-
Understand the Power BI administrator role
-
Power BI tools
-
Steward or captain?
-
Power BI administrator role
-
Typical administrative tasks
-
Typical administrator tools Establish a Power BI environment
-
User accounts versus guest accounts1 min
-
Power BI licensing4 min
Facilitate collaboration and sharing in Power BI
-
Workspaces evolved
-
Impact to Power BI users
-
Permissions in workspaces v2
-
Apps in Power BI
-
Share
-
Publish to web
-
Embed and link in portals
-
Data sensitivity labels
-
Data privacy Monitor and audit usage
• Usage metrics for dashboards and reports
-
Usage metrics for dashboards and reports - new version
-
Audit logs
Provision Premium capacity in Power BI - Premium resource management
Create and manage scalable Power BI dataflows
-
Define use cases for dataflows9 min
-
Create reusable assets5 min
-
Implement best practices3 min
Establish a data access infrastructure in Power BI
-
Personal gateways versus enterprise gateways
-
Download and install a gateway
-
How data is refreshed
-
Gateway network requirements
-
Where to install gateway?
-
Establish high availability gateways
-
Establish load balancing of gateways
-
Gateway performance monitoring documentation
-
Multiple data sources per gateway
-
Manage gateway users
-
Active Directory user mapping with custom property lookup1 min Broaden the reach of Power BI
-
REST API custom development
-
Provision a Power BI embedded capacity
-
Dataflow introduction
-
Dataflow explained
-
Create a Dataflow
-
Dataflow capabilities on Power BI Premium
-
Template apps - install packages
-
Template apps - installed entities
-
Template app governance
Automate Power BI administration
-
REST API - Power BI service
-
Microsoft Power BI cmdlets for Windows PowerShell and PowerShell core
-
Install and use the Power BI cmdlet
-
Test REST API calls
-
Script typical administrator tasks
Who should attend
This course is ideal for IT professionals, data administrators, and Power BI users who are responsible for managing and securing data in their organizations.
It is also suitable for team leaders and managers who oversee report distribution and collaboration within Power BI, as well as anyone looking to enhance their skills in Power BI administration, data management, and integration with other Microsoft services.
Feedback
4.8 out of 5 average
“Learning more about the query editor was very useful and especially the merge tables features. The Bookmarks section was very good and it was nice to see some really good examples of how it can be used to present your work."
AG, Business Analyst, Power BI Advanced, February 2021
Client feedback from Data Analytics training courses: