Best Claude prompts for Management Analysts

Analyze the existing ETL pipeline for our customer database, which currently uses SQL to extract data from Snowflake, Python to transform the data, and Tableau to load the data into a visualization dashboard. Identify bottlenecks in the pipeline and provide a revised architecture that reduces data processing time by at least 30% while maintaining data accuracy. Consider using techniques such as data partitioning, parallel processing, and data caching. Provide a detailed implementation plan, including code snippets and a timeline for completion.

Evaluate the performance of a regression model developed using R, which predicts sales revenue based on marketing spend and seasonality. Compare the model's precision to a baseline model using metrics such as mean absolute error, mean squared error, and R-squared. Identify the most important factors contributing to the model's performance and provide recommendations for improvement, including feature engineering and hyperparameter tuning. Provide a detailed report, including visualizations and statistical summaries.

Conduct a comprehensive data quality audit of our sales database, which contains customer information, order history, and product data. Identify data inconsistencies, inaccuracies, and missing values, and provide a report detailing the findings, including data visualization and statistical summaries. Develop a data cleaning script using Python to address the identified issues and improve data accuracy. Provide a detailed implementation plan, including code snippets and a timeline for completion.

Develop a statistical summary report for our quarterly business review, which includes key performance indicators such as revenue growth, customer acquisition, and customer retention. Analyze the data using SQL and provide insights into trends and patterns, including correlations and regressions. Visualize the data using Tableau and provide recommendations for strategic decision making. Include a detailed appendix with data definitions, methodology, and limitations.