Course Overview

Power BI Developer Bootcamp is an intensive 4-day instructor-led training course with hands-on labs designed to get professional software developers up to speed on developing custom software solutions for Power BI. This course assumes that students already have experience with Power BI Desktop and the Power BI Service and are looking for ways to move beyond what’s possible with just Power BI Desktop alone.

The course examines essential developer extensibility points in the Power BI platform for importing data, creating visualizations and integrating reports and dashboards into custom applications. Students will learn to program in M and to develop custom data connectors with reusable query logic that can be shared across Power BI Desktop projects. The course teaches students how to develop custom visuals using Typescript, Node.JS and Visual Studio Code. Students will also learn how to program using the Power BI Service API to automate common task such as uploading PBIX files and patching datasource credentials.

The course provides in-depth coverage of Power BI embedding features and teaches students how to embed reports and dashboards when developing custom applications. Students will learn to build real-time dashboard solutions using streaming datasets and push datasets. The course concludes by teaching students how to leverage the support in Power BI for the R data analytics platform by writing R scripts for Power BI Desktop and by developing R custom visuals.

Key Learning Areas

  • Introduction to Power BI
  • Creating PBIX Projects with Power BI Desktop
  • Developer Opportunities in Power BI
  • Creating a Power BI Development Environment
  • Deciding What to Measure
  • Query Design Fundamentals
  • Designing Data Model using a Star Schema
  • Working with the Query Editor Window
  • Importing Content from SharePoint Online
  • Understanding Parameters and Template Files
  • Designing with Function Queries Creating Table Relationships
  • Creating Calculated Columns and Measure
  • Creating Tables using DAX Expressions
  • Configuring Fields for Geographic Mapping
  • Creating Dimensional Hierarchies
  • Using the DAX Calculate Function
  • Calendar Tables and Time Intelligence
  • TypeScript Language Primer
  • Getting Started with D3 and SVG Graphics
  • Creating Data-driven Visuals
  • Enhancing Visuals with Scales and Axes
  • Event Handling and Transitions
  • Using D3 Layouts
  • Custom Visuals in Power BI
  • JS and the Cross-platform Toolchain
  • Creating Projects with the PBIVIZ CLI
  • Custom Visual Project Structure
  • Adding Typed Definition Files
  • Testing and Debugging a Custom Visual
  • Defining Data Roles and Data Mappings
  • Extending a Visual with Custom Properties
  • Designing Custom Visuals using a View Model
  • Advanced Custom Visual Design Features
  • Packaging and Deploying Custom Visuals
  • Power BI Service API Overview
  • Authentication with Azure Active Directory
  • Developing with the Power BI SDK
  • Creating and Managing Workspaces
  • Power BI Embedding Fundamentals
  • App Workspaces and Dedicated Capacities
  • Authentication with Azure Active Directory
  • Programming with Power BI Service API
  • Working with Embeddable Resources
  • Embedding with Power BI JavaScript API

Course Outline

  • Power BI Developer Roadmap
  • Designing Queries with Power BI Desktop
  • Advanced Data Modeling using DAX
  • Programming with TypeScript and the D3 Library
  • Getting Started with the Power BI Developer Tools
  • Developing and Distributing Custom Visuals
  • Developing with the Power BI REST API
  • Developing with Power BI Embedding
  • Configuring Power BI Security
  • Developing Streaming Datasets and Real-Time Dashboards
  • Introduction to R with Power BI
  • Developing Custom Connectors

Prerequisites

Attendees should have previous experience working with Power BI Desktop and the Power BI Service, and should also have previous experience programming with JavaScript and C# in Visual Studio.