Best Jasper prompts for Credit Analysts

Design an optimized ETL pipeline using Python and SQL to extract credit data from a Snowflake database, transform it into a suitable format for analysis, and load it into a Tableau dashboard for visualization. The pipeline should handle missing values, outliers, and data inconsistencies, and include data quality checks to ensure accuracy and completeness. Provide a detailed step-by-step implementation plan, including code snippets and sample data.

Develop a regression model using R to predict the likelihood of loan defaults based on a dataset of customer credit information, including demographic, financial, and credit history variables. The model should account for non-linear relationships and interactions between variables, and include feature selection and hyperparameter tuning to optimize performance. Provide a detailed model specification, including equation formulation, coefficient interpretation, and diagnostic metrics.

Create a data cleaning and preprocessing script using Python to prepare a credit scoring dataset for analysis, including handling missing values, outliers, and data inconsistencies. The script should also perform data normalization, feature scaling, and encoding of categorical variables, and include data quality checks to ensure accuracy and completeness. Provide a detailed step-by-step implementation plan, including code snippets and sample data.

Generate a statistical summary report using SQL and Tableau to analyze the performance of a credit portfolio, including metrics such as default rates, loss ratios, and return on investment. The report should include data visualizations, such as histograms, box plots, and scatter plots, to illustrate key trends and relationships, and provide insights into portfolio risk and opportunities for improvement. Provide a detailed report specification, including data sources, calculation formulas, and visualization designs.