Best Gemini prompts for Budget Analysts

Given a dataset of actual expenditures and budgeted amounts for various departments, write a Python script to calculate the variance between actual and budgeted amounts, and then use statistical methods to identify the departments with the largest variance. Assume the data is stored in a Snowflake database and provide the SQL query to extract the relevant data. Finally, provide a recommendation for how to adjust the budget to minimize variance in the future, based on the results of a regression model.

I have a complex SQL query that is taking too long to run on our Tableau dashboard, which is connected to a large dataset in Snowflake. The query joins multiple tables and uses several subqueries. Use Gemini to analyze the query and provide recommendations for how to optimize it, including suggestions for indexing, rewriting subqueries, and reordering joins. Also, provide an example of how to implement a data cleaning script to improve data accuracy.

Using historical data on revenue and expenses, create a statistical model to forecast future budget requirements. The data is stored in a CSV file and has the following columns: date, revenue, expenses. Use R to create a regression model that takes into account seasonal trends and other factors that may impact budget requirements. Then, use the model to generate a forecast for the next quarter and provide a summary of the results, including a statistical summary of the model's precision.

I need to audit our ETL pipeline to ensure that it is accurately extracting data from our various sources and loading it into our data warehouse. Use Gemini to generate a checklist of steps to follow when auditing the pipeline, including how to verify data accuracy, check for data duplication, and test data transformation rules. Also, provide an example of how to use Python to automate the auditing process and generate a report on the results, including any data quality issues that need to be addressed.