Best Claude prompts for Computer Systems Analysts

Given a dataset of customer purchase history, with features including demographic information, purchase frequency, and average order value, develop a step-by-step approach to validate a regression model designed to predict customer lifetime value. The model should be trained on a sample of 10,000 customers and evaluated using metrics such as mean absolute error and R-squared. Provide a detailed explanation of the data preprocessing steps, including handling missing values and outliers, as well as the model selection process and hyperparameter tuning. Finally, interpret the results of the model evaluation and provide recommendations for improving the model's performance.

Design an optimized ETL pipeline to extract data from a Snowflake database, transform it using Python, and load it into a Tableau dashboard for visualization. The pipeline should handle a dataset of 1 million records, with a focus on minimizing data latency and maximizing data freshness. Provide a detailed architecture of the pipeline, including data ingestion, data processing, and data loading, as well as a discussion of the trade-offs between different design choices, such as using a batch processing approach versus a real-time streaming approach.

Develop a comprehensive data quality assessment framework to evaluate the accuracy, completeness, and consistency of a dataset containing customer information, including name, address, phone number, and email. The framework should include a combination of data profiling, data validation, and data verification techniques, as well as a discussion of the potential risks and consequences of poor data quality. Provide a detailed report on the data quality issues identified, including metrics such as data coverage, data density, and data consistency, as well as recommendations for improving data quality through data cleansing, data standardization, and data governance.

Create a statistical summary report to analyze the distribution of a continuous variable, such as customer satisfaction ratings, using a dataset of 5,000 records. The report should include descriptive statistics, such as mean, median, mode, and standard deviation, as well as inferential statistics, such as confidence intervals and hypothesis testing. Provide a detailed interpretation of the results, including a discussion of the implications for business decision-making, as well as recommendations for further analysis and potential avenues for improvement.