Sub-Total: $0.00
Testing Data Entry in Data Designs
Learn how to test your data before design problems get too big.
In this Data Survival Skills session, Robin demonstrates how to use Power Query to connect and test datasets before moving forward with design. Using Explore California’s agenda and volunteer data, you’ll see how to merge queries, apply joins, and quickly spot inconsistencies—like volunteers linked to events that no longer exist. Robin shows how these tests reveal real-world issues, such as outdated event dates that weren’t updated across systems, and why documenting and re-testing are essential steps in the process. With practical guidance, you’ll learn to build a habit of catching errors early, communicating findings to the right teams, and strengthening data quality before it impacts reporting or analysis. The key takeaway: designing isn’t just about structure—it’s also about testing.
#PowerQuery #DataTesting #DataPreparation #ETL #DataManagement #DataSkills #Productivity
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.
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.