Examples are linked in the images below:

  1. The ‘Revenue Sensitivity’ example creates a model to determine the effect of revenue changes on a campaign’s performance, while balancing the CoGS associated with providing this data.

  2. The ‘Unbaked Cohorted Data’ example showcases my knowledge of data architecture, using ETLs and persistent derived tables to serve incomplete data in advance of the required 7-day baking period

  3. The ‘Advanced Date Fields’ Example Showcases some creative SQL logic to provide date fields that are not standard to Looker’s out-of-the-box tools.