var(--variable-gpS1HWJlw)

SUCCESS STORY · ACTIA

ACTIA|Product traceability centralized on Snowflake

KPC centralizes ACTIA's board and component traceability on Snowflake. Business teams view and check the data in a browser, without writing a single SQL query.

KPC key performance indicator
var(--variable-emHvuQnoL)

The impact in numbers

2

Consultants assigned

6+

Months of project

2

Tools integrated (Snowflake, Streamlit)

The impact in numbers

2

Consultants assigned

6+

Months of project

2

Tools integrated (Snowflake, Streamlit)

The impact in numbers

2

Consultants assigned

6+

Months of project

2

Tools integrated (Snowflake, Streamlit)

RESULTS

The results for ACTIA

A single entry point for the business

The quality and support teams view, check and administer traceability without depending on IT. The business works more independently.

The results for ACTIA

Zero SQL queries for the business

Searches that used to need a complex SQL query are now available from the browser. Manual analysis disappears. The results are more reliable.

The results for ACTIA

An architecture that holds the load

Separating the high-volume flows keeps the architecture maintainable. Snowflake compute stays available for heavy analysis on components.

RESULTS

The results for ACTIA

A single entry point for the business

The quality and support teams view, check and administer traceability without depending on IT. The business works more independently.

The results for ACTIA

Zero SQL queries for the business

Searches that used to need a complex SQL query are now available from the browser. Manual analysis disappears. The results are more reliable.

The results for ACTIA

An architecture that holds the load

Separating the high-volume flows keeps the architecture maintainable. Snowflake compute stays available for heavy analysis on components.

RESULTS

The results for ACTIA

A single entry point for the business

The quality and support teams view, check and administer traceability without depending on IT. The business works more independently.

The results for ACTIA

Zero SQL queries for the business

Searches that used to need a complex SQL query are now available from the browser. Manual analysis disappears. The results are more reliable.

The results for ACTIA

An architecture that holds the load

Separating the high-volume flows keeps the architecture maintainable. Snowflake compute stays available for heavy analysis on components.

Background & core challenges

Making traceability usable by the business

Data scattered across technical and business sources

ACTIA, an industrial group specialized in embedded electronic systems, needed to consolidate its traceability data for boards and components. That data was spread across several sources: production, product integration, components, packaging, suppliers and customers.

Searches went through complex SQL queries, barely accessible to the business. Volumes were large, especially on components. Bringing in new data stayed manual.

Centralize data spread across production, components, packaging, suppliers and customers

Make searches available with no SQL query for business users

Automate bringing in new data as it arrives

Simplify exports for exchanges with customers and suppliers

Background & core challenges

Making traceability usable by the business

Data scattered across technical and business sources

ACTIA, an industrial group specialized in embedded electronic systems, needed to consolidate its traceability data for boards and components. That data was spread across several sources: production, product integration, components, packaging, suppliers and customers.

Searches went through complex SQL queries, barely accessible to the business. Volumes were large, especially on components. Bringing in new data stayed manual.

Centralize data spread across production, components, packaging, suppliers and customers

Make searches available with no SQL query for business users

Automate bringing in new data as it arrives

Simplify exports for exchanges with customers and suppliers

Background & core challenges

Making traceability usable by the business

Data scattered across technical and business sources

ACTIA, an industrial group specialized in embedded electronic systems, needed to consolidate its traceability data for boards and components. That data was spread across several sources: production, product integration, components, packaging, suppliers and customers.

Searches went through complex SQL queries, barely accessible to the business. Volumes were large, especially on components. Bringing in new data stayed manual.

Centralize data spread across production, components, packaging, suppliers and customers

Make searches available with no SQL query for business users

Automate bringing in new data as it arrives

Simplify exports for exchanges with customers and suppliers

Our approach

A Snowflake Data platform, with usage driven by the business

KPC put a Data platform in place based on Snowflake. The traceability data is centralized and structured there, then exposed to the business through Streamlit applications built around how they actually work.

Centralization

Centralize traceability on Snowflake

The traceability data, scattered across production, components, packaging, suppliers and customers, is centralized and structured in Snowflake.

Processing & structuring

Transform and check the data

Python processes collect, transform and check the data. It is then structured into several layers and views to optimize how it is consumed in Streamlit.

Business delivery

Putting data in the hands of the business

Streamlit applications let you check a product's traceability from A to Z. The business also manages the mappings, table and product generation, and the integration and non-regression checks. The data is refreshed hourly and can be exported to CSV or Excel.

Our approach

A Snowflake Data platform, with usage driven by the business

KPC put a Data platform in place based on Snowflake. The traceability data is centralized and structured there, then exposed to the business through Streamlit applications built around how they actually work.

Centralization

Centralize traceability on Snowflake

The traceability data, scattered across production, components, packaging, suppliers and customers, is centralized and structured in Snowflake.

Processing & structuring

Transform and check the data

Python processes collect, transform and check the data. It is then structured into several layers and views to optimize how it is consumed in Streamlit.

Business delivery

Putting data in the hands of the business

Streamlit applications let you check a product's traceability from A to Z. The business also manages the mappings, table and product generation, and the integration and non-regression checks. The data is refreshed hourly and can be exported to CSV or Excel.

Our approach

A Snowflake Data platform, with usage driven by the business

KPC put a Data platform in place based on Snowflake. The traceability data is centralized and structured there, then exposed to the business through Streamlit applications built around how they actually work.

Centralization

Centralize traceability on Snowflake

The traceability data, scattered across production, components, packaging, suppliers and customers, is centralized and structured in Snowflake.

Processing & structuring

Transform and check the data

Python processes collect, transform and check the data. It is then structured into several layers and views to optimize how it is consumed in Streamlit.

Business delivery

Putting data in the hands of the business

Streamlit applications let you check a product's traceability from A to Z. The business also manages the mappings, table and product generation, and the integration and non-regression checks. The data is refreshed hourly and can be exported to CSV or Excel.

Our clients

Our clients

They trust us.

They trust us.

CMA CGM logo
France Travail logo
Astore logo
Restalliance logo
Actia logo
La Rosée logo
La Rosée logo
Manitowoc logo
Manitowoc logo
Restalliance logo
Restalliance logo
Restalliance logo
Illustration of performance and growth

A SIMILAR PROJECT IN MIND?

Product traceability to centralize?

Our Data & AI teams centralize your traceability data on Snowflake. The business views and checks the data with no SQL query.

Illustration of performance and growth

A SIMILAR PROJECT IN MIND?

Product traceability to centralize?

Our Data & AI teams centralize your traceability data on Snowflake. The business views and checks the data with no SQL query.

Illustration of performance and growth

A SIMILAR PROJECT IN MIND?

Product traceability to centralize?

Our Data & AI teams centralize your traceability data on Snowflake. The business views and checks the data with no SQL query.