Skip to main content

Introduction to Power BI Using the MSD

The purpose of this course is to teach participants the basic functionality of Power Query, a data management feature, and Power BI Desktop, a data visualization software, using a training MER Structured Dataset (MSD). In Part 1 of this training, participants will learn how to execute data management steps on the training MSD to prepare it for ingestion into Power BI Desktop. Part 1 covers how to import data, transform it from a semi-wide to long format, how to rename, delete, and create new data columns using Power BI. In Part 2, participants will learn about critical Power BI terminology, basic functionality of the platform, key formatting tips and how to create data visualizations that answer PEPFAR-specific analytic questions. This course incorporates demos, bulleted teaching points and narration; participants will absorb the information and execute each step independently in their own Power BI software during the training.

  • Course Number

  • Classes Start


No previous experience with Power BI is required for this training; however, two courses are pre-requisites:PEPFAR Between the Spreadsheets and the introduction to this course. Prior to starting this course, you should either secure a Power BI license through your respective USG agency or download a free Power BI version to gain the full experience of the course.