Cleaning data from a PDF in Power BI

A woman working on a computer.

Discover how to turn static PDF files into interactive, analyzable data. In this Data Survival Skills session, Robin shows how to use Power Query in Power BI to import tables from vendor PDFs and clean them into structured datasets. By converting cost and retail price fields into usable formats, adding custom calculations for total costs…

Read More

Using Unpivot to build data sets from Survey Results

A woman working on a computer.

Learn how to transform messy survey data into powerful insights. In this Data Survival Skills session, Robin shows how to use Unpivot in Power Query to restructure wide-format survey results into clean, record-based tables. By converting multiple-choice word selections into vertical records linked by respondent ID, she demonstrates how to compare responses across questions, add…

Read More