Tableau Report Agent

An automated data quality monitoring and alerting system for Tableau reports that validates data integrity and sends notifications to stakeholders when issues are detected.

Features

• Automated Data Validation: Uses AI-powered analysis to check if datasets meet predefined quality rules
• Tableau Integration: Connects to Tableau servers to extract data and manage report schedules
• Smart Scheduling: Automatically pauses/resumes Tableau schedules based on data quality results
• Multi-Channel Alerts: Sends SMS and email notifications to designated stakeholders
• Contextual Analysis: Incorporates date, holidays, and business context into validation rules
• AWS Lambda Ready: Designed for serverless deployment with configurable rules

How It Works

1. Data Extraction: Pulls data from specified Tableau workbooks and dashboards
2. Rule Validation: Applies predefined quality rules with AI-powered analysis
3. Context Integration: Includes date, day of week, and special events in analysis
4. Schedule Management: Automatically manages Tableau extract schedules based on results
5. Alert Distribution: Notifies stakeholders via SMS and email when issues are detected

Components

• lambda_function.py - Main AWS Lambda handler with rule processing logic
• checker.py - AI-powered data validation engine
• tab_tools.py - Tableau server integration and data extraction
• emailer.py - SMS and email notification system

Use Cases

• Report Quality Assurance: Ensure daily/weekly reports meet expected standards
• Data Pipeline Monitoring: Catch data issues before they impact business decisions
• Automated Stakeholder Communication: Keep teams informed of data quality status
• Schedule Optimization: Automatically manage report refresh schedules based on data availability

Perfect for businesses that rely on Tableau for reporting and need automated data quality monitoring.