Insight Edge

Below, you'll find the instructions for getting started with your task. Please read them carefully to avoid unexpected issues. Best of luck!

Time estimate

Between 1 and 2 hours, plus the time to configure your environment.

Mandatory steps before you get started

1. Configure your SQL environment with BigQuery
2. Learn how to visualise your data in BigQuery
3. Learn how to get help if you run into an issue.

The task

This case study is intended to assess your technical abilities as an Analyst but also to showcase your problem-solving methodology. Please answer each question to the best of your ability.

Your goal is to complete all tasks outlined in the accompanying TODO.md file.

Solution instructions

1. Complete the tasks outlined in the accompanying TODO.md file. Edit it to include your answers. Feel free to upload any additional files with the visualizations (if you edit TODO.md using the GitHub web interface, drag and drop your image, and it'll be uploaded and embedded automatically).

When you are done

1. Create a new Pull Request from the branch where you've committed your solution to the default branch of this repository. Please do not merge the created Pull Request.
2. Go to your application in Alva Labs and submit your test.

---

Authored by Alva Labs.