Data management and preparation for growth

Tescan Orsay, a leading global manufacturer of electron microscopes, operates from fourteen locations worldwide. These sites handle large volumes of data daily, but the lack of structure and consistent formatting made data processing challenging. To address this, we developed a streamlined, automated system that unified data flows, saving employees valuable time and positioning the company for future growth. Here's a closer look at how we collaborated to achieve this.

From spreadsheets to a time-saving system

As Tescan Orsay expanded its operations, the finance and controlling teams struggled with the inefficiencies of manual data collection. Managing data from fourteen branches manually was not sustainable — it significantly slowed down workflows and increased the risk of human errors.

Our first step was to conduct an in-depth audit to understand how data was being handled on a day-to-day basis. This process revealed several key challenges:

• Outputs existed in various formats (emails, shared documents, spreadsheets, etc.).
• Duplicate records were a frequent issue.
• Manual processing consumed significant time.
• There was a high risk of errors.
• Data automation was nearly impossible.
• Communication between teams was inefficient.

With these insights, we developed a solution to consolidate all data into a standardized format and automatically store them in Snowflake's cloud database, making the data accessible to employees through tools like Microsoft's Power BI. To ensure the system's effectiveness, we tested it in operation at two key locations: the Czech Republic and the USA. This approach not only streamlined workflows but also paved the way for long-term scalability and efficiency.

Our work didn’t stop there. At Gauss Algorithmic, we understand that even the best solution is only as effective as the people using it. That’s why we organized a hands-on workshop for the Tescan Orsay finance team, educating them on how to put the system into practice.

What was the outcome of our collaboration?

The solution we delivered is more than just a step toward streamlining data processes—it’s a robust foundation for Tescan Orsay’s future growth. With a proof of concept ready for implementation at any time, the company now has the flexibility to pursue future innovations without needing to overhaul the entire system.

In just one month, we developed a tool capable of consolidating all documents into a single format and storing them in a dedicated database. Employees now have instant access to clearly processed outputs, allowing them to focus on more strategic tasks. The standardization of internal data has also enabled the consolidation of financial information at the holding company level, ensuring that the group management always has up-to-date data critical for effective decision-making.

Are you considering a similar solution for your company?

If you’re looking for a way to save time and energy for yourself or for your employees, we’re here to help. Let’s work together to explore how AI can simplify your daily operations and make your business run more efficiently.