An HTML dashboard platform
BI tools meant repetitive GUI work with little flexibility and no review trail, so I built a delivery form where requirements and data definitions are written in Markdown and generative AI produces the implementation.
- Organisation
- MIIDAS CO., LTD.
- Period
- Mar 2026 – Present
- How it started
- Assigned (My manager asked me to trial it)
- My part
- Architecture, implementation, and coordination with the using divisions, alone
- For whom
- Sales planning, CS, business development and science teams
- What changed
- Repeating GUI work inside the limits of a BI tool → Hand over requirements and data, AI writes the implementation, and every change is reviewed and recorded in Git
What I did
Standardised the purpose and requirements of a dashboard into a format that leaves a record (Markdown).
Built the delivery path from query definition through Lambda, Google Drive, Apps Script and Google Sites.
What comes next
Moving them onto the internal application platform as containers, reading from Redshift directly.
Folding authentication into the shared single sign-on.
Settling on standards for controls and layout.
Three issues are known and open: data passed indirectly through CSV, the time requirements and data preparation take, and the governance the added flexibility demands.
Choices I made
Replaced GUI work in the BI tool with requirements and data definitions written in Markdown, leaving the implementation to generative AI. Changes get reviewed in Git and leave a trail.
Tools
- Languages
- SQL / JavaScript / HTML / CSS / Google Apps Script
- Cloud & Infrastructure
- AWS (Lambda)
- Tools
- Google Drive / Google Sites