Best ChatGPT prompts for Management Analysts

Given a complex SQL query that joins five different tables and applies three subqueries, identify potential bottlenecks, propose index creation on critical columns, and rewrite the query to reduce execution time by at least 25%, considering the database schema and existing data distribution, and provide a step-by-step explanation of the optimization process, including any trade-offs made between query complexity and performance.

Develop a Python script that utilizes the scikit-learn library to build a regression model predicting quarterly sales based on historical data, including seasonal trends and external factors like marketing campaigns, and evaluate the model's precision using cross-validation, then provide recommendations for improving the model's accuracy, such as feature engineering or hyperparameter tuning, and discuss the potential impact of incorporating additional data sources, like social media analytics or customer sentiment analysis.

Design an ETL pipeline using Python and the pandas library to extract data from a relational database, transform it into a denormalized format suitable for a data warehouse, and load it into a Snowflake database, including data quality checks and error handling, and provide a detailed workflow diagram illustrating the pipeline's components and data flow, and discuss potential scalability issues and strategies for mitigating them, such as parallel processing or data partitioning.

Conduct a statistical analysis of a business process, such as customer service response times or inventory turnover, using R and the dplyr library, to identify trends, correlations, and areas for improvement, and generate a report including visualizations, summary statistics, and recommendations for process adjustments or optimizations, and discuss the potential applications of this analysis, such as informing policy changes or guiding resource allocation, and provide guidance on interpreting the results in the context of organizational goals and objectives.