Welcome

Join Luke Duffy for the first session in this four-part PL-300 series, introducing the core skills required to prepare and model data in Microsoft Power BI. In this 60-minute webinar, you will explore practical approaches to connecting, cleaning, transforming, and structuring data for effective analysis. Agenda - 0–5 minutes: Welcome, session overview, and the four PL-300 skill areas - 5–20 minutes: Prepare data by connecting to sources or shared semantic models, configuring source settings, and choosing Import, DirectQuery, or DirectLake - 20–35 minutes: Profile, clean, transform, and load data, including data types, null values, errors, reshaping, merging, and appending - 35–50 minutes: Design a data model using fact and dimension tables, keys, relationships, date tables, and appropriate table and column properties - 50–57 minutes: Introduce DAX calculations, including measures, CALCULATE, time intelligence, calculated columns, and calculated tables - 57–60 minutes: Recap and questions What you'll learn - Identify suitable Power BI data sources and storage modes for common analytical scenarios - Apply practical techniques to profile, clean, reshape, combine, and load data - Recognize how fact tables, dimension tables, keys, relationships, and date tables support a robust data model - Distinguish between common DAX calculation options, including measures, calculated columns, and calculated tables