SUCCESS STORY · ACTIA
ACTIA｜Product traceability centralized on Snowflake
KPC centralizes ACTIA's board and component traceability on Snowflake. Business teams consult and monitor the data in a browser without writing a single SQL query.
The data impact
2
Consultants mobilized
6+
Project month
2
Integrated tools (Snowflake, Streamlit)
The data impact
2
Consultants mobilized
6+
Project month
2
Integrated tools (Snowflake, Streamlit)
The data impact
2
Consultants mobilized
6+
Project month
2
Integrated tools (Snowflake, Streamlit)
RESULTS
Results for ACTIA
A single entry point for business lines
Quality and support teams consult, control, and administer traceability without depending on IT. Business autonomy increases.
Results for ACTIA
Zero SQL queries for business teams
Searches that required a complex SQL query become accessible from the browser. Manual analyses disappear. Results are made more reliable.
Results for ACTIA
An architecture that handles the load
The separation of high-volume flows makes the architecture maintainable. Snowflake's computing power remains available for heavy analytics on the components.
RESULTS
Results for ACTIA
A single entry point for business lines
Quality and support teams consult, control, and administer traceability without depending on IT. Business autonomy increases.
Results for ACTIA
Zero SQL queries for business teams
Searches that required a complex SQL query become accessible from the browser. Manual analyses disappear. Results are made more reliable.
Results for ACTIA
An architecture that handles the load
The separation of high-volume flows makes the architecture maintainable. Snowflake's computing power remains available for heavy analytics on the components.
RESULTS
Results for ACTIA
A single entry point for business lines
Quality and support teams consult, control, and administer traceability without depending on IT. Business autonomy increases.
Results for ACTIA
Zero SQL queries for business teams
Searches that required a complex SQL query become accessible from the browser. Manual analyses disappear. Results are made more reliable.
Results for ACTIA
An architecture that handles the load
The separation of high-volume flows makes the architecture maintainable. Snowflake's computing power remains available for heavy analytics on the components.
Context & central challenges
Les enjeux
Data scattered between technical and business sources
ACTIA, an industrial group specializing in embedded electronic systems, needed to consolidate its traceability, board, and component data. This data was distributed across several sources: production, product integration, components, packaging, suppliers, and customers.
Searches involved complex SQL queries, which were barely accessible to business users. Volumes were significant, particularly for components. The integration of new data remained manual.
Centralize data distributed between production, components, packaging, suppliers and customers
Making searches accessible without SQL queries for business users
Automate the integration of new data as it arrives
Simplify exports for exchanges with customers and suppliers
Context & central challenges
Les enjeux
Data scattered between technical and business sources
ACTIA, an industrial group specializing in embedded electronic systems, needed to consolidate its traceability, board, and component data. This data was distributed across several sources: production, product integration, components, packaging, suppliers, and customers.
Searches involved complex SQL queries, which were barely accessible to business users. Volumes were significant, particularly for components. The integration of new data remained manual.
Centralize data distributed between production, components, packaging, suppliers and customers
Making searches accessible without SQL queries for business users
Automate the integration of new data as it arrives
Simplify exports for exchanges with customers and suppliers
Context & central challenges
Les enjeux
Data scattered between technical and business sources
ACTIA, an industrial group specializing in embedded electronic systems, needed to consolidate its traceability, board, and component data. This data was distributed across several sources: production, product integration, components, packaging, suppliers, and customers.
Searches involved complex SQL queries, which were barely accessible to business users. Volumes were significant, particularly for components. The integration of new data remained manual.
Centralize data distributed between production, components, packaging, suppliers and customers
Making searches accessible without SQL queries for business users
Automate the integration of new data as it arrives
Simplify exports for exchanges with customers and suppliers
Our approach
A Snowflake Data Platform, Business-Driven Use Cases
KPC has set up a Data platform based on Snowflake. Traceability data is centralized and structured there, then exposed to business lines via Streamlit applications designed for their actual uses.
Centralization
Centralize traceability on Snowflake
Traceability data, scattered across production, components, packaging, suppliers, and customers, is centralized and structured in Snowflake.
Processing & structuring
Transform and control the data
Python processes retrieve, transform, and validate the data. It is then structured into several layers and views to optimize its consumption in Streamlit.
Business reporting
Putting data into the hands of business lines
Streamlit applications make it possible to verify the traceability of a product from A to Z. Business teams also use them to manage mappings, table and product generation, and integration and non-regression checks. The data is refreshed hourly and can be exported as CSV or Excel.
Our approach
A Snowflake Data Platform, Business-Driven Use Cases
KPC has set up a Data platform based on Snowflake. Traceability data is centralized and structured there, then exposed to business lines via Streamlit applications designed for their actual uses.
Centralization
Centralize traceability on Snowflake
Traceability data, scattered across production, components, packaging, suppliers, and customers, is centralized and structured in Snowflake.
Processing & structuring
Transform and control the data
Python processes retrieve, transform, and validate the data. It is then structured into several layers and views to optimize its consumption in Streamlit.
Business reporting
Putting data into the hands of business lines
Streamlit applications make it possible to verify the traceability of a product from A to Z. Business teams also use them to manage mappings, table and product generation, and integration and non-regression checks. The data is refreshed hourly and can be exported as CSV or Excel.
Our approach
A Snowflake Data Platform, Business-Driven Use Cases
KPC has set up a Data platform based on Snowflake. Traceability data is centralized and structured there, then exposed to business lines via Streamlit applications designed for their actual uses.
Centralization
Centralize traceability on Snowflake
Traceability data, scattered across production, components, packaging, suppliers, and customers, is centralized and structured in Snowflake.
Processing & structuring
Transform and control the data
Python processes retrieve, transform, and validate the data. It is then structured into several layers and views to optimize its consumption in Streamlit.
Business reporting
Putting data into the hands of business lines
Streamlit applications make it possible to verify the traceability of a product from A to Z. Business teams also use them to manage mappings, table and product generation, and integration and non-regression checks. The data is refreshed hourly and can be exported as CSV or Excel.
Our clients
Our clients
They trust us.
They trust us.
Retail & Beauty
Rag & Bone — Data platform optimization and preparation for AI use cases
Data
Data Platform
→
Retail & Beauty
Marc Jacobs — Redesign of the data foundation in the midst of ERP transformation
Data
Data Platform
→
Finance & Banking
FLOA — A Data platform reviewed and brought back to the state of the art
Finance & Banking
Snowflake
→
Maritime transport
CMA CGM | A single OneStream platform to consolidate, budget, and steer
OneStream
Statutory consolidation
→
Car financing
Toyota Financial Services｜170,000 customers, 100% automated customer journeys on imagino
CRM
Snowflake
→
International public sector
CEB｜ERP transformation on SAP Cloud, at the service of social cohesion
SAP
ERP
→
Retail & Beauty
Rag & Bone — Data platform optimization and preparation for AI use cases
Data
Data Platform
→
Retail & Beauty
Marc Jacobs — Redesign of the data foundation in the midst of ERP transformation
Data
Data Platform
→
Finance & Banking
FLOA — A Data platform reviewed and brought back to the state of the art
Finance & Banking
Snowflake
→
Maritime transport
CMA CGM | A single OneStream platform to consolidate, budget, and steer
OneStream
Statutory consolidation
→
Car financing
Toyota Financial Services｜170,000 customers, 100% automated customer journeys on imagino
CRM
Snowflake
→
International public sector
CEB｜ERP transformation on SAP Cloud, at the service of social cohesion
SAP
ERP
→
Retail & Beauty
Rag & Bone — Data platform optimization and preparation for AI use cases
Data
Data Platform
→
Retail & Beauty
Marc Jacobs — Redesign of the data foundation in the midst of ERP transformation
Data
Data Platform
→
Finance & Banking
FLOA — A Data platform reviewed and brought back to the state of the art
Finance & Banking
Snowflake
→
Maritime transport
CMA CGM | A single OneStream platform to consolidate, budget, and steer
OneStream
Statutory consolidation
→
Car financing
Toyota Financial Services｜170,000 customers, 100% automated customer journeys on imagino
CRM
Snowflake
→
International public sector
CEB｜ERP transformation on SAP Cloud, at the service of social cohesion
SAP
ERP
→
A SIMILAR PROJECT IN MIND?
Product traceability to be centralized?
Our Data & AI teams centralize your traceability data on Snowflake. Business users can consult and control the data without SQL queries.
A SIMILAR PROJECT IN MIND?
Product traceability to be centralized?
Our Data & AI teams centralize your traceability data on Snowflake. Business users can consult and control the data without SQL queries.
A SIMILAR PROJECT IN MIND?
Product traceability to be centralized?
Our Data & AI teams centralize your traceability data on Snowflake. Business users can consult and control the data without SQL queries.