Archive for July 2023

Learn how to keep orders organized and accurate with joins and update queries. In this Data Survival Skills session, Robin works with Leaf & Mortar’s orders from both stores and pop-up shops. Starting with a master order table, she imports the pop-up shop data, links it using order numbers, and updates a new field to…

Learn how to streamline time-based analysis by building a reusable date table in Power Query. In this Data Survival Skills session, Robin starts with a blank query and uses a custom function to generate a continuous range of dates. She then normalizes the table by adding key attributes such as month name, month number, weekday,…

Discover how to turn messy spreadsheets into an organized, normalized database with Microsoft Access. In this Data Survival Skills session, Robin takes Leaf & Mortar’s order and customer list and shows how to make it easier to manage. She starts by importing a CSV file, then uses simple queries to pull out unique values and…

Learn how to combine multiple spreadsheets into a single dataset with append queries in Power Query. In this Data Survival Skills session, Robin demonstrates how to bring in individual Excel files—such as order data from four different shop zones—and merge them into one clean, analysis-ready table. She shows how to connect each file directly from…

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,…