Best Gemini prompts for Architectural and Engineering Managers

Given a dataset of the last 100 deployment scripts, including variables such as script execution time, error logs, and environment variables, identify the most common root causes of deployment failures and provide a ranked list of recommendations for reducing failure rates, considering factors such as recent changes in the codebase, team member experience, and infrastructure updates. Assume the data is stored in a Google BigQuery database and provide the SQL query used to extract the relevant data.

Using historical usage data from our AWS account, including CPU utilization, memory usage, and network throughput, develop a predictive model to forecast resource demand for the next quarter, taking into account seasonal fluctuations, new project launches, and team growth. Provide a detailed report on the optimal resource allocation strategy, including recommendations for rightsizing instances, reserved instances, and auto-scaling groups, and assume the data is stored in a Google Cloud Storage bucket.

Analyze a dataset of 500 code reviews from our Git repository, including metrics such as review time, comment count, and approval rate, to identify the most effective code reviewers and provide recommendations for improving the overall quality of code reviews, considering factors such as reviewer experience, code complexity, and team dynamics. Assume the data is stored in a Google Sheets document and provide the pivot tables used to extract the relevant insights.

Given a dataset of defect reports from our Jira project management system, including variables such as defect type, severity, and resolution time, develop a defect reduction strategy that prioritizes the most critical defects and provides a step-by-step plan for addressing them, considering factors such as team workload, defect density, and testing coverage. Assume the data is stored in a Google Data Studio dashboard and provide the SQL query used to extract the relevant data.