1. What this prompt does

• Function: This prompt identifies anomalies in KPI data by checking for values that exceed predefined thresholds or deviate more than 3 standard deviations from the mean. It then provides likely causes, additional data requirements, and validation steps for each anomaly.
• Target:
  • Data Analysts: Need to quickly identify and understand anomalies in KPI data.
  • Business Managers: Require insights into operational issues affecting KPIs.
  • Quality Control Teams: Focus on maintaining consistent performance metrics.
  • Financial Auditors: Look for irregularities in financial KPIs for compliance.
• Benefit:
  • Save time on manual anomaly detection.
  • Get a comprehensive view of potential issues and solutions.
  • Avoid missing critical deviations that could impact decisions.
  • Enhance data-driven decision-making with detailed analysis.

2. How do you use this prompt?

1. Open ChatGPT
2. Copy the prompt/workflow content
3. Paste into ChatGPT and run
   User Input :

   Please analyze the KPI data provided in the Excel file. First, identify any anomalies by checking for values exceeding specified thresholds or deviating more than 3 standard deviations  from the mean. For each anomaly identified, list possible causes, suggest additional data needed for further investigation, and outline steps to validate the anomaly.
   

4. Get insights on anomalies, likely causes, needed data, and validation steps instantly

3. When will you need this prompt?

• Data Analysts → Analyzing monthly sales KPIs to identify anomalies and improve forecasting.
• Business Managers → Detecting operational hiccups in production KPIs that exceed thresholds.
• Quality Control Teams → Ensuring product quality by monitoring KPI deviations.
• Financial Auditors → Conducting audits for financial compliance and spotting irregularities.
• Project Managers → Tracking project KPIs to ensure adherence to timelines and budgets.