Course Catalog  > Data & Databases  > Data Visualization  > Power BI
WA3313

Power BI for Administrators Training

This course covers Power BI administration-oriented topics related to Pro and Premium capacity features.
Request Information
Request On-Site or Customized Course Info
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