Best Jasper prompts for Computer Systems Analysts

Given a dataset of 10 million customer records with 50 columns, each containing a mix of numeric, categorical, and text data, and a Snowflake warehouse with 4 virtual warehouses, each with 2X-Large compute resources, design an optimized ETL pipeline using Python and the Snowflake connector to load, transform, and aggregate the data, ensuring data accuracy and query performance meet the required KPIs of 99.5% accuracy and 200ms query latency; provide a detailed workflow, including data profiling, data cleaning, data transformation, and data loading, as well as recommendations for resource allocation, warehouse sizing, and query optimization.

For a predictive modeling task involving a dataset with 100,000 samples and 20 features, where the target variable is a continuous outcome and the goal is to predict it with high precision, using Python and scikit-learn, develop a systematic approach to select the most suitable regression model (linear, ridge, lasso, elastic net, or random forest) and tune its hyperparameters to achieve a model precision of at least 0.9, considering factors like feature correlation, multicollinearity, and potential outliers; provide a step-by-step workflow, including data preprocessing, feature engineering, model selection, hyperparameter tuning, and model evaluation.

Given a complex SQL query involving multiple joins, subqueries, and aggregations, running on a large data warehouse with 100 million rows and 100 columns, using Tableau to visualize the query plan and Snowflake to execute the query, optimize the query to reduce latency by at least 50% while maintaining data accuracy, by applying techniques like query rewriting, index optimization, materialized views, and result caching; provide a detailed analysis of the query plan, identification of performance bottlenecks, and recommendations for optimization, including any necessary changes to the query, indexing strategy, or warehouse configuration.

For a dataset containing 1 million customer interactions with 20 variables, including demographic, behavioral, and transactional data, using Python and Pandas, generate a comprehensive statistical summary, including descriptive statistics, distribution plots, and correlation analysis, as well as a data quality report, highlighting potential issues like missing values, outliers, and data inconsistencies; provide a detailed workflow, including data loading, data cleaning, data transformation, and data visualization, as well as recommendations for data quality improvement and potential implications for downstream analytics and modeling tasks.