microsoft partner logo color
8293  Reviews star_rate star_rate star_rate star_rate star_half

Power BI for Administrators

This course covers Power BI administration-oriented topics related to Pro and Premium capacity features. Skills Gained Work with workspaces Create reusable artifacts with datasets, dataflows, and...

Read More
By Request
$1,395 USD
Duration 2 days
Course Code WA3313
Available Formats Classroom

Overview

This course covers Power BI administration-oriented topics related to Pro and Premium capacity features.

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 Details

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
Read Less

Schedule

Upcoming Course Dates

There are currently no scheduled dates for this course. If you are interested in this course, contact us with the form below.

Contact Information
Address

FAQ

How do I get a Microsoft exam voucher?

Pearson Vue Exam vouchers can be requested and ordered with your course purchase or can be ordered separately by clicking here.

  • Vouchers are non-refundable and non-returnable. Vouchers expire 12 months from the date they are issued unless otherwise specified in the terms and conditions.
  • Voucher expiration dates cannot be extended. The exam must be taken by the expiration date printed on the voucher.

Do Microsoft courses come with post lab access?

Most Microsoft official courses will include post-lab access ranging from 30 to 180 calendar days after instructor led course delivery. A lab training key in class will be provided that can be leveraged to continue connecting to a remote lab environment for the individual course attendee.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour-long after 3-3.5 hours of the class day.

What languages are used to deliver training?

Microsoft courses are conducted in English unless otherwise specified.

Reviews

The course was informative, and I learnt a new skill. The instructor was up to the point.

Good training. A lot to take in for the short amount of time we have though

This was effective way to provide a ton of information in a short time period.

Course was great and the instructor had an answer for anything that was asked during the course.

vary good online learning. instructor is vary good the way he explained every thing.