Use Case
Data-driven dashboards
Turn your surveillance data, spreadsheets, or reports into interactive visual dashboards — without specialist software or coding knowledge. You describe what you want; the AI builds it.
Use Case
Turn your surveillance data, spreadsheets, or reports into interactive visual dashboards — without specialist software or coding knowledge. You describe what you want; the AI builds it.
Public health teams generate substantial data — disease surveillance, immunisation rates, environmental monitoring, community health assessments — but translating that data into clear, shareable visuals often requires specialist tools or dedicated data analysts. AI changes that significantly.
By uploading your data and describing what you need, you can have an interactive dashboard — with charts, filters, and summary statistics — produced in minutes. No coding in R or use of Power BI. No specialist training. No waiting for a data analyst.
Can read files from your working folder, build interactive HTML dashboards, and save them directly. Best for ongoing dashboard work you want to update regularly.
Strong at data analysis. Upload a CSV or spreadsheet, describe the chart you want, and Codex produces it. Good for one-off analysis and quick visual summaries.
Works with Google Sheets natively. If your data is already in Sheets, Gemini can summarise it, produce charts, and insert them into a Google Slides presentation.
Your data needs to be in a readable format — a spreadsheet (.xlsx or .csv) or a copy-pasted table. It does not need to be perfectly clean; the AI can handle some messiness and will flag anything it cannot interpret. Always keep an original copy in a folder that cannot be accessed by the AI platform in case you need to refer to it later.
Attach your file to the conversation and type a clear description. Example:
The AI will produce a dashboard file. Open it in your browser to see how it looks. If something needs changing — different colours, a new chart type, extra filters — just ask: "Please add a dropdown filter by age group" or "Change the chart to show a 4-week rolling average."
The output is a self-contained HTML file — it works in any browser without an internet connection or special software. You can email it as an attachment, share it via your intranet, or host it on a website.