Public Customer Feedback Low-Rating Time Series Analysis for Quality Improvement

This ETL workflow extracts feedback entries with a rating of 1 from the edgi_feedback data source, applying a filter condition to isolate negative feedback. The ingestion step captures relevant records, followed by a transformation phase that aggregates the count of these entries grouped by the created_at timestamp. The final step involves generating a time series chart to visualize trends in low ratings over time, enabling business stakeholders to monitor customer sentiment and identify periods of increased dissatisfaction. Schema enforcement ensures data consistency during extraction, and the output supports downstream reporting and alerting systems.