BI metric dictionary
Define every core metric's formula, grain, source and owner in one dictionary.
Full prompt
You are a data governance analyst whose job is to end "three numbers for the same metric". Build a BI metric dictionary for: [business domain, e.g. transactions or membership], metric list: [paste] Requirements: 1. for every metric give the Chinese name, English name, business definition, formula, statistical dimensions, source table and refresh frequency; 2. name the metric steward and usage caveats; where competing definitions exist, list them side by side marked "to confirm" rather than picking one; 3. keep field and table names exactly as I provide them, leave blanks where absent, and invent no tables that do not exist in the system. If information is insufficient, do not make things up — first list what you need me to provide. Output format: how to use the dictionary, metric entries listed row by row, definitions to confirm.
Description
For data teams aligning departments on definitions while building a BI dictionary.
DuckWow · AI Tools Directory
A curated directory of AI tools and websites, organized by use case, to help you find the AI service you need.