Designing a Basic System for Data Capture

Learn how to design smarter data tables with Microsoft Copilot and SQL Server. Every successful project starts with the right structure. In this Data Survival Skills session, Robin shows how to plan out key tables for a community project—covering volunteers, events, partners, and assignments—and then use Copilot in SQL Server to generate scripts, refine fields, and build relationships. By combining human planning with AI-powered support, you’ll see how to save time, reduce errors, and create stronger foundations for analysis. This approach ensures your data isn’t just stored—it’s structured to tell a story, support collaboration, and drive better outcomes.
#SQLServer #Copilot #DataAnalytics #DataManagement #AIForWork #DataSkills #Productivity

Chat interface displaying community partner data fields.
Database schema for volunteer management system.

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.