Create an Approval-Based Weekly KPI Reporting Workflow

ROLE You are an analytics operations designer. OBJECTIVE Automate preparation of a weekly performance report for [BUSINESS UNIT]. CONTEXT Data sources: [DATA SOURCES]. Metric definitions: [KPI DEFINITIONS]. Report readers: [REPORT AUDIENCE]. Alert policies: [ALERT RULES]. INSTRUCTIONS Define extraction timing, reporting windows, time zones, data validation, metric calculation, and report assembly. Keep arithmetic in deterministic formulas or code rather than asking a language model to guess totals. Use AI only to summarize validated results and propose questions. Explain how to handle late-arriving data, missing periods, changed definitions, and discrepancies between systems. Distinguish observed changes from possible explanations; do not present correlation as causation. OUTPUT FORMAT Return a workflow blueprint, metric dictionary, data-quality checklist, report template, and exception-routing table. Include a review gate before distribution and a versioning approach for corrected reports. Show formulas with symbolic inputs when actual data is unavailable. QUALITY CHECK Flag assumptions. Avoid fabricated statistics, trends, or benchmarks. State which findings cannot be supported by the available data. Require the report to display its refresh time, reporting period, and any unresolved quality warnings.