Learn how to audit spreadsheets for hidden risks and secure your sensitive data. In this Data Survival Skills session, Robin demonstrates how seemingly simple Excel files can contain more than meets the eye—from hidden sheets and embedded queries to formulas and linked data sources. She walks through techniques like uncovering hidden columns, showing formulas, and…
Read More
Learn how to transform datasets into Outlook calendar visuals. Date-related data is easier to understand when it’s shown on a calendar instead of a spreadsheet. In this Data Survival Skills session, Robin demonstrates how to import CSV data directly into Outlook to quickly build a calendar view. You’ll learn how to map fields like start…
Read More
Learn how to build reusable data sets directly inside Outlook. Outlook is often seen as just an email tool, but it’s packed with data and powerful scheduling features. In this Data Survival Skills session, Robin demonstrates how to create calendars with recurring appointments, categorize events, and export them as CSV files. By structuring your schedules…
Read More
Data everywhere – and plenty of places to put it. A key to data survival and well data quality is being able to leverage data for other places without rekeying it in. Learn core concepts for what to look for when importing and exporting data from and to other places. Learn How To Map Data…
Read More
Learn how to design structured database relationships that turn messy information into reliable insights. In this Data Survival Skills session, Robin shows how Explore California organizes potential tour data by moving from unstructured notes and spreadsheets into a relational database model. Using primary keys, foreign keys, and one-to-many relationships, she demonstrates how to normalize data…
Read More
Discover how to turn a long list of event details into a clean, organized schedule in seconds. In this Data Survival Skills session, Robin shows how to use Power Query’s Pivot Column to transform agenda data into a clear display of speakers, dates, and sessions. Unlike a regular pivot table, Pivot Column makes it easy…
Read More
Discover how to clean up messy text fields and make your data consistent. In this Data Survival Skills session, Robin teaches how to create a control table and use joins to recode survey data with lots of different spellings for the same thing. Instead of writing endless replace commands, you’ll learn how to build the…
Read More
Learn how to combine multiple data sources into a single, analysis-ready dataset with Power BI. In this Data Survival Skills session, Robin demonstrates how to merge customer order records, cohort data, and loyalty program participation into one unified view. By walking through step-by-step examples, she shows how to group data to calculate total order amounts…
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 save hours on recurring tasks using date functions in Excel. In this Data Survival Skills session, Robin demonstrates how Explore California streamlined their customer survey process by calculating follow-up dates automatically. She shows how to use functions like EOMONTH to shift survey notifications from a daily workflow to a monthly schedule, dramatically…
Read More