Weekly Data Quality Report (Offline / JSON)
An offline automation case study using Power Automate Desktop
This project automates weekly data quality reporting using local JSON files and Power Automate Desktop. It identifies inconsistencies, missing data, and generates a summarized report entirely offline, without requiring SharePoint or cloud services.
🎯 The Challenge
Manual weekly data checks were time-consuming and error-prone. The goal was to automate the process offline, validate data consistency, and generate actionable reports without relying on online platforms.
🛠️ The Process
- Read and parse local JSON files containing multiple datasets.
- Loop through each record to check for anomalies or missing values.
- Apply conditional logic to flag data quality issues.
- Generate a summarized offline report for review.
📊 The Solution
Key Features:
- Fully offline processing with Power Automate Desktop
- Dynamic handling of variable-length JSON datasets
- Automated identification of inconsistencies and missing data
- Report output saved locally for weekly review
Screenshot of the PAD flow and sample report output
🔑 Key Insights
- Identified recurring data entry issues automatically
- Saved significant manual verification time (~80% reduction)
- Ensured weekly reports were accurate and consistent
🚀 Impact
By automating offline data quality checks, the workflow reduced manual effort, increased reliability, and allowed the team to focus on analyzing results rather than gathering data.
🧰 Tools Used
- Power Automate Desktop (PAD)
- JSON (data storage)
- Local Excel/CSV for reporting outputs