Learn how to turn messy order data into clean, usable datasets with Power Query’s Remove Duplicates tool. In this Data Survival Skills session, Robin works with sales from Leaf & Mortar’s pop-up shops, where customer information repeats across every order line. Instead of manually sorting through hundreds of rows, she demonstrates how to duplicate queries,…
Read More
Learn how to create powerful insights from imperfect data by building conditional logic in Power BI. In this Data Survival Skills session, Robin demonstrates how to merge CSV and Excel sources, bringing together wholesale costs and order details into a unified dataset. By walking through step-by-step examples, she shows how to build conditional columns that…
Read More
Learn how to clean and combine data from multiple files in Power BI. Managing monthly files can be tedious—but Power Query’s From Folder command makes it seamless. In this Data Survival Skills session, Robin demonstrates how to combine and clean multiple rebate files stored in a single folder. Instead of manually appending each month’s data,…
Read More
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