Planning a Basic System for Data Collection

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 to plan access, handle permissions, and design an ETL process that extracts, transforms, and loads only the data you need. From deciding what fields to keep, to creating keys that link volunteers, employees, and attendees, Robin demonstrates how thoughtful planning turns raw exports into meaningful datasets. By focusing on structure, permissions, and transformation, you’ll gain the skills to build collections that are accurate, connected, and ready for analysis across any tool or platform.

#DataCollections #ETL #DataManagement #DataSkills #SQLServer #DataPreparation #Productivity

Basic steps for data collection and access.

If you’re a data analyst, you’ve no doubt learned different skills, techniques, and tools pertaining to data. But sometimes it can be difficult to know when and why to apply these tools. In this weekly series, instructor Robin Hunt explains a new skill, secret, tip, technique, best practice, or golden piece of advice in each installment. Robin covers topics that can help you do your job better, such as joining data and data designs, privacy for data, transforming and cleaning data, and making data sets and visualizing data.

Watch the Series Intro Today

Note: Because this is an ongoing series, viewers will not receive a certificate of completion.