You’ll build a free LookML + Looker alternative using dbt + Google Data Studio and Metriql to sync the dbt models to Google Data Studio. You’ll then create a tutorial explaining step-by-step how you defined metrics as code with Metriql on top of dbt and then sync these metrics to Google Data Studio to query and visualize the data directly from Snowflake. You can finish the tutorial by shortly outlining the differences and similarities between using LookML and Metriql.
You must have first-hand experience using dbt to transform your data inside a modern cloud data warehouse like Snowflake, BigQuery or RedShift. You must also have experience modelling data for BI tools. Looker experience is a plus but not required if you can learn enough to write a blog from the internet.