Best Jasper prompts for Management Analysts

Design an ETL pipeline using Python and Snowflake to extract customer data from a SQL database, transform it into a suitable format for analysis, and load it into a data warehouse for querying. The pipeline should handle errors and exceptions, and include logging and monitoring to ensure data accuracy and query optimization. Assume the database has 10 million rows and 20 columns, and the data warehouse has a limit of 1000 concurrent connections. Provide a detailed implementation plan, including code snippets and performance benchmarks.

Given a dataset of sales figures and marketing spend, develop a regression model using R to predict future sales based on historical trends and marketing efforts. The model should account for seasonal fluctuations, outliers, and non-linear relationships between variables. Provide a step-by-step guide to implementing the model, including data preprocessing, feature selection, and hyperparameter tuning. Assume the dataset has 5000 rows and 10 columns, and evaluate the model's performance using metrics such as mean absolute error and R-squared.

Create a data quality audit report using Tableau to identify and prioritize data integrity issues in a dataset of customer information. The report should include visualizations and summaries of data accuracy, completeness, and consistency, as well as recommendations for data cleansing and validation. Assume the dataset has 100,000 rows and 50 columns, and provide a template for the report that can be customized for different datasets and stakeholders.

Develop a statistical summary of a dataset of website traffic and engagement metrics using Python and Pandas. The summary should include descriptive statistics, distribution plots, and correlation analysis to identify trends and patterns in the data. Then, use the summary to generate insights and recommendations for improving website user experience and conversion rates. Assume the dataset has 1 million rows and 20 columns, and provide a code snippet to implement the summary and insights generation.