Best Gemini prompts for Project Management Specialists

Given a project schedule with 50 tasks, 10 resources, and 5 dependencies, analyze the critical path and identify potential risks and bottlenecks using a Monte Carlo simulation with 1000 iterations, assuming a 10% uncertainty in task durations. Provide a detailed report of the results, including the probability of meeting the project deadline and the top 3 risks that could impact the project timeline. Use a Bayesian network to model the relationships between tasks and resources, and calculate the expected value of perfect information for each task. Please include a Gantt chart and a table summarizing the results.

Design a quality metrics dashboard for a software development project using Google Data Studio, incorporating the following metrics: defect density, test coverage, and code complexity. The dashboard should include 5 charts: a line chart showing the trend of defect density over time, a bar chart comparing test coverage across different modules, a scatter plot of code complexity vs. defect density, a gauge chart displaying the overall quality score, and a table listing the top 5 modules with the highest defect density. Use a combination of Google Sheets and Google BigQuery to fetch and process the data, and apply a threshold-based alert system to notify the project manager when any of the metrics exceed the defined limits. Please include a screenshot of the dashboard and a brief description of each chart.

Develop a resource allocation plan for a project with 10 team members, 5 tasks, and 3 skills required (programming, testing, and design). Use a linear programming model to optimize the allocation of resources to tasks, minimizing the total project duration while ensuring that each task is assigned to a team member with the required skills. The model should account for the following constraints: each team member can work on at most 2 tasks, each task requires at least 2 skills, and the total available hours per week per team member is 40. Provide a detailed allocation plan, including the assigned tasks, skills, and hours for each team member, as well as a Gantt chart showing the project schedule. Please include a sensitivity analysis to determine the impact of changing the skills required for each task on the optimal allocation.

Create a script using Google Apps Script to automate the generation of daily project status reports, fetching data from a Google Sheets project dashboard and a Google BigQuery database. The script should extract the following metrics: project progress, task status, and team member workload, and use a natural language generation model to create a concise and readable report. The report should include a summary of the project status, a list of upcoming milestones, and a table showing the task assignments and progress for each team member. Use a scheduling function to run the script daily at 8am, and send the report to the project stakeholders via email. Please include a sample report and a brief description of the script's logic.