Best Gemini prompts for Health Technologists and Technicians, All Other

Given a dataset of 10,000 patient records with inconsistent formatting, containing fields such as patient ID, name, date of birth, and medical history, and a separate dataset of 5,000 lab test results with patient IDs and test codes, use Google BigQuery to merge the two datasets based on patient ID, handle missing values, and generate a report of patients with incomplete medical history information, including the number of patients with missing data and the percentage of total patients affected.

Create a comprehensive quality audit checklist for a medical laboratory setting, including sections for equipment maintenance, supply inventory, and staff training, with a minimum of 20 specific items to inspect or review, and use Google Docs to format the checklist with checkboxes and conditional formatting to highlight critical items, then export the checklist as a PDF and attach it to a quality audit report template.

Using a dataset of 1,000 quality control samples with fields for sample ID, test result, and error status, calculate the error rate for each test type and generate a bar chart using Google Data Studio to visualize the error rates, with separate charts for each test type and a filter to select the date range, then write a brief report summarizing the findings and recommendations for reducing error rates, including the top 3 test types with the highest error rates and the corresponding error reduction strategies.

Design a Google Apps Script to automate the generation of daily status reports for a medical laboratory, including sections for test completion rates, equipment status, and staff workload, by querying a Google Sheets dashboard for key performance indicators, formatting the report with conditional formatting and charts, and emailing the report to laboratory staff and management at 8am each day, with a minimum of 5 KPIs and 2 charts, then schedule the script to run daily using Google Cloud Scheduler.