Sub-Total: $0.00
Using Joins and Update Queries to Create Markers in the Data
Learn how to keep orders organized and accurate with joins and update queries. In this Data Survival Skills session, Robin works with Leaf & Mortar’s orders from both stores and pop-up shops. Starting with a master order table, she imports the pop-up shop data, links it using order numbers, and updates a new field to flag each record. She then applies the same process across multiple sources, ensuring every dataset follows consistent rules. Finally, she fills in the remaining orders as store sales, creating a fully flagged dataset that’s ready for comparison. This method makes analysis repeatable, reliable, and easier to scale—helping you make confident, data-driven decisions.
#Access #SQL #DatabaseManagement #DataCleaning #DataAnalysis #BusinessIntelligence #DataAutomation #DataAnalytics
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.