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.