Planning a Basic System for Data Collection

A woman working on a computer.

Learn how to turn multiple data sources into a unified collection that drives real insights. In this Data Survival Skills session, Robin explores the fundamentals of data collections—how to identify which datasets matter, where they come from, and how to prepare them for analysis. Using examples from event management and HR systems, you’ll see how…

Read More

Scripting views for SQL databases

A woman working on a computer.

Tired of re-running queries and exporting CSVs? 🚀 In this Data Survival Skills session, Robin shows how to use SQL views to turn one-time queries into reusable datasets. With SQL Server Management Studio, she walks through saving a query as a view, using an example of tracking the most popular tour package. Once saved, views…

Read More

Use Copilot to Create a Draft Presentation about your Data Project

A woman working on a computer.

Learn how to build smarter presentations with Microsoft Copilot in PowerPoint. Every data story needs a strong first draft. In this Data Survival Skills session, you’ll see how to turn Word documents and Excel spreadsheets into presentation-ready slides—complete with outlines, speaker notes, and visuals—using Copilot. By iterating between your data sources and AI-powered drafting, you’ll…

Read More

Using Remove Duplicates to Find the Latest or Earliest Record in Excel

A woman working on a computer.

Learn how to find the latest or earliest customer orders using Remove Duplicates in Excel. Sometimes you just need a clean list of customers with their most recent order—but sorting through all the data manually can be tedious. In this Data Survival Skills session, Robin shows how to sort by customer ID and order date,…

Read More