Professional Context
Balancing the daily grind of testing SQL queries against the looming deadline to optimize ETL pipeline performance, all while ensuring data accuracy and model precision, is a daunting task for Software Quality Assurance Analysts and Testers, as they must prioritize between refactoring regression models and troubleshooting Tableau visualizations.
💡 Expert Advice & Considerations
Don't waste time using Perplexity to generate generic test cases - instead, focus on using it to identify obscure edge cases that your existing tests might be missing.
Advanced Prompt Library
4 Expert PromptsSQL Query Optimization Analysis
Given a SQL query with multiple joins and subqueries, analyze the query plan and provide a step-by-step optimization strategy to reduce execution time, including index recommendations and rewriting subqueries as joins, assuming a Snowflake database with 100 million rows of data.
Automated Testing for Data Cleaning Script
Create a comprehensive test suite for a Python data cleaning script that handles missing values, outliers, and data normalization, using a combination of unit tests and integration tests, and provide example test cases for each scenario, assuming a dataset with 10 features and 1000 samples.
Statistical Summary of Model Performance
Generate a detailed statistical summary of a regression model's performance, including metrics such as mean squared error, R-squared, and coefficient of variation, and provide a visual representation of the residuals and predicted values using Tableau, assuming a dataset with 5000 samples and 10 features.
ETL Pipeline Audit and Refactoring
Perform a thorough audit of an existing ETL pipeline, identifying bottlenecks, data quality issues, and opportunities for optimization, and provide a refactored pipeline design that incorporates data validation, error handling, and parallel processing, assuming a pipeline with 10 stages and 100 million rows of data.