Week 5) Merge and reshape data, use SQL + agents, and run a full Make workflow

Learning Goals

• Coding: apply merging, pivoting (wide <-> long), advanced cleaning, complete grids, missing-data handling, and scaling patterns.
• Coding: retrieve and validate data with SQL and use software agents responsibly for drafting and refinement.
• Collaboration: apply advanced Git workflows for pull requests, review comments, follow-up commits, and merge readiness.
• Automation: run a full Make pipeline with staged targets (data_prep, analysis, report), plus clean (and optionally rebuild).

Preparation before class

• Please read chapter 8 of “Marketing Analytics: A Modern Toolkit” (and optionally from the Appendix: “Make”).
• Complete the code quests for week 5.

Tutorial

• Tutorial: advanced coding in R, SQL + agent workflow, and advanced Git + full Make pipeline.

Coaching session

• Work on your team goals for this course week (see coaching #4 on your workplan).

After the lecture

• Complete all exercises from the tutorial shared with students this week.

Optional practice

• Do one extra SQL + agent verification cycle and compare the final query with your first draft.
• Collect peer feedback from at least one PR review before final project integration.