Giter Club home page Giter Club logo

testing-metrics's Introduction

🥪 A Future of Testing

Welcome to this design session! Today we are going to walk through what it would be like to configure testing on top of metrics within your dbt project. For this session we are going to use the experimental spec that is being propsoed - all you need to know is that the actual metric contains less information than the past!

The Excercise

You're an Analytics Engineer with the Jaffle Company. You've built out your Semantic Layer inside of dbt but a recent data quality issue led to your company mis-reporting on your key metrics. The CEO accepted responsibility but has asked you to research a way to make sure it doesn't happen again.

You know that your revenue metric for January of 2023 had the following properties:

  • The overall revenue was $10,000
  • The revenue in the US was $6,729
  • The revenue on Jan 4th was $800
  • Revenue should always be greater than $100

With this information, we are going to be walking through 3 proposed designs for testing metrics. It is your responsibility to determine which of these feels the most dbtonic, which is the highest value, and to provide the team with any suggestions that you have!

Design 1

Referencing the first design in the Notion, please implement a test on the revenue metric inside of the semantic graph file for one (or more) of the three known properties.

A corresponding design document exists in the semantics folder for your convienence.

Design 2

Referencing the second design in the Notion, please implement a test on the revenue metric inside of the semantic graph file for one (or more) of the three known properties.

A corresponding design document exists in the semantics folder for your convienence.

Design 3

Referencing the third design in the Notion, please implement a test on the revenue metric inside of the semantic graph file for one (or more) of the three known properties.

A corresponding design document exists in the semantics folder for your convienence.

testing-metrics's People

Contributors

callum-mcdata avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.