Best Perplexity prompts for Computer Systems Analysts

Given a Snowflake database with 100 million rows of customer data, and a Python script that uses SQL to query the data, write a step-by-step plan to optimize the query performance, including indexing, caching, and parallel processing. Assume the query is a complex join operation between three tables, and provide a comparison of the execution times before and after optimization. Also, provide a list of potential bottlenecks and limitations of the optimization plan.

Develop a data cleaning script in Python to handle missing values, outliers, and data inconsistencies in a dataset of 500,000 rows, containing customer information, including names, addresses, and phone numbers. The script should include data profiling, data validation, and data transformation steps, and provide a summary report of the data quality issues found and resolved. Assume the data is stored in a CSV file and provide a sample output of the cleaned data.

Using a dataset of historical sales data, develop a statistical model in R to forecast future sales, taking into account seasonal and trend components. The model should include a decomposition of the time series into its constituent parts, and provide a comparison of the performance of different models, including ARIMA, SARIMA, and ETS. Assume the data is stored in a CSV file and provide a sample output of the forecasted values.

Design an ETL pipeline using Tableau to extract data from a SQL database, transform the data into a suitable format, and load it into a data warehouse. The pipeline should include data validation, data cleansing, and data aggregation steps, and provide a detailed documentation of the pipeline architecture, including data flows, data transformations, and error handling mechanisms. Assume the data is stored in a relational database and provide a sample output of the transformed data.