Course Objective

At the end of this course, you will be able to:

  • Plan Power BI Projects with organizational goals in mind
  • Incorporate DAX for deeper analysis
  • Model and transform data
  • Create a Deployment Strategy
  • Integrate with Azure DevOps for CI/CD
  • Determine and apply role-based security
  • Administer Power BI to an organization
  • Build custom dashboards using Power BI Desktop

 

Course Outline

Planning Power BI Projects

  • Power BI deployment modes
  • Project discovery and ingestion
  • Power BI project roles
  • Power BI licenses
  • Data warehouse bus matrix
  • Dataset design process
  • Data profiling
  • Dataset planning
  • Sample project analysis

Power BI Desktop

  • Overview
  • Use Cases
  • Architecting a PBIX file
  • Preview features
  • Visualizations
  • Data Models
  • Analyzing data in the PBIX tables
  • Navigation

Power BI Query Editor

  • Loading Data Models
  • Leveraging parameters
  • Advanced Query Editor
  • Data transformation
  • Data manipulation
  • Joining multiple data sources
    • On premise
    • Cloud
    • Hybrid
  • Understanding query process

Connecting to Sources and Transforming Data

  • Query design per dataset mode
  • Data sources
  • SQL views
  • M queries
  • Query folding
  • M Query examples
  • M editing tools

Designing Import and DirectQuery Data Models

  • Dataset layers
  • The Data Model
  • Relationships
  • Model metadata
  • Optimizing performance

Developing DAX Measures and Security Roles

  • DAX measures
  • Base measures
  • Date intelligence metrics
  • Dimension metrics
  • Ranking metrics
  • Security roles
  • Performance testing

Applying Custom Visuals, Animation, and Analytics

  • Drill through report pages
  • Bookmarks
  • ArcGIS Map visual for Power BI
  • Waterfall chart breakdown
  • Analytics pane
  • Quick Insights
  • Custom visuals
  • Animation and data storytelling

Data Visualization

  • End User Interaction design
  • End User Experience design
  • How to select the right visual
  • Understanding visual data alignment

Data Architecting

  • Snowflake schema
  • Star schema
  • Designing to leverage relationships
  • Dynamic filtering

Designing Power BI Dashboards and Architectures

  • Dashboards versus reports
  • Dashboard design
  • Multi-dashboard architectures
  • Dashboard tiles
  • Live report pages
  • Mobile-optimized dashboards

Managing Application Workspaces and Content

  • Application workspaces
  • Staged deployments
  • Dashboard data classifications
  • Version control
  • Metadata management

Managing the On-Premises Data Gateway

  • On-premises data gateway planning
  • Gateway clusters
  • Gateway architectures
  • Gateway security
  • Gateway configuration
  • Managing gateway clusters
  • Troubleshooting and monitoring gateways
  • Scheduled data refresh
  • DirectQuery datasets
  • Live connections to Analysis Services models
  • Dashboard cache refresh

Deploying the Power BI Report Server

  • Planning for the Power BI Report Server
  • Installation
  • Configuration
  • Upgrade cycles
  • Report Server Desktop Application
  • Report Server Web Portal
  • Power BI mobile applications
  • Report server administration
  • Scale Power BI Report Server

Creating Power BI Apps and Content Distribution

  • Content distribution methods
  • Power BI apps
  • Self-Service BI workspace
  • Sharing dashboards and reports
  • SharePoint Online embedding
  • Custom application embedding
  • Publish to web
  • Data alerts
  • Email Subscriptions
  • Analyze in Excel

Administering Power BI for an Organization

  • Data governance for Power BI
  • Azure Active Directory

Power BI Admin Portal

  • Usage metrics reports
  • Audit logs
  • Power BI Premium capacities

Scaling with Premium and Analysis Services

  • Power BI Premium
  • Power BI Premium capacity allocation
  • Premium capacity estimations
  • Analysis Services
  • Migration of Power BI Desktop to Analysis Services

Power BI Dataflows

  • Build an ETL
  • Distributing Dataflow
  • Connecting to Dataflows
  • Management

Power BI Security

  • Role based access
  • Designing for RLS
  • Dynamic Role level security
  • Leveraging the AAD
  • Implementing in the Power BI Service

Integration with Azure DevOps

  • PBIX version control
  • Continuous Integration
  • Continuous Deployment
  • Aligning as an Agile/Scrum BI team
  • Pull Requests
  • Builds
  • Releases
  • Pipeline Management
  • Automatic deployment to Power BI Service
  • Gated deployments with approvals
  • Security
  • Projects

 

A Message From the Head Instructors About This Course

Duration 2 to 4
Materials

Manual and supporting materials included

Prerequisites

None

Software Requirements

Power BI Desktop, Internet Access

Laugh, Cry, Learn Analytics—Schedule This Class.