Best Jasper prompts for Budget Analysts

Design an ETL pipeline to extract financial data from our Snowflake database, transform it into a format suitable for analysis, and load it into a Python-based data warehouse for further processing. The pipeline should handle data from multiple sources, including financial statements, budget allocations, and expense reports. Ensure that the pipeline is optimized for performance, with a focus on minimizing data latency and maximizing data accuracy. Provide a detailed diagram of the pipeline architecture, including data flow, data processing, and data storage components.

Evaluate the performance of a regression model used to forecast budget expenditures, using metrics such as mean absolute error, mean squared error, and R-squared. Compare the results to a baseline model, and provide recommendations for improving the model's accuracy and robustness. Include a sensitivity analysis to identify the most critical input variables and a discussion of potential biases in the data. Use Python and R to implement the model evaluation and provide visualizations of the results.

Generate a comprehensive statistical summary report of our budget data, including descriptive statistics, inferential statistics, and data visualizations. The report should cover key metrics such as budget variance, expense ratios, and revenue growth, and include analysis of trends, correlations, and outliers. Use Tableau to create interactive dashboards and visualizations, and provide recommendations for data-driven decision-making. Ensure that the report is concise, clear, and actionable, with a focus on supporting budget planning and forecasting.

Conduct a thorough data quality audit of our budget data, identifying and documenting data errors, inconsistencies, and gaps. Develop a data quality metrics framework to measure data accuracy, completeness, and timeliness, and provide recommendations for data quality improvement. Use SQL to query the data and identify issues, and create a data quality dashboard to track and monitor data quality over time. Include a discussion of data governance and data stewardship core standards, and provide a roadmap for implementing data quality improvements.