Power BI Administration

• Understand the role and responsibilities of Power BI administrators.
• Navigate the Power BI admin portal.
• Configure Power BI tenant settings.
• Manage licensing and capacity.
• Create and manage Power BI workspaces.
• Manage users and workspace permissions.
• Monitor Power BI usage and auditing.
• Troubleshoot common Power BI issues.
• Configure gateways and data refresh schedules.
• Connect to on-premises and cloud data sources.
• Design efficient Power BI data models.
• Create and publish reports and dashboards.
• Implement role-based access control and row-level security.
• Manage content distribution, sharing, and workspace collaboration.

Day 1: Introduction to Power BI Administration

1. Understanding Power BI Administration

• Role and responsibilities of Power BI administrators
• Overview of Power BI service components
• Live Demonstration: Navigating the Power BI admin portal
• Lab: Setting up your Power BI tenant and configuring basic settings

2. Provisioning and Configuring Power BI Service

• Tenant settings and configuration
• Licensing and capacity management
• Workspace creation and management
• Live Demonstration: Configuring workspace permissions
• Lab: Creating workspaces and managing users

3. Monitoring and Troubleshooting

• Usage metrics and auditing
• Diagnosing issues and resolving common problems
• Handling service incidents
• Live Demonstration: Monitoring resource usage
• Lab: Troubleshooting common Power BI issues

Day 2: Data Sources, Connectivity, and Modeling

4. Data Sources and Connectivity

• Connecting to on-premises and cloud data sources
• Gateway configuration
• Live Demonstration: Setting up data source connections
• Lab: Configuring gateways and data refresh schedules

5. Data Modeling in Power BI

• Creating relationships between tables
• DAX calculations and measures
• Performance optimization techniques
• Live Demonstration: Building a data model
• Lab: Designing efficient data models

Day 3: Reports, Dashboards, Security, and Collaboration

6. Creating Reports and Dashboards

• Building visuals using Power BI Desktop
• Publishing reports to the Power BI service
• Dashboard design best practices
• Live Demonstration: Designing interactive dashboards
• Lab: Creating a sample report and dashboard

7. Security and Permissions

• Role-based access control (RBAC)
• Row-level security (RLS)
• Data protection and compliance
• Live Demonstration: Designing interactive dashboards
• Lab: Creating a sample report and dashboard

8. Workspace Collaboration and Administration

• Collaborating within workspaces
• Content distribution and sharing
• Live Demonstration: Designing interactive dashboards
• Lab: Creating a sample report and dashboard

3 Days

Course Completion Certificate by Network Binary

• Set up a Power BI tenant and configure basic settings.
• Create Power BI workspaces and manage users.
• Configure workspace permissions.
• Monitor Power BI resource usage.
• Troubleshoot common Power BI issues.
• Configure gateways.
• Configure data refresh schedules.
• Design efficient Power BI data models.
• Build reports and dashboards.
• Publish reports to Power BI Service.
• Implement RBAC and RLS.
• Manage workspace collaboration and content sharing.

• IT professionals responsible for Power BI deployment and management.
• Data analysts seeking to enhance their administration skills.
• Business users interested in understanding the administrative aspects of Power BI.

No prerequisites