Discover how to use Copilot to build and verify basic Excel functions. In this Data Survival Skills session, Robin prompts Copilot to calculate the change in county populations from 1990 to 2022 and to find each county’s share of the 2022 state population. Copilot delivers formulas and explains the logic behind them, helping you learn…
Read More
Learn when to lean on Copilot vs. Power Query in Excel. In this Data Survival Skills session, Robin shows how to clean up a dataset for a quick ad hoc marketing request—removing unnecessary fields, reformatting values into easy-to-read percentages, and applying conditional formatting to highlight negatives. Along the way, you’ll see where Copilot is great…
Read More
Discover how to use Copilot to quickly explore and understand your datasets. In this Data Survival Skills session, Robin shows how to use Power Query to remove distracting fields before diving into insights with Copilot. With a cleaner dataset, Copilot surfaces trends like population growth and highlights outliers such as Jefferson County. You’ll see how…
Read More
Learn how to streamline documentation and research with Microsoft Word and Copilot. Every data project needs context, whether for yourself, your team, or final presentations. In this Data Survival Skills session, Robin shows how to use Copilot in Word to look up Rural Urban Continuum (RUC) codes, generate explanations, and even turn results into tables.…
Read More
Learn how to design user interfaces for better data entry. In this Data Survival Skills session, Robin shows how to translate data requirements into simple, effective UI mockups. Starting with a volunteer signup form, you’ll see how to think through fields, dropdowns, and workflows—even using basic tools like PowerPoint. The goal isn’t to make something…
Read More
Learn how to clearly visualize cohort data over time. Cohort data can be complex—especially when it comes to tracking progression across grades, years, or other time-based stages. In this Data Survival Skills session, Robin demonstrates how to structure and visualize cohort data in Power BI to make patterns clear and actionable. You’ll see how to…
Read More
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 quickly assign full schedules to all employees using SQL cross joins. In this Data Survival Skills session, Robin demonstrates how to create two tables—one for employees and one for schedules—and use a cross join to generate every possible combination. She shows how to execute the scripts in SQL Server, verify the results,…
Read More
Learn how to uncover booking trends with SQL and Excel. Every business wants to know when customers commit—are they booking last-minute or months in advance? In this Data Survival Skills session, Robin shows how to use SQL case statements to group bookings into bands like 0–45 days, 46–90 days, and 180+ days. By transforming raw…
Read More
Learn how to uncover hidden booking gaps with Power BI. Static reports often hide the story behind missing activity—weeks or days where tours never filled. In this Data Survival Skills session, Robin shows how to replace Excel pivots with interactive Power BI visuals that make patterns clear. You’ll learn how to build matrices, apply conditional…
Read More