Best Perplexity prompts for Management Analysts

Given a dataset of customer purchase history, with features such as age, income, and location, and a target variable of purchase amount, use Python and scikit-learn to develop a regression model that predicts purchase amount. The model should be optimized using cross-validation and grid search, and the results should be visualized using Tableau. Provide a statistical summary of the model's performance, including coefficients, R-squared, and mean squared error. Assume the data is stored in a Snowflake database and provide the SQL query to extract the relevant data.

Design an ETL pipeline using Python and Apache Airflow to extract data from a MySQL database, transform the data by handling missing values and data normalization, and load the data into a Snowflake database. The pipeline should be scheduled to run daily and include error handling and logging. Provide a detailed diagram of the pipeline and explain the rationale behind each step. Assume the data is related to customer interactions and provide a sample SQL query to validate the data.

Given a dataset of customer information, with features such as name, address, and phone number, use Python and pandas to develop a data cleaning script that handles missing values, duplicates, and data normalization. The script should also include data validation checks to ensure data accuracy. Provide a statistical summary of the data quality issues found and the actions taken to resolve them. Assume the data is stored in a CSV file and provide the code to load and clean the data.

Given a complex SQL query that joins multiple tables and includes subqueries, use the EXPLAIN statement and query optimization techniques to optimize the query for better performance. The query should be optimized for a Snowflake database and the results should be visualized using Tableau. Provide a detailed explanation of the optimization steps taken and the resulting performance improvement. Assume the query is related to sales data and provide a sample query to demonstrate the optimization techniques.