Power BI Training Course (1-3 days, from basic to advanced) 

A. for Business Analysts

B. Developers

Note: this outline is our proposal, but the training can be tailored to your specific requirements upon prior request ahead of the proposed course date.

Why Learn Power BI?

Microsoft Power BI is a free Software as a Service (SaaS) suite for analyzing data and sharing insights. Power BI dashboards provide a 360-degree view of the most important metrics in one place, updated in real time, and available on all of their devices.

In this instructor-led, live training (onsite or remote), participants will learn how to use Microsoft Power BI to

A. analyze and visualize data using a series of sample data sets.

B. develop custom software solutions for the Power BI and Azure platforms.

By the end of this training, participants will be able to:

A.

  • Create visually compelling dashboards that provide valuable insights into data.

  • Obtain and integrate data from multiple data sources.

  • Build and share visualizations with team members.

  • Adjust data with Power BI Desktop.

B.

  • Configure real-time dashboards.

  • Create custom visualizations.

  • Integrate rich analytics into existing applications.

  • Embed interactive reports and visuals into existing applications.

  • Access data from within an application.

  • Master Power BI Portal, Desktop, Embedded and Rest API.

  • Integrate R Scripts into Power BI Desktop.

 

Course details

The outline below covers both fundamental and advanced topics.

The final training outline will be designed depending on your particular requirements.

The practical exercises constitute a big part of the course time, besides demonstrations and theoretical presentations. Discussions and questions can be asked throughout the course.

Audience

A. Business Analysts

B. Developers

Prerequisites

A.

  • An understanding of business analytics concepts

 

B.​

  • Experience working with Power BI and Power BI Desktop

  • Experience with Javascript, Typescript, Node.js and D3.js library

  • Experience with C# in Visual Studio

Course Outline

A. 

Introduction

Data Visualization

  • Authoring in Power BI Desktop

  • Creating reports

  • Interacting with reports

  • Uploading reports to the Power BI Service

  • Revising report layouts

  • Publishing to PowerBI.com

  • Sharing and collaborating with team members

 

Data Modeling

  • Aquiring data

  • Modeling data

  • Security

  • Working with DAX

  • Refreshing the source data

  • Securing data

 

Advanced Querying and Data Modeling

  • Data modeling principals

  • Complex DAX patterns

  • Power BI tips and tricks

 

Summary and Conclusion

B.

Introduction

The data workflow: data source, ETL (Extract, Transform, Load), data warehousing and data analysis

Overview of Power BI Desktop

Power BI Developer Tools

Programming with TypeScript and d3.js

Developing and Distributing Custom Visuals

Developing R Scripts using RStudio

Integrating R Scripts into Power BI Desktop

Developing Custom R Visuals

Developing with the Power BI REST API

Updating the Power BI Dashboard in Real-time

Embedding Dashboard and Reports into an Application with Power BI Embedded

Closing remarks