BIS & Compliance Dashboard on Top of Google Sheets
Salasar manages BIS and quality compliance data across multiple product lines using Google Sheets and manual reports. Fireflux Labs built a consolidated dashboard on top of their existing spreadsheets to track batches, quality checks and dispatch KPIs, with audit-ready exports.
The Challenges
- •Compliance and test results scattered across multiple spreadsheets and folders.
- •Difficult to answer BIS / audit queries quickly because data had to be stitched together.
- •No single view of batches, test status and dispatch readiness.
What We Built
A data pipeline that reads and normalises data from existing Google Sheets (no need to change their current way of entry initially).
A web dashboard that shows batch-wise status, test completion, and non-conformance items.
Exportable, audit-ready reports filtered by period, product line or standard.
Core Features
- Data pipeline reading from existing Google Sheets
- Batch-wise status tracking and test completion
- Non-conformance item tracking and alerts
- Audit-ready reports with flexible filtering
- Dispatch readiness dashboard by product line
- Quality KPIs and compliance metrics
Results & Impact
Key Outcomes
- Now we track batches, quality and dispatch KPIs in one place and can share audit-ready reports in minutes.
- Audits are easier to handle because information is structured and consistently presented.
Additional Benefits
- • Single source of truth for compliance and quality data
- • Faster response to BIS and customer audit queries
- • Better visibility into batch status and dispatch readiness
- • Reduced manual effort in report compilation
- • Maintained existing Google Sheets workflows
Tech & Approach
Google Sheets Integration
Real-time data sync from existing spreadsheets without changing entry workflows
Data Transformation
Normalisation and validation layer to structure compliance data
Modern Dashboard
Web-based dashboard with filtering, exports, and role-based access
Transform Your Spreadsheets into Powerful Dashboards
Get a customised assessment for building compliance and KPI dashboards on your existing data.