This section aims to present the Data Architecture implemented for data flow in Lab Booster.
ELN Schemas
| File Name | Data Model File |
|---|---|
| Agro | |
| Battery | |
| Coatings | |
| Seed Care | |
| Actizone | |
| HPC Flocculation | |
ELN Spreadsheets design standards
Design is really important for user experience.
The user feedback about the first version of the ELN templates where more about the design than the content. They didn't really enjoy the "black and yellow" spreadsheets.
So for Coatings' Paint Formulation SS V2, we worked on defining design standards using Solvay's color palette as a base.
These standards are going to evolve according to the future needs.
Here are documentations about developed spreadsheet in PROD:
| Agro | ||
| Battery | Conductivity | |
| Battery | Mechanosynthesis | |
| Coatings | EP | |
| Seed Care | Formulation | |
| Seed Care | Results & Requests | |
Lab Booster Data model
BigQuery
New Data Model of ALB Data Mart (Exposition layer): https://app.genmymodel.com/api/projects/_k07o4IBOEe29ie0vpi-P5A/diagrams/_k07o4oBOEe29ie0vpi-P5A/svg
Data Mapping to Data Mart:
The following BigQuery datasets are all staging as per the data convention explained previously.
For more ETL (extraction, transformation, loading) details, please refers to: App Lab Booster (ALB) - Data
Batteries
Materials
Coatings
